IBM BPM, V8.0.1, All platforms > Programming IBM BPM > Developing client applications for BPEL processes and tasks > Queries on BPEL process and task data > Business Process Choreographer EJB query API > Syntax of the API query method

Select clause

The select clause in the query function identifies the object properties that are to be returned by a query.

The select clause describes the query result. It specifies a list of names that identify the object properties (columns of the result) to return. Its syntax is similar to the syntax of an SQL SELECT clause; use commas to separate parts of the clause. Each part of the clause must specify a column from one of the predefined views. The columns must be fully specified by view name and column name. The columns returned in the QueryResultSet object appear in the same order as the columns specified in the select clause.

The select clause does not support SQL aggregation functions, such as AVG(), SUM(), MIN(), or MAX().

To select the properties of multiple name-value pairs, such as custom properties and properties of variables that can be queried, add a one-digit counter to the view name. This counter can take the values 1 through 9.

Examples of select clauses

• "WORK_ITEM.OBJECT_TYPE, WORK_ITEM.REASON"

  Gets the object types of the associated objects and the assignment reasons for the work items.

• "DISTINCT WORK_ITEM.OBJECT_ID"

  Gets all of the IDs of objects, without duplicates, for which the caller has a work item.

• "ACTIVITY.TEMPLATE_NAME, WORK_ITEM.REASON"

  Gets the names of the activities the caller has work items for and their assignment reasons.

• "ACTIVITY.STATE, PROCESS_INSTANCE.STARTER"

  Gets the states of the activities and the starters of their associated process instances.

• "DISTINCT TASK.TKIID, TASK.NAME"

  Gets all of the IDs and names of tasks, without duplicates, for which the caller has a work item.

• "TASK_CPROP1.STRING_VALUE, TASK_CPROP2.STRING_VALUE"

  Gets the values of the custom properties that are specified further in the where clause.

• "QUERY_PROPERTY1.STRING_VALUE, QUERY_PROPERTY2.INT_VALUE

  Gets the values of the properties of variables that can be queried. These parts are specified further in the where clause.

• "COUNT( DISTINCT TASK.TKIID)"

  Counts the number of work items for unique tasks that satisfy the where clause.

Syntax of the API query method