This page describes JQL functions from JQL Search Extensions for Jira Cloud. Instructions for Data Center can be found here.
👉Jira Hierarchy & Advanced Roadmaps
Powerful generic functions that support standard Jira hierarchy and Advanced Roadmaps: Subtasks, Stories, Epics, Initiatives, etc:
ParentsOfIssuesInQuery()
ParentsOfIssuesInQueryRecursive()
ChildrenOfIssuesInQuery()
ChildrenOfIssuesInQueryRecursive()
👉Epics
EpicsOfChildrenInQuery()
ChildrenOfEpicsInQuery()
issuesInEpicCount
bugsInEpicCount
storiesInEpicCount
issuesInEpicToDoCount
issuesInEpicInProgressCount
issuesInEpicDoneCount
bugsInEpicToDoCount
bugsInEpicInProgressCount
bugsInEpicDoneCount
storiesInEpicToDoCount
storiesInEpicInProgressCount
storiesInEpicDoneCount
👉Subtasks
ParentsOfSubtasksInQuery()
SubtasksOfParentsInQuery()
ParentSummary
ParentPriority
ParentIssueType
ParentStatus
ParentStatusCategory
SubtasksCount
SubtaskSummary
SubtaskKey
SubtaskPriority
SubtaskIssueType
SubtaskStatus
SubtaskStatusCategory
👉Links
LinkedIssuesOfQuery()
LinksCount
LinkedBy
LinksIssue
LinkType
LinkedIssueStatus
LinkedIssueStatusCategory
LinkedIssueType
LinkedIssuePriority
LinksIssuesCount
LinkedByIssuesCount
LinkedByIssueProject
LinksIssueProject
👉Web Links
Formerly called remote links
RemoteLinkUrl
RemoteLinkUrlPartialMatch
RemoteLinkApplicationName
RemoteLinkApplicationType
RemoteLinkHost
RemoteLinkQuery
RemoteLinkPath
RemoteLinkTitle
RemoteLinkTitlePartialMatch
RemoteLinkRelationship
RemoteLinksCount
👉Versions
AffectedVersionsArchived
AffectedVersionsReleased
AffectedVersionsOpened
AffectedVersionsCount
AffectedVersionReleaseDate
FixVersionsArchived
FixVersionsReleased
FixVersionsOpened
FixVersionsCount
FixVersionReleaseDate
👉Attachments
AttachmentContent
AttachmentsCount
AttachedByUser
AttachedOnDate
AttachmentExtension
AttachmentName
👉Comments
CommentsCount
CommentedByUser
CommentLastCreatedBy
CommentLastUpdatedBy
CommentedOnDate
CommentedUpdatedOnDate
👉Issue updates
UpdatedByUsersCount
UpdatedBy
TransitionedBy
LoggedTimeBy
UpdatedOnDates
LastUpdatedBy
MovedProjects
MovedProjectsCount
👉Text
ExactTextMatch()
ExactTextMatchCaseInsensitive()
WildcardMatch()
Regex()
👉Agile
NextSprint()
PreviousSprint()
AddedToSprintAfterStart()
👉Field Comparisons
HasSameUpdatedAndCreatedDate
HasSameAssigneeAndReporter
HasSameVersions
Standard JQL
Links to the documentation of standard JQL funtions in Jira Cloud
Jira Service Management - JSM specific fields and functions, especially around SLA