Topics

Drizzle Team•15mo 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•15mo ago

we have a small example in docs

Andrii Sherman•15mo ago

Andrii Sherman•15mo ago

not sure if it's something you are looking for

Jeyprox•15mo 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•13mo ago

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

Noahh•13mo ago

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

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

8.2KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Simulate enums with SQLite `CHECK()`I'm a heavy enum user in Postgres. Using SQLite now, wondering if anyone has come up with something Migrating from Prisma graduallyWe're in the middle of migrating away from Prisma to Drizzle which we just found out that Drizzle ha select with limit of 1Is there a cleaner way of selecting only one item with proper type safety than this? ```ts const us Option filter parametersHi! Love using drizzle so far! Had a quick question (not a bug): ``` const res = await ctx.datab How to delete with cascade?I'm using postgres with the following schema (reduced to the important parts): ``` export const wor PSQL SQL query does not workUnable to achieve it with Drizzle helpers - I had to write my query in plain SQL. I'm trying to bu drop tablesIs there a way to do a migration to drop tables? Other ORMs like Sequelize and Prisma have a concept db.query error with relationI have created a schema.ts, with two tables, with a one-to-one relationship. I have also create the How to transform to camelCase with json_agg()?As topic. I can't find any example on how to go about this. The closest I can find is https://orm.dr How to use select?I have a SQL query ``` SELECT row_to_json(departments.*) as department, row_to_json