© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•2y ago
lukas

limiting json_agg

Having a bit of a skill issue limiting the amount of data returned from
json_agg
json_agg


      const query = ctx.db
        .select({
          ...groupByFilters,
          rowCount: sql<number>`count(${schema.returns.id})`.as(
            "row_count",
          ),
          data: sql`json_agg(${schema.returns})`,
        })
        .from(schema.returns)
        .groupBy(...Object.values(groupByFilters))
        .limit(limit + 1); // limit the amount of groups returned
      const query = ctx.db
        .select({
          ...groupByFilters,
          rowCount: sql<number>`count(${schema.returns.id})`.as(
            "row_count",
          ),
          data: sql`json_agg(${schema.returns})`,
        })
        .from(schema.returns)
        .groupBy(...Object.values(groupByFilters))
        .limit(limit + 1); // limit the amount of groups returned


I tried to add a subquery, but I can't seem to get it right
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Postgres json_agg
Drizzle TeamDTDrizzle Team / help
3y ago
Custom SQL function (json_agg & json_build_object)
Drizzle TeamDTDrizzle Team / help
3y ago
Custom postgres JSON_AGG function help
Drizzle TeamDTDrizzle Team / help
15mo ago
Using json_agg does not format correctly
Drizzle TeamDTDrizzle Team / help
3y ago