Changes in the Object API in SDK 2.1. If your application is built with an earlier
version of the SDK, update your application to include the required or recommended API
changes.
Object Query Enhancements
The Object API provides increased access to the underlying relational persistence
layer. SQL features and functions have been added to the dynamic query method,
ExecuteQuery.
The additions allow you to:
- (Update) Exclude duplicate entries from result sets using the arbitrary find
method Query.DISTINCT property.
- (Update) Define a filter condition using an MBO attribute using the new
conditions, IN, NOT_IN, EXISTS, and NOT_EXISTS. You can nest queries, as well as
use LIKE keywords in queries.
- (New) Use aggregate functions.
- (New) Group your results using specific attributes.
- (New) Specify how your results are filtered.
- (New) Combine the results of multiple queries into a single result set.
- (New) Include subqueries in SELECT statements.
Documented in
Developer Guide: Android Object API Applications,
Developer Guide: BlackBerry Object API Applications,
Developer Guide: iOS Object API Applications, and
Developer
Guide: Windows and Windows Mobile Object API Applications