FindByCursorOptions <T, P, F, E>
Hierarchy
- Omit<FindOptions<T, P, F, E>, limit | offset>
- FindByCursorOptions
Index
Properties
optionalafter
optionalbefore
Fetch items before
this cursor.
optionalcache
Control result caching for this query. Result cache is by default disabled, not to be confused with the identity map.
optionalcomments
sql only
optionalconnectionType
optionalconvertCustomTypes
optionalctx
optionaldisableIdentityMap
optionalexclude
optionalfields
optionalfilters
optionalfirst
Fetch first
N items.
optionalflags
optionalflushMode
optionalgroupBy
sql only
optionalhaving
optionalhintComments
sql only
optionalindexHint
sql only
optionallast
Fetch last
N items.
optionallockMode
sql only
optionallockTableAliases
sql only
optionalloggerContext
optionallogging
optionalorderBy
Ordering of the results.Can be an object or array of objects, keys are property names, values are ordering (asc/desc)
optionaloverfetch
Fetch one more item than first
/last
, enabled automatically in em.findByCursor
to check if there is a next page.
optionalpopulate
optionalpopulateFilter
Filter condition for populated relations. This is similar to populateWhere
, but will produce a left join
when nesting the condition. This is used for implementation of joined filters.
optionalpopulateOrderBy
Used for ordering of the populate queries. If not specified, the value of options.orderBy
is used.
optionalpopulateWhere
Where condition for populated relations. This will have no effect on the root entity.
With select-in
strategy, this is applied only to the populate queries.
With joined
strategy, those are applied as join on
conditions.
When you use a nested condition on a to-many relation, it will produce a nested inner join,
discarding the collection items based on the child condition.
optionalrefresh
optionalschema
optionalstrategy
sql only
Fetch items
after
this cursor.