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
Andrii Sherman13mo ago
we have a small example in docs
Andrii Sherman
Andrii Sherman13mo ago
Andrii Sherman
Andrii Sherman13mo ago
not sure if it's something you are looking for
Jeyprox
Jeyprox13mo 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
pabz12mo ago
any updates on this? looking for exactly that (filtering against relation table column)
Noahh
Noahh12mo ago
I believe I looked into this before and there was no way to do it currently.