DT
Drizzle Team•5mo ago
Droutin

Missing where in findMany with

Hi, i wanna make a 'where' on relation, but typescript dont show me option 'where' in 'with' block. It should be possible according to docs https://orm.drizzle.team/docs/rqb#select-filters
Drizzle ORM - Query
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
No description
4 Replies
Droutin
Droutin•5mo ago
I think its due to one-to-one relation. Is there plan to support it?
Mykhailo
Mykhailo•5mo ago
@Droutin hello, yes, it is because one-to-one relation
Droutin
Droutin•5mo ago
will it be supported also for one-to-one? Or how can i filter these one-to-one relations with SQL?
Mykhailo
Mykhailo•5mo ago
Unfortunately, I don't know about future support for this functionality, but you can create GH feature for this. BTW, what is your use case for this filter?
Want results from more Discord servers?
Add your server
More Posts
Error performing migration: LibsqlError: SQLITE_UNKNOWN: SQLite error: cannot rollbackI've already tried downgrading to drizzle kit v0.19 as advised in https://discord.com/channels/93307How to get findMany with count?I have following query ```ts const result = await this.db.query.serviceOrders.findMany({ wpush to a database with some initial tables already on CIBecause there was already an initial table in the database, `push` will ask for confirmation before db variable bug in drizzle runnerI'm getting "Cannot find name 'db'." errorIs there a way to re-use a specific tables columns in multiple queries across an application?I'm trying to build a bunch of models/queries like this: ``` const workOrder = await db.query.workOrOdd connection ended errorI've been using Drizzle for months without a hitch. But for some reason I'm now running to an error Finding it hard to get started with vercel postgresHi guys, I'm totally new to Drizzle and I want to know if there is any blog/article or something wheSupabase & DrizzleSupabase has automatic auth.uid() for every inserts and a row level security as well. How can I do tHow can I get imports with file extensions?I have an azure function that runs on node, and use Drizzle for a postgres database. The node/typescI need help with Enums in Drizzle.I referenced two images showing my schema file and the migration generated. I always get this error