How to query for uuid in an array?

[jesper-bylund]

Hi,
I have a datatype that looks something like this

const model = {
  id: uuid,
  reference: uuid[]
}

But I cannot figure out a way to query for this using the normal syntax. 🤔 I there a way?

My current code:

supabaseClient
  .from("notes")
  .select("*")
  .in('references', ["583104d5-xxxxxx-131a40531afc"]);

returns the quite logical error:
"could not find array type for data type uuid[]"

[jesper-bylund]

I also can't seem to create a function for this.. 🤔 Seems like the syntax is a bit obscure and hard to google.

[GaryAustin1]

Try .contains.
.in means search column for anything in this array of values.

[jesper-bylund]

@GaryAustin1 amazing! That seems to have worked perfectly! Thank you Add it as an Answer and I'll mark this as solved.

[GaryAustin1]

Still new to Github.... adding so can be answer....
Try .contains.
.in means search column for anything in this array of values.

[jesper-bylund]

Thanks Gary!