Setting Up a DataSearch Filter

  1. To launch the DataSearch Source Filter Setup form, click Filter on the DataSearch Source Setup form.
    Note:  You cannot open this form directly.
  2. In the Property Name field, specify the IDO property for which you want to set up the filter.
  3. Specify the operator to use for the filter. If you select IS NULL or IS NOT NULL, the comparison field and value need not be specified.
  4. Select the comparison type:
    • Literal: The property value is compared to the literal value that you specify in the last field on this row.
    • DataSearch Source Property: The property value is compared to another property value from the DataSearch source.

      This can be useful when you want to use a comparison of two properties to control what records are searched. For example, if you wanted to search only orders that do not have the full number of items shipped, you could set up the property comparison QtyShipped < QtyOrdered. Or suppose you wanted to search only orders that were not shipped on time, you could set up the property comparison ShipDate > DueDate.

  5. In the last field on this row, specify the comparison value to be used for the corresponding comparison type.
  6. Optionally, if you use multiple filter clauses, to instruct the system to treat the clause as Boolean OR comparisons rather than Boolean AND comparisons with the previous clause, select OR Instead of AND with Previous Clause.
  7. To add the filter clause to the list of clauses in the display panel, click Add.

    The clause is added to the list, formatted with the proper syntax.

  8. Optionally, use Steps 2 through 7 to specify additional filter clauses.
  9. Optionally, to remove all filter clauses and start over, click Remove.
    Note:  You cannot selectively remove individual filter clauses: If you choose to remove one, you remove them all.
  10. Click OK.

For complex comparison logic, it might be necessary to add parentheses around filter clauses, to make sure they are evaluated properly. To accomplish this task, manually edit the data in the display list.

Note:  To get a better understanding of how filters can be used, look at the vendor level DataSearch Sources provided as part of the application installation.
Related topics