I am trying a query to find how many bugs that existed on a certain date were not closed on that specific date.
the query project = proj and issuetype = Bug AND created < "2014/05/08" and status was not closed BEFORE "2014/05/08"
not giving the expected result. actually it's not returning anything.
I ran following on 8th of May, 2014: project = proj and issuetype = Bug AND status != closed
and it returned 100 issues. I expect when we run a query today using the "was not" clause for the same day, I should see the same number of issues. Am I right? or am I making silly mistake?
You would need to specify the field to be compared to the BEFORE date. Out of the box I don't think there is one. I routinely capture milestone dates in custom fields in my workflows so this kind of query can be run. You may be able to structure a query that looks at the history but I wouldn't know what fields to point you to.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG