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

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?

1 Like

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..

1 Like

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

2 Likes

Here’s the response:

There is a reason — it has to do with how this data is stored in the back-end. I don’t think you can use “is included in” when looking at a certain type of data due to the way it’s actually stored (it’s not seen as a piece of text that can be broken into parts).

2 Likes