Object Queries

A SQL statement associated with a mobile business object (MBO), that returns a subset of a result set. For example, an object query is used to filter downloaded data to display a single row of a table when triggered.

Define object queries to return a subset of MBO results, either from an MBO deployed to Unwired Server or a local business object.

Object query usage
MBO type	Usage
Not bound to a data source (local business object)	The requested data must be available on the mobile device. If not, another (syncable) MBO must trigger a synchronization to download the requested data. The query can then continue to return data from the client's local database.
Bound to a data source	Create the query. Call the query from the device application at runtime to display a subset of the results on the device.

Generating Object Queries from Primary Key Attributes
An object query is automatically generated for each mobile business object (MBO) attribute identified as a Primary key, as well as an additional "composite" object query if there are multiple primary keys.
Object Query Definition Guidelines
Understand how to define object queries.
Object Query Indexes
Indexes improve the performance of searches on the indexed attributes (database columns to which the MBO attributes map), by ordering a table's rows based on the values in some or all the attributes. An index locates rows quickly, and permits greater concurrency by limiting the number of database pages accessed. An index also provides a convenient means of enforcing a uniqueness constraint on the rows in a table.
FindAll Object Query Guidelines
Understand FindAll query definition guidelines.

Parent topic: Mobile Business Object Mobility Properties