Filtering against a relation

I have a orgs table that have a many to many relation with a users table.

while querying with the findFirst method how can i filter against the relation so that I only return an org if the user have access to it.

Drizzle Team Join

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

11,879Members

Resources

Similar Threads

Was this page helpful?

Twitter GitHub Discord

Communities Docs About Terms Privacy

Star

Setup for Free

Drizzle Team•3y ago

dubo

Filtering against a relation

Drizzle Team Join

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

11,879Members

Resources

Similar Threads

Nested relation filtering

DTDrizzle Team / help

14mo ago

RQB | using specific fields from a query against relations

DTDrizzle Team / help

3y ago

TypeScript error when specifying `relationName` in a one-to-one relation

DTDrizzle Team / help

3y ago

Filtering

DTDrizzle Team / help

3y ago

Similar Threads

Was this page helpful?

Recent Announcements

Similar Threads

Nested relation filtering

DTDrizzle Team / help

14mo ago

RQB | using specific fields from a query against relations

DTDrizzle Team / help

3y ago

TypeScript error when specifying `relationName` in a one-to-one relation

DTDrizzle Team / help

3y ago

Filtering

DTDrizzle Team / help

3y ago