Using User-Defined Attributes

If a user-defined attribute is used in the SELECT statement of a paginated query, the attribute and its type should be included in the request, otherwise a database query must be made to get the type of the user-defined attribute, making the request less efficient.

To include the attribute and type in the request, use the names and types parameters with the queryProcessInstances and queryProcessInstancesAlt functions.

For the queryProcessInstanceCount function (which doesn't provide the names and types parameters), you can specify a type casting as an in-place alternative. For example: 

   SELECT MODULE.NAME, INSTANCE.ID, LONG(BALANCE), DOUBLE(PAYMENT)