Can anyone help me with the JQL for finding out how many bugs were opened between Oct.4th and Nov. 29th I would then like to know how many bugs were closed in the same timeframe. Any help would be greatly appreciated!
Hi Scott,
Something like these
Created between Oct 4th and Nov 29th:
Type = Bug AND created >= "2016/10/4 00:00" AND created < "2016/11/30 00:00"
Closed between Oct 4th and Nov 29th:
Type = Bug AND resolved >= "2016/10/4 00:00" AND resolved < "2016/11/30 00:00"
Sam
Thanks so much Sam, I almost had it but was messing up the date range entry method. Really appreciate the help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Those JQLs are correct. However, they do not have into account the possibility of reopened issues (if your workflow allows to do so):
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good point Ignacio.
What would your suggestions be to count re-opened issues?
It does tend to get a bit complicated. For example:
Type = Bug AND (created >= "2016/10/4 00:00" AND created < "2016/11/30 00:00" OR resolution CHANGED TO Unresolved during ("2016/10/4 00:00", "2016/11/30 00:00") )
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sam, it entirely depends on the purpose behind the query, but your new JQL for created issues looks preferable to the previous one in most of the cases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good point, however, it's not particularly relevant in my situation as I am aware of issues that have been re-opened. Thanks again for your help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.