Filter the data in columns

Any filters that are set are displayed at the bottom left of the data workbench next to the  button. You can clear all filters by clicking Clear at the bottom right:

Filter the data in columns: Click the   button at the top of a column. Set a checkmark for all values that you want to display. The button at the bottom will show all values that have been hidden via the filter settings. Click the link to open the Filter Builder to view and modify the operators of the query.

Filter the data using operators: Click the    Column Filters button at the bottom left of the data workbench to open the Filter Builder. If a filter has already been defined for columns via the column headers, these conditions will already be displayed in the Filter Builder as a combined AND condition. You can add or remove existing conditions in the Filter Builder.

• Define a condition
  1. Click + > Add Condition. You will see the default query searching within the first column of the table.
  2. Click the first field of the query and select the table column to query.
  3. Click Contains and select the search operator.
  4. Click <enter a value> and enter the value to query in the text field.
• Change the operator combining the conditions

  Click the And button and select a search operator.

• Add new operators combining a sub-set of conditions

  Some search conditions require the definition of more than one operator combining the conditions. For example, if you would like to search for results of the object state restricted to "Active" and the object name either starting with "A" or with "B", you need an AND operator to combine the searches in the two columns and an OR operator to combine the search for object names starting with "A" or with "B". For this purpose, operators can be added which are only applied to a group of conditions defined beneath them.

  1. Click + > Add Group.
  2. Click the And button of the new group and select a search operator.
  3. Use + > Add Condition to add as many conditions as you would like to combine with the operator.
• Remove a filter element

  To remove a condition or an operator grouping conditions from the filter, click the X on the left of the condition or operator.

Deactivate the filter. You can keep the filter settings but not apply them to the dataset. To do so, close the filter definition panel. Clear the checkbox showing the filter definition displayed at the bottom left of the data table. You can re-activate the filter later by selecting the checkbox.

Clear the complete filter. You can delete the entire filter definition from the data table. To do so, close the filter definition panel. Click Clear displayed at the bottom right of the data table.