Welcome > Queries > Create a System query

Create a System query

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

See Queries.

  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 are displayed.

    Note 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 of 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 in the query.
  11. Click Save.
    Note

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

    Note 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 Assigned resource.

  • Core worker service

  • Export service

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

  • Transformation server service

Activity SLA

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

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)

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

  • Awaiting allocation

  • Awaiting events

  • On hold

  • Pending

  • Pending & saved

  • Saved

  • Suspended

  • Taken

Priority type

Allows selection of priority type as Activity or Job. (Default: Activity)

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

Note

  • This option is only available if you select the Completed work option.

  • This option is disabled if you set the criteria of Completed by as Assigned resource and "Anyone".

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

Due date

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

Note

  • If Completed work is selected, the Due date field changes to 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>