Include Rows

Use Include to display rows in the Table Editor that satisfy the specified criteria only, and exclude all other rows. In the Include dialog, you specify a search string. You also specify whether the search should proceed forward or backward, wrap to search all of the available data, be case-sensitive, or locate complete words. Click Include to display rows that contain the search string.

Rows that do not contain the search string are retained in the fetch set. A thick line between rows indicates the presence of hidden rows. Position the pointer on the thick line to display the number of hidden rows. You can right-click and select Show Excluded Rows on the shortcut menu to show all of the rows.

To use Include

  1. Right-click in a grid column heading and select Include from the shortcut menu to open the Include dialog.
    include dialog, described below
  2. On the Criteria tab, specify the string or value you want to include.
  3. Select a direction for the search.
  4. Select matching options, as needed.
  5. On the Columns tab, select the columns you want to search. The column in which you right-clicked is selected by default.
  6. Select Include to choose all rows that contain the search string in the selected columns.