1. Data Review Guide
  2. View data listings, display data flow, and create discrepancies
  3. Create a custom listing
  4. Specify and test criteria

Specify and test criteria

Specify the data condition the listing will look for.

  1. If not done already, open the custom listing you created in Define query details.
  2. Select the Criteria tab.
  3. Build the WHERE clause to determine which records appear in the listing. Click the Icon shows letters and a pencil. Add or Modify Criteria icon and Use the Expression Builder.
  4. In the custom listing Query Details pane, view and test the generated code:

    • Click View Source. The system generates and displays the PL/SQL code.

    • Click Test: The system generates PL/SQL code, validates it, and displays either an error message or the records retrieved.

  5. Do one of the following:
    • Continue on to Save and install a custom listing to continue defining your custom listing.
    • Click OK to close the dialog box and save the custom listing with the details you entered. You can return to this procedure and search for it to continue defining it later.

Parent topic: Create a custom listing