Summary

This operator allows to filter rows of a data node's result table according to the fields of up to three columns.

This operator a TIS Board operators that connects to the Controller Portlet. The operator settings define the available filter criteria as columns of the table. These filter criteria are passed to the portlet by the operation. In the portlet, a TIS Board user can then make a selection. The selected filter criteria are then passed as parameter values back to the operation. The operation updates the data node's table accordingly.

Example: Single and multiple selection 

File

Situation

Data node A01_create-table is defined as follows.

We want to filter according to data in the columns "Name" and "Value". For "Name", we want to be able to select more than one value, for "Value", we only want to allow to select one value.

E.g., we want to filter all rows of the table that contain "A" or "B" as "Name" and "1" as "Value".

Note that both "Name" and "Value" are of type "Text".

Settings

Data node A02_multi-selection references A01_create-table as parent and contains [TIS]Board - Multiple selection 3.0 in its first operation. (This operator always has to be in the first operation.)

The operation settings are as follows.

Options "Selection 1" and "Selection 2" contain the columns of the table we want to select filter criteria from.

The fields "Selected elements 1" and "Selected elements 2" contain the selected criteria, i.e., values of the columns defined in "Selection 1" and "Selection 2". They are parameter values that are typically set by the Controller Portlet in the TIS Board. However, we can also set it manually.

Result

The result table of A02_multi-selection contains only the selected rows where "Name" is "A" or "B" and "Value" is "1".


Want to learn more?

Settings


Columns of input table

Parameter


Related topics