Filter to display all Jira status that have more than 10 issues

Question

I need to create a filter to show status on a portfolio of Jira projects, and exclude the status that have less then 5 issues. Do you have a query for that?

At the same time I need to display only Jira projects that show up in my filter and have just more than 10 issues.

Do you know how to do it?

Is there a count function ?

lau pel · Answer

thanks. I feared it....:-(

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

No, there is no count function in JQL.  There's no way to do it reliably that I know of, but there are some reports in the marketplace that have a "only show the first X results from a JQL", and more that can display the count of issues returned from a JQL (even the issue navigator will tell you how many issues are returned from a search)