DT
Drizzle Teamtomri

how to group Related Items

// index.ts

const coursesList = await db
  .select({ title: courses.title, tags: tags.tag })
  .from(courseTags)
  .leftJoin(courses, eq(courses.id, courseTags.courseId))
  .leftJoin(tags, eq(courseTags.tagId, tags.id));
// index.ts

const coursesList = await db
  .select({ title: courses.title, tags: tags.tag })
  .from(courseTags)
  .leftJoin(courses, eq(courses.id, courseTags.courseId))
  .leftJoin(tags, eq(courseTags.tagId, tags.id));
# actual output

courses: [
  {
    title: "Course 1",
    tags: "Tag 1"
  }, {
    title: "Course 2",
    tags: "Tag 2"
  }, {
    title: "Course 3",
    tags: "Tag 3"
  }, {
    title: "Course 1",
    tags: "tag 4"
  }, {
    title: "Course 1",
    tags: "tag 5"
  }
]
# actual output

courses: [
  {
    title: "Course 1",
    tags: "Tag 1"
  }, {
    title: "Course 2",
    tags: "Tag 2"
  }, {
    title: "Course 3",
    tags: "Tag 3"
  }, {
    title: "Course 1",
    tags: "tag 4"
  }, {
    title: "Course 1",
    tags: "tag 5"
  }
]
# desired output

courses: [
  {
    title: "Course 1",
    tags: ["Tag 1", "tag 4", "tag 5"]
  }, {
    title: "Course 2",
    tags: ["Tag 2"]
  }, {
    title: "Course 3",
    tags: ["Tag 3"]
  }
]
# desired output

courses: [
  {
    title: "Course 1",
    tags: ["Tag 1", "tag 4", "tag 5"]
  }, {
    title: "Course 2",
    tags: ["Tag 2"]
  }, {
    title: "Course 3",
    tags: ["Tag 3"]
  }
]
Want results from more Discord servers?
Add your server
More Posts
Nested where filter, how to not include emptyThe following almost works ``` const query = db.query.productionItem.findMany({ with: { itemStis placeholder in prepare statements deprecated!??```typescript const courses = db.query.userCourses .findMany({ where: eq(placeholder("userId")