JQL for tasks without a dropdown selection does not work

Andrew Tran October 8, 2024

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

1 answer

0 votes
Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 9, 2024

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 October 10, 2024

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:

Embedded Confluence.png

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

Confluence Jira Filter.png

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

MoSCoW Jira Search.png

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

Lisa Forstberg
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 11, 2024

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 October 14, 2024

Hi Lisa,

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

Simplified query (1).png

We migrated from Confluence on prem to Confluence Cloud.

Regards,

Andrew

Andrew Tran October 23, 2024

Hi Lisa,

Were you able to reproduce my issue?

Regards,

Andrew

Suggest an answer

Log in or Sign up to answer