Interface QuerySelectionModifiersWithOrderByRaw<TFields>

SQL modifiers that only affect the selection but not the projection.

interface QuerySelectionModifiersWithOrderByRaw<TFields> {
    limit?: number;
    offset?: number;
    orderBy?: {
        fieldName: keyof TFields;
        order: OrderByOrdering;
    }[];
    orderByRaw?: string;
}

Type Parameters

  • TFields

Hierarchy (view full)

Properties

limit?: number

Limit the number of entities returned.

offset?: number

Skip the specified number of entities queried before returning.

orderBy?: {
    fieldName: keyof TFields;
    order: OrderByOrdering;
}[]

Order the entities by specified columns and orders.

orderByRaw?: string

Order the entities by a raw SQL ORDER BY clause.