Forums

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

how to write the jql query for bugs that are logged in a year, monthly wise

Praveen Kumar baradi
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!
July 22, 2022

how to write the jql query for bugs that are logged in a year, monthly wise

1 answer

1 accepted

1 vote
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 22, 2022 edited

Hi @Praveen Kumar baradi and welcome to the Community!

You cannot write a query monthly wise. What you can do, however, is retrieve a list of bugs created in the last year:

Issuetype = bug and created >= -365d

This would fetch all bugs created in the last 365 days. To view these per month, you would need a visualisation tool to display them by month. You can do so with a Recently created chart on a dashboard. Save the above JQL search as a filter and use it as the source for your dashboard gadget.

created vs resolved gadget might also do the trick.

Hope this helps!

Praveen Kumar baradi
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!
July 22, 2022

Thank you 

Walter Buggenhout

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, loom, AI, meeting recording, community

[NEW] Record your meetings with Loom

Welcome to great meetings, with less work. Automatically record, summarize, and share instant recaps of your meetings with Loom AI.

Learn more
AUG Leaders

Atlassian Community Events