JQL extension for system fields

On this page:

Extended JQL syntax for system fields

Issue Matrix for Jira Cloud offers you an extended JQL syntax that allows filtering of issues in Jira Software and Service Management based on the values of the system fields of the current issue. This JQL syntax is an extension of Jira’s query language (JQL).
You can see more information on how you can use the feature in our JQL extension document.

Supported system fields

Below is a list of all the supported system fields with examples of how to use them.

Affected version

Syntax

${currentIssue.affectedVersion}

Return value description

Comma-separated list of the ids of all affected versions by the current issue.

Return value example

10001, 10003

Examples

  • Find all issues with an affected version which is contained in the list of affected versions for the current issue
    affectedVersion IN (${currentIssue.affectedVersion})

     

  • Find all issues with affected version which is contained in the list of affected versions for the current issue as well as the issues with empty value for that field
    affectedVersion in (${currentIssue.affectedVersion}, EMPTY)

  • Find all issues with fix version which is contained in the list of affected versions for the current issue

    fixVersion IN (${currentIssue.affectedVersion})

 

Assignee

Syntax

${currentIssue.assignee}

Return value description

The accountId of the "assignee" user of the current issue surrounded by double quotes.

Return value example

"557058:f14b7e17-b5c0-4a14-bbae-37296b8c50a0"

Examples

  • Find all issues with the same assignee as the current issue assignee

    assignee = ${currentIssue.assignee}

     

  • Find all issues with reporter different than the current issue assignee

    reporter != ${currentIssue.assignee}

 

Component(s)

Syntax

${currentIssue.components}

Return value description

Comma-separated list of component IDs of the current issue.

Return value example

10015, 10022

Examples

  • Find all issues with a component in the current issue components
    component in (${currentIssue.components})

     

  • Find all issues with a component in the current issue components as well as all issues with empty value for that field
    component in (${currentIssue.components}, EMPTY)

 

Created

Syntax

${currentIssue.created}, ${currentIssue.createdDate}

Return value description

The date when the current issue was created in the format "yyyy/MM/dd HH:mm" surrounded by double quotes.

Return value example

"2017/03/25 15:30"

Examples

  • Find all issues that were created after the creation date of the current issue
    created > ${currentIssue.created}

 

Creator

Syntax

${currentIssue.creator}

Return value description

The accountID of the user who created the current issue surrounded by double quotes.

Return value example

"557058:f14b7e17-b5c0-4a14-bbae-37296b8c50a0"

Examples

  • Find all issues with the same assignee as the current issue creator

    assignee = ${currentIssue.creator}

  • Find all issues with assignee that was the same as the current issue creator

    assignee WAS ${currentIssue.creator}

 

Description

Syntax

${currentIssue.description}

Return value description

The description of the current issue surrounded by double quotes.

Return value example

"Some long description returned in double quotes"

Examples

  • Find all issues with summary not like the current issue description
    summary !~ ${currentIssue.description}

 

Due Date

Syntax

${currentIssue.due}, ${currentIssue.duedate}

Return value description

The due date of the current issue in the format "yyyy/MM/dd" surrounded by double quotes.

Return value example

"2017/03/25"

Examples

  • Find all issues that are due before the due date of the current issue
    dueDate < ${currentIssue.due}

 

Environment

Syntax

${currentIssue.environment}

Return value description

The environment of the current issue surrounded by double quotes.

Return value example

"Such a lovely environment does this issue have"

Examples

  • Find all issues with a description like the current issue environment
    description ~ ${currentIssue.environment}

 

Fix version

Syntax

${currentIssue.fixVersion}

Return value description

Comma-separated list of the ids of all fix versions for the current issue.

Return value example

10001, 10005

Examples

  • Find all issues with fix version in current issue fix versions
    fixVersion IN (${currentIssue.fixVersion})

     

  • Find all issues with fix version in current issue fix versions as well as all issues with empty value in that field
    fixVersion in (${currentIssue.fixVersion},EMPTY)"

     

  • Find all issues with an affected version in current issue fix versions
    affectedVersion IN (${currentIssue.fixVersion})

 

Issue Key

Syntax

${currentIssue.key}, ${currentIssue.issuekey}, ${currentIssue.id}, ${currentIssue.issue}

Return value description

Key of the current issue.

Return value example

HSP-225

Examples

  • Find all issues linked to the current issue.
    issue in linkedIssues(${currentIssue.key})

 

Issue Type

Syntax

${currentIssue.type}, ${currentIssue.issuetype}

Return value description

Id of the issue type of the current issue

Return value example

10010

Examples

  • Find all issues with the same issue type as the current issue.
    type = ${currentIssue.issuetype}

 

Labels

Syntax

${currentIssue.labels}

Return value description

A comma-separated list of all the labels of the current issue.

Return value example

X, Y, Z

Examples

  • Find all issues having a common label with the current issue.
    labels IN (${currentIssue.labels})

 

Last Viewed

Syntax

${currentIssue.lastViewed}

Return value description

The date when an issue was last viewed in the format "yyyy/MM/dd HH:mm" surrounded by double quotes.

Return value example

"2017/03/25 15:30"

Examples

  • Find all issues updated before the current issue was last viewed:

    updated < ${currentIssue.lastViewed}

     

  • Find all issues created before the current issue’s last view time:

    created < ${currentIssue.lastViewed}

 

Original Estimate

Syntax

${currentIssue.timeoriginalestimate}

Return value description

The original estimate of an issue returned as a number.

Return value example

10

Examples

  • Find all issues with a remaining estimate smaller than the original estimate of the current issue

    originalEstimate < ${currentIssue.timeoriginalestimate}

     

  • Find all issues with the same original estimate as the current issue

    originalEstimate = ${currentIssue.timeoriginalestimate}

 

Σ Original Estimate

Syntax

${currentIssue.aggregatetimeoriginalestimate}

Return value description

The aggregated original estimate of an issue.

Return value example

10

Examples

  • Find all issues with original estimate as the aggregated original estimate of the current issue

    originalEstimate = ${currentIssue.aggregatetimeoriginalestimate}

     

  • Find all issues with remаining estimate as the aggregated original estimate of the current issue

    remainingEstimate = ${currentIssue.aggregatetimeoriginalestimate}

 

Parent

Syntax

${currentIssue.parent}

Return value description

The id of the parent issue.

Return value example

10001

Examples

  • Find all issues which have the same parent as the current issue.
    parent = ${currentIssue.parent}

 

Priority

Syntax

${currentIssue.priority}

Return value description

The id of the priority of the current issue.

Return value example

10001

Examples

  • Find all issues which have the same priority as the current issue.
    priority = ${currentIssue.priority}

 

Project

Syntax

${currentIssue.project}

Return value description

The id of the current issue project.

Return value example

10001

Examples

  • Find all issues which are in the same project as the current issue.
    project = ${currentIssue.project}

 

Remaining Estimate

Syntax

${currentIssue.timeestimate},${currentIssue.remainingEstimate}

Return value description

The remaining estimate of an issue returned as a number.

Return value example

10

Examples

  • Find all issues with the same remaining estimate as the current issue

    remainingEstimate = ${currentIssue.remainingEstimate}

     

  • Find all issues with original estimate as the remaining estimate of the current issue

    originalEstimate = ${currentIssue.remainingEstimate}

 

Σ Remaining Estimate

Syntax

${currentIssue.aggregatetimeestimate}

Return value description

Number of the aggregated remaining estimate of an issue.

Return value example

10001

Examples

  • Find all issues with original estimate as the aggregated remaining estimate of the current issue

    originalEstimate = ${currentIssue.aggregatetimeestimate}

     

  • Find all issues with remining estimate as the aggregated remaining estimate of the current issue

    remainingEstimate = ${currentIssue.aggregatetimeestimate}

 

Reporter

Syntax

${currentIssue.reporter}

Return value description

The accountId of the {fieldName} user who is the reporter of the current issue surrounded by double quotes.

Return value example

"557058:f14b7e17-b5c0-4a14-bbae-37296b8c50a0"

Examples

  • Find all issues with the same reporter as the current issue reporter
    reporter = ${currentIssue.reporter}

     

  • Find all issues with the assignee different from the current issue reporter
    assignee != ${currentIssue.reporter}

 

Resolution

Syntax

${currentIssue.resolution}

Return value description

Id of the resolution of the current issue.

Return value example

1

Examples

  • Find all issues which have the same resolution as the current issue.
    resolution = ${currentIssue.resolution}

 

Resolved

Syntax

${currentIssue.resolved}, ${currentIssue.resolutiondate}

Return value description

The resolution date of the current issue in the format "yyyy/MM/dd HH:mm" surrounded by double quotes.

Return value example

"2017/10/05 23:00"

Examples

  • Find all issues which were resolved before the current issue was resolved.
    resolved < ${currentIssue.resolved}

Status

Syntax

${currentIssue.status}

Return value description

Id of the status of the current issue.

Return value example

1

Examples

  • Find all issues which have the same status as the current issue.
    status = ${currentIssue.status}

     

 

Status Category

Syntax

${currentIssue.statusCategory}

Return value description

ID of current issue’s status category

Return value example

“2”

Examples

  • Find all issues with the same status category as the current issue

    statusCategory = ${currentIssue.statusCategory}

 

Status Category Changed

Syntax

${currentIssue.statuscategorychangedate}

Return value description

The date when the category of the current issue was changed in the format "yyyy/MM/dd HH:mm" surrounded by double quotes.

Return value example

"2021/09/25 15:30"

Examples

  • Find all issues that have been updated after the category of the current issue was changed.

    updated > ${currentIssue.statuscategorychangedate}

     

  • Find all issues whose category was changed before the category of the current issue was changed.

    statuscategorychangeddate < ${currentIssue.statuscategorychangedate}

 

Security Level

Syntax

${currentIssue.level}

Return value description

The id of the security level of the current issue.

Return value example

10001

Examples

  • Find all issues having the same security level as the current issue.
    level = ${currentIssue.level}

 

Summary

Syntax

${currentIssue.summary}

Return value description

The summary of the current issue surrounded by double quotes.

Return value example

"This is the issue summary"

Examples

  • Find all issues which have the same summary as the current issue.
    summary ~ ${currentIssue.summary}

 

Time Spent

Syntax

${currentIssue.timespent}

Return value description

The time spent on an issue returned as a number.

Return value example

100

Examples

  • Find all issues with time spent longer than the time spent on the current issue

    timeSpent > ${currentIssue.timespent}

     

  • Find all issues with the same time spent as the current issue

    timeSpent = ${currentIssue.timespent}

 

Time Spent Σ

Syntax

${currentIssue.aggregatetimespent}

Return value description

The aggregated time spent on an issue returned as a number.

Return value example

100

Examples

  • Find all issues with longer time spent than the aggregated time spent on the current issue

    timespent < ${currentIssue.aggregatetimespent}

     

  • Find all issues with the time spent the same as the aggregated time spent on the current issue

    timespent = ${currentIssue.aggregatetimespent}

 

Updated

Syntax

${currentIssue.updated}, ${currentIssue.updatedDate}

Return value description

The last update date of the current issue in the format "yyyy/MM/dd HH:mm" surrounded by double quotes.

Return value example

"2017/10/05 23:00"

Examples

  • Find all issues which were last updated before the current issue was last updated.
    updated < ${currentIssue.updated}

 

Votes

Syntax

${currentIssue.votes}

Return value description

Number of votes of the current issue.

Return value example

10

Examples

  • Find all issues with the same number of votes as the current issue.
    votes = ${currentIssue.votes}

 

Watchers

Syntax

${currentIssue.watchers}

Return value description

Number of watchers of the current issue.

Return value example

10

Examples

  • Find all issues with the same number of watchers as the current issue.
    watchers = ${currentIssue.watchers}

 

Work Ratio

Syntax

${currentIssue.workratio}

Return value description

The work ratio of an issue represented as a number.

Return value example

500

Examples

  • Find issues with the same work ration as the current issue

    workRatio = ${currentIssue.workratio}

     

  • Find issues with smaller work ration than the current issue

    workRatio < ${currentIssue.workratio}