I want to get the tickets that were not commented in the last 2 weeks

[Natalia Mojica]

Hello!

I want to create a JQL query that returns tickets that were not commented on in the last 2 weeks by a specific role (former assignee or reporter)

[Hannes Obweger - JXL for Jira]

Hi @Natalia Mojica

to the best of my knowledge, Jira doesn't natively allow filtering based on comments. The only native solution I can think of is to use Jira Automation to trigger a rule whenever a comment is added, write data into a custom field, and then filter by the custom field. 

Alternatively, if you're open to solutions from the Atlassian Marketplace, there are a number of apps available that either extend JQL by additional functions, or offer alternative search/filter mechanisms.

To advice on a specific solution: Would it be useful to filter on the last comment date in general, or would it really have to be based on particular users' comments? If it's the latter, would you be able to list the specific users in your query (like "John", "Paul", "Ringo", etc.), or would that have to be dynamic as well (like, e.g., whoever is the reporter of the given issue)?

Best,

Hannes

[Dan Breyen]

Hi @Natalia Mojica would this work?  (Reporter = X or assignee = X) and updated < -14d 

I might be missing something in your description, but this will be if the entire ticket has been updated or not, not just commented on.  

Hope that helps .

[Natalia Mojica]

The problem is that I need the tickets that don't have new comments after 2 weeks, bc every week I open a new sprint, so using that query, is not going to work :c