Arbitrary Find

The arbitrary find method lets custom device applications dynamically build queries based on user input. The Query.DISTINCT property lets you exclude duplicate entries from the result set.

The arbitrary find method also lets the user specify a desired ordering of the results and object state criteria. A SUPQuery class is included in the client object API. The SUPQuery 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:

SUPTestCriteria – criteria used to filter returned data.
SUPSortCriteria – 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.

SUPTestCriteria can be an SUPAttributeTest or a SUPCompositeTest.

TestCriteria
You can construct a query SQL statement to query data from a local database. You can create a SUPTestCriteria object (in this example, AttributeTest) to filter results. You can also query across multiple tables (MBOs) when using the executeQuery API.
SUPAttributeTest
An SUPAttributeTest defines a filter condition using an MBO attribute, and supports multiple conditions.
SortCriteria
SortCriteria defines a 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: SUPQuery and Related Classes