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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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