Search Operators and Data Types
The following table lists the operators that you can select while searching records for different data types:
| Description | Data Types |
|---|---|
| equals | ALL |
| not equals | ALL |
| is defined | ALL |
| is not defined | ALL |
| in | ALL supported data types except Boolean |
| not in | ALL supported data types except Boolean |
| like | String, File |
| not like | String, File |
| starts with | String, File |
| ends with | String, File |
| sounds like | String, File |
| greater than | Number |
| greater than equals | Number |
| less than | Number |
| less than equals | Number |
| later than | Date and Timestamp |
| earlier than | Date and Timestamp |
| later than or equals | Date and Timestamp |
| earlier than or equals | Date and Timestamp |
| between | Number, Date, and Timestamp |
Copyright © Cloud Software Group, Inc. All rights reserved.