JQL extension for system fields
On this page:
- 1 Extended JQL syntax for system fields
- 2 Supported system fields
- 2.1 Affected version
- 2.2 Assignee
- 2.3 Component(s)
- 2.4 Created
- 2.5 Creator
- 2.6 Description
- 2.7 Due Date
- 2.8 Environment
- 2.9 Fix version
- 2.10 Issue Key
- 2.11 Issue Type
- 2.12 Labels
- 2.13 Last Viewed
- 2.14 Original Estimate
- 2.15 Σ Original Estimate
- 2.16 Parent
- 2.17 Priority
- 2.18 Project
- 2.19 Remaining Estimate
- 2.20 Σ Remaining Estimate
- 2.21 Reporter
- 2.22 Resolution
- 2.23 Resolved
- 2.24 Status
- 2.25 Status Category
- 2.26 Status Category Changed
- 2.27 Security Level
- 2.28 Summary
- 2.29 Time Spent
- 2.30 Time Spent Σ
- 2.31 Updated
- 2.32 Votes
- 2.33 Watchers
- 2.34 Work Ratio
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 |
|
Return value description | Comma-separated list of the ids of all affected versions by the current issue. |
Return value example | 10001, 10003 |
Examples |
|
Assignee
Syntax |
|
Return value description | The accountId of the "assignee" user of the current issue surrounded by double quotes. |
Return value example |
|
Examples |
|
Component(s)
Syntax |
|
Return value description | Comma-separated list of component IDs of the current issue. |
Return value example | 10015, 10022 |
Examples |
|
Created
Syntax |
|
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 |
|
Creator
Syntax |
|
Return value description | The accountID of the user who created the current issue surrounded by double quotes. |
Return value example |
|
Examples |
|
Description
Syntax |
|
Return value description | The description of the current issue surrounded by double quotes. |
Return value example | "Some long description returned in double quotes" |
Examples |
|
Due Date
Syntax |
|
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 |
|
Environment
Syntax |
|
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 |
|
Fix version
Syntax |
|
Return value description | Comma-separated list of the ids of all fix versions for the current issue. |
Return value example | 10001, 10005 |
Examples |
|
Issue Key
Syntax |
|
Return value description | Key of the current issue. |
Return value example |
|
Examples |
|
Issue Type
Syntax |
|
Return value description | Id of the issue type of the current issue |
Return value example |
|
Examples |
|
Labels
Syntax |
|
Return value description | A comma-separated list of all the labels of the current issue. |
Return value example | X, Y, Z |
Examples |
|
Last Viewed
Syntax |
|
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 |
|
Original Estimate
Syntax |
|
Return value description | The original estimate of an issue returned as a number. |
Return value example | 10 |
Examples |
|
Σ Original Estimate
Syntax |
|
Return value description | The aggregated original estimate of an issue. |
Return value example | 10 |
Examples |
|
Parent
Syntax |
|
Return value description | The id of the parent issue. |
Return value example |
|
Examples |
|
Priority
Syntax |
|
Return value description | The id of the priority of the current issue. |
Return value example |
|
Examples |
|
Project
Syntax |
|
Return value description | The id of the current issue project. |
Return value example |
|
Examples |
|
Remaining Estimate
Syntax |
|
Return value description | The remaining estimate of an issue returned as a number. |
Return value example | 10 |
Examples |
|
Σ Remaining Estimate
Syntax |
|
Return value description | Number of the aggregated remaining estimate of an issue. |
Return value example | 10001 |
Examples |
|
Reporter
Syntax |
|
Return value description | The accountId of the {fieldName} user who is the reporter of the current issue surrounded by double quotes. |
Return value example |
|
Examples |
|
Resolution
Syntax |
|
Return value description | Id of the resolution of the current issue. |
Return value example |
|
Examples |
|
Resolved
Syntax |
|
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 |
|
Examples |
|
Status
Syntax |
|
Return value description | Id of the status of the current issue. |
Return value example |
|
Examples |
|
Status Category
Syntax |
|
Return value description | ID of current issue’s status category |
Return value example | “2” |
Examples |
|
Status Category Changed
Syntax |
|
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 |
|
Security Level
Syntax |
|
Return value description | The id of the security level of the current issue. |
Return value example |
|
Examples |
|
Summary
Syntax |
|
Return value description | The summary of the current issue surrounded by double quotes. |
Return value example |
|
Examples |
|
Time Spent
Syntax |
|
Return value description | The time spent on an issue returned as a number. |
Return value example | 100 |
Examples |
|
Time Spent Σ
Syntax |
|
Return value description | The aggregated time spent on an issue returned as a number. |
Return value example | 100 |
Examples |
|
Updated
Syntax |
|
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 |
|
Examples |
|
Votes
Syntax |
|
Return value description | Number of votes of the current issue. |
Return value example |
|
Examples |
|
Watchers
Syntax |
|
Return value description | Number of watchers of the current issue. |
Return value example |
|
Examples |
|
Work Ratio
Syntax |
|
Return value description | The work ratio of an issue represented as a number. |
Return value example | 500 |
Examples |
|