/
JQL functions and keywords reference

JQL functions and keywords reference

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 Data Center documentation.

Refer to the category pages for complete descriptions and examples.

Issue hierarchy

See Issue hierarchy for complete descriptions and examples.

  • parentsOfIssuesInQuery()

  • parentsOfIssuesInQueryRecursive()

  • childrenOfIssuesInQuery()

  • childrenOfIssuesInQueryRecursive()

Epics

See Epics for complete descriptions and examples.

  • epicsOfChildrenInQuery()

  • childrenOfEpicsInQuery()

  • issuesInEpicCount

  • bugsInEpicCount

  • storiesInEpicCount

  • issuesInEpicToDoCount

  • issuesInEpicInProgressCount

  • issuesInEpicDoneCount

  • bugsInEpicToDoCount

  • bugsInEpicInProgressCount

  • bugsInEpicDoneCount

  • storiesInEpicToDoCount

  • storiesInEpicInProgressCount

  • storiesInEpicDoneCount

Text matches

See Text matches for complete descriptions and examples.

  • exactTextMatch()

  • exactTextMatchCaseInsensitive()

  • wildcardMatch()

  • regex()

Agile sprints

See Agile sprints for complete descriptions and examples.

  • nextSprint()

  • previousSprint()

  • addedToSprintAfterStart()

Attachments

See Attachments for complete descriptions and examples.

  • attachmentContent

  • attachmentsCount

  • attachedByUser

  • attachedOnDate

  • attachmentExtension

  • attachmentName

Subtasks

See Subtasks for complete descriptions and examples.

  • subtasksOfParentsInQuery()

  • parentSummary

  • parentPriority

  • parentIssueType

  • parentStatus

  • parentStatusCategory

Issues with subtasks

See Issues with subtasks for complete descriptions and examples.

  • parentsOfSubtasksInQuery()

  • subtasksCount

  • subtaskSummary

  • subtaskKey

  • subtaskPriority

  • subtaskIssueType

  • subtaskStatus

  • subtaskStatusCategory

Comments

See Comments for complete descriptions and examples.

  • commentsCount

  • commentedByUser

  • commentLastCreatedBy

  • commentLastCreatedOnDate

  • commentLastUpdatedBy

  • commentLastUpdatedOnDate

  • commentedOnDate

  • commentUpdatedOnDate

Versions

See Versions for complete descriptions and examples.

  • affectedVersionsArchived

  • affectedVersionsReleased

  • affectedVersionsOpened

  • affectedVersionsCount

  • affectedVersionReleaseDate

  • fixVersionsArchived

  • fixVersionsReleased

  • fixVersionsOpened

  • fixVersionsCount

  • fixVersionReleaseDate

Links

See issue links for complete descriptions and examples.

  • linkedIssuesOfQuery()

  • linksCount

  • linkedBy

  • linksIssue

  • linkType

  • linkedIssueStatus

  • linkedIssueStatusCategory

  • linkedIssueType

  • linkedIssuePriority

  • linksIssuesCount

  • linkedByIssuesCount

  • linkedByIssueProject

  • linksIssueProject

Web links

Formerly called remote links

See Web links for complete descriptions and examples.

  • remoteLinkUrl

  • remoteLinkUrlPartialMatch

  • remoteLinkApplicationName

  • remoteLinkApplicationType

  • remoteLinkHost

  • remoteLinkQuery

  • remoteLinkPath

  • remoteLinkTitle

  • remoteLinkTitlePartialMatch

  • remoteLinkRelationship

  • remoteLinksCount

Issue updates

See Issue updates for complete descriptions and examples.

  • updatedByUsersCount

  • updatedBy

  • transitionedBy

  • loggedTimeBy

  • updatedOnDates

  • lastUpdatedBy

  • movedProjects

  • movedProjectsCount

Field values

See Field values for complete descriptions and examples.

  • dateCompare()

  • dateCompareIgnoreTime()

  • hasSameUpdatedAndCreatedDate

  • hasSameAssigneeAndReporter

  • hasSameVersions

Using dates in JQL

Using standard JQL in Jira Cloud

Need support? Create a request with our support team.

Copyright © 2005 - 2025 Appfire | All rights reserved.