Selecting a Constant Value


Concept


Steps:

  1. Begin by navigating to the Criteria page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "pt_sec_plist"
    .

    Step 3
  4. Click the Search button.

    Step 4
  5. Click an entry in the Edit column.

    Step 5
  6. Click the Criteria tab.

    Step 6
  7. Use the Criteria page to view and edit selection criteria for your query statement.

    Step 7
  8. In this example, you want to add a constant value in the Menu Name criteria.

     

    Click the Edit button.

    Step 8
  9. Use the Edit Criteria Properties page to edit selection criteria properties for your query statement.

    Step 9
  10. Click the Constant look up button.

    Step 10
  11. Use the Select a Constant page to add a constant value.

    Step 11
  12. Click the Menu Name look up button.

    Step 12
  13. Note that a list of constants is available only for fields that have translate values or an assigned prompt table.

    Step 13
  14. Select the value that you want from the result list by clicking its associated link.

     

    If you are working with a date field, you can select a date/constant from a calendar.

     

    Click the APPLICATION ENGINE link.

    Step 14
  15. The Select a Constant page appears again with the selected value in the field.

     

    If more than one field exists on this page, you must repeat selecting each field to further narrow your search for the constant.

    Step 15
  16. Click the OK button.

    Step 16
  17. The Edit Criteria Properties page appears with the selected value in the Define Constant section.

    Step 17
  18. Click the OK button.

    Step 18
  19. Click the Save button.

    Step 19

You have successfully selected a constant value.

Table of Contents  Start Topic