Can I saerch by date - 7d?

[Toby Moore]

Hi all,

just trying to make my queries as easy to update as possible, to allow me to create easily editable confluence report pages.

so the current query being used is

project = AA AND (status changed to "In Implementation" during ("2017/10/30 00:00", "2017/11/04 00:00")  OR status changed to Released during ("2017/10/30 00:00", "2017/11/04 00:00") )  AND "Epic Link" = AA-1  

im trying to make it easier like

project = AA AND status changed to ("In Implementation", Released) during "2017/11/04 00:00" -7d AND "Epic Link" = AA-1  

but it doesn't work

The best I have so far is below, but ideally id like it to just be one day to update

status changed to ("In Implementation", Released) during ("2017/10/30 00:00", "2017/11/04 00:00") AND project = AA AND "Epic Link" = AA-1

Any help?

[Thomas Schlegel · Accepted solution]

Hi Toby,

a relative date such as "-7d" is always based on the current date. So "-7d" is 7 days before today, not 7 days before the date you mentioned before.

[Toby Moore]

Hi Thomas, thanks for the reply, I think I may have done it with the below, what do you think?

status changed to ("In Implementation", Released) during (-7d, "2017/11/04 00:00") AND project = AA AND "Epic Link" = AA-1

[Thomas Schlegel]

This jql will list you all the issues that were released between last monday until last friday.

But if you do the same jql tomorrow, it will list issues that were released between last tuesday and last friday.

If you call the same jql after next saturday, you'll always get no result, because then, you have a negative time period. 

[Toby Moore]

ah I see, thanks! will just have to stick to two dates then :'(