Begin by navigating to the Criteria page.
Click the Reporting Tools link.Step 1
Click the Query Manager link.Step 2
In this example, you will search for the PT_SEC_ACCESSLOG_DAY query.
Enter the desired information into the begins with field. Enter
Click the Search button.Step 4
In this example, select the PT_SEC_ACCESSLOG_DAY query.
Click an entry in the Edit column.Step 5
Click the Criteria tab.Step 6
Use the Criteria page to view and edit selection criteria for your query statement.Step 7
Use the Add Criteria button to access the Edit Criteria Properties page.
Click the Add Criteria button.Step 8
Use the Edit Criteria Properties page to edit existing criteria or add additional criteria.Step 9
Click the Choose Record and Field button.Step 10
Click the User ID link.Step 11
Click the Condition Type list.Step 12
Click the in tree list item.Step 13
Use the New Node List link to access the Select a Tree page.Step 14
In this example, you want to add a new node list.
Click the New Node List link.Step 15
Use the Select a Tree page to select a predefined tree from the list.Step 16
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
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
In this example, you want to select the QE_JOBCODES tree.
Click an entry in the Tree Name column.Step 19
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
The QE_JOBCODES tree appears on the Display and Select TreeNodes page.Step 21
Click the Expand Node button.Step 22
Click the Corporate Officer link.Step 23
Click the Add To Node Selection List button.Step 24
Click the OK button.Step 25
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
Click the OK button.Step 27
Click the Save button.Step 28
You have successfully added comparison value to an expression list.
Table of Contents Start Topic