SQL features and functions have been added to the dynamic query API.
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 Object API is documented in the Developer Guide for Windows and Windows Mobile.
The additions are intended to permit developers 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.