Difference between revisions of "REST API:Dynamic Search"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 16: | Line 16: | ||
:*<tt>pageSize</tt> - Number of records to retrieve from the result set in order to make a "page". | :*<tt>pageSize</tt> - Number of records to retrieve from the result set in order to make a "page". | ||
:*<tt>page</tt> - Number of the logical page in a database result set. The first page is page "zero" (0). | :*<tt>page</tt> - Number of the logical page in a database result set. The first page is page "zero" (0). | ||
:: So appending these parameters returns a single record: <tt>&pagesize=1&page=0</tt> | |||
:*<tt>sortBy</tt> - Field name for primary sort<br/>Ex: <tt>&sortBy=name</tt> | :*<tt>sortBy</tt> - Field name for primary sort<br/>Ex: <tt>&sortBy=name</tt> | ||
:*<tt>sortOrder</tt> - Sort order of the primary field, either <tt>"asc"</tt> or <tt>"desc"</tt> (ascending or descending)<br/>Ex: <tt>&sortOrder="desc"</tt> | :*<tt>sortOrder</tt> - Sort order of the primary field, either <tt>"asc"</tt> or <tt>"desc"</tt> (ascending or descending)<br/>Ex: <tt>&sortOrder="desc"</tt> |
Revision as of 00:17, 21 September 2011
- Query Parameters
- fieldList - A comma-separated list of field names to retrieve
- The asterisk (*) wildcard specifies all fields
- Use the REST API:field Resource to get a complete list of fields
- Field lists for database views need to specify the object's alias, as well as the field name.
- filter - Filtering criteria to filter the records
- For more examples, see Filter Expressions in REST APIs and the REST API Examples.)
- pageSize - Number of records to retrieve from the result set in order to make a "page".
- page - Number of the logical page in a database result set. The first page is page "zero" (0).
- So appending these parameters returns a single record: &pagesize=1&page=0
- sortBy - Field name for primary sort
Ex: &sortBy=name - sortOrder - Sort order of the primary field, either "asc" or "desc" (ascending or descending)
Ex: &sortOrder="desc" - sortBy2 - Field name for secondary sort
- sortOrder2 - Sort order of the second field, either "asc" or "desc" (ascending or descending)
- For more information, see: Specifying Query Parameters in REST APIs
This segment has two formats: One for normal searches, and another for searching Composite Objects. It generally isn't possible to embed templates and conditionals, so this page duplicates the format of Template:Query Parameters.