Order By Relational Data

I'm testing out the new relations API and have a slight issue but I'm not sure if this is a limitation of the querying API or if I'm just missing something.

The scenerio is that I have 2 tables with a one-to-one relationship between them on a column. For instance:

Users:
id - PK
name - String
role_id - int (with one-to-one on a role)

Roles:
id - PK
name - String

Users:
id - PK
name - String
role_id - int (with one-to-one on a role)

Roles:
id - PK
name - String

I want to be able to order the users by their role name. How I imagined using it would be the following:

await db.query.users.findMany({
  with: {
    role: true,
  },
  orderBy: {
    role: {
      name: "asc",
    }
  },
});

await db.query.users.findMany({
  with: {
    role: true,
  },
  orderBy: {
    role: {
      name: "asc",
    }
  },
});

Is this possible with the new relational API?

Drizzle Team•10mo ago

Jaden

Order By Relational Data

Users:
id - PK
name - String
role_id - int (with one-to-one on a role)

Roles:
id - PK
name - String

Users:
id - PK
name - String
role_id - int (with one-to-one on a role)

Roles:
id - PK
name - String

I want to be able to order the users by their role name. How I imagined using it would be the following:

await db.query.users.findMany({
  with: {
    role: true,
  },
  orderBy: {
    role: {
      name: "asc",
    }
  },
});

await db.query.users.findMany({
  with: {
    role: true,
  },
  orderBy: {
    role: {
      name: "asc",
    }
  },
});

Is this possible with the new relational API?

Order By Relational Data

Similar Threads

Order By Relational Data

Similar Threads

Similar Threads

Similar Threads