Drizzle Team•2y ago

RQB | using specific fields from a query against relations

is there a way to create a select filter that matches specific fields from a relation? say i findMany on posts and want to select all the posts where a relational one-to-many tags.name is inArray of a tagList array

6 Replies

Andrii Sherman•2y ago

we have a small example in docs

Andrii Sherman•2y ago

Andrii Sherman•2y ago

not sure if it's something you are looking for

JeyproxOP•2y ago

i'm looking for something that might look like: where: (posts) => inArray(posts.tags.name, tagList) with:

with: {
  tags: {
    name: true,
  }
}

with: {
  tags: {
    name: true,
  }
}

however posts.tags has a type of Many<"tags>" that doesn't seem to allow for what i have in mind is there any way to implement something like this with RQB rn?

pabz•2y ago

any updates on this? looking for exactly that (filtering against relation table column)

Noahh•2y ago

I believe I looked into this before and there was no way to do it currently.

Gaming

Programming

RQB | using specific fields from a query against relations