• Verified

    • JQL functions and keywords reference

    Owned by
    Deborah Scott
    Last updated: Jul 02, 2024 by
    Deborah Scott
    1 min read

    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