Interface for a key-value database table query.

interface IDatabaseTableQuery {
    limit?: number;
    offset?: number;
    orderBy?: {
        direction: "asc" | "desc";
        key: string;
    };
    where?: IDatabaseTableQueryWhereValue | IDatabaseTableQueryWhereValues | IDatabaseTableQueryWhereBetween;
}

Properties

limit?: number

The limit for the query, allowing pagination.

offset?: number

The offset for the query, allowing pagination.

orderBy?: {
    direction: "asc" | "desc";
    key: string;
}

The order by clause for the query. The key must be a valid indexed key path for the table and match the where clause key, if provided.

The where clause for the query.