...
The following table lists the JQL extensions available on server and their cloud counterparts. Almost all functions from server have an equivalent in cloud.
See the full list of Cloud JQL extensions with examples: JQL aliases and functions (reference)
JQL on Server and DC | JQL in Cloud | Comments |
---|---|---|
Projects | ||
MovedIssues |
| |
Fields | ||
FieldMatch | functions: | |
FieldsHaveSameValue | aliases:
| Limited support at the moment but a generic function is on our roadmap |
Attachments | ||
AttachedAfter |
| |
AttachedBefore |
| |
AttachedBetween |
| |
AttachedOnDate |
| |
AttachedByUser |
| |
AttachmentExtension |
| |
AttachmentName |
| |
AttachmentsCountEqualTo |
| |
AttachmentsCountGreaterThan |
| |
AttachmentsCountLessThan |
| |
Comments | ||
CommentedAfter |
| |
CommentedBefore |
| |
CommentedBetween |
| |
CommentedOnDate |
| |
CommentedByUser |
| |
CommentsCountEqualTo |
| |
CommentsCountGreaterThan |
| |
CommentsCountLessThan |
| |
Versions | ||
AffectedVersionsArchivedCountLessThan |
| |
AffectedVersionsArchivedCountEqualTo |
| |
AffectedVersionsArchivedCountGreaterThan |
| |
AffectedVersionsCountLessThan |
| |
AffectedVersionsCountEqualTo |
| |
AffectedVersionsCountGreaterThan |
| |
AffectedVersionsOpenedCountLessThan |
| |
AffectedVersionsOpenedCountEqualTo |
| |
AffectedVersionsOpenedCountGreaterThan |
| |
AffectedVersionsReleasedCountLessThan |
| |
AffectedVersionsReleasedCountEqualTo |
| |
AffectedVersionsReleasedCountGreaterThan |
| |
AffectedVersionReleasedOnDate |
| |
AffectedVersionReleasedBetweenDates |
| |
AffectedVersionReleasedAfterDate |
| |
AffectedVersionReleasedBeforeDate |
| |
FixVersionsArchivedCountLessThan |
| |
FixVersionsArchivedCountEqualTo |
| |
FixVersionsArchivedCountGreaterThan |
| |
FixVersionsCountLessThan |
| |
FixVersionsCountEqualTo |
| |
FixVersionsCountGreaterThan |
| |
FixVersionsOpenedCountLessThan |
| |
FixVersionsOpenedCountEqualTo |
| |
FixVersionsOpenedCountGreaterThan |
| |
FixVersionsReleasedCountLessThan |
| |
FixVersionsReleasedCountEqualTo |
| |
FixVersionsReleasedCountGreaterThan |
| |
FixVersionReleasedOnDate |
| |
FixVersionReleasedBetweenDates |
| |
FixVersionReleasedAfterDate |
| |
FixVersionReleasedBeforeDate |
| |
LatestReleaseVersionForProject | no direct cloud equivalent at the moment | |
Links | ||
LinksCountLessThan |
| |
LinksCountGreaterThan |
| |
LinksCountEqualTo |
| |
LinkedBy([linktype], jql-query or issuekeys) | function | |
Links(jql-query, link type) | function | |
LinksIssue |
| |
LinkType |
| |
LinkedIssueStatus |
| |
LinkedIssueStatusCategory |
| |
LinkedIssueType |
| |
LinkedIssuePriority |
| |
LinkedByIssueProject |
| |
Updated | ||
UpdatedByUserCountLessThan |
| |
UpdatedByUserCountGreaterThan |
| |
UpdatedByUserCountEqualTo |
| |
UpdatedByUser |
| |
TransitionedByUser |
| |
LoggedTimeByUser |
| |
Subtasks | ||
SubTaskOf(jql-query) | function | |
ParentOf(jql-query) | functions
| |
SubtaskCountLessThan |
| |
SubtaskCountGreaterThan |
| |
SubtaskCountEqualTo |
| |
SubTaskKey |
| |
SubtaskPriority |
| |
SubTaskType |
| |
SubTaskStatus |
| |
SubTaskStatusCategory |
| |
Software development | ||
OpenPullRequestsCount | 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 | |
EpicOf(jql-query) | function | |
User | ||
| no direct cloud equivalent at the moment |
Migration steps
The first step is to identify queries that are using JQL extensions. You should especially look at:
...