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; } } }

I want the JQL query to automatically filter the issues from last Wednesday to this Thursday.

Currently I cannot specify a time interval which automatic updates.

For example, if I open JQL on Friday, June 9, it will automatically filter all issues from May 30(last Wednesday) to June 7(this Thursday). And I don't want the issues from June 7 to June 9 in the JQL.

I hope to get your help

Accepted answers

Charlie Misonne

Do I understand your requirement correctly?

This friday you need:
created > 2023-05-30 AND created < 2023-06-08

And next friday you need:
created > 2023-06-06 AND created < 2023-06-15

But you want to to be dynamic so you have a new result every week?

If you only run it on Fridays you could do something like this:
created > endOfDay(-11) AND created < endOfDay(-2) ORDER BY created ASC

If I understood right, you need something like this:

created > startOfWeek(-4d) AND created < startOfWeek(4d)

All comments

Charlie Misonne

Do I understand your requirement correctly?

This friday you need:
created > 2023-05-30 AND created < 2023-06-08

And next friday you need:
created > 2023-06-06 AND created < 2023-06-15

But you want to to be dynamic so you have a new result every week?

If you only run it on Fridays you could do something like this:
created > endOfDay(-11) AND created < endOfDay(-2) ORDER BY created ASC

If I understood right, you need something like this:

created > startOfWeek(-4d) AND created < startOfWeek(4d)

Yes that's exactly what I need, thank you!

Thanks for helping!

Charlie Misonne

did not think about using startOfWeek().

Better than my solution!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud