Try OpenEdge Now
skip to main content
BP Server Developer's Guide
Query service : Working with filters : Filter properties

Filter properties

A filter has the following properties:
*Name — Name of the Filter.
*Type — WorkItem, WorkStepInstance, or ProcessInstance type.
*Condition — Condition can be set on the filter. QSWorkItemFilter condition should not contain the performer of the WorkItem, and the WorkStepInstance and the ProcessInstance Filter condition should not contain the creator of the process instance.
*Additional columns — It might be necessary to retrieve dataslot values with WorkStepInstance data. Therefore, additional columns can be added to the Filter in java.util.List. Note that you can use only dataslots in the additional column.
*Order By — The order by which the data is to be retrieved can be specified in the Filte.
*ProcessName — The application name can be optional in the Filter. However, if a dataslot is used in the condition, additional columns, or order properties, then the process name is mandatory.
*FetchSize — The size of the SVO for every request to the Filter may be more than 500 items, but the user may want only the first 100 items at any time. In that case, the fetch size can be set to 100 items. The returned SVO list size is equal to 100 items or the ResultSet size, whichever is less. If the user does not set fetch size explicitly, then the default value is 100 items. User can set the fetch size by calling the setFetchSize() method on the QSFilter object.
*Connection — It is required sometimes for the QueryService requests to be part of an existing client transaction. In that case, a connection object can be set in the Filter. Note that the Connection is a transient attribute in the Filter, which means the Filter object loses the reference of the Connection during serialization and deserialization.