JIRA JQL query every week

[Vic Chen]

Hi experts,

Recently, I want to download the issues during every week.

How can I use JQL language to query the result?

I know I can use this command many times. For example, like this.

"Closed Date" >= "2020-06-01" and "Closed Date" <= "2020-06-07"'

"Closed Date" >= "2020-06-08" and "Closed Date" <= "2020-06-15"'

.

.

...etc.

However, it needs to enter the year-month-day information.

Is there any possibility to enter this one?

2020-wk1

2020-wk2

.

.

.

etc.

[Guanglin Zhang (XDevPod) · Accepted solution]

I tried to generate the JQL with "AI for Jira", you can try it: 

resolved >= startOfWeek(-1) AND resolved <= endOfWeek(-1)

[Vic Chen]

Follow your thought. I made it. Thanks.

[Lukas Ortner]

Hi,

I think what you are looking for are these 2 JQL functions:

* startOfWeek

* endOfWeek

Hope this helps

Best,

Lukas