KeysetQuery<R, F extends Fields> extension

Stable keyset pagination for a filtered table query.

Sort columns must include a non-null declared primary or unique key. Joins, grouping, DISTINCT, offsets, CTEs, and UNION queries cannot use this pagination.

on

Methods

cursorToken(List<CursorTerm> cursor(F)) String

Available on Query<R, F>, provided by the KeysetQuery extension

Versioned, lossless cursor transport. This is pagination input, not an authorization token. The next query still applies its own WHERE policies.
seekAfter(List<CursorTerm> cursor(F)) Query<R, F>

Available on Query<R, F>, provided by the KeysetQuery extension

Adds a lexicographic boundary after cursor and replaces query ordering.
seekToken(String token, {required List<OrderTerm> orderBy(F)}) Query<R, F>

Available on Query<R, F>, provided by the KeysetQuery extension

Restores a cursorToken using the expected table and complete sort order.