Defining Criteria


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_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 Add Criteria button to access the Edit Criteria Properties page, where you can add additional criteria.

    Step 8
  9. Use the Group Criteria button to access the Edit Criteria Grouping page, where you can group your criteria logically.

    Step 9
  10. Use the Reorder Criteria button to access the Edit Criteria Ordering page, where you can reorder the criteria positions for your query.

    Step 10
  11. Use the Edit button to the right of the required criteria to edit it.

    Step 11
  12. Use the Delete button to the right of the required criteria to delete it.

    Step 12
  13. In this example, you want to add a criteria.

     

    Click the Add Criteria button.

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

    Step 14
  15. Select the Field option if you want to base the selection criterion on another field’s value, usually a field in another record component.

     

    When you select this option, you must then select an appropriate comparison operator from the Condition Type list.

    Step 15
  16. Select the Expression option if you want PeopleSoft Query to evaluate an expression that you enter before comparing the result to the value in the selected field.

     

    When you select this option, you must click the New Expression link to create a new expression and then select an expression type.

    Step 16
  17. In this example, you will select a field.

     

    Click the Select Record and Field button.

    Step 17
  18. In this example, use the Message Name field.

     

    Click the Message Name link.

    Step 18
  19. Click the Condition Type list.

    Step 19
  20. In this example, you will use the is not null condition type.

     

    Click the is not null list item.

    Step 20
  21. Click the OK button.

    Step 21
  22. Click the Save button.

    Step 22

You have successfully defined criteria.

Table of Contents  Start Topic