The $query
parameter allows you to combine multiple SoQL clauses together into a single parameter, for convenience. Similar to SQL, clauses must be specified in a specific order:
Note that unlike SQL, there is no FROM
clause.
For example, you could combine $select
and $where
parameters together as follows:
For a full listing of the functionality available in SoQL, check out the the SoQL documentation.