Filter

The Filter portlet allows for customized filter lists and buttons to apply towards other portlets. With this portlet, one can choose from a pre-configured list of values or manually type in a value to send a filter request with the chosen criteria.

General

General data is required for all portlets.

General configuration

Listeners

The portlet can send the following events:

• OnFilter

• OnRowSelection

Listeners configuration

Settings

Order - Set if the filter should be displayed horizontally or vertically.

Send Filter command on Clear - if checked the values in the Filter portlet will be cleared followed by a Filter command sent to all listening portlets. If the box is left un-checked the Filter portlets values will be cleared but no command will be sent to the listening portlets.

Filters

Click New to add a new filter.

• Name: the text displayed above the filter drop down box

• Parameter: the column or variable name the filter will look for in the listen portlet

• Edit as: the type of filter

  • text: type in free text

  • number: filter for integer number

  • decimal: filter with configurable number of decimals

  • date: fill in date to filter

  • date & time: filters on date and time

  • list of values: gives a drop-down list of values. Select a value to filter

  • checkbox: filters on boolean values

• List of values: the list of values which is to be used (only available when Edit as is set to "list of values")

• Precision: number of decimals in the filter (only used for Decimal filter)

• Operator: for each input type specific operators are available

Type of filter	Supported operators
Text	equals, not equals, contains, starts with, ends with
Number, Decimal, Date, Date and Time	equals, not equals, is greater than, is less than, is greater than or equal, is less than or equal
List of values, Checkbox	equals

Below is an example of number, text, and list of value filters in use. Note that the filtered columns are indicated in blue in the column header. In case of filtering same column more than once, last value will always be applied.

Style

Change the header text color and add a header stripe by configuring style.

Style configuration