Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Natalia Mojica March 18, 2024

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)

2 answers

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 18, 2024

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

 

0 votes
Dan Breyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2024

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 March 18, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events