Supported Operators
The following is a list of supported operators:
| Operator | Description | Data Types |
|---|---|---|
| eq | Equals | ALL |
| ne | Not equals | ALL |
| in | In
Note: Use comma as value separator and double quotes as text qualifier in case the value itself contains comma. |
ALL except Boolean |
| ni | Not In
Use in record query web services to exclude multiple values in your search filter. For example, if you want to retrieve all the records with PRODUCTIDEXT not in 2 and 3. |
String, Number, and Date |
| lk | Like | String, File |
| nl | Not Like | String, File |
| sw | Starts With | String, File |
| ew | Ends With | String, File |
| sl | Sounds like | String, File |
| gt | Greater than | Number, Date, and Timestamp |
| ge | Greater than equals | Number, Date, and Timestamp |
| lt | Less than | Number, Date, and Timestamp |
| le | Less than equals | Number, Date, and Timestamp |
| bw | Between | Number, Date, and Timestamp |
For the string type attributes, additionally, you can check for case sensitivity using caseSensitive. It specifies whether a case sensitive query is to be done. The default is false.
Copyright © Cloud Software Group, Inc. All rights reserved.