Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning
Events
Champions
Release Notes
Community
Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning Events Champions Release Notes
Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning Events Champions Release Notes

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources
  • Community
  • Q&A
  • Jira
  • Questions
  • I want to query for the number of bugs where the status is not closed or done on the end of a month

I want to query for the number of bugs where the status is not closed or done on the end of a month

Tim Manley
Tim Manley
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!
Get involved
February 13, 2020

This is the query I'm trying to make work:

type in (bug,sub-bug) AND status not in (closed,done) ON endOfMonth(-13)

 

I want to query for the number of bugs where the status is not closed or done on the end of a month.

 

This query above does not work, please help.

 

I intend to run this for each month building a chart over time.

Answer
Watch
Like Be the first to like this
1056 views

1 answer

0 votes
Jack Brickey
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.
Get recognized
February 13, 2020

If you are saying you want to find all open bugs at the end of the month then I suggest you set up a subscription that runs monthly.

issuetype in (bug, sub-bug) and status not in (closed, done)

Filter_Subscription_-_JIRA.jpg

If you are wanting to find issues that were opened during the current month and not closed in the current month, I would again use a subscription but modify the filter as below.

issuetype in (bug, sub-bug) and status not in (closed, done) and createdDate >= startOfMonth()

 

Finally, if you are asking for a one-time query please explain further as I don't understand how end-of-month comes into play exactly and is see you are trying to use "-13". Are you maybe trying to find the issues that were open at the end of January? if so....

issuetype in (bug, sub-bug) and and status was not in (closed, done) on 2020-01-31

View More Comments
Tim Manley
Tim Manley
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!
Get involved
February 13, 2020

than, you, been trying to run this:

issuetype in (bug, sub-bug) and status was not in (closed, done) on 2019-01-3

but it's returning bugs that have just been created.  Any ideas?

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Champions
    Release Notes
    Copyright © 2026 Atlassian
    Privacy Policy Notice at Collection Terms Security