Filter nested relation based on parent value in RQBv2

drizzle orm

For a PostgreSQL database with the schema

table team (id, ...)

table team (id, ...)

table user (id, team_id, ...)

table user (id, team_id, ...)

, and corresponding

relations

relations

definitions:
How can I query a user with its team including the team members, but without the user itself as part of the members array?

db.query.user.findMany({
  with: {
    team: {
      with: {
        members: {
          where: { /* member id != user id */ }
        },
      },
    }.
  },
});

db.query.user.findMany({
  with: {
    team: {
      with: {
        members: {
          where: { /* member id != user id */ }
        },
      },
    }.
  },
});

Using

[email protected]

[email protected]

Drizzle Team•5w ago

Aaron

Filter nested relation based on parent value in RQBv2

drizzle orm

For a PostgreSQL database with the schema

table team (id, ...)

table team (id, ...)

table user (id, team_id, ...)

table user (id, team_id, ...)

, and corresponding

relations

relations

definitions:
How can I query a user with its team including the team members, but without the user itself as part of the members array?

db.query.user.findMany({
  with: {
    team: {
      with: {
        members: {
          where: { /* member id != user id */ }
        },
      },
    }.
  },
});

db.query.user.findMany({
  with: {
    team: {
      with: {
        members: {
          where: { /* member id != user id */ }
        },
      },
    }.
  },
});

Using

[email protected]

[email protected]

Filter nested relation based on parent value in RQBv2

Similar Threads

Filter nested relation based on parent value in RQBv2

Similar Threads

Similar Threads

Similar Threads