JQL to see what bugs & enhancements have been made between releases?

[chris sieverts]

I'm trying to query the Jira & Confluence backlogs to see what has been fixed and added to the range of releases between what we have and the latest LTS we are going to but I'm struggling with getting results that I am confident in. 

I've tried these but I'm getting way too many results (Jira JQL giving 51k+ rows!) or getting results where it seems to be ignoring the status 

project = "Confluence Data Center" AND (fixVersion > 8.5.17 AND fixVersion < 9.2.2) ORDER BY fixVersion ASC

project = JRASERVER OR project = "Jira Software Data Center" AND issuetype in (Bug, Suggestion) AND status = Closed AND (fixVersion > 9.12.10 AND fixVersion < 10.3.3) ORDER BY fixVersion

I'm trying to avoid having to go into each set of release notes. Is there an easier way to get what I'm looking for?

Thank you in advanced!

[Aaron Pavez _ServiceRocket_]

Hi @chris sieverts 

Does this work for you?

project = "Confluence Data Center" AND (fixVersion >= 8.5.17 AND fixVersion <= 9.2.2) and resolution in (Done,Deployed,Fixed,"Resolved Locally",Answered)

You need to consider whether the bug was fixed, released, or something else.

Play with the Resolution and Status and see which brings the data you need.

Regards

[chris sieverts]

hmmm, that seems to be an improvement in that the results seem to be a reasonable number. Thank you! I'll spot check these with the release notes.