Viewing and editing traversal steps

Use the Traversal Steps window to view and edit the traversal steps of an access definition.

You can evaluate the tables, relationships, and the steps performed to select data. This evaluation can ensure that you retrieve the desired set of data.

The steps in a process may be repeated any number of times according to relationships you select and criteria you specify.

Any table may be revisited several times in successive steps. Cycles may also be involved. A cycle causes a set of tables to be traversed repeatedly until a complete pass through the cycle does not result in selecting additional rows.

When a relationship is traversed to select parent rows for child rows already selected, any selection criteria for the parent table are ignored.

To view and edit traversal steps:

  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. Click Show Steps. The Traversal Steps window opens.
  4. Review the steps and edit the order in which tables are selected.
  5. Click OK.
  6. Save the access definition.


Feedback