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

[Meghana kamble]

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 

[Trudy Claspill · Accepted solution]

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

[Meghana kamble]

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