Editing Criteria Properties

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