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

Question

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.

Tim Manley_oehppb · Answer

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?

Jack Brickey · Answer

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)

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