Query for Released and Archived Fix Versions that have Open Tickets

[Robert Dalton]

I am looking for a JQL that will let me know of any Released or Archived Fix Versions that still have Open Tickets.

[John Funk]

Hi Robert - Welcome to the Atlassian Community!

Here is what I did. 

1. I created a new filter with: 

fixVersion is not EMPTY AND statusCategory != Done

2. I created a new dashboard (or added a gadget to an existing dashboard) with the Issue Statistics gadget

3. I used the filter I created in 1. and used and a Statistics Type of: Fix For Versions (all)

That gives me a list grouped by Version with the number of open issues in each release. 

[Robert Dalton]

@John Funk  This is very helpful.  Thank you.

Do you know how to add the results to a Confluence page?

[John Funk]

Unfortunately I do not as we don’t use Confluence 😔