Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Empty filed counter query

Hi All,

I'm a new-joiner to the community so hello to Everyone! :)

I need a support in counting empty fields in a issue.

So this is how it's look like - we've established a list of mandatory fields that should  always be filled in for different projects for a certain group of teams. The tricky part is with the field mandatoriness asterisk - we can't use this feature because other teams are also using those projects and they are not oblige with the liste of mandatory fields. 

However, we need to track progress of filling out of those fields and we need to know how many fields are still empty among all issues within the projects. 

When using a simple query like:

"Field 1" is empty or "Field 2" is empty or "Field 3" is empty

I receive only the number of issues but still missing information how many empty fields are there. 

What I don't want to do - creating query to show number of issues per each field or to show number of issues per each project. 


Is there any way to show number of empty fields?

Of course, if this topic was discussed earlier or even solved please let me know (I was searching for the solution but I couldn't find any). 




1 answer

0 votes

Hi @Artur Nogaj 

Once simple approach would be to create separate JQL filters for those empty fields.

For instance a query like this will give you all the issues where this field is not filled in.

"Date Picker Field[Date]" is EMPTY

You can then further narrow it down to your project only, save your JQL query as filter, subscribe to email notifications, display on dashboard, add as quickly filter on your boards and may be do automations to add comment on the issues.

I hope it helps.


Hi @Ravi Sagar _Sparxsys_

thanks for your answer! 

Correct me if I'm wrong - by creating separate JQL filter for those empty fields, then using filter, dashboard etc. I will bring only number of the issues where the field is empty, not number of empty fields (which is what I need)? 

Suggest an answer

Log in or Sign up to answer

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