---
title: "JQL functions and keywords reference"
canonical: "https://support.appfire.com/space/JQLSEARCH/604209395/JQL%20functions%20and%20keywords%20reference"
format: markdown
---
> Macro (aura-html)

This page lists the JQL functions and keywords available in JQL Search Extensions for Jira Cloud. Use it as a starting point to explore the available query functions by category, including issue hierarchy, epics, sprints, comments, links, attachments, and field values. Each category page includes detailed descriptions, syntax, and examples to help you build advanced JQL queries in Jira Cloud.

For details on using functions with Jira Data Center, see the Data Center <u>[documentation](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/1865482654)</u>.

Refer to the category pages for complete descriptions and examples.

## Issue hierarchy

See [Issue hierarchy](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209353) for complete descriptions and examples.

- parentsOfIssuesInQuery()
- parentsOfIssuesInQueryRecursive()
- childrenOfIssuesInQuery()
- childrenOfIssuesInQueryRecursive()

## Epics

See [Epics](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209425) for complete descriptions and examples.

- epicsOfChildrenInQuery()
- childrenOfEpicsInQuery()
- issuesInEpicCount
- bugsInEpicCount
- storiesInEpicCount
- issuesInEpicToDoCount
- issuesInEpicInProgressCount
- issuesInEpicDoneCount
- bugsInEpicToDoCount
- bugsInEpicInProgressCount
- bugsInEpicDoneCount
- storiesInEpicToDoCount
- storiesInEpicInProgressCount
- storiesInEpicDoneCount

## Text matches

See [Text matches](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209903) for complete descriptions and examples.

- exactTextMatch()
- exactTextMatchCaseInsensitive()
- wildcardMatch()
- regex()

## Agile sprints

See [Agile sprints](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209345) for complete descriptions and examples.

- nextSprint()
- previousSprint()
- addedToSprintAfterStart()

## Attachments

See [Attachments](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209221) for complete descriptions and examples.

- attachmentContent
- attachmentsCount
- attachedByUser
- attachedOnDate
- attachmentExtension
- attachmentName

## Subtasks

See [Subtasks](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209285) for complete descriptions and examples.

- subtasksOfParentsInQuery()
- parentSummary
- parentPriority
- parentIssueType
- parentStatus
- parentStatusCategory

## Issues with subtasks

See [Issues with subtasks](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/1348927877) for complete descriptions and examples.

- parentsOfSubtasksInQuery()
- subtasksCount
- subtaskSummary
- subtaskKey
- subtaskPriority
- subtaskIssueType
- subtaskStatus
- subtaskStatusCategory

## Comments

See [Comments](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209943) for complete descriptions and examples.

- commentsCount
- commentedByUser
- commentLastCreatedBy
- commentLastCreatedOnDate
- commentLastUpdatedBy
- commentLastUpdatedOnDate
- commentedOnDate
- commentUpdatedOnDate

## Versions

See [Versions](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209229) for complete descriptions and examples.

- affectedVersionsArchived
- affectedVersionsReleased
- affectedVersionsOpened
- affectedVersionsCount
- affectedVersionReleaseDate
- fixVersionsArchived
- fixVersionsReleased
- fixVersionsOpened
- fixVersionsCount
- fixVersionReleaseDate

## Links

See [issue links](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209269) for complete descriptions and examples.

- linkedIssuesOfQuery()
- linkedIssuesOfQueryRecursive()
- linksCount
- linkedBy
- linksIssue
- linkType
- linkedIssueStatus
- linkedIssueStatusCategory
- linkedIssueType
- linkedIssuePriority
- linksIssuesCount
- linkedByIssuesCount
- linkedByIssueProject
- linksIssueProject

## Web links 

*Formerly called remote links*

See [Web links](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209213) for complete descriptions and examples.

- remoteLinkUrl
- remoteLinkUrlPartialMatch
- remoteLinkApplicationName
- remoteLinkApplicationType
- remoteLinkHost
- remoteLinkQuery
- remoteLinkPath
- remoteLinkTitle
- remoteLinkTitlePartialMatch
- remoteLinkRelationship
- remoteLinksCount

## Issue updates

See [Issue updates](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209933) for complete descriptions and examples.

- updatedByUsersCount
- updatedBy
- transitionedBy
- loggedTimeBy
- updatedOnDates
- lastUpdatedBy
- movedProjects
- movedProjectsCount

## Field values

See [Field values](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209909) for complete descriptions and examples.

- dateCompare()
- dateCompareIgnoreTime()
- hasSameUpdatedAndCreatedDate
- hasSameAssigneeAndReporter
- hasSameVersions

## Using dates in JQL

- <u>[Aggregation of dates](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209257)</u>
- <u>[Dates with time](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209245)</u>

## Using standard JQL in Jira Cloud

- <u>[What is Advanced Search](https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-searching-in-jira-cloud/)</u>
- Standard JQL<u>[ functions](https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/)</u>, <u>[fields](https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/)</u>, <u>[keywords](https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-keywords/)</u>, <u>[operators](https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/)</u>
- <u>[Development functions](https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-developer-status/)</u>
- <u>[Jira Service Management](https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-fields/)</u> - JSM specific fields and functions, especially around SLA
- <u>[Advanced Roadmaps functions](https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/)</u>

> Macro (appfire-confluence-analytics)