Date
dateCompare
The comparison operators available in this function are <, >, <=, >=, =. The use of the "!=" operator when using the dateCompare function is only supported on ScriptRunner for Jira Cloud. However, you can achieve the same result by using "=" and negating the JQL clause itself in ScriptRunner for Jira Server/DC.
dateCompare(Subquery, date comparison expression)
This function lets you compare two dates on the same issue, for instance to find all issues that were resolved later than their due date:
issueFunction in dateCompare("", "resolutionDate > dueDate")
You can use time windows on either side of the expression. Eg to find issues resolved before or up to one week after their due date:
issueFunction in dateCompare("", "resolutionDate < dueDate +1w")
You can also use created and updated. To find issues that were resolved within two weeks of creation, use:
issueFunction in dateCompare("", "created +2w > resolutionDate ")
In addition, you can use the "fields" firstCommented, and lastCommented (reindex required after first install). To find issues that had not been commented within one week of creation:
issueFunction in dateCompare("", "created +1w < firstCommented ")
You can also use date and datetime custom fields. Example:
issueFunction in dateCompare("", "resolutionDate > Delivery Date")
where Delivery Date is the name of a date custom field.
You can also use the equality operator = to find issues issues that have been resolved on their delivery date:
issueFunction in dateCompare("", "resolutionDate = Delivery Date")
Performance
Performance will be proportional to the number of issues that have both fields in the date comparison set. If this is a very high number of issues (greater than 50k) you can filter some out: eg:
issueFunction in dateCompare("project in myProjects()", "resolutionDate > dueDate")
lastUpdated
lastUpdated (by / inRole / inGroup)
Finds issues by the user who last updated them. Example, find all issues that were last updated by members of the Developers role:
issueFunction in lastUpdated('inRole Administrators')
Last updated comprises the following actions:
edits
state changes
adding/removing links, labels etc
commenting