# warmUpOptReferences

fun <SID> warmUpOptReferences(references: List<SID>, refColumn: Column<SID?>, forUpdate: Boolean? = null, orderBy: Array<Pair<Expression<*>, SortOrder>>? = null): List<T>

Returns a list of retrieved Entity instances whose refColumn optionally matches any of the id values in references.

The EntityCache in the current transaction scope will be searched for matching entities, if appropriate for refColumn's column type; otherwise, matching results will be queried from the database.

Set forUpdate to `true` or `false` depending on whether a locking read should be placed or removed from the search query used. Leave the argument as `null` to use the query without any locking option.

Set orderBy to specify the order in which entities should be sorted.