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?
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.
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.
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 ...
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