Query column - filter on "This row>Multiple Texts"

[Andrew_Davies]

HI

I am doing a query to a table, and trying to return only rows with rowIds that do NOT exist in a “This row>Multiple Texts” column (Trebuchet method)

However I can not select a “This row>Multiple Texts” column. I need to convert it to a Joined List first.

It works fine, but I thought I should able to choose “Row ID” is not included in “This row>Multiple Texts”

Or am I missing something?

[Mazen]

You’re right that Glide doesn’t let you compare a Row ID directly against a “Multiple Texts” column unless you first turn that column into a Joined List. That’s because Multiple Texts is actually an array, and Glide can only do “is included in” checks with plain text. Don’t Mind it..

[ThinhDinh]

Checking with the team on this. I’m not sure why array contains something is supported, but not the inverse.