Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to get all Projects without any open issues?

Our Confluence instance is used not just by my team but also by our customers. We control the licensing cost by revoking the license once the Project linked with Confluence page is completed. We want to generate list of all the Projects without any open Issues. Can you please provide a way - a JQL or a Rest API - for achieving this?

1 answer

0 votes

You cannot search for things that are not there.

The best you can do is look in admin to get a list of all projects, then look at a list of all projects with an issue count (write a filter for all open issues and use it in a filter statistics gadget, grouping by project, to get a list of projects that have issues), and subtract the used projects from the list of all, to get a list with no issues.

Thanks for the response

Can you point me to the Widget I can use for this?

It's literally the one called "filter statistics"

Your suggestion is of no use. Was googling to see if we get something better. Few discussion threads I saw involved requests from Customers for having this feature - and Atlassian putting it down saying it is not important (this is despite so many people asking).

Incidentally - I saw you were involved in these discussions too. And seeing at the sort of responses you made there we can't expect to receive any resolution for this. I am considering this ticket closed from my side.

I was responsible for introducing Jira in my organization. Some of my experiences - not having Group by is the most recent one - I regret taking this initiative of adopting Atlassian. Quality has fallen down drastically. Will be moving away from Atlassian at the very first chance.

The suggestion is not of no use, it is the only thing you can currently do.  It solves the problem, so it is useful. 

I'm 100% with you that it's clunky and far from ideal.  There should be a way to do it explicitly - heck the first genuinely useful plugin I wrote for Jira was a project report that gave you this info (with a load of other stuff)

As for that other conversation, yes, it's another one where someone is being told they can't have what they are asking for.  In that case though, it's because they are asking for something that makes no sense because doing it the way they think they want to can not work.  In your case, you have a solution that is less than ideal but could be done the way you want, you're just stuck because Atlassian haven't coded it.

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,193 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you