Edit Criteria Properties Page
The Edit Criteria Properties page is the page on which you define the criteria for your query.
- In addition to accessing the Edit Criteria Properties page from the Criteria page (by clicking on Add Criteria), you can also access it as follows:
- On the Query page – Click the Use as Criteria button (
)
- On the Fields page or the Expressions page – Click the Add Criteria button (
- If the Expression 1 Field is an Effective Date field, there are additional special Effective Date operators that you can select.
Elements on the Edit Criteria Properties Page
Choose Expression 1 Type
- Determines whether the first part of the selection criteria is based on a field or an expression.
- Field – Another field’s value that you want to base the selection criterion on. This is usually a field in another record.
- Expression – An expression which Query uses to evaluate before comparing the result to the value in the selected field.
Expression 1 (Choose Record and Field)
- Contains the value of the first part of the selection criteria.
Condition Type
- Determines how Query Manager compares the first expression value to the second expression value.
- It contains a dropdown list of operators (see Condition Type chart below).
- For each of the condition types, Query Manager offers a “not” option that reverses its effect.
- For example, “Not equal to” returns all rows that “Equal to” would not return.
- Note that it is always better to use the “Not” version of an operator rather than the NOT operator on the entire criterion.
- When you use NOT, PeopleSoft Query cannot use SQL indexes to speed up the data search.
- When you use the “Not” version of an operator, PeopleSoft Query can translate it into a SQL expression that enables it to use the indexes.
Choose Expression 2 Type
- Determines whether the second part of the selection criteria is based on a field, an expression, a constant, a prompt, a subquery, and so on.
- Field – Another field’s value that you want to base the selection criterion on. This is usually a field in another record.
- Expression – An expression which Query uses to evaluate before comparing the result to the value in the selected field.
- Constant – A single, fixed value.
- Prompt – A prompt value
- Subquery – The value in the selected field is compared to the data returned by a subquery.
Expression 2 (Choose Record and Field)
- Contains the value of the second part of the selection criteria.
Condition Type:
The options for selecting the appropriate Operator (Condition Type) are summarized in the following chart:
