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

[Dina Whelan]

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? 

[John Funk]

Hi Dina,

I am a little confused. You don't paste the query into the Filter Results gadget - you select an existing filter which hopefully would have been the one you saved above. 

[Dina Whelan]

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

[Thorsten Letschert _Decadis AG_]

Hey @Dina Whelan ,

Where exactly are you trying to "copy and paste" the query? I'm asking, since the default Filter Results gadget in Jira Cloud depends on a saved filter (or query).

Regards from Germany,
Thorsten

[Dina Whelan]

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!

[Thorsten Letschert _Decadis AG_]

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]

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!