This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.
Take a look here! If you have any questions please email support@appfire.com
JQL Functions Reference
- Daniel Turczanski
- Deborah Scott
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
CommentLastUpdatedBy
CommentedOnDate
CommentedUpdatedOnDate
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