JQL for tasks without a dropdown selection does not work

Question

Hi Atlassian Community,

Prior to migrating to Jira Cloud, our team had some filters to track whether our team has entered or not entered certain fields. One of those fields was a custom dropdown. This has since broken since migration to Jira Cloud.

I've tried the following:

* "CustomField[Dropdown]" NOT IN ("Option A", "Option B", "Option C", "Option D")
* "CustomField[Dropdown]" IS NULL OR "CustomField[Dropdown]" IS EMPTY

Could you please let me know how I can determine whether a user has selected an option or not?

Note that for the first dot point, I've listed all the possible options besides the empty option (i.e. a non-selection)

Thanks in advance,
Andrew

Andrew Tran_f47apt · Answer

Hi Lisa,

Were you able to reproduce my issue?

Regards,

Andrew

Andrew Tran_f47apt · Answer

Hi Lisa,

I tried a simplified query but I get the same problem:

We migrated from Confluence on prem to Confluence Cloud.

Regards,

Andrew

Lisa Forstberg_o85gu4 · Answer

Ok good, that your JQL seems to be functional but your Confluence does not seem t to like it?

Have you also migrated a Confluence on prem to Confluence Cloud or are you connecting a Jira Cloud to a Confluence on prem?

I would next to try to run a simpler JQL in the Jira issue/filter macro. like Project in ("MyTeamname") just to see what happens.

/Lisa