Welcome > Data module > Queries > Create a Job query

Create a Job query

  1. On the Home page, click Data > Job Query.
  2. Click the General tab.
  3. Consume the Category in which to create a Job query. (Default: Default Category)
  4. Enter a Name for the Job 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. Specify the search criteria. See Filter criteria for a Job query.
  7. Define metadata. See Create metadata.
    1. Consume a Work Type.
    2. Configure and add the required meta fields.
  8. Click Save.

Filter criteria for a Job query

The following table describes the fields available as filter criteria.

Job Field

Description

Type

The type of job such as Job, Case, Associated Job or All.

Created By

Includes the following options:

  • Dynamic: Includes Me, Me and My Group, My Direct Subordinates, Me and My Direct Subordinates, My Subordinate and Me and My Subordinates.

  • Static: Includes individual resource or group resource.

Job Owner

The name of the person who currently owns the job. Select either option:

  • Dynamic: Includes Me, Me and My Group, My Direct Subordinates, Me and My Direct Subordinates, My Subordinate and Me and My Subordinates.

  • Static: Includes individual resource or group resource.

Score

Enter the score rule. Score includes the following options:

  • Equals

  • Greater Than

  • Greater Than Equal To

  • Less Than

  • Less Than Equal To

  • Not Equal To

  • In

Priority

The priority of the activity with 1 being the highest and 100 the lowest.

Category

The category under which the job is created.

Sub Categories

The sub categories under which the job is created.

Retrieval Limit

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

The following table describes the job fields and date fields available as filter criteria.
Job Field Description

Job ID

ID of the case job.

Case Reference

Case reference based on which job is created.

Process

Consume a process based on which job is created.

Version

Select the process version from the list.

Status

The following job statuses are available :

  • Active: Jobs that are currently running.

  • Live And Finished: Live jobs and jobs that can be completed and terminated.

  • Finished: Jobs that can be completed and terminated.

  • Live: Jobs that are either not completed, terminated, awaiting completion or awaiting termination.

  • Completed: Jobs that are completed.

  • Ready For Evaluation: Jobs that are in the process of reevaluation.

  • Pending: Completed jobs with pending activities.

  • Suspended: Suspended jobs that can be manually reactivated.

  • Terminated: Jobs that cannot be executed; all activities within the terminated jobs are stopped, and the job is removed.

  • On Hold: Jobs that are on hold for a specific time to delay all event processing. When a job is placed on hold, exceptions, milestones and triggers are affected. When the hold time expires, the job moves to active status and the job activities become pending.

  • Completed Awaiting Associated Jobs Completion: Completed cases that still have active associated jobs.

  • Completed Awaiting Associated Case Completion: Associated jobs that are complete and awaiting case completion.

  • Terminated Awaiting Associated Jobs Completion: Terminated cases awaiting completion of associated jobs.

  • Terminated Awaiting Associated Case Completion: Associated jobs that are terminated and awaiting case completion.

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. Indicates if the job is within or has exceeded the set time limits or target duration.

Job State

Name of the state associated with the process.

Start Date

The period within which the job has started.

Completion Date

The period within which the job is completed.

Due Date

The period within which the job is due to be completed.

Sort columns in a Job query

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

    The Sorting tab is only displayed if the Enable JobList Custom Sorting is set to Yes in the System Settings. 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: Expected Duration, Ascending)
    2. Sort Order 2 (Default: None, Descending)

      The Sort Order 3 is only available when you specify a column for Sort Order 2.

    3. Sort Order 3 (Default: Disabled)
  4. Click Save.

    At runtime, the sorted results are displayed in the JobList control.