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: Working 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 (default): Jobs which are currently in an active state, that is actively progressing or in a state to progress.

  • Live And Finished: Jobs which are currently live or finished.

  • Finished: Jobs which are completed or terminated.

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

  • Completed: Jobs which have completed their life cycle as designed.

  • Ready For Evaluation: Jobs which are in the process of re-evaluating what should happen next.

  • Pending: Jobs which have completed, but there are taken activities.

  • Suspended: Jobs which are suspended but can manually be reactivated to get them up and running again.

    Note The jobs that have failed evaluation cannot be suspended.

  • Terminated: Jobs which have stopped processing before completing the lifecycle.

  • On Hold: Jobs which 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: Cases which are completed but still have active associated jobs.

  • Completed Awaiting Associated Case Completion: Associated jobs which are completed and awaiting case completion.

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

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

  • Evaluation Failed: Jobs that have failed evaluation.

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. (Default: All)

Job State

Name of the state associated with the process.

Suspend Reason

The reason for suspending the job.

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.