DT

Drizzle Team•13mo ago

brynthrax

Nested relation filtering

We have a user table (id, name, role…)user table (id, name, role…) and section table (id, name…)section table (id, name…), bridged by a user_section table (userId, sectionId)user_section table (userId, sectionId). Hence, a many-to-many relationship.

How can I accomplish in drizzle wherein I query for a section, including users (and its fields) under it, but only usersusers with the role “Student”role “Student”? Right now, I can only filter through userIduserId and sectionIdsectionId in the relational query API (see screenshot).