JQL Query assistance: Issues with no new comments

[David Stefancies]

I would like to write a query that will return all open tickets in the current sprint that have not been updated with a new comment in the past 24 hours

[David Stefancies · Accepted solution]

From what I have gathered from checking the forum, this is possible but only with a paid add-on such as Script Runner. Can anyone confirm that?

https://community.atlassian.com/t5/Jira-Software-questions/Need-JQL-query-for-no-comment-added-in-past-24hrs/qaq-p/1418313

The above is a similar question.

[David Stefancies]

This is what I have so far. It seems to work but could use some refinement if anyone has any ideas. Currently I would have to modify the active sprint manually.

sprint = 321 and status = "In Progress" AND updated < -1d

[Gustavo Félix]

You could use sprint in openSprints () . 
But the updated will bring you your issues in general(any field) that were updated. You will need to use the "issueFunction in commented ('after -1d') "

[David Stefancies]

@Gustavo Félix I am under the impression that the issueFunction isn't available out of the box and requires a paid plugin. Is that right?

[Gustavo Félix]

Yes, thats included with scriptrunner. 

[David Stefancies]

Ok I will stick with the query that I have since we do not have ScriptRunner. Thank you for your help.