how to report the age of an issue (last time it was updated)? using jira/filter

[Sandra Lawrence]

I am curious how to show/report/calculate the age of an issue (last time it was updated by # days)? using jira/filter

Any help would be appreciated.

[Jakub Sławiński · Accepted solution]

Hi @Sandra Lawrence 

You can only display the "Updated" column in the JQL search results, which is a date field.

You can then export your results and do the calculations in excel. A little bit cumbersome but will do the trick.

[Nic Brough -Adaptavist-]

You don't.  That data is not held on the issue (and you couldn't store it anyway, you'd have to update every issue every minute)

JQL is also a search, it actually says nothing about the format of what you get out of it.  A filter result is simply a sorted list of issues that match the JQL.

When we look at a filter though, we're usually looking at it in the "issue navigator" - this allows you to choose what fields you want to display, and in this case, you probably want to tell it to show you created and/or updated.

These are both date and time stamps of when something happened, they're fixed points in time.   You don't get "how long ago it was updated" because that changes every second...

[Sandra Lawrence]

there is no way to calculate using dateentered and updated in some type of calculation to derive number of days old an issue?

[Suvradip Paul]

Hi @Sandra Lawrence ,

Thanks for posting in the community.

Could you please use 'updated' in your Jira filter to search the details - like last time updated with a date range? Please check the documentation with Jira Advanced Filters - https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/.

Please accept the answer if it solves your query else respond and allow others to share input.

Stay safe and healthy.

Cheers

Suvradip