Skip to end of banner
Go to start of banner

JQL functions and keywords reference

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 53 Next »

This page lists JQL functions and keywords 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

  • 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

  • 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

Resources for using standard JQL functions in Jira Cloud

  • No labels