Uses of Interface com.exasol.sql.expression.BooleanExpression (Exasol SQL Statement Builder 4.5.3 API)

Packages that use BooleanExpression
Package	Description
com.exasol.sql.dml.merge
com.exasol.sql.dql.select
com.exasol.sql.expression
com.exasol.sql.expression.comparison
com.exasol.sql.expression.literal
com.exasol.sql.expression.predicate
com.exasol.sql.expression.rendering

Uses of BooleanExpression in com.exasol.sql.dml.merge

Methods in com.exasol.sql.dml.merge that return BooleanExpression
Modifier and Type	Method	Description
`BooleanExpression`	OnClause.`getCondition()`	Get the merge condition.

Methods in com.exasol.sql.dml.merge with parameters of type BooleanExpression
Modifier and Type	Method	Description
`Merge`	Merge.`on(BooleanExpression condition)`	Define the merge criteria.
`Merge`	MergeInsertClause.`where(BooleanExpression expression)`	Add a `WHERE` clause insertion definition.
`Merge`	MergeMethodDefinition.`where(BooleanExpression expression)`	Add a `WHERE` clause `MERGE` definition.

Constructors in com.exasol.sql.dml.merge with parameters of type BooleanExpression
Constructor	Description
`OnClause(Fragment root, BooleanExpression condition)`	Create a new instance of a `OnClause`.

Uses of BooleanExpression in com.exasol.sql.dql.select

Methods in com.exasol.sql.dql.select that return BooleanExpression
Modifier and Type	Method	Description
`BooleanExpression`	WhereClause.`getExpression()`	Get the boolean expression defining the filter criteria
`BooleanExpression`	GroupByClause.`getHavingBooleanExpression()`	Get the "having" boolean expression.

Methods in com.exasol.sql.dql.select with parameters of type BooleanExpression
Modifier and Type	Method	Description
`Select`	GroupByClause.`having(BooleanExpression booleanExpression)`	Add having statement to the SQL query.
`Select`	Select.`where(BooleanExpression expression)`	Create a new `WhereClause`.

Constructors in com.exasol.sql.dql.select with parameters of type BooleanExpression
Constructor	Description
`WhereClause(SqlStatement root, BooleanExpression expression)`	Create a new instance of a `WhereClause`

Uses of BooleanExpression in com.exasol.sql.expression

Classes in com.exasol.sql.expression that implement BooleanExpression
Modifier and Type	Class	Description
`class`	`AbstractBooleanExpression`	Abstract base class for all types of BooleanExpressions.
`class`	`And`	This class represents a logical AND predicate.
`class`	`BooleanTerm`	This class represents boolean terms like `AND` or `NOT`.
`class`	`Not`	This class implements the logical unary NOT predicate.
`class`	`Or`	This class represents a logical OR predicate.

Methods in com.exasol.sql.expression that return BooleanExpression
Modifier and Type	Method	Description
`static BooleanExpression`	BooleanTerm.`and(boolean... values)`	Logical `AND` combination of boolean values.
`static BooleanExpression`	BooleanTerm.`and(boolean value, BooleanExpression expression)`	Logical `AND` combination of boolean value and expression.
`static BooleanExpression`	BooleanTerm.`and(BooleanExpression... expressions)`	Logical `AND` combination of boolean expressions.
`static BooleanExpression`	BooleanTerm.`and(BooleanExpression expression, boolean value)`	Logical `AND` combination of boolean expression and value.
`static BooleanExpression`	BooleanTerm.`between(ValueExpression expression, ValueExpression start, ValueExpression end)`	Check if value is between two other values.
`static BooleanExpression`	BooleanTerm.`compare(ValueExpression left, SimpleComparisonOperator operator, ValueExpression right)`	General comparison with operator enum.
`static BooleanExpression`	BooleanTerm.`compare(ValueExpression left, String operatorSymbol, ValueExpression right)`	General comparison with operator as string.
`static BooleanExpression`	BooleanTerm.`eq(ValueExpression left, ValueExpression right)`	Equality comparison.
`static BooleanExpression`	BooleanTerm.`exists(Select select)`	Check if the sub-select has any result.
`static BooleanExpression`	BooleanTerm.`ge(ValueExpression left, ValueExpression right)`	Greater-than-or-equal comparison.
`BooleanExpression`	Not.`getOperand()`	Get the boolean expression literal to be negated.
`static BooleanExpression`	BooleanTerm.`gt(ValueExpression left, ValueExpression right)`	Greater-than comparison.
`static BooleanExpression`	BooleanTerm.`in(ValueExpression operand, Select select)`	Check for value sub-select.
`static BooleanExpression`	BooleanTerm.`in(ValueExpression toFind, ValueExpression... inList)`	Check for value in list.
`static BooleanExpression`	BooleanTerm.`isNotNull(ValueExpression operand)`	Check for not null.
`static BooleanExpression`	BooleanTerm.`isNull(ValueExpression operand)`	Check for null.
`static BooleanExpression`	BooleanTerm.`le(ValueExpression left, ValueExpression right)`	Less-than-or-equal comparison.
`static BooleanExpression`	BooleanTerm.`like(ValueExpression left, ValueExpression right)`	Comparison with `LIKE` operator.
`static BooleanExpression`	BooleanTerm.`like(ValueExpression left, ValueExpression right, char escape)`	Comparison with `LIKE` operator.
`static BooleanExpression`	BooleanTerm.`lt(ValueExpression left, ValueExpression right)`	Less-than comparison.
`static BooleanExpression`	BooleanTerm.`ne(ValueExpression left, ValueExpression right)`	Not-equal comparison.
`static BooleanExpression`	BooleanTerm.`not(boolean value)`	Unary `NOT` of boolean value.
`static BooleanExpression`	BooleanTerm.`not(BooleanExpression expression)`	Unary `NOT` of boolean expression.
`static BooleanExpression`	BooleanTerm.`notBetween(ValueExpression expression, ValueExpression start, ValueExpression end)`	Check if value is not between two other values.
`static BooleanExpression`	BooleanTerm.`notIn(ValueExpression operand, Select select)`	Check if value not in sub-select.
`static BooleanExpression`	BooleanTerm.`notIn(ValueExpression toFind, ValueExpression... inList)`	Check if value not in list.
`static BooleanExpression`	BooleanTerm.`notLike(ValueExpression left, ValueExpression right)`	Comparison with inverted `LIKE` operator.
`static BooleanExpression`	BooleanTerm.`notLike(ValueExpression left, ValueExpression right, char escape)`	Comparison with inverted `LIKE` operator.
`static BooleanExpression`	BooleanTerm.`operation(String operator, BooleanExpression... expressions)`	Create a logical operation from an operator name and a list of operands
`static BooleanExpression`	BooleanTerm.`or(boolean... values)`	Logical `OR` combination of boolean values.
`static BooleanExpression`	BooleanTerm.`or(boolean value, BooleanExpression expression)`	Logical `OR` combination of boolean value and expression.
`static BooleanExpression`	BooleanTerm.`or(BooleanExpression... expressions)`	Logical `OR` combination of boolean expressions.
`static BooleanExpression`	BooleanTerm.`or(BooleanExpression expression, boolean value)`	Logical `OR` combination of boolean expression and value.

Methods in com.exasol.sql.expression that return types with arguments of type BooleanExpression
Modifier and Type	Method	Description
`List<BooleanExpression>`	And.`getOperands()`	Get the operands of this AND.
`List<BooleanExpression>`	Or.`getOperands()`	Get the operands of this OR.

Methods in com.exasol.sql.expression with parameters of type BooleanExpression
Modifier and Type	Method	Description
`static BooleanExpression`	BooleanTerm.`and(boolean value, BooleanExpression expression)`	Logical `AND` combination of boolean value and expression.
`static BooleanExpression`	BooleanTerm.`and(BooleanExpression... expressions)`	Logical `AND` combination of boolean expressions.
`static BooleanExpression`	BooleanTerm.`and(BooleanExpression expression, boolean value)`	Logical `AND` combination of boolean expression and value.
`static BooleanExpression`	BooleanTerm.`not(BooleanExpression expression)`	Unary `NOT` of boolean expression.
`static BooleanExpression`	BooleanTerm.`operation(String operator, BooleanExpression... expressions)`	Create a logical operation from an operator name and a list of operands
`static BooleanExpression`	BooleanTerm.`or(boolean value, BooleanExpression expression)`	Logical `OR` combination of boolean value and expression.
`static BooleanExpression`	BooleanTerm.`or(BooleanExpression... expressions)`	Logical `OR` combination of boolean expressions.
`static BooleanExpression`	BooleanTerm.`or(BooleanExpression expression, boolean value)`	Logical `OR` combination of boolean expression and value.
`void`	ValueExpressionVisitor.`visit(BooleanExpression booleanExpression)`	Visit a boolean expression.

Constructors in com.exasol.sql.expression with parameters of type BooleanExpression
Constructor	Description
`And(BooleanExpression... operands)`	Create a new `And` instance
`Not(BooleanExpression operand)`	Create a new instance of a unary `Not` from a boolean expression
`Or(BooleanExpression... operands)`	Create a new `Or` instance

Uses of BooleanExpression in com.exasol.sql.expression.comparison

Subinterfaces of BooleanExpression in com.exasol.sql.expression.comparison
Modifier and Type	Interface	Description
`interface`	`Comparison`	Interface for classes that implement comparisons between two columns.

Classes in com.exasol.sql.expression.comparison that implement BooleanExpression
Modifier and Type	Class	Description
`class`	`AbstractComparison`	Abstract basis for comparisons.
`class`	`LikeComparison`	This class represents a LIKE comparison.
`class`	`SimpleComparison`	This class implements all simple comparison operators.

Uses of BooleanExpression in com.exasol.sql.expression.literal

Classes in com.exasol.sql.expression.literal that implement BooleanExpression
Modifier and Type	Class	Description
`class`	`BooleanLiteral`	This class represents boolean literals (read "true" and "false")

Methods in com.exasol.sql.expression.literal that return BooleanExpression
Modifier and Type	Method	Description
`static BooleanExpression[]`	BooleanLiteral.`toBooleanExpressions(boolean[] values)`	Map an array of booleans to and array of BooleanExpressions

Uses of BooleanExpression in com.exasol.sql.expression.predicate

Subinterfaces of BooleanExpression in com.exasol.sql.expression.predicate
Modifier and Type	Interface	Description
`interface`	`Predicate`	Interface for classes that implement predicate expressions.

Classes in com.exasol.sql.expression.predicate that implement BooleanExpression
Modifier and Type	Class	Description
`class`	`AbstractPredicate`	An abstract basis for predicate classes.
`class`	`BetweenPredicate`	A class that represents a `[NOT] BETWEEN` predicate.
`class`	`ExistsPredicate`	A class that represents a `EXISTS` predicate.
`class`	`InPredicate`	A class that represents a `[NOT] IN` predicate.
`class`	`IsNullPredicate`	A class that represents a `IS [NOT] NULL` predicate.

Uses of BooleanExpression in com.exasol.sql.expression.rendering

Methods in com.exasol.sql.expression.rendering with parameters of type BooleanExpression
Modifier and Type	Method	Description
`void`	ValueExpressionRenderer.`visit(BooleanExpression booleanExpression)`

Uses of Interfacecom.exasol.sql.expression.BooleanExpression

Uses of BooleanExpression in com.exasol.sql.dml.merge

Uses of BooleanExpression in com.exasol.sql.dql.select

Uses of BooleanExpression in com.exasol.sql.expression

Uses of BooleanExpression in com.exasol.sql.expression.comparison

Uses of BooleanExpression in com.exasol.sql.expression.literal

Uses of BooleanExpression in com.exasol.sql.expression.predicate

Uses of BooleanExpression in com.exasol.sql.expression.rendering

Uses of Interface
com.exasol.sql.expression.BooleanExpression