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

 Use this JQL functions reference to learn how to use the advanced search functions provided by **JQL Search Extensions**. This page explains the available functions, their syntax, and example queries to find Jira issues by project, field, attachment, comment, version, link, update, and other issue details.

> ℹ️ The instructions on this page describe how to use the functions from [JQL Search Extensions](https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-the-jql-extensions?hosting=datacenter&tab=overview).
> ℹ️ 
> ℹ️ JQL Search Extensions are accessed from Jira’s [Advanced search](https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html).

##   Projects

> ℹ️ ### **movedIssues(projectKey)**
> ℹ️ 
> ℹ️ Finds issues which moved from the project in argument. For instance: 
> ℹ️ 
> ℹ️ ```
> ℹ️ project = SEARCHSERVER AND issue in movedIssues("SEARCHCLOUD")
> ℹ️ ```
> ℹ️ 
> ℹ️ Will find all issues which are in project SEARCHSERVER and moved from project SEARCHCLOUD.

## Fields

> ℹ️ ### **fieldMatch(jql-subquery, field-name, regexp)**
> ℹ️ 
> ℹ️ FieldMatch can be used to find issues with field matching the regular expression in the argument. For instance:
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fieldMatch("project = SEARCH", "description", "find issues mat*")
> ℹ️ ```
> ℹ️ 
> ℹ️ Will find all issues with description field matching the regular expression `find issues mat*`. 
> ℹ️ 
> ℹ️ The `asterisk *` matches any alphanumeric characters. It is also possible to use all regular expression constructs, such as
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fieldMatch("project = SEARCH", "description", "find issu[a-z]{2} mat*") 
> ℹ️ issue in fieldMatch("project = SEARCH", "my custom field", "f[a-z]{5}
> ℹ️ ```
> ℹ️ 
> ℹ️ This function can be used with any system or custom field.
> ℹ️ 
> ℹ️ For documentation of of regular expression constructs, refer to the [documentation](https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html) from Oracle. 
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **fieldsHaveSameValue(jql-subquery, field-name1, field-name2,...,field-name-x)**
> ℹ️ 
> ℹ️ FieldsHaveSameValue can be used to find issues with fields having the same value. For instance: 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fieldsHaveSameValue("version", "my-custom-field-with-version")
> ℹ️ ```
> ℹ️ 
> ℹ️ It is possible to use multiple fields in the expression, such as below: 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fieldsHaveSameValue("version", "my-custom-field-with-version", "one-more-field-with-version")
> ℹ️ ```
> ℹ️ 
> ℹ️ It is also possible to add JQL subquery to the expression. It will narrow the search only to those issues which match the subquery (in the example below, are in the project DEMO and have the same value of fields version and my-custom-field-with-version).
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fieldsHaveSameValue("project = SEARCH", "version", "my-custom-field-with-version")
> ℹ️ ```
> ℹ️ 
> ℹ️ In case fields contain multiple values (for instance, there are many values of field version) the function will expect all values to be equal (but doesn't expect the same order).

## Attachments

> ℹ️ ### **AttachedAfter**
> ℹ️ 
> ℹ️ AttachedAfter can be used to find issues with attachments added after particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedAfter("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachedBefore**
> ℹ️ 
> ℹ️ AttachedBefore can be used to find issues with attachments added before particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedBefore("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachedBetween**
> ℹ️ 
> ℹ️ AttachedBetween can be used to find issues with attachments added between particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedBetween("2018-05-26", "2018-07-01")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachedOnDate**
> ℹ️ 
> ℹ️ AttachedOnDate can be used to find issues with attachments added on particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedOnDate("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachedByUser**
> ℹ️ 
> ℹ️ AttachedByUser can be used to find issues with attachments added by a particular user (username is expected)
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedByUser("filip")
> ℹ️ ```
> ℹ️ 
> ℹ️ 
> ℹ️ This function can be used together with membersOf to find issues attached by users who are members of a particular group.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedByUser("membersOf(employees)")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachmentExtension**
> ℹ️ 
> ℹ️ AttachmentExtension can be used to find issues with attachments with particular extension.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachmentExtension("pdf")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachmentName**
> ℹ️ 
> ℹ️ AttachmentName can used to find issues with attachments with particular name.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachedName("documentation")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachmentsCountEqualTo**
> ℹ️ 
> ℹ️ AttachmentsCountEqualTo can be used to find issues with particular number of attachments.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachmentsCountEqualTo(2)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachmentsCountGreaterThan**
> ℹ️ 
> ℹ️ AttachmentsCountGreaterThan can be used to find issues with number of attachments greater than provided number
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachmentsCountGreaterThan(1)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AttachmentsCountLessThan**
> ℹ️ 
> ℹ️ AttachmentsCountLessThan can be used to find issues with number of attachments lesser than provided number
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in attachmentsCountLessThan(2)
> ℹ️ ```

 

## Comments

> ℹ️ ### **CommentedAfter**
> ℹ️ 
> ℹ️ CommentedAfter can be used to find issues with comments added after particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedAfter("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentedBefore**
> ℹ️ 
> ℹ️ CommentedBefore can be used to find issues with comments added before particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedBefore("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentedBetween**
> ℹ️ 
> ℹ️ CommentedBetween can be used to find issues with comments added between particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedBetween("2018-05-26", "2018-07-01")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentedOnDate**
> ℹ️ 
> ℹ️ CommentedOnDate can be used to find issues with comments added on particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedOnDate("2018-05-26")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentedByUser**
> ℹ️ 
> ℹ️ CommentedByUser can be used to find issues with comments added by a particular user (username is expected)
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedByUser("filip")
> ℹ️ ```
> ℹ️ 
> ℹ️ This function can be used together with membersOf to find issues commented by users who are members of a particular group.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentedByUser("membersOf(employees)")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentsCountEqualTo**
> ℹ️ 
> ℹ️ CommentsCountEqualTo can be used to find issues with particular number of comments.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentsCountEqualTo(2)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentsCountGreaterThan**
> ℹ️ 
> ℹ️ CommentsCountGreaterThan can be used to find issues with number of comments greater than provided number
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentsCountGreaterThan(2)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommentsCountLessThan**
> ℹ️ 
> ℹ️ CommentsCountLessThan can be used to find issues with number of comments lesser than provided number
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in commentsCountLessThan(2)
> ℹ️ ```

 

## Versions

> ℹ️ ### **AffectedVersionsArchivedCountLessThan**
> ℹ️ 
> ℹ️ ### **FixVersionsArchivedCountLessThan**
> ℹ️ 
> ℹ️ AffectedVersionsArchivedCountLessThan and FixVersionsArchivedCountLessThan can be used to find issues with number of archived versions less than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsArchivedCountLessThan(2) OR issue in fixVersionsArchivedCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsArchivedCountEqualTo**
> ℹ️ 
> ℹ️ ### **FixVersionsArchivedCountEqualTo**
> ℹ️ 
> ℹ️ AffectedVersionsArchivedCountEqualTo and FixVersionsArchivedCountEqualTo can be used to find issues with number of archived versions equal to provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsArchivedCountEqualTo(2) OR issue in fixVersionsArchivedCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsArchivedCountGreaterThan**
> ℹ️ 
> ℹ️ ### **FixVersionsArchivedCountGreaterThan**
> ℹ️ 
> ℹ️ AffectedVersionsArchivedCountGreaterThan and FixVersionsArchivedCountGreaterThan can be used to find issues with number of archived versions greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsArchivedCountGreaterThan(2) OR issue in fixVersionsArchivedCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsCountLessThan**
> ℹ️ 
> ℹ️ ### **FixVersionsCountLessThan**
> ℹ️ 
> ℹ️ AffectedVersionsCountLessThan and FixVersionsCountLessThan can be used to find issues with number of versions less than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsCountLessThan(2) OR issue in fixVersionsCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsCountEqualTo**
> ℹ️ 
> ℹ️ ### **FixVersionsCountEqualTo**
> ℹ️ 
> ℹ️ AffectedVersionsCountEqualTo and FixVersionsCountEqualTo can be used to find issues with number of versions equal to provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsCountEqualTo(2) OR issue in fixVersionsCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsCountGreaterThan**
> ℹ️ 
> ℹ️ ### **FixVersionsCountGreaterThan**
> ℹ️ 
> ℹ️ AffectedVersionsCountGreaterThan and FixVersionsCountGreaterThan can be used to find issues with number of versions greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsCountGreaterThan(2) OR issue in fixVersionsCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsOpenedCountLessThan**
> ℹ️ 
> ℹ️ ### **FixVersionsOpenedCountLessThan**
> ℹ️ 
> ℹ️ AffectedVersionsOpenedCountLessThan and FixVersionsOpenedCountLessThan can be used to find issues with number of opened versions less than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsOpenedCountLessThan(2) OR issue in fixVersionsOpenedCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsOpenedCountEqualTo**
> ℹ️ 
> ℹ️ ### **FixVersionsOpenedCountEqualTo**
> ℹ️ 
> ℹ️ AffectedVersionsOpenedCountEqualTo and FixVersionsOpenedCountEqualTo can be used to find issues with number of opened versions equal to provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsOpenedCountEqualTo(2) OR issue in fixVersionsOpenedCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsOpenedCountGreaterThan**
> ℹ️ 
> ℹ️ ### **FixVersionsOpenedCountGreaterThan**
> ℹ️ 
> ℹ️ AffectedVersionsOpenedCountGreaterThan and FixVersionsOpenedCountGreaterThan can be used to find issues with number of opened versions greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsOpenedCountGreaterThan(2) OR issue in fixVersionsOpenedCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsReleasedCountLessThan**
> ℹ️ 
> ℹ️ ### **FixVersionsReleasedCountLessThan**
> ℹ️ 
> ℹ️ AffectedVersionsReleasedCountLessThan and FixVersionsReleasedCountLessThan can be used to find issues with number of released versions less than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsReleasedCountLessThan(2) OR issue in fixVersionsReleasedCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsReleasedCountEqualTo**
> ℹ️ 
> ℹ️ ### **FixVersionsReleasedCountEqualTo**
> ℹ️ 
> ℹ️ AffectedVersionsReleasedCountEqualTo and FixVersionsReleasedCountEqualTo can be used to find issues with number of released versions equal to provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsReleasedCountEqualTo(2) OR issue in fixVersionsReleasedCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **AffectedVersionsReleasedCountGreaterThan**
> ℹ️ 
> ℹ️ ### **FixVersionsReleasedCountGreaterThan**
> ℹ️ 
> ℹ️ AffectedVersionsReleasedCountGreaterThan and FixVersionsReleasedCountGreaterThan can be used to find issues with number of released versions greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in affectedVersionsReleasedCountGreaterThan(2) OR issue in fixVersionsReleasedCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **FixVersionReleasedOnDate**
> ℹ️ 
> ℹ️ ### **AffectedVersionReleasedOnDate**
> ℹ️ 
> ℹ️ FixVersionReleasedOnDate and AffectedVersionReleasedOnDate can be used to find issues with versions released on particular date.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fixVersionReleasedOnDate("2018-05-26") OR issue in affectedVersionReleasedOnDate("2018-05-26")
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **FixVersionReleasedBetweenDates**
> ℹ️ 
> ℹ️ ### **AffectedVersionReleasedBetweenDates**
> ℹ️ 
> ℹ️ FixVersionReleasedBetweenDates and AffectedVersionReleasedBetweenDates can be used to find issues with versions released between provided dates.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fixVersionReleasedBetweenDates("2018-05-26", "2018-07-01") OR issue in affectedVersionReleasedBetweenDates("2018-05-26", "2018-07-01")
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **FixVersionReleasedAfterDate**
> ℹ️ 
> ℹ️ ### **AffectedVersionReleasedAfterDate**
> ℹ️ 
> ℹ️ FixVersionReleasedAfterDate and AffectedVersionReleasedAfterDate can be used to find issues with versions released after particular date.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fixVersionReleasedAfterDate("2018-05-26") OR issue in affectedVersionReleasedAfterDate("2018-05-26")
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **FixVersionReleasedBeforeDate**
> ℹ️ 
> ℹ️ ### **AffectedVersionReleasedBeforeDate**
> ℹ️ 
> ℹ️ FixVersionReleasedBeforeDate and AffectedVersionReleasedBeforeDate can be used to find issues with versions released before particular date.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in fixVersionReleasedBeforeDate("2018-05-26") OR issue in affectedVersionReleasedBeforeDate("2018-05-26")
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LatestReleaseVersionForProject**
> ℹ️ 
> ℹ️ LatestReleaseVersionForProject can be used to find issues with versions which are the most recently released version for the project. 
> ℹ️ 
> ℹ️ ```
> ℹ️ fixVersion in latestReleaseVersionForProject("SEARCH")
> ℹ️ 
> ℹ️ ```

 

## Links

> ℹ️ ### **LinksCountLessThan**
> ℹ️ 
> ℹ️ LinksCountLessThan can be used to find issues with number of links less than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linksCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinksCountGreaterThan**
> ℹ️ 
> ℹ️ LinksCountGreaterThan can be used to find issues with number of links greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linksCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinksCountEqualTo**
> ℹ️ 
> ℹ️ LinksCountEqualTo can be used to find issues with number of links equal to the provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linksCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedBy([linktype], jql-query or issuekeys)**
> ℹ️ 
> ℹ️ Search for issues that are linked by given issues or by issues matched by the given JQL. Link type can be provided to limit the search to particular link type or types. Many link types can be specified in a single function call.
> ℹ️ 
> ℹ️ The first optional list of arguments specifies link types. They are followed by either JQL or a list of issue keys.
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which are linked by JQL-3 or JQL-5. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedBy(JQL-3, JQL-5)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ Find issues which are linked by issues from project JQL with priority = Highest. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedBy("project = JQL AND priority = Highest")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ Find issues which are blocked by issue JQL-3 or JQL-5. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedBy("is blocked by", "JQL-3", JQL-5)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ Find issues which are blocked by issues from project JQL with priority = Highest. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedBy("is blocked by", "is related to", "project = JQL AND priority = Highest")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **Links(jql-query, link type)**
> ℹ️ 
> ℹ️ Search for issues which links issues matched by JQL. Link type can be provided to limit the search to particular link type or types. Many link types can be specified in single function call.
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which link at least one issue from project JQL. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in links("project = JQL")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which "blocks" at least one issue from project JQL. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in links("blocks", "project = JQL")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinksIssue**
> ℹ️ 
> ℹ️ Search for issues which links a particular issue. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which link JQL-3 or JQL-5
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linksIssue(JQL-3, JQL-5)
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkType**
> ℹ️ 
> ℹ️ Search for issues which have a particular link type. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are blocked by another issue
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkType("is blocked by")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedIssueStatus**
> ℹ️ 
> ℹ️ Search for issues which are linked or link issues with a particular status. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are linked by issues in "To Do" status. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedIssueStatus("To Do")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedIssueStatusCategory**
> ℹ️ 
> ℹ️ Search for issues which are linked or link issues with a particular status category. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are linked or link issues in status category "Done"
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedIssueStatusCategory("Done")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedIssueType**
> ℹ️ 
> ℹ️ Search for issues which are linked or link issue with a particular issue type. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are linked by Bugs. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedIssueType("Bug")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedIssuePriority**
> ℹ️ 
> ℹ️ Search for issues which are linked or links issues with a particular priority. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are linked by "blockers"
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedIssuePriority("Blocker")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LinkedByIssueProject**
> ℹ️ 
> ℹ️ Search for issues which are linked or links issues from a particular project. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all issues which are linked or links project JQL
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in linkedByIssueProject("JQL")
> ℹ️ ```

 

## Updated

> ℹ️ ### **UpdatedByUserCountLessThan**
> ℹ️ 
> ℹ️ UpdatedByUserCountLessThan can be used to find issues updated by less than provided number of users.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in updatedByUserCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **UpdatedByUserCountGreaterThan**
> ℹ️ 
> ℹ️ UpdatedByUserCountGreaterThan can be used to find issues updated by greater than provided number of users.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in updatedByUserCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **UpdatedByUserCountEqualTo**
> ℹ️ 
> ℹ️ UpdatedByUserCountEqualTo can be used to find issues updated by particular number of users.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in updatedByUserCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **UpdatedByUser**
> ℹ️ 
> ℹ️ Search for issues which were updated by a particular user/users. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which were updated by Helen or Daniel:
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in updatedByUser("helen", "daniel")
> ℹ️ issue in updatedByUser("membersOf(employees)")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **TransitionedByUser**
> ℹ️ 
> ℹ️ Search for issues which were transitioned by a particular user/users. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues which were transitioned by Helen or Daniel:
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in transitionedBy in ("daniel", "helen")
> ℹ️ issue in transitionedBy("membersOf(employees)")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **LoggedTimeByUser**
> ℹ️ 
> ℹ️ Search for issues on which particular users reported time. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues on which Helen or Daniel reported time. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in loggedTimeByUser("daniel", "helen")
> ℹ️ issue in loggedTimeByUser("membersOf(employees)"
> ℹ️ ```

 

## Subtasks

> ℹ️ ### **SubTaskOf(jql-query)**
> ℹ️ 
> ℹ️ Search for subtasks of issues matching JQL. 
> ℹ️ 
> ℹ️ **EXAMPLES**  
> ℹ️ Find subtasks of parents with priority = Blocker. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subtaskOf("priority = Blocker")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **ParentOf(jql-query)**
> ℹ️ 
> ℹ️ Search for parents of issues matching JQL. 
> ℹ️ 
> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find parents of subtasks with issue type = Bug. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in parentOf("issueType = Bug")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubtaskCountLessThan**
> ℹ️ 
> ℹ️ SubtaskCountGreaterThan can be used to find issues with number of subtasks lesser than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subtaskCountLessThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubtaskCountGreaterThan**
> ℹ️ 
> ℹ️ SubtaskCountGreaterThan can be used to find issues with number of subtasks greater than provided number.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subtaskCountGreaterThan(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubtaskCountEqualTo**
> ℹ️ 
> ℹ️ SubtaskCountEqualTo can be used to find issues with a particular number of subtasks.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subtaskCountEqualTo(2)
> ℹ️ 
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubTaskKey**
> ℹ️ 
> ℹ️ Search for issues that have subtasks with a particular key. 
> ℹ️ 
> ℹ️ **EXAMPLES** 
> ℹ️ 
> ℹ️ Find issues with subtask with key ABC-123
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subtaskKey("ABC-123")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubtaskPriority**
> ℹ️ 
> ℹ️ Search for issues that have subtasks with a particular [Priority](https://confluence.atlassian.com/jira/what-is-an-issue-270829373.html).
> ℹ️ 
> ℹ️ **EXAMPLES** 
> ℹ️ 
> ℹ️ Find issues with subtasks which have a "Blocker" priority. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subTaskPriority("Blocker")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubTaskType**
> ℹ️ 
> ℹ️ Search for issues that have subtasks with a particular [Issue Type](https://confluence.atlassian.com/jira/what-is-an-issue-270829373.html).
> ℹ️ 
> ℹ️ **EXAMPLES** 
> ℹ️ 
> ℹ️ Find issues which have "Test" issue type. 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subTaskType("Test")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubTaskStatus**
> ℹ️ 
> ℹ️ Search for issues that have subtasks with a particular [Status](https://confluence.atlassian.com/jira/what-is-an-issue-270829373.html).
> ℹ️ 
> ℹ️ **EXAMPLES** 
> ℹ️ 
> ℹ️ Find issues which have subtasks "In Progress". 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subTaskStatus("In Progress")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **SubTaskStatusCategory**
> ℹ️ 
> ℹ️ Search for issues that have subtasks with a particular [Status Category](https://confluence.atlassian.com/adminjiraserver070/defining-status-field-values-749382903.html).
> ℹ️ 
> ℹ️ **EXAMPLES** 
> ℹ️ 
> ℹ️ Find issues which have "To Do" status category.
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in subTaskStatusCategory("To Do")
> ℹ️ ```

 

## Software Development

> ℹ️ ### **OpenPullRequestsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of open pull requests. This value is present if JIRA is connected to Bitbucket. 
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with open pull requests.
> ℹ️ 
> ℹ️ ```
> ℹ️ openPullRequestsCount > 0
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **CommitsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of commits. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with commits.
> ℹ️ 
> ℹ️ ```
> ℹ️ commitsCount > 0
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **FailingBuildsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of failed builds. This value is present if JIRA is connected to Bamboo. 
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with failing builds. 
> ℹ️ 
> ℹ️ ```
> ℹ️ failingBuildsCount > 0
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **OpenReviewsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of open reviews. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with failing builds. 
> ℹ️ 
> ℹ️ ```
> ℹ️ openReviewsCount > 0
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **PullRequestsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of pull requests. This value is present if JIRA is connected to Bitbucket. 
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with pull requests. 
> ℹ️ 
> ℹ️ ```
> ℹ️ pullRequestsCount > 0
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **ReviewsCount**
> ℹ️ 
> ℹ️ Search for issues that have particular number of reviews. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues with pull requests. 
> ℹ️ 
> ℹ️ ```
> ℹ️ reviewsCount > 0
> ℹ️ ```

 

## Issue hierarchy 

> ℹ️ ### **AllIssuesInEpic(jql-query or issuekey)**
> ℹ️ 
> ℹ️ Search for all epics, issues in epics and subtasks of these issues. 
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find issues and subtasks of epic "SEARCH-12"
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in allIssuesInEpic(SEARCH-12)
> ℹ️ ```
> ℹ️ 
> ℹ️ Find issues and subtasks of epics "SEARCH-12, SEARCH-13"
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in allIssuesInEpic(SEARCH-12, SEARCH-13)
> ℹ️ ```
> ℹ️ 
> ℹ️ Find issues and subtasks of epics and issues for fixVersion = 1.0 in project SEARCH 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in allIssuesInEpic("fixVersion = 1.0 AND project = SEARCH")
> ℹ️ ```
> ℹ️ 
> ℹ️  
> ℹ️ 
> ℹ️ ### **EpicOf(jql-query)**
> ℹ️ 
> ℹ️ Find all epics which have issues matching JQL query. 
> ℹ️ 
> ℹ️ **SUPPORTED OPERATORS **

| **=** | **!=** | **~** | **!~** | **>** | **>=** | **<** | **<=** | **IS** | **IS NOT** | **IN** | **NOT IN** | **WAS** | **WAS IN** | **WAS NOT** | **WAS NOT IN** | **CHANGED** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :check_mark: | :check_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: | :cross_mark: |

> ℹ️ **EXAMPLES**
> ℹ️ 
> ℹ️ Find all epics with unresolved, high-priority stories 
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in epicOf("issuetype = Story and resolution is empty and priority = High")
> ℹ️ ```
> ℹ️ 
> ℹ️ Find all epics for the fixVersion 1.0 in project SEARCH
> ℹ️ 
> ℹ️ ```
> ℹ️ issue in epicOf("fixVersion = 1.0 and project = SEARCH")
> ℹ️ ```

##  User

> ℹ️ ### **UserMatch(regular-expression)**
> ℹ️ 
> ℹ️ UserMatch can be used to find issues with user fields matching the regular expression in the argument. For instance:
> ℹ️ 
> ℹ️ ```
> ℹ️ assignee in userMatch("danie*")
> ℹ️ ```
> ℹ️ 
> ℹ️ Will find all issues with assignee username matching the regular expression danie*, such as daniel, danied, danie3 etc.
> ℹ️ 
> ℹ️ The asterisk **'*'** matches any alphanumeric characters. It is also possible to use all regular expression constructs, such as
> ℹ️ 
> ℹ️ ```
> ℹ️ assignee in userMatch("danie[a-z]") // matching danie followed by a single lowercase alphabet character
> ℹ️ assignee in userMatch("dan[a-z]{3}") // matching dan followed by three lowercase alphabet characters
> ℹ️ ```
> ℹ️ 
> ℹ️ This function can be used for any user field. For documentation of regular expression constructs, please follow [this link](https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html)

 

 


Write a comment…