Arbitrary Find

The arbitrary find method provides custom device applications the ability to dynamically build queries based on user input.

In addition to allowing for arbitrary search criteria, the arbitrary find method lets the user specify the ordering of the results and object state criteria. A Query class is included in the client object API’s core classes. The Query class is the single object passed to the arbitrary search methods and consists of search conditions, object/row state filter conditions, and data ordering information.

Define these conditions by setting properties in a query:

TestCriteria – criteria used to filter returned data.
SortCriteria – criteria used to order returned data.
Skip – an integer specifying how many rows to skip. Used for paging.
Take – an integer specifying the maximum number of rows to return. Used for paging.

TestCriteria can be an AttributeTest or a CompositeTest.

Dynamic Query
You can construct a query SQL statement to query data from a local database. This query may across multiple tables (MBOs).
SortCriteria
SortCriteria defines a list of SortOrder, which contains an attribute name and an order type (ASCENDING or DESCENDING).
Paging Data
On low-memory devices, retrieving up to 30,000 records from the database may cause the custom client to fail and throw an OutOfMemoryException.

Parent topic: Query and Related Classes