JQL for tasks without a dropdown selection does not work

[Andrew Tran]

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

[Lisa Forstberg]

Hi @Andrew Tran ,

Welcome to the community!

Can you confirm that the field you are looking for is indeed in your new Site on cloud?

I assume that where you type "CustomField[Dropdown]"  you replaced this with the actual field name right?  

A few screenshots of your JQL would speed up the help you can get on the community.

br

/Lisa

[Andrew Tran]

Hi Lisa,

Thanks for your reply. Yes CustomField is replaced with the actual field name (MoSCoW). We've lived with this issue for some time now. I need to update you that the Jira search appears to work now. The only issue remaining is the Jira filter embedded in Confluence does not show the correct result:

When I edit the filter, it also shows 0 issues:

When I click on the "0 issues" link or copy that filter into Jira, I see the correct results (2 tasks):

Note that the filter is exactly the same except "MyTeamName" is replaced with my team's actual name.

[Lisa Forstberg]

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

[Andrew Tran]

Hi Lisa,

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

We migrated from Confluence on prem to Confluence Cloud.

Regards,

Andrew

[Andrew Tran]

Hi Lisa,

Were you able to reproduce my issue?

Regards,

Andrew