How to filter at the data set level
In Data Explorer, right-click the data set whose rows you want to filter, then choose Edit. Edit Data Set displays the query for the data set, as shown in
Edit Data Set displaying the query
Choose Filters from the left side of the window. Edit Data Set displays filter information, as shown in
Edit Data Set displaying filtering information
Choose New to create a filter condition.
On New Filter, specify the following values:
In Expression, select a field from the drop-down list. Alternatively, open the expression builder to create a more complex expression.
In Operator, select an operator from the drop-down list.
In Value 1, specify the value to search. You can type the value, select from the list of values, or use the expression builder to create a more complex value expression. If you select the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
In Value 2, specify a value only if you select the Between or Not Between operator.
Figure 11‑3 shows an example of a filter condition.
New Filter displaying a filter condition
Choose OK to save the new filter condition.
To create additional filter conditions for the data set, repeat steps
Figure 11‑4 shows two examples of filter conditions created for a data set.
Figure 11‑5 shows the rows that the data set returns.
Edit Data Set displaying the filter conditions for the data set
Choose Preview Results to verify the results that filtering the data set returns. If you specified multiple filter conditions, the data set returns only rows that match all filter conditions, as shown in
Figure 11‑5. To return rows that match any one of the filter conditions, create a single filter condition that contains an OR expression, then select the Is True operator.
Preview Results shows only rows that meet both filter conditions