Advanced query to fetch the defects based on the comments field

[Tushar Kulkarni]

Use case: Fetch the task details(defects) where Assignee have not added the comment in last 48 hours.

There could be a scenario where Assignee added first comment to the defect but then forgot to add the comments for next 3-4 consecutive days then our query should be able to fetch the details of such tasks.

Query should not consider any other fields apart from comments for search criteria.

Any quick help would be appreciated.

version 8.5.6

[Muhammad Ramzan(Atlassian Certified Master)]

You can achieve this by using some third party plugins. I am using JQL Search Extensions for Jira & reports and can give you some examples.

CommentedAfter can be used to find issues with comments added after particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

issue in commentedAfter("2018-05-26")

CommentedBetween can be used to find issues with comments added between particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

 issue in commentedBetween("2018-05-26", "2018-07-01")

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-CommentedAfter