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: 

JQL to get all the issues created in 0-3 days of month

Gajanan Sasane
Contributor
March 31, 2021

I need JQL to get all the issues which was created in first 0 to 3 days of the month.

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes
Answer accepted
Jack Brickey
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 Champions.
March 31, 2021

Please see if this gives you the desired results 

createdDate >= startOfMonth() AND createdDate <= startOfMonth(3d)

Gajanan Sasane
Contributor
March 31, 2021

Hi @Jack Brickey :

Thanks for the answer.
again I have a query, how would I get the issues which is created 4 to 7 days of the month.

Jack Brickey
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 Champions.
March 31, 2021

Please explain what you mean by 4 to 7. Do you mean, for example March 4th - 7th? If so...

createdDate >= startOfMonth(4d) AND createdDate <= startOfMonth(7d)

hopefully you see the concept here. I recommend you playing with this to get a feel for the logic/syntax. Also, you might want to reference this article - what-is-advanced-searching-in-jira-cloud 

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events