Selecting Condition Types

The condition type determines how Query Manager compares the values of the first (left-hand) expression to the second (right-hand) expression.

Query Manager also offers a not option that reverses the effect of each condition type. For example, not equal to returns all rows that equal to would not return.

Note:

You should use the not version of an operator (for example, not equal or not less than) rather than the NOT operator on the entire criterion (for example, AND NOT or OR NOT logical operator). 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.

Condition Types	Return Values
between	The value in the selected record field falls between two comparison values. The range is inclusive.
equal to	The value in the selected record field exactly matches the comparison value.
exists	This operator is different from the others, in that it does not compare a record field to the comparison value. The comparison value is a subquery. If the subquery returns any data, PeopleSoft Query returns the corresponding row.
greater than	The value in the record field is greater than the comparison value.
in list	The value in the selected record field matches one of the comparison values in a list.
in tree	The value in the selected record field appears as a node in a tree created with PeopleSoft Tree Manager. The comparison value for this operator is a tree or branch of a tree that you want PeopleSoft Query to search. Note: PeopleSoft Query should not use trees that contain a combination of dynamic details and range details. The results returned from trees with this combination of details may be inaccurate. See Tree Manager: PeopleSoft Tree Manager Overview.
is null	The selected record field does not have a value in it. You do not specify a comparison value for this operator. Key fields, required fields, character fields, and numeric fields do not allow null values.
less than	The value in the record field is less than the comparison value.
like	The value in the selected field matches a specified string pattern. The comparison value may be a string that contains wildcard characters. The wildcard characters that PeopleSoft Query recognizes are % and _. % matches any string of zero or more characters. For example, C% matches any string starting with C, including C alone. _ matches any single character. For example, _ones matches any five-character string ending with ones, such as Jones or Cones. PeopleSoft Query also recognizes any wild-card characters that your database software supports. See your the documentation for your database management system for details. To use one of the wild-card characters as a literal character (for example, to include a % in your string), precede the character with a \ (for example, percent\%).

Note:

If you select the EFFDT field on an effective-dated table, you can use the effective-date operators in PSQuery.