The Filter element provides a graphical representation of the 'filter' expression and creates a new list containing all the items in an existing list which meet the filter condition. Other palette elements, e.g., Reference can be added to the empty list of the Filter element. Other palette elements, e.g., Sum or Choose can be added to the empty member (listitemexpression) of the Filter element. The Filter element can be added to other palette elements, e.g., And, Or or When.
Properties:
The following table lists specific properties items for this element:
| Name | Description |
|---|---|
| Single Item | Only one item returned from the element. This is visible in the Technical Tab. |
| Behavior when no items found | Return either one of these results (error, return null) when no items found. This is active when the 'Single Item' is checked. |
| Behavior when multiple items found | Return either one of these results (error, return null, return first, return last) when multiple items found. This is active when the 'Single Item' is checked. |
Pop-up menu:
The following table lists specific pop-up menu items for this element:
| Name | Description |
|---|---|
| Remove Duplicates | Remove duplicate items in the Filter element. |
| Concatenate Results | Concatenate the items in the Filter element. |
| Join Inner Lists | Join the lists together to make one list. |
| Wrap in OR | Wrap the Filter element in Or Rule Group element. |
| Wrap in AND | Wrap the Filter element in the And Rule Group element. |