request |
read for query parameters to be used as search criteria; use any combination of fields from the
provided table using a prefix of the table name or no prefix.
For example, /order_type/search?order_type.is_active=Y would find all active order
type codes.
Sorting: To sort the result set, you can provide the following reserved
query parameter: orderBy If the orderBy parameter is not provided a default sort of
the provided tables primary key+ASC will be applied.
For example,
/order_type/search?order_type.id=*&orderBy=order_type.descr+DESC
would return all order_type records sorted descending by the order_type description. Multiple
sort columns can be provided in a comma delimited format.
orderBy=prefix.field+direction,prefix.field+direction
Pagination: To page the result set, you can provide the following
reserved query parameters: recordLength and recordOffset
For example,
/order_type/search?order_type.is_active=Y&recordLength=100&recordOffset=50
would return 100 records starting at the 51st record in the return record set. If no recordLength
parameter is provided the search result maximum value in the mobile service control file will be
applied. Note: Result size is limited to 1000 records unless specifically configured using
the
-Dloadmaster.api.maxresultsize vmparam. |
context
|
|
HttpServletRequest
|