...
Or invoked as functions in the Extended Search screen. Queries that contain functions need to be saved as filters if they need to be used in Jira
JQL aliases added by the app are accessible in Jira Advanced Search. JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search.
Refer to the table in the next section to see the mapping between server and cloud JQL functions.
...
The following table lists the JQL extensions available on server and their cloud counterparts.
See the full list of Cloud JQL extensions that is available in the cloudwith examples: JQL aliases and functions (reference)
JQL on Server and DC | JQL in Cloud | Comments |
---|---|---|
Projects | ||
|
| |
Fields | ||
| functions: | |
| 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 | ||
Issue hierarchy | ||
...