How do I write a WHERE clause to filter for when a multi-select field isn't empty. I've tried:

WHERE myMultiSelectField IS NOT NULL

results incl. null values

WHERE myMultiSelectField IS NOT EMPTY

results incl. null values

WHERE myMultiSelectField IN ('1')

no records found (1 being a value the multi-select could be)

WHERE myMultiSelectField = '1'

no records found

WHERE myMultiSelectField != ''

no records found

You might be able to join to the mapping table that represents the relationship between the record and the multi-select field list. • SuiteAnswers • Zig thezig

make a dataset in the ui with the filter you want

Will try both approaches, thanks =]