Struct KeysetCondition 

#[non_exhaustive]
pub struct KeysetCondition {
    pub sort_fields: Vec<SortField>,
    pub cursor_values: Vec<Value>,
    pub forward: bool,
}

Keyset pagination condition.

Generates efficient (col1, col2) > ($1, $2) style WHERE clauses for keyset/seek pagination.

Fields (Non-exhaustive)

Non-exhaustive structs could have additional fields added in future. Therefore, non-exhaustive structs cannot be constructed in external crates using the traditional Struct { .. } syntax; cannot be matched against without a wildcard ..; and struct update syntax will not work.

sort_fields: Vec<SortField>

The sort fields and their directions.

cursor_values: Vec<Value>

The cursor values for each field.

forward: bool

Direction: true for “after”, false for “before”.

Implementations

impl KeysetCondition

pub fn after(sorts: &[SortField], cursor: &Cursor) -> Option<Self>

Create a new keyset condition for paginating after a cursor.

pub fn before(sorts: &[SortField], cursor: &Cursor) -> Option<Self>

Create a new keyset condition for paginating before a cursor.

pub fn to_filter_expr(&self) -> FilterExpr

Convert to a filter expression for the query builder.

For a single field, generates: field > $1 (or < for DESC)

For multiple fields, generates proper compound OR conditions: (a, b) > (1, 2) becomes: (a > 1) OR (a = 1 AND b > 2)

For 3+ fields: (a > 1) OR (a = 1 AND b > 2) OR (a = 1 AND b = 2 AND c > 3)

This follows the keyset pagination standard used by PostgreSQL, GraphQL Relay, and major ORMs. See: https://use-the-index-luke.com/no-offset

Trait Implementations

impl Clone for KeysetCondition

fn clone(&self) -> KeysetCondition

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for KeysetCondition

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for KeysetCondition

fn eq(&self, other: &KeysetCondition) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for KeysetCondition