Using the $in operator to provide an array from the multi select component to the query.
Unable to validate the query in retool unless I add the array  brackets. As I am providing an array to the query this results in double brackets and causes the query to return empty.
A screen shot of the situation:
(the ternary operator is used to provide all array values when none are selected)
What am I missing here?