inList
open infix fun <T> ExpressionWithColumnType<T>.inList(list: Iterable<T>): InListOrNotInListBaseOp<T>
Checks if this expression is equal to any element from list.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithSingleExpression01open infix fun <T1, T2> Pair<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>>.inList(list: Iterable<Pair<T1, T2>>): InListOrNotInListBaseOp<Pair<T1, T2>>
Checks if expressions from this Pair
are equal to elements from list. This syntax is unsupported by SQL Server.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithPairExpressions01open infix fun <T1, T2, T3> Triple<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>, ExpressionWithColumnType<T3>>.inList(list: Iterable<Triple<T1, T2, T3>>): InListOrNotInListBaseOp<Triple<T1, T2, T3>>
Checks if expressions from this Triple
are equal to elements from list. This syntax is unsupported by SQL Server.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithTripleExpressionsChecks if all columns in this List
are equal to any of the lists of values from list.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithMultipleColumnsopen infix fun List<Column<*>>.inList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
Checks if all columns in this List
are equal to any of the CompositeIDs from list.
Samples
org.jetbrains.exposed.sql.tests.shared.entities.CompositeIdTableEntityTest.testInListWithCompositeIdEntitiesopen infix fun <T : Any, ID : EntityID<T>?> Column<ID>.inList(list: Iterable<T>): InListOrNotInListBaseOp<EntityID<T>?>
Checks if this EntityID column is equal to any element from list.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithEntityIDColumnsopen infix fun <ID : EntityID<CompositeID>> Column<ID>.inList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>
Checks if this EntityID column is equal to any element from list.