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 find what status an issue had at a gived point in time

I am looking for a way to get the status of an issue or a number of issues at a given point in time. E.g. What status did the different issues in a sprint have on the third day of the sprint.

2 answers

Hi @Henrik Gerdtsson

There's no direct way of searching for this - there are a few options though...

History Searches:

  • History searches allow you to search for issues that were in a specific status in the past
  • For example, if I wanted to locate issues which were "In Progress" between Sept 1st and Sept 19th, I could write: status was "In Progress" DURING ("2019-09-01","2019-09-19")
  • For more information on history searches, see this article here

Other:

  • There are apps which will visualise this information - for example, see Status History and Status History PRO which might get you close to what you need.
  • You can export the issue history via the database / APIs - there are also apps for exporting the issue history if more useful - see this example search on the Marketplace for some options

Ste

0 votes

Hi Henrik, you can use something like this:

status was "In Progress" BEFORE startOfDay()

But you can't use the value of a field in the BEFORE statement without some plugin or customization.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

839 views 5 22
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