Search examples

Some search examples might be helpful for understanding the various searches that you can run.

Currently running work items

You can search for all work items that are currently running in the isolated region.

To search for all running work items:

Search result type Work items
Workflow structure Workflow roster
Workflow structure name DefaultRoster

Obsolete tracker work items

You can search for obsolete tracker work items. Normally, tracker work items are terminated by individual trackers. Tracker work items remain in the system until they are manually terminated.

To search for obsolete tracker work items:

Search result type Work items
Workflow structure User Queue
Workflow structure name Tracker(0)
Search mode Editable
Search Filter: User Criteria Optionally select one or more specific users.
Search Filter: General Criteria F_Overdue = 3

User work items

You can search for the work items that are assigned to particular users.

To search for all user-assigned work items:
Search result type Work items
Workflow structure User Queue
Workflow structure name Inbox
Search Filter: User Criteria Add one or more users to the filter list

Work items in an error state

You can search for work items that are in error state. To fix the problem, you might use the administration console, Process Tracker, or other tools.

To search for work items in an error state:
Search result type Work items
Workflow structure Work Queue
Workflow structure name Conductor

Work items launched after a particular date

You can search for the work items that were launched after a particular date and time.

To search for work items with date-related search criteria:
Search result type Work items
Workflow structure Workflow roster
Workflow structure name DefaultRoster
Search Filter: General Criteria F_StartTime > 11/25/2010 11:59 pm

F_StartTime is the time of launch for the workflow. All the work items for the same workflow have the same launch time. The date can be entered in a number of formats. For information about these formats, see Valid date/time formats.

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