QRY_Condition.Operator
Class · Group: Query Infrastructure
Learn it: Fast Start - Selectors and Selectors guide
global enum QRY_Condition.OperatorSOQL comparison operators used to build query conditions. Operator SOQL Description EQUALS = Equal to NOT_EQUALS != Not equal to LESS_THAN < Less than LESS_THAN_OR_EQUAL_TO <= Less than or equal to GREATER_THAN > Greater than GREATER_THAN_OR_EQUAL_TO >= Greater than or equal to LIKE_X LIKE Pattern matching IN_X IN Value in set NOT_IN NOT IN Value not in set INCLUDES INCLUDES Multi-select picklist includes EXCLUDES EXCLUDES Multi-select picklist excludes
Inner Classes
| Class | Description |
|---|---|
| EQUALS | The field holds exactly the given value (SOQL =). |
| EXCLUDES | Multi-select picklist excludes |
| GREATER_THAN | The field is larger than the given value (SOQL >); for a date or a time, later. |
| GREATER_THAN_OR_EQUAL_TO | The field is equal to the given value or larger (SOQL >=); for a date or a time, the same or later. |
| IN_X | The field holds any one of a list of values, or any value a subquery returns (SOQL IN). |
| INCLUDES | Multi-select picklist includes |
| LESS_THAN | The field is smaller than the given value (SOQL <); for a date or a time, earlier. |
| LESS_THAN_OR_EQUAL_TO | The field is equal to the given value or smaller (SOQL <=); for a date or a time, the same or earlier. |
| LIKE_X | Pattern matching (LIKE) |
| NOT_EQUALS | The field does not hold the given value (SOQL !=). |
| NOT_IN | The field holds none of a list of values, or none of the values a subquery returns (SOQL NOT IN). |
Value Details
EQUALS
global EQUALSThe field holds exactly the given value (SOQL =). With a null value, the field is blank.
EXCLUDES
global EXCLUDESMulti-select picklist excludes
GREATER_THAN
global GREATER_THANThe field is larger than the given value (SOQL >); for a date or a time, later.
GREATER_THAN_OR_EQUAL_TO
global GREATER_THAN_OR_EQUAL_TOThe field is equal to the given value or larger (SOQL >=); for a date or a time, the same or later.
IN_X
global IN_XThe field holds any one of a list of values, or any value a subquery returns (SOQL IN). The name ends in _X because IN is a reserved word in Apex.
INCLUDES
global INCLUDESMulti-select picklist includes
LESS_THAN
global LESS_THANThe field is smaller than the given value (SOQL <); for a date or a time, earlier.
LESS_THAN_OR_EQUAL_TO
global LESS_THAN_OR_EQUAL_TOThe field is equal to the given value or smaller (SOQL <=); for a date or a time, the same or earlier.
LIKE_X
global LIKE_XPattern matching (LIKE)
NOT_EQUALS
global NOT_EQUALSThe field does not hold the given value (SOQL !=). With a null value, the field has a value.
NOT_IN
global NOT_INThe field holds none of a list of values, or none of the values a subquery returns (SOQL NOT IN).