Oracle CRM On Demand REST API Developer's Guide > Using the Oracle CRM On Demand REST API >

Querying a Collection Resource

You can search for specific resources in a collection by using query parameters in the URL to specify your search criteria. You can use a combination of different query parameters to filter, page, and sort the query results. Query terms such as AND, OR, LIKE, TRUE, and FALSE, are case insensitive, while all field identifiers and values are case sensitive. For information about special search fields that you can use to avoid the case sensitivity on the regular search fields, see Special Search Fields.

You can query resource collections using the q URL parameter with query expressions to specify search criteria. The maximum supported expression length is 4096 characters.

The following is the query expression syntax:

QUERY EXPRESSION = FIELD EXPRESSION [; FIELD EXPRESSION]

[FIELD EXPRESSION] = <Field> <OPERATOR> <VALUE> [ANDOR CLAUSE]

[ANDOR CLAUSE] = <AND/OR> <OPERATOR> <VALUE> [ ANDOR CLAUSE]

The following in an example of a query expression:

AccountName='PSKDemo02' OR = 'A. C. Networks'; Reference = false

The previous query expression example is comprised of two field expressions and the two expressions are separated with a semi-colon.

AccountName="PSKDemo02" OR = "A. C. Networks"

Reference = false

The first field expression includes a field (AccountName), an operator (=), a value ("PSKDemo02"), and then an optional ANDOR clause. The ANDOR clause is comprised of either AND or OR (in this example OR), an operator (=), and a value ("A. C. Networks"). Reference is an Account field, where the false value indicates that the account cannot be used as a reference for potential customers or sales representatives to contact.