The select clause describes the query result. It specifies a list of names that identifies the object properties (columns of the result) to return. Its syntax is the same as an SQL select clause; use commas to separate parts of the clause. Each part of the clause must specify a property from one of the predefined views. The columns returned in the QueryResultSet object appear in the same order as the properties specified in the select clause.
The select clause does not support SQL aggregation functions, such as AVG(), SUM(), MIN(), MAX(), or COUNT().
Example select clauses
Gets the object types of the associated objects and the assignment reasons for the work items.
Gets all object IDs of objects for which the caller has a work item without duplicates.
Gets the names of the activities the caller has work items for and their assignment reason.
Gets the states of the activities and the starters of their associated process instances.
If an error occurs during the processing of the select clause, a QueryUnknownTable or a QueryUnknownColumn exception is thrown with the name of the property that is not recognized as a table or column name.