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 |
|
|