Difference between revisions of "Common:Searching Different Kinds of Fields in APIs"
From AgileApps Support Wiki
imported>Aeric (Created page with "====Text search==== :Search for records where the <tt>last_name</tt> field contains the string <tt>'smith'</tt>: ::<tt>last_name contains 'smith'</tt> :Search for records where t…") |
(No difference)
|
Latest revision as of 00:04, 20 September 2011
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