Begin by navigating to the Criteria page.
Click the Reporting Tools link.Step 1
Click the Query Manager link.Step 2
Enter the desired information into the begins with field. Enter
Click the Search button.Step 4
In this case, you will edit the PT_SEC_PLIST_CREF_MENU_CMP_MKT query.
Click an entry in the Edit column.Step 5
Click the Criteria tab.Step 6
Use the Add Criteria button to access the Edit Criteria Properties page.Step 7
In this example, you want to add a new criteria with a list of values.
Click the Add Criteria button.Step 8
Use the Edit Criteria Properties page to determine how this field is used as a criterion for the current query.Step 9
Click the Choose Record and Field button.Step 10
In this example, select the Usage Type field for expression 1.
Click the Usage Type link.Step 11
Click the Condition Type list.Step 12
Click the in list list item.Step 13
Click the List Members look up button.Step 14
Use the Edit List page to build a list of values for PeopleSoft Query to compare to the value from the first expression.
(After you have created such a list, you can also use this page to select from the list.)Step 15
To add a value, enter it into the Value text box.
Enter the desired information into the Value field. Enter
Click the Add Value button.Step 17
The List Members section lists the values that have been selected using the Add Value button.Step 18
Use the Delete Checked Values button to delete a value selected in the List Members group box.Step 19
Use the Add Prompt link to add one or more prompts to the list so that users can enter the comparison values when they run the query.Step 20
In this example, you want to add the predefined list values, such as HTMT and TARG.
Click the Add Value button.Step 21
Click the Add Value button.Step 22
Use the Cancel button to return to the Edit Criteria Properties page without saving selections.Step 23
In this example, you want to accept the values that are listed in the List Members section.
Click the OK button.Step 24
The Edit Criteria Properties page reappears and the selected values are displayed in the Edit List section.Step 25
Click the OK button.Step 26
Click the Save button.Step 27
You have successfully built a list of values.
Table of Contents Start Topic