inList

Checks if this expression is equal to any element from list.

Samples

org.jetbrains.exposed.sql.tests.shared.dml.SelectTests.testInListWithSingleExpression01

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.testInListWithPairExpressions01

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.testInListWithTripleExpressions
open infix fun List<Column<*>>.inList(list: Iterable<List<*>>): InListOrNotInListBaseOp<List<*>>

Checks 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.testInListWithMultipleColumns
@JvmName(name = "inListCompositeIDs")
open 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.testInListWithCompositeIdEntities
@JvmName(name = "inListIds")
open 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.testInListWithEntityIDColumns
@JvmName(name = "inListCompositeEntityIds")
open 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.

Samples

org.jetbrains.exposed.sql.tests.shared.entities.CompositeIdTableEntityTest.testInListWithCompositeIdEntities