1. Study Setup Guide
  2. Create custom programs, listings, and filters, and set up reference data
  3. Create public custom listings
  4. Specify and test criteria

Specify and test criteria

Specify the data condition the listing will look for.

  1. Select the Criteria tab.
  2. 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.
  3. 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.

  4. Click OK.

Next: Save and install a custom listing.

Back to Create public custom listings steps

Parent topic: Create public custom listings