nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can I saerch by date - 7d?

Toby Moore_v50vis

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?

Accepted answers

Thomas Schlegel

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.

All comments

Thomas Schlegel

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_v50vis

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_v50vis

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql