# notInList

infix fun <T> ExpressionWithColumnType<T>.notInList(list: Iterable<T>): InListOrNotInListBaseOp<T>

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

#### Samples

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

infix fun <T1, T2> Pair<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>>.notInList(list: Iterable<Pair<T1, T2>>): InListOrNotInListBaseOp<Pair<T1, T2>>

Checks if expressions from this `Pair` are not equal to elements from list. This syntax is unsupported by SQL Server.

#### Samples

org.jetbrains.exposed.v1.tests.shared.dml.SelectTests.testNotInListWithPairExpressionsAndEmptyList

infix fun <T1, T2, T3> Triple<ExpressionWithColumnType<T1>, ExpressionWithColumnType<T2>, ExpressionWithColumnType<T3>>.notInList(list: Iterable<Triple<T1, T2, T3>>): InListOrNotInListBaseOp<Triple<T1, T2, T3>>

Checks if expressions from this `Triple` are not equal to elements from list. This syntax is unsupported by SQL Server.

#### Samples

org.jetbrains.exposed.v1.tests.shared.dml.SelectTests.testInListWithTripleExpressions

infix fun List<Column<*>>.notInList(list: Iterable<List<*>>): InListOrNotInListBaseOp<List<*>>

Checks if all columns in this `List` are not equal to any of the lists of values from list.

#### Samples

org.jetbrains.exposed.v1.tests.shared.dml.SelectTests.testInListWithMultipleColumns

@JvmName(name = "notInListCompositeIDs")
infix fun List<Column<*>>.notInList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>

Checks if all columns in this `List` are not equal to any of the CompositeIDs from list.

#### Samples

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

@JvmName(name = "notInListIds")
infix fun <T : Any, ID : EntityID<T>?> Column<ID>.notInList(list: Iterable<T>): InListOrNotInListBaseOp<EntityID<T>?>

Checks if this EntityID column is not equal to any element from list.

#### Samples

org.jetbrains.exposed.v1.tests.shared.dml.SelectTests.testInListWithEntityIDColumns

@JvmName(name = "notInListCompositeEntityIds")
infix fun <ID : EntityID<CompositeID>> Column<ID>.notInList(list: Iterable<CompositeID>): InListOrNotInListBaseOp<List<*>>

Checks if this EntityID column is not equal to any element from list.

#### Samples

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