1 reply

left join not properly hydrating results

tx
          .select({
            ...getTableColumns(projects),
            clients: { id: clients.id, name: clients.name },
          })
          .from(projects)
          .leftJoin(clients, eq(clients.id, projects.clientId))

tx
          .select({
            ...getTableColumns(projects),
            clients: { id: clients.id, name: clients.name },
          })
          .from(projects)
          .leftJoin(clients, eq(clients.id, projects.clientId))

The query this generates is correct:

select "projects"."id", "projects"."created_at", "projects"."updated_at", "projects"."organization_id", "projects"."name", "projects"."client_id", "clients"."id", "clients"."name" from "projects" left join "clients" on "clients"."id" = "projects"."client_id"

select "projects"."id", "projects"."created_at", "projects"."updated_at", "projects"."organization_id", "projects"."name", "projects"."client_id", "clients"."id", "clients"."name" from "projects" left join "clients" on "clients"."id" = "projects"."client_id"

And running this query also returns the clients name, as expected. But the resulting object says clients is null, whereas I am expecting an object with the id and name values set.

Why is this not hydrating?

Drizzle Team•10mo ago•

1 reply

RWOverdijk

left join not properly hydrating results

tx
          .select({
            ...getTableColumns(projects),
            clients: { id: clients.id, name: clients.name },
          })
          .from(projects)
          .leftJoin(clients, eq(clients.id, projects.clientId))

tx
          .select({
            ...getTableColumns(projects),
            clients: { id: clients.id, name: clients.name },
          })
          .from(projects)
          .leftJoin(clients, eq(clients.id, projects.clientId))

The query this generates is correct:

select "projects"."id", "projects"."created_at", "projects"."updated_at", "projects"."organization_id", "projects"."name", "projects"."client_id", "clients"."id", "clients"."name" from "projects" left join "clients" on "clients"."id" = "projects"."client_id"

select "projects"."id", "projects"."created_at", "projects"."updated_at", "projects"."organization_id", "projects"."name", "projects"."client_id", "clients"."id", "clients"."name" from "projects" left join "clients" on "clients"."id" = "projects"."client_id"

left join not properly hydrating results

Similar Threads

left join not properly hydrating results

Similar Threads

Similar Threads

Similar Threads