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

[Yu Ke (York)]

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 :)

[Evgenii · Accepted solution]

If I understood right, you need something like this:

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

[Yu Ke (York)]

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

[Charlie Misonne]

did not think about using startOfWeek().

Better than my solution!

[Charlie Misonne · Accepted solution]

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

[Yu Ke (York)]

Thanks for helping! :D