These operators are used while creating a List.
Operator Definition and Examples
Operators are data type dependent. For each data type, definitions and examples have been mentioned in detail to understand the correct usage/implementation
Data Types:
- String / Email / Phone
- Date
- Number / Currency
- Boolean
| Data Type | Operators | Definition | Examples |
| String / Email / Phone | is | equals | status = "placed" |
| is not | not equals | status ≠ "placed" | |
| is not empty/ not- null | not equal null AND not equal empty | status ≠ empty AND status ≠ null | |
| is empty/ null | equal empty OR equal null | status = empty OR status = null | |
| contains one of | values that contain the substring |
email contains one of "@gmail" possible values = abc@gmail.com, xyz@gmail.in |
|
| doesn't contains one of | values that does not contain the substring |
email doesn't contains one of "@yahoo" possible values = "abc@gmail.com", "xyz@outlook.in" |
|
| starts with one of the | values that match the string from the start |
name starts with one of "John" possible values = "John R", "John Matthew" |
|
| doesn't starts with one of the | values that do not match the string from the start |
name doesn't starts with one of "John" possible values = "Mick K.", "Ram C" |
|
| ends with one of the | values that match the string from the end |
email ends with one of "@gmail.com", "@yahoo.com" possible values = "abc@gmail.com", "xyz@yahoo.com" |
|
| is one of the | value equals “a” OR value equals “b” | company name = "Dell" OR company name = "Microsoft" | |
| is not one of the | value does not equal “a” AND value does not equal “b” | company name ≠ "Dell" AND company name ≠ "Microsoft" | |
| is within radius of | pin codes are within a specific radius from the source pin code | radius = 20 miles from source pincode (12069) |
| Data Type | Operators | Definition | Examples |
| Date | is after | greater than | date_added > 2023-06-01 |
| is before | less than | date_added < 2023-06-09 | |
| is equal to | equals | date_added = 2023-06-09 | |
| is on or after | greater than equal to | date_added >= 2023-06-01 | |
| is on or before | less than equal to | date_added is <= 2023-06-09 | |
| is empty/ null | not equal null AND not equal empty | date_added is empty OR null | |
| is not empty/ not- null | equal empty OR equal null | date_added ≠ empty AND date_added ≠ null |
| Data Type | Operators | Definition | Examples |
| Boolean | is true | equals true | candidate/active is true |
| is false | equals false | candidate/active is false |
| Data Type | Operators | Definition | Examples |
| Number / Currency | greater than | greater than | value > 5 |
| less than | less than | value < 5 | |
| equals | equals | value = 5 | |
| not equals | not equals | value ≠ 5 |