Welcome > Queries > Create a Work queue query

Create a Work queue query

The Work queue queries help you search for required activities.

See Queries.

  1. Navigate to Queries > Work queue queries.

    The Work queue queries page appears.

  2. Click New.

    The New workqueue query dialog box is displayed.

  3. Enter a Name for the query.
  4. Select the Category in which to create a work queue 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.

    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. Specify the Filter criteria .
  7. Define the metadata.
    1. Select a Work type and the Filter operator.
    2. Configure and add the required meta fields.
  8. Click Save.

Filter criteria for a work queue query

The following table describes the work queue fields available as search criteria:

Work queue field

Description

Activity name

Name of the activity.

Type

The type of activity. All, Normal, or Alert. (Default: All)

Assigned to

Includes Me, Me and My groups, My direct subordinates, Me and My direct subordinates, My subordinates, and Me and My subordinates.

Activity SLA

Current status of the activity. All, 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.

Priority type

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

Priority

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

Retrieval limit

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

Case tasks only

If selected, allows the display of activities that belong to cases.

The following table describes the job fields, dates and metadata available as search criteria.
Work queue field Description

Job ID

ID of the case job.

Process

Select a process 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

Includes All, Since, Between, Today, This week, This month & This year.

Metadata

Creates a filter criteria by selecting the work type and corresponding fields.

Sort columns in a work queue query

  1. Navigate to Queries > Work queue queries.

    The list of work queue queries appear.

  2. Open the work queue query in which to sort the columns.

    The Edit workqueue query dialog box is displayed.

  3. Click the Sorting tab.

    The Sorting tab is only displayed if the Work queue setting under Enable custom sorting is selected in the System >System settings>System>General.

  4. 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)
    2. Sort Order 2 (Default: Priority, Ascending)
    3. Sort Order 3 (Default: Pending time, Ascending)

      Note When a Work queue control is added to a new form, by default None is displayed on the sort order list. For upgraded and imported forms, the None option is available but the selected column remains as is. None property is used for client side sorting and is applied to the result set returned, even when custom server side sorting is enabled. Therefore, the results are sorted on the server and returned, and then client side sorting is applied. We recommend that you set client side sorting to None when using server side sorting.

  5. Click Save.

    At runtime, the sorted results are displayed in the Work queue control in the order specified in the query. If you select Pending Time as display column, the time the activity became pending is displayed in the results.

See also: