Create a System query

You can create a system query and view the completed work performed in the system.

  1. Navigate to Queries > System queries.

    The System queries page appears.

  2. Click New.

    The New system query dialog box is displayed.

  3. Enter a Name for the System query.
  4. Select the Category in which to create a system query.

    By default, the query is added to your working category.

  5. 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 is displayed.

    If you select this option, there may be a performance overhead.

  6. To specify the number of the latest activities that are to be retrieved from the server at a given point in time, set the Retrieval limit. (Default: 100)
  7. To view the completed work performed in the system to help you analyze and identify the areas of concern, select Completed work. (Default: Clear)
  8. Specify the filter criteria.
  9. Define the metadata.
    1. Select a Work type and the Filter operator.
    2. Configure and add the required meta fields.
  10. Add columns, provide access control, and sort columns, and add filter fields in the query.
  11. Click Save.

    • When you run the system query, all activity types including the custom service activities if any are included in the query.

    • When you use the system query in a Chart control, the custom service activities are also displayed.

    • When you run a system query that filters on a specific custom service grouping, only activities of that type are displayed.

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:

  • Anyone (manual work assigned to any role, resource, or group)

    If "Completed work" is selected, the "Assigned to" field changes to "Completed by".

  • Assigned resource

  • Resource (Group or Individual)

    This field is only available when you select an assigned resource.

  • Core worker service

  • Export service

  • System (Default. Includes Core worker service, Transformation Server service, and Export service)

  • Transformation Server service

Activity SLA

The status of the activity. Green, Amber, Red (Default: All)

The activity SLA 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.

Work queue automation

If selected, allows you to retrieve tasks completed by Work queue automation.

This option is only available if "Completed work" is selected and if you set "Completed by" as "Anyone" or "Assigned resource".

Pending time

Displays for how long the activity has been pending. The values include:

  • All (Default)

  • Less than 5 minutes

  • More than 5 minutes

  • Less than 15 minutes

  • More than 15 minutes

  • Less than 30 minutes

  • More than 30 minutes

  • Less than 60 minutes

  • More than 60 minutes

  • Less than 1 day

  • More than 1 day

  • Less than 7 days

  • More than 7 days

  • Less than 30 days

  • More than 30 days

Activity status

Displays the status of the activity as:

  • All (Default)

    If "Completed work" is selected, the default "Activity status" changes to "Completed".

  • Awaiting events

  • Evaluation failed

    This status is only available when you search for work assigned to the Core worker service, Export service, System, and Transformation Server service.

  • Locked

    This status is only available when you search for work assigned to the Core worker service, Export service, System, and Transformation Server service.

  • On hold

  • Pending

  • Suspended

  • Taken

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 from 1 to 10 and for job priority, accepted values are from 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 Create new job. (Default: All)

The Node type drop-down also includes the custom service groups only when the "Assigned to" field is set to System or Core worker service.

Suspend reason

The reason for suspension of the job.

Machine name

Displays the list of available machine names (default: All). The machine name is available as a column and on the sorting order list.

  • This option is not available if you set "Assigned to" as "Anyone" and "Assigned resource".

  • This option is not available if you set the criteria of Completed by (if "Completed work" is selected) as "Anyone" and "Assigned resource".

The following table describes the time filters, job fields, dates, and metadata available as search criteria.

Field

Description

Time filters

Time pending

Displays how long the activity has been pending for a specific period in days, hours, minutes, and seconds.

For example, you can search for activities that are pending for less than 5 seconds, greater than 1 minute or greater than 4 hours, or greater than 2 days 6 hours.

Time spent

Displays how many seconds it took to complete the activity (that is, how long the activity was in a taken state) in days, hours, minutes, and seconds.

For example, you can search for the activities that took less than 5 seconds to complete, or greater than 1 minute, or greater than 4 hours, or greater than 2 days 6 hours.

The Time spent filter becomes available only when you select Completed work at both design time and runtime.

Job

Job ID

The ID of the case job.

Process

Allows selection of a Process or Case based on which the job is created.

Job SLA

The status of the job. All, Green, Amber, Red (Default: All)

The job SLA 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.

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)

Dates

Due date

Available options are All (default), Since, Between, Today, This week, This month, and This year.

  • If "Completed work" is selected, the "Due date" field changes to the Completed date.

  • If the due date option is "Since" or "Between", you can provide a value to be "@Today" or a certain number of days from today in the following format:

    @Today +/- NUM. For example, <@Today - 7>

Metadata

Creates filter criteria by selecting the work type and corresponding fields. See Create metadata.