How to find what status an issue had at a gived point in time

Question

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.

unknown · Answer

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.

Inactive Stephen · Answer

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