Info |
---|
This page lists JQL functions forĀ JQL Search Extensions for Jira Cloud. For details on using functions with Jira Data Center see the Server/Data Center documentation. |
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
CommentLastCreatedOnDate
CommentLastUpdatedBy
CommentLastUpdatedOnDate
CommentedOnDate
CommentUpdatedOnDate
Issue updates
UpdatedByUsersCount
UpdatedBy
TransitionedBy
LoggedTimeBy
UpdatedOnDates
LastUpdatedBy
MovedProjects
MovedProjectsCount
Text
ExactTextMatch()
ExactTextMatchCaseInsensitive()
WildcardMatch()
Regex()
Agile
NextSprint()
PreviousSprint()
AddedToSprintAfterStart()
Field Comparisons
DateCompare()
DateCompareIgnoreTime()
HasSameUpdatedAndCreatedDate
HasSameAssigneeAndReporter
HasSameVersions
Standard JQL
References for using standard JQL functions in Jira Cloud
Jira Service Management - JSM specific fields and functions, especially around SLA