Jira Filter: Recently updated filter with comments

Question

Hi,

I would like to know how to create a filter where i have a ticket not been updated for the last 5 days with comments.

I wrote for updated date " AND updated <= -5d " but Jira considers a status update also a reassign of a ticket or an update from "in progress" to "Pending" because it is mentioned as a comment of an action that happened.

In my case i want a filter to show tickets that havent been updated last 5 days with comments showing progress.

Is this possible?

I also noticed that when someone changes a status for example from "in progress" to "pending" it is generating a comment like this : Yhan Masuyo made changes - 07/Jun/2021 08:20:06PM +0200 but if someone trully comments with his work it then shows Yhan Masuyo added a comment - 07/Jun/2021 08:20:06PM +0200 .

Shahzad Iqbal · Answer

Hi

I have used the following JQL query to return Tickets last updated within 5 hours by myself

project = ABC AND updated >= -5h

Records Return = 17

which are Right as I had updated them in following areas

* Added Comments on Tickets
* Changed Status of Ticket from In Progress to Closed etc. 
* Added Category on Tickets
* Done assignment of Tickets

Regards

Vikrant Yadav · Answer

Hi @Yhan Masuyo  Wow that's great. Script Runner installed in your instance.

You can generate correct result using Issuefunction now. Kindly check below links , having all JQL method based on Comment.

https://scriptrunner.adaptavist.com/5.4.48/jira/jql-functions.html#_comments

https://www.adaptavist.com/blog/top-10-most-commonly-used-jira-query-language-functions#commented

Thanks

Yhan Masuyo · Answer

Thank you Vikrant.

I have issuefunction but not lastcomment.

I added AND issueFunction not in commented("after -5d")

Seems to work and presents me all the tt's that do not have a comment for 5 days.

still i check it.