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

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
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,

 

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

startOfWeek

endOfWeek

 

Hope this helps

Best,

Lukas

Suggest an answer

Log in or Sign up to answer
TAGS
Atlassian, Team '25 Europe, Atlassian conference, AI-powered teamwork, Atlassian events, keynote speakers, Barcelona tech conference, Atlassian Williams Racing, Carlos Sainz, Jenson Button, Mike Cannon-Brookes, Anu Bharadwaj, Atlassian Rovo

Atlassian Williams Racing is coming to Team '25 Europe 🏎️

Discover the teamwork and precision behind success on and off the track. See how this high-performing team makes the impossible possible. Be one of the first 100 customers to register for a chance to win 2 tickets to an Atlassian Williams 2026 race.

Register now
AUG Leaders

Atlassian Community Events