Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

3 answers

1 accepted

0 votes
Answer accepted

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.

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

0 votes

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...

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence

🏑 Atlympic Event: Confluence

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

574 views 19 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you