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