Forums

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

JQL Query Needed to find issues within the next 3 months

Marvo Barker January 30, 2023

Hi all,

 

I wonder if anyone could help me with a JQL query that will look for issues (epics,tasks, stories etc) that are being worked on between now and the next 3 months. 

 

Any help woudl be appreciated :)

1 answer

1 accepted

2 votes
Answer accepted
Ashley Hudson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2023

Hey @Marvo Barker ,

The JQL would be the following:

project = xxx AND issueType = epic AND issuetype = task AND updated > startOfMonth(-3)

I hope this helps you  :)

Kind Regards,

Ashley Hudson

Ashley Hudson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2023

FYI: This is searching for issues that are updated from the past 3 months but if you want the next 3 months then do +3 :)

Marvo Barker January 30, 2023

Thanks Ashley, this has helped :)

Like Ashley Hudson likes this
Chloe Lee Kang Yu
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!
February 21, 2024

if i want it to be from jan 1st to jan 31st? what do i type

Suggest an answer

Log in or Sign up to answer