Query based dropdown list stalling at time of setup

Hi, I am trying to set up a query based dropdown list and am using the following code as a test run to make sure the dropdown list works:

select count(distinct s.id)
from shipment s
join company c
on s.company_id = c.id
where c.name = '{{customer name}}'

The base query works (without the where clause). With the where clause, the widget pops up with the default text box with the heading of “customer name”.

The problem is when I go to select “Query based dropdown list” using the following parameters:
Screen Shot 2021-09-27 at 5.06.53 PM

When I select those parameters and click “ok”, this happens:
Screen Shot 2021-09-27 at 5.07.35 PM

And the query based dropdown list just never loads. I’m not sure how to address this given that there’s no error thrown or anything, it just spins eternally in a spinning wheel of death. Anyone run into this before/have any advice on how to deal with it? Thanks in advance.

Sorry for my delay.

How many results does your customer query return?

Do you see any errors in your browser console when it spins?