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

[Henrik Gerdtsson]

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.

[Inactive Stephen]

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

[Deleted user]

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.