Solution in JQL to filter ticket on the date of the last comment updated on a ticket ?

[julien.bongrand]

Hello, 

I would like to create on Jira a filter based on the date of the last comment updated on an issue but I can not find a solution.

Do you know if is it possible to have that in JQL?

Thank you in advance,

Best regards,

Julien 

[Isaac Savage]

I just set up a Custom Field as Date Picker.

Then added an Automation to update this field with {{now.jiraDate}} when a new comment was made by the Reporter (or substitute your own need here).

Then, add this field as a Column in your Queue and/or to your Issue View.

[Daniel Turczanski - __JQL Search Extensions]

JQL filtering is powerful, but you can hit its limits in more complex workflows.

You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations and comments.

So, if you're serious about JQL, look beyond standard Jira.

The big mistake Jira users make is they forget about exploring the app marketplace. Our app, JQL Search Extensions, is a good example of a solution to JQL limitations.

For example, in your quick filter, you can use the commentLastUpdatedOnDate JQL extension:

commentLastUpdatedOnDate < -2d

Alternatively, you may work around any JQL reporting limitations with an Excel export. This doesn't work well if you want to create a filter though.

[Michael diLorenzo]

The issue I have with marketplace apps like this is that I must pay for a license for EVERY user of Jira.  In my case, I have 300 Jira users in my organization, but I am the only one that needs this functionality.  The cost for me is nearly $400 per month.  I can't justify paying that amount so that twice a month I can create a report on the last time someone made a comment on a ticket.

That is a big issue for me with the Community forum.  Someone posts a question, and there is always a reply that essentially says "buy this product."  It's sometimes a pain to weed through the sales pitches to find someone who can actually provide the Jira-native answer.

[Mahesh Shinde]

I guess there is no way in Jira default to find the last comment date on issues through JQL.

May be you can try with automation for Jira or Scriptrunner third party addon to get the list of issues.

[edern]

I'm not sure I got what you intend to do. Do you want to FILTER the issues, for example that were commented during last week (or last week, or whatever)? Or do you want to ORDER them by the time of the last comment? 

This is just to help next readers of your questions because either way I don't think it is possible.

The only thing that I know that could help you is to use 

updatedBy() 

see here: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html

Can you precise exactly what you want to do?