I want to see jira tickets which haven’t update in more than 6 months

Meghana kamble May 21, 2024

I’m trying to get an jira tickets on a board which haven’t updated in more than 6 months. Could you help? What would be j query for that? I have mentioned updateddate <= -6 and it’s still giving me January, march, may 2024 tickets 

2 answers

1 accepted

0 votes
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 21, 2024

Hello @Meghana kamble 

Welcome to the Atlassian community!

You need to provide a time unit when using a criteria for a relative date. For example

updated <= -6d   : all issues updated 6 days ago or longer

Unfortunately there is not a unit for months. You could use weeks instead

6 months * 4 weeks/month = 24 weeks

updated <= -24w

Or you can set a criteria relative to the start of the current month:

updated <= startOfMonth(-6)

 

You did not indicate if you are using Jira Cloud or Jira Data Center, so here are the links to advanced search documentation related to the Updated field for both.

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Updated

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html

0 votes
Meghana kamble June 4, 2024

Thank you so much. It worked when i mentioned updated <= -24w

Suggest an answer

Log in or Sign up to answer