Editing Criteria Properties


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. In this example, you will search for the PT_MSG_PUBTO_NODES query.

     

    Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "pt_msg"
    .

    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. Use the Edit button to access the Edit Criteria Properties page.

     

    In this example, click the Edit button for the Message 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 Expression option.

    Step 10
  11. In this example, you will create a new expression.

     

    Click the New Expression link.

    Step 11
  12. Use the Edit Expression Properties page in Query Manager to create expressions.

    Step 12
  13. Click the Add Field link.

    Step 13
  14. In this example, select the Message Status field.

     

    Click the Message Status link.

    Step 14
  15. The A.MSGSTATUS field appears in the Expression Text field.

    Step 15
  16. Click the OK button.

    Step 16
  17. Click the Condition Type list.

    Step 17
  18. Click the equal to list item.

    Step 18
  19. Click in the Constant field.

    Step 19
  20. Enter the desired information into the Constant field. Enter

     a valid value
     e.g.
     "NEW"
    .

    Step 20
  21. Click the OK button.

    Step 21
  22. Click the Save button.

    Step 22

You have successfully edited query criteria properties.

Table of Contents  Start Topic