JQL extension for system fields
Ā
Extended JQL syntax for system fields
The "Custom JQL" mode and the JQL filtering functionality of Issue Matrix for Jira support an extended JQL syntax which allows filtering based on the values of the system fields of the current issue. Below is a list of all the supported system fields with examples on how to use them.
Ā
- 1 Affected version
- 2 Assignee
- 3 Category
- 4 Component
- 5 Created
- 6 Creator
- 7 Description
- 8 Due Date
- 9 Environment
- 10 Fix version
- 11 Issue Key
- 12 Issue Type
- 13 Labels
- 14 Level
- 15 Parent
- 16 Priority
- 17 Project
- 18 Reporter
- 19 Resolution
- 20 Resolved
- 21 Status
- 22 Summary
- 23 Updated
- 24 Voter
- 25 Votes
- 26 Watcher
- 27 Watchers
- 28 Sprint
- 29 Organizations
- 30 Customer Request Type
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 |
Ā
|
Ā
Assignee
Syntax | |
Return value description | The username of the "assignee" user of the current issue surrounded by double quotes. |
Return value example | "Admin Username" |
Examples |
|
Ā
Category
Syntax | |
Return value description | The id of the project category for the project to which the current issue belongs. |
Return value example | 10001 |
Examples |
|
Ā
Component
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 username of theĀ user who created the current issue surrounded by double quotes. |
Return value example | "Admin Username" |
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 | HSP-225 |
Examples |
|
Ā
Issue Type
Syntax | |
Return value description | Id of the issue type of the current issue |
Return value example | 10010 |
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 |
|
Ā
Level
Syntax | |
Return value description | The id of the security level of the current issue. |
Return value example | 10001 |
Examples |
|
Ā
Parent
Syntax | |
Return value description | The id of the parent issue. |
Return value example | 10001 |
Examples |
|
Ā
Priority
Syntax | |
Return value description | The id of the priority of the current issue. |
Return value example | 10001 |
Examples |
|
Ā
Project
Syntax | |
Return value description | The id of the current issue project. |
Return value example | 10001 |
Examples |
|
Ā
Reporter
Syntax | |
Return value description | The username of the {fieldName}Ā userĀ who is the reporter of the current issue surrounded by double quotes. |
Return value example | "Admin Username" |
Examples |
|
Ā
Resolution
Syntax | |
Return value description | Id of the resolution of the current issue. |
Return value example | 1 |
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 | 1 |
Examples |
|
Ā
Summary
Syntax | |
Return value description | The summary of the current issue surrounded by double quotes. |
Return value example |
|
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 |
|
Ā
Voter
Syntax | |
Return value description | Comma-separated list ofĀ usernames of all the voters on the current issue. |
Return value example | "James Jones", "Kate Hudson" |
Examples |
|
Ā
Votes
Syntax | |
Return value description | Number of votes of the current issue. |
Return value example |
|
Examples |
|
Ā
Watcher
Syntax | |
Return value description | Comma-separated list of usernamesĀ of all the watchers of the current issue. |
Return value example | "James Jones", "Kate Hudson" |
Examples |
|
Ā
Watchers
Syntax | |
Return value description | Number of watchers of the current issue. |
Return value example |
|
Examples |
|
Ā
Sprint
Used in Jira Software only
Syntax | ${currentIssue.sprint} |
---|---|
Return value description | Comma-separated list of sprint ids for the current issue |
Return value example | 1, 15 |
Examples |
Ā
Ā
Ā
|
Ā
Organizations
Used in Jira Service Management only
Syntax | ${currentIssue.organizations} |
---|---|
Return value description | Comma-separated list of organizations' names surrounded by double quotes |
Return value example | "Alpha", "Bravo", "Charlie" |
Examples |
Ā
Ā
Ā
|
Ā
Customer Request Type
Used in Jira Service Management only
Syntax |
|
---|---|
Return value description | Customer request type surrounded by double quotes |
Return value example | "New employee" |
Examples |
Ā
Ā
|
Ā