The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA JQL query every week

Vic Chen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 19, 2024

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.

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote
Answer accepted
Guanglin Zhang _XDevPod_
Atlassian Partner
August 19, 2024

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

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

 

5.29.38.png

 

Vic Chen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 19, 2024

Follow your thought. I made it. Thanks.

1 vote
Lukas Ortner
Contributor
August 19, 2024

Hi,

 

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

startOfWeek

endOfWeek

 

Hope this helps

Best,

Lukas

TAGS
AUG Leaders

Atlassian Community Events