An object that is used to configure how an entity is retrieved from the database. It accepts as a typed parameter an
which provides correct typing of field names in its properties.
An object used to specify how to sort the returned records. Its keys are the names of attributes of the entity, and a key's value can either be
ASCto sort retrieved records in an ascending order, or
DESCto sort retrieved records in a descending order.
An array of strings, each being relation names of the entity to retrieve in the result.
select(string | keyof Entity)
An array of strings, each being attribute names of the entity to retrieve in the result.
skipnull | number
A number indicating the number of records to skip before retrieving the results.
takenull | number
A number indicating the number of records to return in the result.
A boolean indicating whether deleted records should also be retrieved as part of the result. This only works if the entity extends the
Was this section helpful?