Jira's Filter Results gadget returns wrong values when using is empty (dropdown field)

Question

Trying to create a dashboard to track if a drop-down field is empty.

When I do an advance query:

project = NightFury AND type = Epic AND "customer-facing[checkboxes]" IS EMPTY AND status != Closed and fixVersion >= CY26_Q2 ORDER BY created DESC

I get the expected results (94)

However, when I copy and paste this query into Jira's Filter Results gadget on the dashboard, I am returned with a subset of the results (66). Additionally, the returned results are not just returning ones where customer-facing drop-down is empty.

[Edit: sorry. I created a saved filter. At first I was using Sumup which allows custom JQL. That is where I saw the issue initially, but wanted to troubleshoot further. Good catch to those who called it out!]

I tried to work around this by using:

project = NightFury AND type = Epic AND "customer-facing[checkboxes]" not in (Yes, No) AND status != Closed ORDER BY created DESC but that yields zero results (in both the gadget and advance query)

Anyone experience something similar? Any workaround?

Dina Whelan · Answer

About to reply to support, but your 7.2 update fixed the issue within Sumup. The issue still stands for Jira's Filter Results, but works perfect now in your app. Thank you!

Thorsten Letschert [Decadis AG] · Answer

Hey @Dina Whelan

What a coincidence. I'm part of the team behind sumUp and just saw that you've already engaged with our support team.

I'll update the thread accordingly as soon as we've figured out the problem together.

Regards from Germany,
Thorsten

Dina Whelan · Answer

sorry you are right. I created a saved filter. At first I was using Sumup and that allows custom JQL. That is where I saw the issue initially, but wanted to troubleshoot further. Good catch! I updated my post