JQL functions reference

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

  • LinkedIssuesOfQuery()

  • LinksCount

  • LinkedBy

  • LinksIssue

  • LinkType

  • LinkedIssueStatus

  • LinkedIssueStatusCategory

  • LinkedIssueType

  • LinkedIssuePriority

  • LinksIssuesCount

  • LinkedByIssuesCount

  • LinkedByIssueProject

  • LinksIssueProject

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

Links to the documentation of standard JQL funtions in Jira Cloud