© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Drizzle Team•3y ago•

20 replies

Query only one item from Many-To-Many

I would like only to take one stat not all the arrays. Is there a method to replace limit with something which returns only one item.

const res = await ctx.db.query.servers.findMany({
  with: {
    game: true,
    stat: {
      limit: 1,
      orderBy: (table, { desc }) => [desc(table.statId)],
      with: {
        stat: true,
      },
    },
  },
});

const res = await ctx.db.query.servers.findMany({
  with: {
    game: true,
    stat: {
      limit: 1,
      orderBy: (table, { desc }) => [desc(table.statId)],
      with: {
        stat: true,
      },
    },
  },
});