How to write a JQL that lists issues that have new comments (2 weeks old) and are in a status

Question

How to write a JQL that lists issues that have new comments (2 weeks old) and are in a particular status?

unknown · Answer

Hi @Daniel,

Unfortunately JQL is limited when it comes to querying comments and their creation dates.

Only method I know would be to invest in a solution such as Script Runner.

Apologies I could not be any further assistance.

Daniel_u2gf0i · Answer

Hey @[deleted], unfortunately we don't have extension privileges. Would there be another way without using extensions? thx

unknown · Answer

Hi @Daniel,

You will need to look into something like Script Runner for Jira.

Look at the script runner commented jql function:

issueFunction in commented("after 2012/12/31 before 2013/01/07") and status = Done

Hope this helps