Welcome > Data module > Queries > Create a System query

Create a System query

  1. On the Home page, click Data > System Query.

    The System Query page appears.

  2. Click the General tab.
  3. Consume the Category in which to create a system query. (Default: Working category)
  4. Enter a Name for the System query.
  5. Optionally, to view the total number of items matching the query, select the check box for Return Query Total.

    At runtime, the total number of items regardless of the retrieval limit specified in the query are displayed.

    Note If you turn this setting on, there will be a performance overhead.
  6. To view the completed work performed in the system to help you analyze and identify the areas of concern, click Yes for Completed Work. (Default: No)
  7. Specify the search criteria. See Filter criteria for a System query.
  8. Define metadata. See Create metadata.
    1. Consume a Work Type.
    2. Configure and add the required meta fields.
  9. Click Save.

Filter criteria for a System query

The following table describes the system fields available as search criteria:

Work Queue Field

Description

Activity Name

Name of the activity.

Type

All, Standard or Alert Task.

Note By default all activity types are selected.

Assigned To

Includes the following:

  • Core Worker Service

  • Transformation Server Service

  • Export Service

  • System (Default. Includes Core Worker Service, Transformation Server Service and Export Service)

  • Resource (specific resource or group)

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

Note If "Completed Work" is set to "Yes", the "Assigned To" field changes to "Completed By".

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:

  • 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

  • Taken

  • Awaiting Allocation

  • Awaiting Events

  • On Hold

  • Pending (Default)

  • Saved

  • Suspended

Note If "Completed Work" is set to "Yes", the "Activity Status" field changes to "Completed".

Priority Type

Allows selection of Activity or Job. (Default: Activity)

Priority

For Activity Priority, accepted values are 1 to 10 and for Job Priority, accepted values are 1 to 100. 1 being the highest and 10/100 lowest.

Case Tasks Only

Allow display of activities that only belong only to cases. (Default: No)

Retrieval Limit

The number of the latest activities that are to be retrieved from the server at a given point in time.

Node Type

Allows selection of an activity type, such as Ordinary Activity. (Default All)

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

Consume a process 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.

Case Ref

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, Since, Between, Today, This Week, This Month and This year.

Note If "Completed Work" is set to "Yes", the "Due Date" field changes to Completed Date.

Metadata

Create a filter criteria by consuming the work type and selecting the corresponding fields, such as Field Operator, Meta Field, Operator and Value.

Sort columns in a System query

  1. On the Home page, click Data > System Query.
  2. Click the Sorting tab.

    The Sorting tab is only displayed if the Enable Workload Custom Sorting option is set to Yes. See Work process.

  3. To specify the sort order, on the list of sort order, select a column, and specify the direction as Ascending or Descending.
    1. Sort Order 1 (Default: Due Date, Ascending)
      The default sort order 1 is Completed Date and Ascending, if "Completed Work" is set to "Yes".
    2. Sort Order 2 (Default: Priority, Ascending)
    3. Sort Order 3 (Default: Pending For, Ascending)
  4. 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.