Common:Searching Different Kinds of Fields in APIs
From AgileApps Support Wiki
Text search
- Search for records where the last_name field contains the string 'smith':
- last_name contains 'smith'
- Search for records where the state field does not contain the string 'CA':
- state != 'CA'
Numeric search
- Search for records where a field value matches a specific number:
- price = 20.00
- Search for records where a field value is less than a specific number:
- price < 20.00
Empty field search
- Search for records where a field is empty:
- price = BLANK