Creating a Table Filter

  1. In the Catalog Explorer, double-click the Table Definitions node.

    The catalog's table definitions are displayed.

  2. Double-click the required table definition.

    The table definition is displayed.

  3. Click Create Table Filter.

    The Table Filter pane is displayed on the right-hand side.

  4. Click (Add Factor) to the right of the AND operator.

    An empty factor is displayed.

  5. Click and select an 88-level condition name.

    The condition names in this list are associated with data items in the FD form. If an appropriate condition name is not already defined, you must a create it in the FD form; see Creating a Condition Item.

  6. Click and select the desired outcome:
    • Select True so that when the value of the 88-level condition matches its conditional variable, the filter is applied to the record.
    • Select False so that when the value of the 88-level condition does not match its conditional variable, the filter is applied to the record. This is the equivalent of a NOT operator.

      You can define further factors that have an AND or OR relationship with the one you just created.

  7. To define an AND relationship:
    1. Click (Add Factor) to the right of AND.

      A new factor is displayed beneath the current one.

    2. Repeat steps 5 and 6 above to define the factor.
    3. Repeat step 7 to add more AND factors.
  8. To define an OR relationship:
    1. Click (Add Condition) to the right of an existing factor.

      An OR + is displayed above the existing condition, and a new condition is added beneath the existing one.

    2. Repeat steps 5 and 6 above to define the condition.
    3. To add further factors to the OR relationship, click (Add Condition) to the right of OR and define the condition.
  9. Click Save to Catalog.

    The filter is immediately applied to the table definition.