Filter
Last updated
Last updated
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 data is required for all portlets.
The portlet can send the following events:
OnFilter
OnRowSelection
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.
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
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.
Change the header text color and add a header stripe by configuring style.
