UAConnect: Understand Criteria Condition Types

The more you use Query Manager, the more you are likely to refine queries with conditions other than the Equal To condition that is the default.

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 subquery. If the subquery returns any data, Query Manager 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.
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 fields is less than the comparison value.
Like The value in the selected fields matches a specified string pattern. The comparison value may be a string that contains wildcard characters. The wildcard characters that Query Manager recognizes are Percent (%) and Underscore (_).

% 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.

Updated 01/01/2016

Was this helpful?

Yes    No

IT Services