How can I collect the bug age for 'non-closed' status?

For example, we have 1000 bugs in the jira, and I want to know how many defects be in opened status for the long time like more than 1 month? somehting like that.
And the import thing what I want to do is: I want to filter out them, and order by bug opened age, that it means, we have like one table the x(line) is bug age, the y(column) is bugID.
--> The result I would like to see, like the openned age of bug 2234 is 2 weekys, bug 2289 is 1 week...

Looking forward to get your feedback, thanks a lot!

Dana Cai

3 answers

Please use the below mentioned JQL for filtering the issues based on open status and sort it by the created date.

status in (Open, "In Progress") order by created asc

Here, Please add the extra conditions as required like <Project=''>, <assignee=''>,..

Add all the required non closed statuses like open, 'In progress', Addressed and so on in the IN operators braces as seen. Please replace it with <status = open> if you prefer only the bugs in open status specifically.

When the results are displayed, click on Columns-> Filter in the issue navigator, just above the results displayed. Mark 'Key' and 'Created' alone, so that you will get the results with the y(column) as bugID and x(line) as bug age, in the order of creation date. Please drag x and y columns to get what you needs as mentioned in your question.

i had similar requirement . Did it using script runner plugin. added Scripted Field with below script.
it tracks from created date to resolved date.. 

Long sourceDate= new Date().time
          sourceDate = issue.getResolutionDate().time
        long diff = Math.abs(sourceDate - issue.getCreated().time)
        long diffDays = (diff + 12 * 60 * 60 * 1000) / (24 * 60 * 60 * 1000)
        def fvalue= diffDays.intValue()
return fvalue as Double

does above can be worked by you?

if yes, could you share with me the detail steps, thanks.

OK, thank you, I can try it.

hi, thank you for your feedback, this is great solution, however I would like to say this is one workaround to filter out them.

So the further question from me is: can we auto count the age for them, now - created date. and generate as one table that I can see it in the gadget to add it into my dashboard for team view.

Thank you!



I tried it with a filter results gadget in the dashboard, as seen in the pic below.


Is this what you needed? However, I couldn't understand how can we add the created date.



Hi Mahesh,

Thank you for your feedback.

what I ask for should like below table, I need to know the age of issue be lived - not closed.

image2016-6-14 11:24:23.png



Dana Cai

These dashboards actually works from JQLs. There is no in built JIRA field to calculate this field. However, we will be able to calculate via a scripted field. But I'm unsure whether that scripted field value could be displayed in the issue navigator.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

226 views 6 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you