Sorting and Filtering Work Lists
Work lists can be sorted and filtered so that they list only the desired work items, in the desired order.
The WorkListService contains the following functions to get and set sort and filter criteria:
- getWorkItemOrderFilter - Get the fields that can be used to define sort and filter criteria for a work list.
- setResourceOrderFilterCriteria - Sets sort and filter criteria for work lists for a specified resource.
- getResourceOrderFilterCriteria - Gets sort and filter criteria, which was previously set with the setResourceOrderFilterCriteria function, for work lists for a specified resource.
Note, however, sort and filter criteria can also be specified when retrieving work lists using the getWorkListItems, getWorkListItemsAllResources, and getAllocatedWorkListItems functions.
The syntax and criteria for sort and filter expressions is the same regardless which of the methods described above is used to set the criteria..
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. For information about this property, see "Configuring TIBCO ActiveMatrix BPM Resource Management" in TIBCO ActiveMatrix BPM - BPM Administration .
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 sorted 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 sorting 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.