AgileApps Support Wiki Pre Release

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
  • 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.