Defining selection criteria for an attribute

You can use the attributes list in the selection policy editor to define selection criteria for an attribute in an entity.

Selection criteria allow you to pinpoint the data you want to process. You can select data according to values in one or more attributes. Selection criteria must conform to SQL syntax and include relational or logical operators.

To define selection criteria for an attribute:

  1. From the data access plan editor, click Selection. The selection policy editor opens.
  2. Click the Entity Specification heading. The Entity Specification editor opens.
  3. From the Entity Name list, select the entity that contains the attributes to which you want to add selection criteria.
  4. Select the Combine all criteria with iterator that determines how the criteria is applied.
    1. Select AND if a row must match selection criteria for all attributes.
    2. Select OR if a row must match selection criteria for one attribute.
  5. In the Selection Criteria column of the attributes list, click the browse button. The Selection Criteria window opens.
  6. Enter SQL syntax in the editor area. For convenience, you can select the Operator Symbols or Logical Operators to include.

    Click Check Syntax to identify SQL syntax errors.

  7. Click OK to return to the Entity Specification editor. The selection criteria is displayed in the Selection Criteria for area.
  8. Select View Selection Criteria SQL Summary to view the attribute selection criteria in the Select statement for the entity.
  9. Click File > Save.