public interface IAbstractConditionalExpressionStateObjectBuilder<T extends IScalarExpressionStateObjectBuilder<T>> extends IScalarExpressionStateObjectBuilder<T>
Modifier and Type | Method and Description |
---|---|
T |
all(SimpleSelectStatementStateObject subquery)
Creates the expression
ALL(subquery) . |
T |
and(T builder)
Creates the expression
x AND y . |
T |
any(SimpleSelectStatementStateObject subquery)
Creates the expression
ANY(subquery) . |
T |
between(T lowerBoundExpression,
T upperBoundExpression)
Creates the expression
x BETWEEN y AND z . |
T |
collectionPath(String path)
Creates a new collection-valued path expression.
|
T |
different(Number number) |
T |
different(String literal) |
T |
different(T builder) |
T |
equal(Number number) |
T |
equal(String literal) |
T |
equal(T builder) |
T |
exists(SimpleSelectStatementStateObject subquery) |
T |
FALSE() |
T |
greaterThan(Number number) |
T |
greaterThan(String literal) |
T |
greaterThan(T builder) |
T |
greaterThanOrEqual(Number number) |
T |
greaterThanOrEqual(String literal) |
T |
greaterThanOrEqual(T builder) |
T |
in(SimpleSelectStatementStateObject subquery) |
T |
in(String... inItems) |
T |
in(T... inItems) |
T |
isEmpty(String path) |
T |
isNotEmpty(String path) |
T |
isNotNull(String path) |
T |
isNull(String path) |
T |
like(String patternValue) |
T |
like(T patternValue) |
T |
like(T patternValue,
String escapeCharacter) |
T |
lower(T builder) |
T |
lowerThan(Number number) |
T |
lowerThan(String literal) |
T |
lowerThan(T builder) |
T |
lowerThanOrEqual(Number number) |
T |
lowerThanOrEqual(String literal) |
T |
lowerThanOrEqual(T builder) |
T |
member(String path) |
T |
memberOf(String path) |
T |
notBetween(T lowerBoundExpression,
T upperBoundExpression) |
T |
notExists(SimpleSelectStatementStateObject subquery) |
T |
notIn(SimpleSelectStatementStateObject subquery) |
T |
notIn(String... inItems) |
T |
notIn(T... inItems) |
T |
notLike(String patternValue) |
T |
notLike(T builder) |
T |
notLike(T builder,
String escapeCharacter) |
T |
notMember(String path) |
T |
notMemberOf(String path) |
T |
NULL() |
T |
or(T builder) |
T |
some(SimpleSelectStatementStateObject subquery) |
T |
sub(StateObject stateObject) |
T |
substring(T parameter1,
T parameter2,
T parameter3) |
T |
trim(TrimExpression.Specification specification,
String trimCharacter,
T builder) |
T |
trim(TrimExpression.Specification specification,
T builder) |
T |
TRUE() |
T |
upper(T builder) |
T |
variable(String variable)
Creates the expression representing an identification variable.
|
abs, add, avg, avgDistinct, case_, coalesce, concat, count, countDistinct, currentDate, currentTime, currentTimestamp, date, divide, entityType, enumLiteral, function, function, getCaseBuilder, index, length, locate, locate, max, maxDistinct, min, minDistinct, minus, mod, multiply, nullIf, numeric, numeric, parameter, path, plus, size, sqrt, string, sub, subtract, sum, sumDistinct, type
T all(SimpleSelectStatementStateObject subquery)
ALL(subquery)
.subquery
- The already constructed subqueryT and(T builder)
x AND y
.builder
- The right side of the logical expressionT any(SimpleSelectStatementStateObject subquery)
ANY(subquery)
.subquery
- The already constructed subqueryT between(T lowerBoundExpression, T upperBoundExpression)
x BETWEEN y AND z
.lowerBoundExpression
- The lower bound expressionupperBoundExpression
- The upper bound expressionT collectionPath(String path)
path
- The collection-valued path expressionT exists(SimpleSelectStatementStateObject subquery)
T FALSE()
T in(SimpleSelectStatementStateObject subquery)
T notExists(SimpleSelectStatementStateObject subquery)
T notIn(SimpleSelectStatementStateObject subquery)
T NULL()
T some(SimpleSelectStatementStateObject subquery)
T sub(StateObject stateObject)
T trim(TrimExpression.Specification specification, String trimCharacter, T builder)
T trim(TrimExpression.Specification specification, T builder)
T TRUE()