FindByCursorOptions <T, P, F, E>
Hierarchy
- Omit<FindOptions<T, P, F, E>, limit | offset>
- FindByCursorOptions
Index
Properties
optionalinheritedafter
optionalinheritedbefore
Fetch items before
this cursor.
optionalinheritedcache
Control result caching for this query. Result cache is by default disabled, not to be confused with the identity map.
optionalinheritedcomments
sql only
optionalinheritedconnectionType
optionalinheritedconvertCustomTypes
optionalinheritedctx
optionalinheriteddisableIdentityMap
optionalinheritedexclude
optionalinheritedfields
optionalinheritedfilters
optionalinheritedfirst
Fetch first
N items.
optionalinheritedflags
optionalinheritedflushMode
optionalinheritedgroupBy
sql only
optionalinheritedhaving
optionalinheritedhintComments
sql only
optionalinheritedindexHint
sql only
optionalinheritedlast
Fetch last
N items.
optionalinheritedlockMode
sql only
optionalinheritedlockTableAliases
sql only
optionalinheritedloggerContext
optionalinheritedlogging
optionalinheritedorderBy
Ordering of the results.Can be an object or array of objects, keys are property names, values are ordering (asc/desc)
optionalinheritedoverfetch
Fetch one more item than first
/last
, enabled automatically in em.findByCursor
to check if there is a next page.
optionalinheritedpopulate
optionalinheritedpopulateFilter
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.
optionalinheritedpopulateOrderBy
Used for ordering of the populate queries. If not specified, the value of options.orderBy
is used.
optionalinheritedpopulateWhere
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.
optionalinheritedrefresh
optionalinheritedschema
optionalinheritedstrategy
sql only
Fetch items
after
this cursor.