In addition to allowing for arbitrary search criteria, the arbitrary find method lets the user specify a desired ordering of the results and object state criteria. A Query class is included in the client object API’s core assembly sup-client.dll Sybase.Persistence namespace. The QQuery 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.
The following classes define arbitrary search methods and filter conditions, and provide methods for combining test criteria and dynamically querying result sets.
| Class | Description |
|---|---|
| Query | Defines arbitrary search methods and can be composed of search conditions, object/row state filter conditions, and data ordering information. |
| AttributeTest | Defines filter conditions for MBO attributes. |
| CompositeTest | Contains a method to combine test criteria using the logical operators AND, OR, and NOT to create a compound filter. |
| SUPQueryResultSet | Provides for querying a result set for the dynamic query API. |
In addition queries support select, where, and join statements.
TestCriteria can be an AttributeTest or a CompositeTest.
An AttributeTest defines a filter condition using an MBO attribute, and supports these conditions: