Feature request: `distinct` and `withSearchIndex`

[widavies]

Is it possible to support using distinct and withSearchIndex together?

Something like:

  return stream(ctx.db, schema)
    .query('addresses')
    .withSearchIndex(`by_state`, (si) => si.search('state', 'N'))
    .order('asc')
    .distinct(['state'])
    .paginate(args.paginationOpts);

The idea is that if addresses contains 1000s of address with state NY and 1000s with NJ, searching for N does not always return all addresses with states beginning with N because it may exhaust the initialNumItems in the usePaginatedQuery before it reaches unique values.

Relevant source:

convex-helpers/packages/convex-helpers/server/stream.ts

Line 621 in c0dc53b

withSearchIndex(_indexName: any, _searchFilter: any): any {

[ianmacartney]

The search indexes would need a way to search on `gt("state", lastResult)` for their filter fields efficiently for this to work

…

On Sat, Oct 25, 2025 at 5:30 PM Will ***@***.***> wrote: *widavies* created an issue (get-convex/convex-helpers#833) <#833> Is it possible to support using distinct and withSearchIndex together? Something like: return stream(ctx.db, schema) .query('addresses') .withSearchIndex(`by_state`, (si) => si.search('state', 'N')) .order('asc') .distinct(['state']) .paginate(args.paginationOpts); Relevant source: https://github.com/get-convex/convex-helpers/blob/c0dc53b35d02012cdd8505eaeb15784212765259/packages/convex-helpers/server/stream.ts#L621 — Reply to this email directly, view it on GitHub <#833>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AACZQW3B3B3UVBK26OCOLAL3ZQI3HAVCNFSM6AAAAACKG5LQU6VHI2DSMVQWIX3LMV43ASLTON2WKOZTGU2TGMJTGYYTMNI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>