Forums

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

Month on Month data

Manish Morey
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!
October 3, 2024

How to create a filter listing issues created my specific month. not by date range   like  Jan- 50 Feb 45 March 48 

 

2 answers

1 vote
Aaron Pavez [ServiceRocket]
Community Champion
October 3, 2024

Hi @Manish Morey 

You can filter it like this

project = PJnamehere and (createdDate >= 2024-08-01 AND createdDate <= 2024-08-30)

That will bring all tickets created in August.

JQL doesn't have a MONTH value to pass using the created date.

This is a good page to understand the date search using JQL:

https://www.testmanagement.com/blog/2023/09/using-dates-and-date-operators-with-jira-jql/

regards

0 votes
Manoj Gangwar
Community Champion
October 3, 2024

To create a JQL filter in Jira Cloud that lists issues created in a specific month, you can use the created field with the startOfMonth() and endOfMonth() functions. However, Jira's JQL doesn't directly allow querying by month names. Instead, you need to specify the month and year numerically. You can refer @Aaron Pavez [ServiceRocket] suggestions. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events