Summary
This operator allows to filter rows from a table according to conditions on their fields. It roughly corresponds to the WHERE
condition of an SQL statement.
Example: Search for the term "Shop A". All rows containing the string "Shop A" in a given column are selected.
Note that implicit parameter reference has been removed in operator version 1.2. Parameter must be referenced explicitly using the syntax
#XI.TISPar('...')#
.
Example: Filter for times related to work
Situation | From the table below only data containing times related to work (starting with "Arbeit" in column D) should be displayed. |
Operation setting | It is possible to filter for more than one criterium, but only one is needed here. |
Result | |
TIS Project | Confluence Op Filter Columns.gzip |
Simple Filters
| |
In the operations view you can see now the defined filters and number of chosen lines. |
User Defined Filters
Filters can also be created manually. | |
Filter statement |
|
Parameter Controlled Filter Conditions
To filter tables via [TIS]Board and parameters, define filter parameters. | |
Now define a statement which includes the filter | #XI.TISPar("Filter 1")# == |
Controller portlet | Now make a controller portlet for [TIS]Board, where you can type in the condition for your filter. |
Parameter Controlled Filters for Columns
Create a parameter for defining column names | |
Now define a statement, which includes the filter | BeginsWith(#XI.TISPar("Column name")#,"A") |
Controller portlet | Now make a controller portlet for [TIS]Board, where you can type in the column for your filter. |