Interface PagingWrappedSQL

Result of wrapping SQL with paging directives.

interface PagingWrappedSQL {
    CountSQL: string;
    DataSQL: string;
    Offset: number;
    PageSize: number;
}

Properties

CountSQL: string

SQL that returns the total row count (without paging)

DataSQL: string

SQL that returns the paged data rows

Offset: number

The computed offset (same as startRow input)

PageSize: number

The page size (same as maxRows input)