Need JQL query for no comment added in past 24hrs

[siva boddu]

Using jira server need JQL query for no comments add in past 24hrs

thanks

[Nic Brough -Adaptavist- · Accepted solution]

There isn't a way to do this in plain Jira - you'll need an app to provide either a field that pulls out the date or a JQL function that can work with it.

However, "last comment" is often not as useful as you would assume.  It's usually better to look for any changes - there are plenty of updates to issues that you don't have to comment on, when people are looking at "date of last comment", what they're usually interested in is "last time it was changed".

You can look for that easily - "updated < -1d" will give you all issues that have not been updated for a day (you'll probably want to combine it with at least "and resolution is empty" so you don't get any of the closed issues)

[siva boddu]

Hello Nic Brough thanks for responce

Here I used jql query for comments commeted on past 24hrs

issuetype = Support AND project in (10102, 12300, 13701, 14402) AND status not in (Closed) AND (resolution = unresolved OR resolutiondate >= -1w) AND status in ("In Progress") AND issueFunction in commented ('after -24h')

But my question is no comments added in past 24hr can you please help me how to prepare jql query based on above query

Thanks

[Nic Brough -Adaptavist-]

Ah, ok, you have Scriptrunner installed if you're using issueFunction

You should be able to simply invert the last clause - And issueFunction not in commented()

[siva boddu]

Thank you it’s working