JQL functions and keywords reference

Owned by Deborah Scott
Last updated: Dec 10, 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.

 

Issue hierarchy

Powerful generic functions that support standard Jira hierarchy and Advanced Roadmaps

  • parentsOfIssuesInQuery()

  • parentsOfIssuesInQueryRecursive()

  • childrenOfIssuesInQuery()

  • childrenOfIssuesInQueryRecursive()

Epics

  • epicsOfChildrenInQuery()

  • childrenOfEpicsInQuery()

  • issuesInEpicCount

  • bugsInEpicCount

  • storiesInEpicCount

  • issuesInEpicToDoCount

  • issuesInEpicInProgressCount

  • issuesInEpicDoneCount

  • bugsInEpicToDoCount

  • bugsInEpicInProgressCount

  • bugsInEpicDoneCount

  • storiesInEpicToDoCount

  • storiesInEpicInProgressCount

  • storiesInEpicDoneCount

Text matches

  • exactTextMatch()

  • exactTextMatchCaseInsensitive()

  • wildcardMatch()

  • regex()

Agile sprints

  • nextSprint()

  • previousSprint()

  • addedToSprintAfterStart()

Attachments

  • attachmentContent

  • attachmentsCount

  • attachedByUser

  • attachedOnDate

  • attachmentExtension

  • attachmentName

Subtasks

  • subtasksOfParentsInQuery()

  • parentSummary

  • parentPriority

  • parentIssueType

  • parentStatus

  • parentStatusCategory

Issues with subtasks

  • parentsOfSubtasksInQuery()

  • subtasksCount

  • subtaskSummary

  • subtaskKey

  • subtaskPriority

  • subtaskIssueType

  • subtaskStatus

  • subtaskStatusCategory

Comments

  • commentsCount

  • commentedByUser

  • commentLastCreatedBy

  • commentLastCreatedOnDate

  • commentLastUpdatedBy

  • commentLastUpdatedOnDate

  • commentedOnDate

  • commentUpdatedOnDate

Versions

  • affectedVersionsArchived

  • affectedVersionsReleased

  • affectedVersionsOpened

  • affectedVersionsCount

  • affectedVersionReleaseDate

  • fixVersionsArchived

  • fixVersionsReleased

  • fixVersionsOpened

  • fixVersionsCount

  • fixVersionReleaseDate

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

Issue updates

  • updatedByUsersCount

  • updatedBy

  • transitionedBy

  • loggedTimeBy

  • updatedOnDates

  • lastUpdatedBy

  • movedProjects

  • movedProjectsCount

Field values

  • dateCompare()

  • dateCompareIgnoreTime()

  • hasSameUpdatedAndCreatedDate

  • hasSameAssigneeAndReporter

  • hasSameVersions

Standard JQL

Resources for using standard JQL functions in Jira Cloud