Query Builder Statement Operators

When you add a conditional statement, you must select an operator. The operator is used to determine whether or not a record meets the criteria defined in a conditional statement. When you add a conditional statement, the default operator and other available operators depend on the field type.

The following table describes all of the possible operators.

Operator Selects a record if the applicable field contains a value that:
Starting With Starts with the value defined in the Value is box.
Contains Contains the string defined in the Value is box.
(=) equal to Equals the value defined in the Value is box.
(<>) not equal to Is not equal to the value defined in the Value is box.
(<) less than Is less than the value defined in the Value is box.
(<=) less than or equal to Is less than or equal to the value defined in the Value is box.
(>) greater than Is greater than the value defined in the Value is box.
(>=) greater than or equal to Is greater than or equal to the value defined in the Value is box.
In Contains one of the strings defined in the Value is box, such as an embedded literal OR statement. You must use quotation marks around any values to indicate what it should search for.
does not contain data Is null (contains no value).
does contain data Is not null (contains any value).
within last xxx days Is a date within the last "xxx" days (past). Enter either an integer or two integers separated by a comma for a date range.
within next xxx days Is a date within the next "xxx" days (future). Enter either an integer or two integers separated by a comma for a date range.

Related Topics

Query Builder Overview

 

 

What's New in this Release

 

For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at documentation@infor.com.