Defining selection criteria

Use the Table Specification window to define selection criteria with an SQL WHERE clause.

To define selection criteria:

  1. Expand a folder in the Directory Explorer that contains the access definition, expand the Access Definitions node, and double-click the access definition. The Access Definition Editor opens.
  2. Select the Tables tab.
  3. Select the table to which you will add selection criteria.
  4. Click Add Selection Criteria. The Table Specification window opens.
  5. Select the Selection Criteria tab. The tab displays a WHERE clause for the table.
  6. Enter selection criteria.

    To display a list of columns and operators, right-click the WHERE clause and click Content Assist.

    To add a variable, select a Variable delimiter and click Insert Variable.

    Click Check Syntax to verify the syntax and identify errors.

  7. Click OK.

    If the syntax is not valid, a prompt will open to identify to error. You cannot save the criteria if it contains errors.

  8. Save the access definition.


Feedback