How to query the issues which age is more than 10 days in JIRA

[Liu Maggie]

I'd like to create a filter to query the issues (bug) which age is more than 10 days in JIRA.

[Alexey Matveev · Accepted solution]

Hello,

I guess, a JQL query would look like this:

created < -10d and issuetype = Bug

[Liu Maggie]

Thanks Alexey!

[Liu Maggie]

@Alexey Matveev, tried it and it works as I expected. Very simple query, and I like it. Thank you again!

[Alexey Matveev]

By the way, if you want to display bug's age. You would need a plugin for it. For example, you could use the Power Custom Fields plugin. It is a free add-on:

https://marketplace.atlassian.com/apps/1210749/power-custom-fields?hosting=server&tab=overview

Your custom field code would look like this

return currentDate() - created;

Then you can add this field to your query result.

[Liu Maggie]

@Alexey Matveev, perfect solution. Appreciated your help!

[Alexey Matveev]

@Liu MaggieIf you feel like I answered your question, kindly mark my answer as accepted. I am glad to help you.

[Liu Maggie]

@Alexey Matveev, accepted your answer, thank you! Sorry to respond it late.

[Yogesh Mude · Accepted solution]

HI @Liu Maggie

Welcome to the Community!

You can use the JQL like Project = XYZ and IssueTyep = Bug and createdDate (between range, More than function.)

[Liu Maggie]

Thank you, Yogesh!

Another question: I want to display each bug's age in query result list, how to do it?