Sorting and Filtering Work Lists
There are a number of WorkListService operations that are used to define the sort and/or filter criteria to be applied to a work item list.
They are:
- getWorkItemOrderFilter (Request message)—Get the fields defined by BRM that can be used to define sort/filter criteria for a work item list.
- setResourceOrderFilterCriteria (Request message)—Set sort/filter criteria for work lists for a resource.
- getResourceOrderFilterCriteria (Request message)—Get (previously defined) sort/filter criteria for work lists for a resource.
These expressions can include an expression defining the sort and/or filter criteria to be applied to the work list. The following operations, used to retrieve work lists, can also include the same expressions:
- getWorkListItems (Request message)—Get a work list for an organization model entity.
- getAllocatedWorkListItems (Request message)—Get an allocated work list for an organization model entity.
The syntax and criteria for sort/filter expressions is the same for each of these operations.
The default sort criteria, used to display a work list if no other sort is specified, are defined by the defaultSort property in the brm.properties file. See "Configuring TIBCO ActiveMatrix BPM Resource Management" in TIBCO ActiveMatrix BPM - BPM Administration for this property.
Filtering Performance Considerations
Some installations that make heavy use of filtering in TIBCO ActiveMatrix BPM may benefit from either tuning of existing database indexes or the creation of new indexes. Work items can be filtered and ordered on any number of columns that are present on the brm_work_items table. On a standard installation, only the first four attributes are indexed. If Work List ordering and filtering is being applied to columns that aren't indexed, for example, listing all work items that have attribute19 greater than a specified date, then both filter and overall system performance may benefit if the database administrator adds an index to the attribute19 column.