How can I use a filter to find information for a certain date?

Eric Smith July 15, 2015

I have a filter that is basically tracking all of my tasks for a certain release.  I'd like to use that filter to give me a snapshot of what that filter would have returned on a certain date.  I can't seem to figure this out...

If that's not clear, lets say I have a filter that shows me all bugs and tasks with a certain fixversion.  However, I want to know what the results of that filter would have returned 7 / 14 / 21 days ago.

2 answers

1 vote
Sean Herring [Equip] March 16, 2016

A clean way to handle this is using DURING:

status was not Closed during ("start date","end date")  and issuetype in (Bug, Task)

Here are a couple of variations on this theme. 

If you want to go back 7 days from today:

status was not Closed during (-7d, now())

If you want to look back from a certain date until now: 

status was not Closed during ("2016/03/10", now()) 

 

Hope this helps.

1 vote
Sean Herring [Equip] March 16, 2016

Using your example: 

fixVersion = <yourfixversion> and status was not Closed ON -7d and issuetype in (Bug, Task)

If you want a certain date, say, 13 March 2015, you would write it this way: 

fixVersion = <yourfixversion> and status was not Closed ON "2015/03/13" and issuetype in (Bug, Task)

Eric Smith March 16, 2016

Can that be done for a range of dates?

Suggest an answer

Log in or Sign up to answer