JQL Support (Cloud)
Looking for the documentation on the newest versions of Power Scripts for Jira 8 for Server/Data Center? Click here !
Power Scripts for Jira Cloud can enhance your ability to search for issues using JQL. However, it is important to point out the difference between a traditional, server-hosted JQL function and a cloud-hosted JQL keyword. A JQL function performs an evaluation of the issue in real-time during the JQL search. This type of search is not possible in Jira Cloud and may never be possible in Cloud because it is a very resource intensive way of searching. A JQL keyword is meta-data for an issue that has been evaluated and saved prior to a JQL search. This type of search will always be faster and more efficient than a traditional, functional search since the results can be indexed and it is less resource intensive.
JQL Keywords
Attachments
attachedBy
Search issues where a specified user has attached a file to them using the attachedBy keyword.
attachedBy = "jdoe" AND created > startOfYear() |
Data type: User
attachmentEarliestDate
Search issues based on the earliest date an attachment was added using attachmentEarliestDate keyword.
attachmentEarliestDate < startOfMonth()
//or
attachmentEarliestDate = "2020-01-01" |
Data type: Date
attachmentLatestDate
Search issues based on the latest date an attachment was added using attachmentLatestDate keyword.
attachmentLatestDate > startOfDay() |
Data type: DateÂ
countOfAttachments
Search issues based on the number of attachments it has using the countOfAttachments keyword. This can be used to determine if the issue has any attachments at all.Â
Data type: NumberÂ
typeOfAttachment
Search for issus that contain a specific type of attachment. This search is based on the file extension of the attachment. For example, to search for a Microsoft Word document use "doc" or "docx".
Data type: Text
Comments
commentAuthors
Search for issues based on users who have commented on the issue using the commentAuthors keyword.
Data type: User
commentedOnDatesÂ
Search for issues based on the dates that comments were created using the commentedOnDates keyword.
Data type: Date
commentVisibleGroups
Search for issues with comments that have visibility restrictions applied for a specified group using the commentVisibleGroups keyword.
Data type: Text
commentVisibleRoles
Search for issues with comments that have visibility restrictions applied for a specified project role using the commentVisibleRoles keyword.
Data type: Text
countOfComments
Search issues based on the number of comments it has. This can be used to determine if the issue has any comments at all using the countOfComments keyword.Â
Data type: Number
firstCommentedOnDate
Search issues based on the earliest date a comment was added using the firstCommentedOnDate keyword.Â
Data type: Date
newestCommentAuthor
Search issues based on username of the last person to add a comment to an issue using the newestCommentAuthor keyword.
Data type: Text
lastCommentedOnDate
Search issues based on the latest date a comment was added using the lastCommentedOnDate keyword.
Data type: DateÂ
newestCommentVisibleGroup
Search for issues with a visibility restrictions applied for a specified group for the newest comment added using the newestCommentVisibleGroup keyword.
Data type: TextÂ
newestCommentVisibleRole
Search for issues with a visibility restrictions applied for a specified project role for the newest comment added using the newestCommentVisibleRole keyword.
Data type: Text
Issue Links
hasLinkType
Search issues based on the link type name using the hasLinkType keyword.
hasIssueLinks
Search issues based on the link type inward description using the hasIssueLinks keyword.Â
countOfLinks
Search issues based on the number of links it has. This can be used to determine if the issue has any links at all using the linksNumber keyword.Â
Data type: Number
Subtasks
countOfSubtasks
Search issues based on the number of subtasks it has. This can be used to determine if the issue has any subtasks at all using the countOfSubtasks keyword.Â
Data type: NumberÂ