IBM FileNet P8, Version 5.2.1

Work items with indexed field values

You can search on indexed field values to find work items.

Simple example

For example, you might have a loan_amount workflow field with a corresponding database field that is indexed. To search for work items with a loan amount 50,000 - 150,000:

Search result type	Work items
Workflow structure	Workflow roster
Workflow structure name	DefaultRoster
Selected index	Select the index with the `loan_amount` field.
Set index search criteria	Min: 50,000 Max: 150,000

Composite-index example

Suppose that you enter the following inclusive search criteria for an index with three fields:

Name	Type	Minimum	Maximum
Lastname	String	Jones	Smith
Firstname	String	John	John
Zipcode	String	12304	34599

This criteria is not equivalent to the following SQL WHERE clause:

WHERE 
(Lastname>=“Jones” AND Lastname<=“Smith”) AND
(Firstname>=“John” AND Firstname<=“John”) AND
(Zipcode>=“12304” AND Zipcode<=“34599”)

Rather, the minimum and maximum criteria are treated as two separate sets of criteria. Based on the table row order as determined by the index, the minimum criteria determines the first search result, and the maximum criteria determines the last search result. For example, suppose the row order to be as follows:

Lastname	Firstname	Zipcode	Row returned?
Adam	John	34623
Jones	Adam	46723
Jones	John	01060
Jones	Tom	12304	Yes
Jones	Tom	23923	Yes
Murphy	Pat	12300	Yes
Smith	Amy	99009	Yes
Smith	John	34509	Yes
Smith	John	99009
Smith	Max	12304