Adding Comparison Values to an Expression List


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_SEC_ACCESSLOG_DAY query.

     

    Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "pt_sec"
    .

    Step 3
  4. Click the Search button.

    Step 4
  5. In this example, select the PT_SEC_ACCESSLOG_DAY query.

     

    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.

     

    Click the Add Criteria button.

    Step 8
  9. Use the Edit Criteria Properties page to edit existing criteria or add additional criteria.

    Step 9
  10. Click the Choose Record and Field button.

    Step 10
  11. Click the User ID link.

    Step 11
  12. Click the Condition Type list.

    Step 12
  13. Click the in tree list item.

    Step 13
  14. Use the New Node List link to access the Select a Tree page.

    Step 14
  15. In this example, you want to add a new node list.

     

    Click the New Node List link.

    Step 15
  16. Use the Select a Tree page to select a predefined tree from the list.

    Step 16
  17. If you do not know the name of the tree, use this Search button to perform a search for the tree.

     

    Click the Search button.

    Step 17
  18. Click the name of the tree that you want to display on the Display and Select TreeNodes page, which you can use to select which element of the tree PeopleSoft Query checks.

    Step 18
  19. In this example, you want to select the QE_JOBCODES tree.

     

    Click an entry in the Tree Name column.

    Step 19
  20. Use the Display and Select TreeNodes page to view and select a list of values for PeopleSoft Query to compare to the value from the first expression.

    Step 20
  21. The QE_JOBCODES tree appears on the Display and Select TreeNodes page.

    Step 21
  22. Click the Expand Node button.

    Step 22
  23. Click the Corporate Officer link.

    Step 23
  24. Click the Add To Node Selection List button.

    Step 24
  25. Click the OK button.

    Step 25
  26. If the Select Nodes List has been previously populated, you can either:

    •  Change the tree by clicking the New Nodes List link.

    •  Open the previously selected tree, bypassing the Tree Selection page, by clicking the Edit Node List link.

    Step 26
  27. Click the OK button.

    Step 27
  28. Click the Save button.

    Step 28

You have successfully added comparison value to an expression list.

Table of Contents  Start Topic