Jira JQL Functions Questions and
Answers| Latest Update
elapsed() ✔️✔️Service Desk Only.
Returns issues whose SLA clock is at a certain point relative to a cycle's start event.
Find issues that have been waiting for a first response for more than 1 hour:"Time to First
Response" > elapsed("1h")
endOfDay() ✔️✔️Find issues due by the end of tomorrow:due < endOfDay("+1")
endOfMonth() ✔️✔️Find issues due by the end of this month:due < endOfMonth()
Find issues due by the end of next month:due < endOfMonth("+1")
Find issues due by the 15th of next month:due < endOfMonth("+15d")
endOfWeek() ✔️✔️Find issues due by the end of this week:due < endOfWeek()
Find issues due by the end of next week:due < endOfWeek("+1")
endOfYear() ✔️✔️Find issues due by the end of this year:due < endOfYear()
Find issues due by the end of March next year:due < endOfYear("+3M")
everbreached() ✔️✔️Only applicable if Jira Service Desk is installed and licensed.
Returns issues that have missed one of their SLA goals.
Find issues have missed their goal for Time to First Response:"Time to First Response" =
everbreached()
issueHistory() ✔️✔️Find issues that you have recently viewed, i.e. issues that are in the 'Recent
Issues' section of the 'Issues' drop-down menu.
, Note:
issueHistory() returns up to 50 issues, whereas the 'Recent Issues' drop-down returns only 5.
if you are not logged in to JIRA, only issues from your current browser session will be included.
Find issues which I have recently viewed, that are assigned to me:issue in issueHistory() AND
assignee = currentUser()
issuesWithRemoteLinksByGlobalId() ✔️✔️Perform searches based on issues that are associated
with remote links that have any of the specified global ids.
Note:
This function accepts 1 to 100 globalIds. Specifying 0 or more than 100 globalIds will result in
errors.
lastLogin() ✔️✔️Perform searches based on the time at which the current user's previous session
began.
Find issues that have been created during my last session:created > lastLogin()
latestReleasedVersion() ✔️✔️Note, the "latest" is determined by the ordering assigned to the
versions, not by actual Version Due Dates.
Find issues that relate to the latest released version of the ABC project:affectedVersion =
latestReleasedVersion(ABC) or fixVersion = latestReleasedVersion(ABC)
linkedIssues() ✔️✔️Perform searches based on issues that are linked to a specified issue. You can
optionally restrict the search to links of a particular type. Note that LinkType is case-sensitive.
Find issues that are linked to a particular issue:issue in linkedIssues(ABC-123)
Find issues that are linked to a particular issue via a particular type of link:issue in
linkedIssues(ABC-123,"is duplicated by")
membersOf() ✔️✔️Find issues where the Assignee is a member of the group "jira-
administrators":assignee in membersOf("jira-administrators")
Answers| Latest Update
elapsed() ✔️✔️Service Desk Only.
Returns issues whose SLA clock is at a certain point relative to a cycle's start event.
Find issues that have been waiting for a first response for more than 1 hour:"Time to First
Response" > elapsed("1h")
endOfDay() ✔️✔️Find issues due by the end of tomorrow:due < endOfDay("+1")
endOfMonth() ✔️✔️Find issues due by the end of this month:due < endOfMonth()
Find issues due by the end of next month:due < endOfMonth("+1")
Find issues due by the 15th of next month:due < endOfMonth("+15d")
endOfWeek() ✔️✔️Find issues due by the end of this week:due < endOfWeek()
Find issues due by the end of next week:due < endOfWeek("+1")
endOfYear() ✔️✔️Find issues due by the end of this year:due < endOfYear()
Find issues due by the end of March next year:due < endOfYear("+3M")
everbreached() ✔️✔️Only applicable if Jira Service Desk is installed and licensed.
Returns issues that have missed one of their SLA goals.
Find issues have missed their goal for Time to First Response:"Time to First Response" =
everbreached()
issueHistory() ✔️✔️Find issues that you have recently viewed, i.e. issues that are in the 'Recent
Issues' section of the 'Issues' drop-down menu.
, Note:
issueHistory() returns up to 50 issues, whereas the 'Recent Issues' drop-down returns only 5.
if you are not logged in to JIRA, only issues from your current browser session will be included.
Find issues which I have recently viewed, that are assigned to me:issue in issueHistory() AND
assignee = currentUser()
issuesWithRemoteLinksByGlobalId() ✔️✔️Perform searches based on issues that are associated
with remote links that have any of the specified global ids.
Note:
This function accepts 1 to 100 globalIds. Specifying 0 or more than 100 globalIds will result in
errors.
lastLogin() ✔️✔️Perform searches based on the time at which the current user's previous session
began.
Find issues that have been created during my last session:created > lastLogin()
latestReleasedVersion() ✔️✔️Note, the "latest" is determined by the ordering assigned to the
versions, not by actual Version Due Dates.
Find issues that relate to the latest released version of the ABC project:affectedVersion =
latestReleasedVersion(ABC) or fixVersion = latestReleasedVersion(ABC)
linkedIssues() ✔️✔️Perform searches based on issues that are linked to a specified issue. You can
optionally restrict the search to links of a particular type. Note that LinkType is case-sensitive.
Find issues that are linked to a particular issue:issue in linkedIssues(ABC-123)
Find issues that are linked to a particular issue via a particular type of link:issue in
linkedIssues(ABC-123,"is duplicated by")
membersOf() ✔️✔️Find issues where the Assignee is a member of the group "jira-
administrators":assignee in membersOf("jira-administrators")
