Filtering Data Rows

Filtering the rows to return when browsing the data saved to a Data Designer table.

Implementation:

1. Click the icon in the Activity Bar.
2. Switch to the Definitions tab.
3. Select the intended table and click the Browse Data button to open the Filter Criteria tab.
4. Click the link at the top of the left-hand part of the tab, which is initially labelled satisfy all, and select whether you want to return rows that satisfy all conditions, do not match at least one condition, match just one condition, or don't comply with any conditions.
5. Click to add a new filter condition. This can either be a condition for a single column, a general condition for the entire filter, or a group to which you can apply multiple conditions.
6. (Condition for column only) Click the first link to select the column to interrogate, then use the second link to select an filter operator, and (if applicable) use the third link to provide the required value.
7. (General condition only) Click the link to enter the condition you want to apply.
8. (Optional) Click next to condition to bring up a context menu. Here you can choose Move Up or Move Down to change the condition's position, or Delete the condition from the filter.
9. Repeat steps 5-7 until you have added all required conditions.
10. Use the right-hand list to select the check boxes next to the columns you want to return. To return all columns, tick the first check box marked with an asterisk (*).
11. To apply the filter and view the rows matching your filter, open the Results tab.