1. User Guide
  2. Business Rules Administration
  3. Common Rules
  4. Filters
  5. Creating Filter Definitions
  6. Defining a Data Element Filter
  7. Specific Values Filter

5.2.3.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.
  1. Select Specific Values in the Filter Methods.
  2. 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.
  3. 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.
  4. 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.
  5. To delete a value, select the value by clicking the check-box adjacent to the value. Click Delete.
  6. To view the SQL statement for the specific value, select the value and click View SQL.