Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Are you using JQL Search Extensions for Jira Server/Data Center and want to continue using JQL Search Extensions on Jira Cloud? This page describes the key platform and feature differences. You can also find a list of the additional Cloud-only extensions that are available to you with JQl Search Extensions for Jira Cloud.

In On this sectionpage:

Table of Contents
minLevel2
maxLevel3
outlinefalse
stylediscdefault
typelist
printablefalse

Platform differences

JQL syntax

The implementation of JQL Search Extensions is different for Jira Server/Data Center and Jira Cloud.

...

For Jira Cloud, most JQL extensions are implemented as JQL keywords as references to issue metadata resulting in indexed searches. Keywords are followed by operators, for example, commentedOnDate < "2018-05-26". Other, more complex searches are implemented as JQL functions.

Usage

In JQL Search Extensions for Jira Server/Data Center, you can use the extensions in Jira’s advanced search.

In JQL Search Extensions for Jira Cloud, JQL keywords provided by the app can be used in Jira’s advanced search and the Extended Search page. JQL functions are accessible from the Extended Search page or by using Extended Search filters in Jira advanced search.

Examples

Jira Server/ Data Center

Jira Cloud

Execution model

With the Server/Data Center version, the search queries are executed in the same Java Virtual Machine (JVM) as Jira. In the Cloud version, the JQL Search Extensions service is a separate deployment communicating with Jira over the REST API. As a result, all operations in the cloud are indexed asynchronously, and updates to issues in Jira can be reflected in the JQL with a slight delay.

Migration pathway

Queries are not migrated. If you want to use any saved queries from your Server/Data instance in Jira Cloud, the first step is to identify queries that use JQL Search Extensions. You should especially look at:

  • filtersFilters

  • board Board filters

  • automation Automation rules

  • dashboard Dashboard gadgets

  • plugins Other apps that accept filters and JQL queries (e.g. JSU, JMWE, Power Scripts, BigPicture)

Once you have identified where the saved queries are used, translate them to the Cloud-equivalent JQL extension using the table below. You can also build new queries using the additional extensions provided by JQL Search Extensions for Jira Cloud. If you need further guidance, contact our support team.

Feature parity comparison

The table below lists the parity between JQL Search Extensions for Jira Server/Data Center and Jira Cloud. Note the difference in syntax for Server/Data Center functions and Cloud keywords.

Server/Data Center

Cloud

Notes

Projects

movedIssues()

movedProjects

Fields

fieldMatch()

regex(), or wildcardMatch()

fieldsHaveSameValue()

hasSameUpdatedAndCreatedDate

hasSameAssigneeAndReporter

hasSameVersions

Limited support at the moment but a generic function is on our roadmap

Attachments

attachedAfter()

attachedOnDate

attachedBefore()

attachedOnDate

attachedBetween()

attachedOnDate

attachedOnDate()

attachedOnDate

attachedByUser()

attachedByUser

attachmentExtension()

attachmentExtension

attachmentName()

attachedByUser

attachmentsCountEqualTo()

attachmentsCount

attachmentsCountGreaterThan()

attachmentsCount

attachmentsCountLessThan()

attachmentsCount

Comments

commentedAfter()

commentedOnDate

commentedBefore()

commentedOnDate

commentedBetween()

commentedOnDate

commentedOnDate()

commentedOnDate

commentedByUser()

commentedByUser

commentLastCreatedBy

commentLastUpdatedBy

commentsCountEqualTo()

commentsCount

commentsCountGreaterThan()

commentsCount

commentsCountLessThan()

commentsCount

Versions

affectedVersionsArchivedCountLessThan()

affectedVersionsArchived

affectedVersionsArchivedCountEqualTo()

affectedVersionsArchived

affectedVersionsArchivedCountGreaterThan()

affectedVersionsArchived

affectedVersionsCountLessThan()

affectedVersionsCount

affectedVersionsCountEqualTo()

affectedVersionsCount

affectedVersionsCountGreaterThan()

affectedVersionsCount

affectedVersionsOpenedCountLessThan()

affectedVersionsOpened

affectedVersionsOpenedCountEqualTo()

affectedVersionsOpened

affectedVersionsOpenedCountGreaterThan()

affectedVersionsOpened

affectedVersionsReleasedCountLessThan()

affectedVersionsReleased

affectedVersionsReleasedCountEqualTo()

affectedVersionsReleased

affectedVersionsReleasedCountGreaterThan()

affectedVersionsReleased

affectedVersionReleasedOnDate()

affectedVersionReleasedDate

affectedVersionReleasedBetweenDates()

affectedVersionReleasedDate

affectedVersionReleasedAfterDate()

affectedVersionReleasedDate

affectedVersionReleasedBeforeDate()

affectedVersionReleasedDate

fixVersionsArchivedCountLessThan()

fixVersionsArchived

fixVersionsArchivedCountEqualTo()

fixVersionsArchived

fixVersionsArchivedCountGreaterThan()

fixVersionsArchived

fixVersionsCountLessThan()

fixVersionsCount

fixVersionsCountEqualTo()

fixVersionsCount

fixVersionsCountGreaterThan()

fixVersionsCount

fixVersionsOpenedCountLessThan()

fixVersionsOpened

fixVersionsOpenedCountEqualTo()

fixVersionsOpened

fixVersionsOpenedCountGreaterThan()

fixVersionsOpened

fixVersionsReleasedCountLessThan()

fixVersionsReleased

fixVersionsReleasedCountEqualTo()

fixVersionsReleased

fixVersionsReleasedCountGreaterThan()

fixVersionsReleased

fixVersionReleasedOnDate()

fixVersionReleaseDate

fixVersionReleasedBetweenDates()

fixVersionReleaseDate

fixVersionReleasedAfterDate()

fixVersionReleaseDate

fixVersionReleasedBeforeDate()

fixVersionReleaseDate

latestReleaseVersionForProject()

No direct cloud equivalent at the moment

Links

linksCountLessThan()

linksCount

linksCountGreaterThan()

linksCount

linksCountEqualTo()

linksCount

linkedBy([linktype], jql-query or issuekeys)

function linkedIssuesOfQuery()

links(jql-query, link type)

function linkedIssuesOfQuery()

linksIssue()

linkedBy

linksIssue

linkType()

linkType

linkedIssueStatus()

linkedIssueStatus

linkedIssueStatusCategory()

linkedIssueStatusCategory

linkedIssueType()

linkedIssueType

linkedIssuePriority()

linkedIssuePriority

linkedByIssueProject()

linkedByIssueProject

Issue Updates

updatedByUserCountLessThan()

updatedByUsersCount

updatedByUserCountGreaterThan()

updatedByUsersCount

updatedByUserCountEqualTo()

updatedByUsersCount

updatedByUser()

updatedBy

transitionedByUser()

transitionedBy

loggedTimeByUser()

loggedTimeBy

Subtasks

subTaskOf(jql-query)

function subtasksOfParentsInQuery()

parentOf(jql-query)

functions

parentsOfIssuesInQuery()

parentsOfIssuesInQueryRecursive()

subtaskCountLessThan()

subtasksCount

subtaskCountGreaterThan()

subtasksCount

subtaskCountEqualTo()

subtasksCount

subTaskKey()

subtaskKey

subtaskPriority()

subtaskPriority

subTaskType()

subtaskIssueType

subTaskStatus()

subtaskStatus

subTaskStatusCategory()

subtaskStatusCategory

Software development

openPullRequestsCount()
commitsCount()
failingBuildsCount()
openReviewsCount()
pullRequestsCount()
reviewsCount()

There is no support in JQL Search Extensions

If you linked your development tools, refer to the native Jira Cloud JQL documentation https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-development-fields-reference-973491363.html

Issue hierarchy

allIssuesInEpic(jql-query or issuekey)

function childrenOfEpicsInQuery()

epicOf(jql-query)

function epicsOfChildrenInQuery()

User

userMatch

No direct cloud equivalent

Cloud-only features

JQL Search Extensions for Jira Cloud provides the following additional extensions unavailable with the Server/Data Center app.

...