go back to TableRowService

GET /{table}/unvalidatedsearch

Searches the database for provided table matching the given request parameters.

Roles that can access this endpoint are Users.

Parameters

name description type default type
table path String
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.

context HttpServletRequest

Result

List < ReadOnlyRow > of type: application/xml application/json

a list of table row objects matching the row class of the provided table.

Try It Out

Request

- Authentication Help
- String