.find*methods accept special options you can use to query data you need without using
select- indicates which properties of the main object must be selected
relations- relations needs to be loaded with the main entity. Sub-relations can also be loaded (shorthand for
where- simple conditions by which entity should be queried.
order- selection order.
withDeleted- include entities which have been soft deleted with
softRemove, e.g. have their
@DeleteDateColumncolumn set. By default, soft deleted entities are not included.
find*methods which return multiple entities (
findAndCountBy) also accept following options:
skip- offset (paginated) from where entities should be taken.
take- limit (paginated) - max number of entities that should be taken.
takeshould be used together
limit, you need to use order as well or you will receive the following error:
'Invalid usage of the option NEXT in the FETCH statement.'
lock- Enables locking mechanism for query. Can be used only in
lockis an object which can be defined as:
Rawfunction to provide a list of parameters to bind to the query.