Create a System query
You can create a system query and also view the completed work performed in the system.
-
Navigate to
.
The System queries page appears.
-
Click
New.
The New system query dialog box is displayed.
- Enter a Name for the System query.
-
Select the
Category in which to
create a system query.
By default, the query is added to your working category.
-
Optional. Select
Return query total to
view the total number of items matching the query. (Default: Clear)
At runtime, the total number of items regardless of the retrieval limit specified in the query are displayed.
If you select this option, there may be a performance overhead. - To specify the number of the latest activities that are to be retrieved from the server at a given point of time, set the Retrieval limit. (Default: 100)
- To view the completed work performed in the system to help you analyze and identify the areas of concern, select Completed work. (Default: Clear)
- Specify the filter criteria.
-
Define the
metadata.
- Select a Work type and the Filter operator.
- Configure and add the required meta fields.
- Click Save.
Filter criteria for a System query
The following table describes the system fields available as search criteria.
Field |
Description |
---|---|
Activity name |
Name of the activity |
Type |
The type of activity such as All, Normal or Alert. (Default: All) |
Assigned to |
Includes the following:
|
Activity SLA |
Current status of the activity. The activity SLA (Green-Amber-Red) status is the visual representation of the activity status on your work queue to indicate if the activity is within or has exceeded the set time limits, that is, target duration. (Default: All) |
Pending time |
Displays for how long the activity has been pending. The values include:
|
Activity status |
Displays the status of the activity as:
|
Priority type |
Allows selection of priority type as Activity or Job. (Default: Activity)
The Priority type and Priority fields are not
available if Completed work is selected.
|
Priority |
For activity priority, accepted values are 1 to 10 and for job priority, accepted values are 1 to 100. (Highest: 1, Lowest: 10,100) (Default: All) |
Case tasks only |
If selected, displays activities that only belong to cases. (Default: Clear) |
Node type |
Allows selection of an activity type, such as Ordinary activity. (Default: All) |
Suspend reason |
The reason for suspending the job. |
The following table describes the job fields, dates and metadata available as search criteria.
Job field | Description |
---|---|
Job ID |
ID of the case job. |
Process |
Allows selection of a process or case based on which the job is created. |
Job SLA |
Current status of the job. The job SLA (Green- Amber- Red) status is the visual representation of the job status on your work queue to indicate if the job is within or has exceeded the set time limits, that is, target duration. (Default: All) |
Case reference |
Case reference based on which the job is created. |
Job state |
Name of the state associated with the process. |
Due date order |
Allows selection of Activity or Job. (Default: Activity) |
Due date |
Includes All (default), Since, Between, Today, This week, This month and This year. Completed Workis selected, the Due datefield changes to Completed date. |
Sort columns in System queries
You can define a custom sort order using the columns available in System queries.
-
Navigate to
.
The list of system queries appear.
-
Open the system query in which to sort the columns.
The Edit system query dialog box is displayed.
-
Click the
Sorting tab.
The Sorting tab is only displayed if the Workload setting under Enable custom sorting is selected. See Configure the general settings.
-
To specify the sort order, on the list of sort order, select a
column, and specify the direction as
Ascending or
Descending.
-
Sort order 1
(Default: Due date, Ascending)
The default sort order 1 is Completed date and Ascending, if
Completed work
is selected. -
Sort order 2
(Default: Priority, Ascending)
The default sort order 2 is Pending time and Ascending, if
Completed work
is selected. -
Sort order 3
(Default: Pending time, Ascending)
The default sort order 3 is None and Descending, if
Completed work
is selected. -
Click
Save.
At runtime, the sorted results are displayed in the Workload control. If you select the Pending time as display column, the time the activity became pending is displayed in the results.
-
Sort order 1
(Default: Due date, Ascending)
- Click Save.