Queries

Queries help you search for required jobs and activities and view the workload for automatic and manual tasks.

You can create the job, work queue, and system queries, and share these queries with specific individuals or groups. The job queries help you search for required jobs, and the work queue queries to search for required activities. The system queries help you view the workload for automatic and manual tasks so that you can take action to avoid delays in processing tasks, and improve performance. You can view the completed work performed in the system and identify and analyze the areas of concern.

Manage the display of the columns in the queries at runtime by selecting the columns and sorting them in the order of appearance or define a custom sort order and specify the direction for each field as ascending or descending.

You can provide permissions to groups or individual resources to run, view, edit or delete a query.

You can configure the query to display the count of items regardless of the retrieval limit specified in the query where the count is the distinct number of activities in the system. For example, if an activity is assigned directly to you and to a group of which you are a member, the activity is shown twice in your work queue even though it is one distinct activity.

When you view the query in a Job list, Work queue, or Workload control at runtime, the total number of items matching the query is displayed. The count of items is displayed in brackets beside the title above the table.

How to:

• Create a Job query

• Create a Work queue query

• Create a System query

• Manage columns in queries

• Provide access control for a query

• Sort columns in a query

• Manage queries