5.2.4.3.2.1 Specific Values Filter
You can match a selected database column to a specified value or values, using the Specific Value filter.
You may either include or exclude Specific Values, to view the
data.
To create a specific value filter, proceed with the following steps, after
selecting the Database table name, column name and the Data element.
- Select Specific Values in the Filter Methods.
- Enter the required filter value in the Values
column.
- When comparing Specific Values for a date type column, select the date using the Calendar control.
- When comparing Specific Values for a character type column, enter only Character strings.
- To add another row click Add (Plus sign) on the right hand side corner of the Specific Values pane. Repeat the previous step, to enter multiple values.
- To include or exclude the specific values, in the results:
- To view the results containing the entered specific value, select the value and select Include. Click Add to add the expression to the filter condition.
- To view the results without the entered specific value, select the value and select Exclude. Click Add to add the expression to the filter condition.
- To delete a value, select the value by clicking the check-box adjacent to the value. Click Delete.
- To view the SQL statement for the specific value, select the value and click View SQL.