Interface RestrictionBuilder<T>
- Type Parameters:
T
- The builder type that is returned on terminal operations
- All Known Subinterfaces:
RestrictionBuilderExperimental<T>
SubqueryInitiator
.- Since:
- 1.0.0
- Author:
- Christian Beikov
-
Method Summary
Modifier and TypeMethodDescriptionStarts a builder for a between predicate with parameterized lower bound.betweenExpression
(String start) Starts a builder for a between predicate with lower bound expression.betweenLiteral
(Object start) Starts a builder for a between predicate with parameterized lower bound that is rendered as literal.betweenSubqueries
(String expression) Starts aMultipleSubqueryInitiator
for a between predicate with the given expression as lower bound.Starts a builder for a between predicate with a subquery as lower bound.betweenSubquery
(FullQueryBuilder<?, ?> criteriaBuilder) Starts a builder for a between predicate with a subquery as lower bound.betweenSubquery
(String subqueryAlias, String expression) Starts a builder for a between predicate with a subquery as lower bound.betweenSubquery
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts a builder for a between predicate with a subquery as lower bound.eq()
Starts aQuantifiableBinaryPredicateBuilder
for the EQ predicate that can be used to apply quantors.eq
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the right hand side for the EQ predicate.Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
.Starts aSubqueryInitiator
for the EQ predicate that can be used to apply quantors.eq
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the EQ predicate that can be used to apply quantors.eqExpression
(String expression) Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
.Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
.eqSubqueries
(String expression) Starts aSubqueryInitiator
for the EQ predicate that can be used to apply quantors.ge()
Starts aQuantifiableBinaryPredicateBuilder
for the GE predicate that can be used to apply quantors.ge
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GE predicate that can be used to apply quantors.Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
.Starts aSubqueryInitiator
for the GE predicate that can be used to apply quantors.ge
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GE predicate that can be used to apply quantors.geExpression
(String expression) Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
.Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
.geSubqueries
(String expression) Starts aSubqueryInitiator
for the GE predicate that can be used to apply quantors.gt()
Starts aQuantifiableBinaryPredicateBuilder
for the GT predicate that can be used to apply quantors.gt
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GT predicate that can be used to apply quantors.Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
.Starts aSubqueryInitiator
for the GT predicate that can be used to apply quantors.gt
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GT predicate that can be used to apply quantors.gtExpression
(String expression) Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
.Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
.gtSubqueries
(String expression) Starts aSubqueryInitiator
for the GT predicate that can be used to apply quantors.in()
Starts aSubqueryInitiator
for the right hand side of the IN predicate.in
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the right hand side of the IN predicate.Likein(java.util.Collection)
but the values will be wrapped in aCollection
.in
(Collection<?> values) Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
.inCollectionExpression
(String collectionParameterExpression) Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
.inExpressions
(String... parameterOrLiteralExpressions) Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
.inLiterals
(Object... values) LikeinLiterals(java.util.Collection)
but the values will be wrapped in aCollection
.inLiterals
(Collection<?> values) Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
.isEmpty()
Finishes the IS EMPTY predicate and adds it to the parent predicate container represented by the typeT
.isMemberOf
(String expression) Finishes the MEMBER OF predicate and adds it to the parent predicate container represented by the typeT
.LikeisEmpty()
but the result is wrapped in a NOT predicate.isNotMemberOf
(String expression) LikeisMemberOf(java.lang.String)
but the result is wrapped in a NOT predicate.LikeisNull()
but the result is wrapped in a NOT predicate.isNull()
Finishes the IS NULL predicate and adds it to the parent predicate container represented by the typeT
.le()
Starts aQuantifiableBinaryPredicateBuilder
for the LE predicate that can be used to apply quantors.le
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LE predicate that can be used to apply quantors.Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
.Starts aSubqueryInitiator
for the LE predicate that can be used to apply quantors.le
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LE predicate that can be used to apply quantors.leExpression
(String expression) Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
.Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
.leSubqueries
(String expression) Starts aSubqueryInitiator
for the LE predicate that can be used to apply quantors.like()
Likelike(boolean)
withcaseSensitive = true
.like
(boolean caseSensitive) Creates aLikeBuilder
for building a like predicate.lt()
Starts aQuantifiableBinaryPredicateBuilder
for the LT predicate that can be used to apply quantors.lt
(FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LT predicate that can be used to apply quantors.Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
.Starts aSubqueryInitiator
for the LT predicate that can be used to apply quantors.lt
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LT predicate that can be used to apply quantors.ltExpression
(String expression) Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
.Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
.ltSubqueries
(String expression) Starts aSubqueryInitiator
for the LT predicate that can be used to apply quantors.Switch to the non portable mode which might to be portable to other JPA providers.notBetween
(Object start) Likebetween(java.lang.Object)
but the resulting predicate is negated.notBetweenExpression
(String start) LikebetweenExpression(java.lang.String)
but the resulting predicate is negated.notBetweenLiteral
(Object start) LikebetweenLiteral(java.lang.Object)
but the resulting predicate is negated.notBetweenSubqueries
(String expression) LikebetweenSubqueries(java.lang.String)
but the resulting predicate is negated.LikebetweenSubquery()
but the resulting predicate is negated.notBetweenSubquery
(FullQueryBuilder<?, ?> criteriaBuilder) LikebetweenSubquery(FullQueryBuilder)
but the resulting predicate is negated.notBetweenSubquery
(String subqueryAlias, String expression) LikebetweenSubquery(java.lang.String, java.lang.String)
but the resulting predicate is negated.notBetweenSubquery
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) LikebetweenSubquery(java.lang.String, java.lang.String, FullQueryBuilder)
but the resulting predicate is negated.notEq()
Likeeq()
but the result is wrapped in a NOT predicate.notEq
(FullQueryBuilder<?, ?> criteriaBuilder) Likeeq(FullQueryBuilder)
but the result is wrapped in a NOT predicate.Likeeq(java.lang.Object)
but the result is wrapped in a NOT predicate.Likeeq(java.lang.String,java.lang.String)
but the result is wrapped in a NOT predicate.notEq
(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Likeeq(java.lang.String,java.lang.String, FullQueryBuilder)
but the result is wrapped in a NOT predicate.notEqExpression
(String expression) LikeeqExpression(java.lang.String)
but the result is wrapped in a NOT predicate.notEqLiteral
(Object value) LikeeqLiteral(java.lang.Object)
but the result is wrapped in a NOT predicate.notEqSubqueries
(String expression) LikeeqSubqueries(java.lang.String)
but the result is wrapped in a NOT predicate.notIn()
Likein()
but the result is wrapped in a NOT predicate.notIn
(FullQueryBuilder<?, ?> criteriaBuilder) Likein(FullQueryBuilder)
but the result is wrapped in a NOT predicate.LikenotIn(java.util.Collection)
but the values will be wrapped in aCollection
.notIn
(Collection<?> values) Likein(java.util.Collection)
but the result is wrapped in a NOT predicate.notInCollectionExpression
(String collectionParameterExpression) LikeinCollectionExpression(String)
but the result is wrapped in a NOT predicate.notInExpressions
(String... parameterOrLiteralExpressions) LikeinExpressions(String...)
but the result is wrapped in a NOT predicate.notInLiterals
(Object... values) LikenotInLiterals(java.util.Collection)
but the values will be wrapped in aCollection
.notInLiterals
(Collection<?> values) LikeinLiterals(java.util.Collection)
but the result is wrapped in a NOT predicate.notLike()
LikenotLike(boolean)
withcaseSensitive = true
.notLike
(boolean caseSensitive) Likelike(boolean)
but the resulting like predicate is negated.
-
Method Details
-
betweenExpression
Starts a builder for a between predicate with lower bound expression.- Parameters:
start
- The between start expression- Returns:
- The
BetweenBuilder
-
between
Starts a builder for a between predicate with parameterized lower bound.- Parameters:
start
- The between start value- Returns:
- The
BetweenBuilder
-
betweenLiteral
Starts a builder for a between predicate with parameterized lower bound that is rendered as literal.- Parameters:
start
- The between start value- Returns:
- The
BetweenBuilder
- Since:
- 1.4.0
-
betweenSubquery
SubqueryInitiator<BetweenBuilder<T>> betweenSubquery()Starts a builder for a between predicate with a subquery as lower bound.- Returns:
- The
SubqueryInitiator
-
betweenSubquery
Starts a builder for a between predicate with a subquery as lower bound.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with it's then expression are added to this predicate container as disjunct.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The
SubqueryInitiator
-
betweenSubqueries
Starts aMultipleSubqueryInitiator
for a between predicate with the given expression as lower bound.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the lower bound of the between predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
betweenSubquery
Starts a builder for a between predicate with a subquery as lower bound.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
betweenSubquery
SubqueryBuilder<BetweenBuilder<T>> betweenSubquery(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts a builder for a between predicate with a subquery as lower bound.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with it's then expression are added to this predicate container as disjunct.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
notBetweenExpression
LikebetweenExpression(java.lang.String)
but the resulting predicate is negated.- Parameters:
start
- The between start expression- Returns:
- The
BetweenBuilder
-
notBetween
Likebetween(java.lang.Object)
but the resulting predicate is negated.- Parameters:
start
- The between start value- Returns:
- The
BetweenBuilder
-
notBetweenLiteral
LikebetweenLiteral(java.lang.Object)
but the resulting predicate is negated.- Parameters:
start
- The between start value- Returns:
- The
BetweenBuilder
- Since:
- 1.4.0
-
notBetweenSubquery
SubqueryInitiator<BetweenBuilder<T>> notBetweenSubquery()LikebetweenSubquery()
but the resulting predicate is negated.- Returns:
- The
SubqueryInitiator
-
notBetweenSubquery
LikebetweenSubquery(java.lang.String, java.lang.String)
but the resulting predicate is negated.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The
SubqueryInitiator
-
notBetweenSubqueries
LikebetweenSubqueries(java.lang.String)
but the resulting predicate is negated.- Parameters:
expression
- The expression for the lower bound of the between predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
notBetweenSubquery
LikebetweenSubquery(FullQueryBuilder)
but the resulting predicate is negated.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
notBetweenSubquery
SubqueryBuilder<BetweenBuilder<T>> notBetweenSubquery(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) LikebetweenSubquery(java.lang.String, java.lang.String, FullQueryBuilder)
but the resulting predicate is negated.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
eq
Starts aQuantifiableBinaryPredicateBuilder
for the EQ predicate that can be used to apply quantors.- Returns:
- The quantifiable binary predicate builder
-
eq
Starts aSubqueryInitiator
for the EQ predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The quantifiable subquery initiator
-
eqSubqueries
Starts aSubqueryInitiator
for the EQ predicate that can be used to apply quantors.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the right hand side of the EQ predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
eq
Starts aSubqueryBuilder
based on the given criteria builder for the right hand side for the EQ predicate.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
eq
SubqueryBuilder<T> eq(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the EQ predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
eq
Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is equal to the given value.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
eqLiteral
Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is equal to the given value rendered as literal.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
eqExpression
Finishes the EQ predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is equal to the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
notEq
QuantifiableBinaryPredicateBuilder<T> notEq()Likeeq()
but the result is wrapped in a NOT predicate.- Returns:
- The quantifiable binary predicate builder
-
notEq
Likeeq(java.lang.String,java.lang.String)
but the result is wrapped in a NOT predicate.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate- Returns:
- The quantifiable binary predicate builder
-
notEqSubqueries
LikeeqSubqueries(java.lang.String)
but the result is wrapped in a NOT predicate.- Parameters:
expression
- The expression for the right hand side of the NOT EQ predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
notEq
Likeeq(FullQueryBuilder)
but the result is wrapped in a NOT predicate.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
notEq
SubqueryBuilder<T> notEq(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Likeeq(java.lang.String,java.lang.String, FullQueryBuilder)
but the result is wrapped in a NOT predicate.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicatecriteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
notEq
Likeeq(java.lang.Object)
but the result is wrapped in a NOT predicate.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
notEqLiteral
LikeeqLiteral(java.lang.Object)
but the result is wrapped in a NOT predicate.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
notEqExpression
LikeeqExpression(java.lang.String)
but the result is wrapped in a NOT predicate.- Parameters:
expression
- The expression on the right hand side- Returns:
- The quantifiable binary predicate builder
-
gt
Starts aQuantifiableBinaryPredicateBuilder
for the GT predicate that can be used to apply quantors.- Returns:
- The quantifiable binary predicate builder
-
gt
Starts aSubqueryInitiator
for the GT predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The quantifiable subquery initiator
-
gtSubqueries
Starts aSubqueryInitiator
for the GT predicate that can be used to apply quantors.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the right hand side of the GT predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
gt
Starts aSubqueryBuilder
based on the given criteria builder for the GT predicate that can be used to apply quantors.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
gt
SubqueryBuilder<T> gt(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GT predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
gt
Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater than the given value.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
gtLiteral
Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater than the given value rendered as literal.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
gtExpression
Finishes the GT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater than the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
ge
Starts aQuantifiableBinaryPredicateBuilder
for the GE predicate that can be used to apply quantors.- Returns:
- The quantifiable binary predicate builder
-
ge
Starts aSubqueryInitiator
for the GE predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The quantifiable subquery initiator
-
geSubqueries
Starts aSubqueryInitiator
for the GE predicate that can be used to apply quantors.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the right hand side of the GE predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
ge
Starts aSubqueryBuilder
based on the given criteria builder for the GE predicate that can be used to apply quantors.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
ge
SubqueryBuilder<T> ge(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the GE predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
ge
Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater or equal to the given value.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
geLiteral
Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater or equal to the given value rendered as literal.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
geExpression
Finishes the GE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is greater or equal to the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
lt
Starts aQuantifiableBinaryPredicateBuilder
for the LT predicate that can be used to apply quantors.- Returns:
- The quantifiable binary predicate builder
-
lt
Starts aSubqueryInitiator
for the LT predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The quantifiable subquery initiator
-
ltSubqueries
Starts aSubqueryInitiator
for the LT predicate that can be used to apply quantors.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the right hand side of the LT predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
lt
Starts aSubqueryBuilder
based on the given criteria builder for the LT predicate that can be used to apply quantors.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
lt
SubqueryBuilder<T> lt(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LT predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
lt
Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less than the given value.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
ltLiteral
Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less than the given value rendered as literal.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
ltExpression
Finishes the LT predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less than the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
le
Starts aQuantifiableBinaryPredicateBuilder
for the LE predicate that can be used to apply quantors.- Returns:
- The quantifiable binary predicate builder
-
le
Starts aSubqueryInitiator
for the LE predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.- Returns:
- The quantifiable subquery initiator
-
leSubqueries
Starts aSubqueryInitiator
for the LE predicate that can be used to apply quantors.All occurrences of subsequently defined
subqueryAlias
es inexpression
will be replaced by the respective subquery. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
expression
- The expression for the right hand side of the LE predicate.- Returns:
- The subquery initiator for building multiple subqueries for their respective subqueryAliases
- Since:
- 1.2.0
-
le
Starts aSubqueryBuilder
based on the given criteria builder for the LE predicate that can be used to apply quantors.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
le
SubqueryBuilder<T> le(String subqueryAlias, String expression, FullQueryBuilder<?, ?> criteriaBuilder) Starts aSubqueryBuilder
based on the given criteria builder for the LE predicate that can be used to apply quantors.All occurrences of
subqueryAlias
inexpression
will be replaced by the subquery. When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as right hand side of a predicate. This expression contains thesubqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
le
Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less or equal to the given value.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
-
leLiteral
Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less or equal to the given value rendered as literal.- Parameters:
value
- The value on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
leExpression
Finishes the LE predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is less or equal to the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
in
SubqueryInitiator<T> in()Starts aSubqueryInitiator
for the right hand side of the IN predicate. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Returns:
- The subquery initiator for building a subquery
-
notIn
SubqueryInitiator<T> notIn()Likein()
but the result is wrapped in a NOT predicate.- Returns:
- The subquery initiator for building a subquery
-
in
Starts aSubqueryBuilder
based on the given criteria builder for the right hand side of the IN predicate. When the builder finishes, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
notIn
Likein(FullQueryBuilder)
but the result is wrapped in a NOT predicate.- Parameters:
criteriaBuilder
- The criteria builder to base the subquery on- Returns:
- The subquery builder for building a subquery
- Since:
- 1.2.0
-
inExpressions
Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is in the parameter- or literal-expressions denoted by the given parameters.- Parameters:
parameterOrLiteralExpressions
- The parameter- or literal-expressions on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.1.0
-
inCollectionExpression
Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is in the collection parameter-expression denoted by the given parameter.- Parameters:
collectionParameterExpression
- The collection parameter--expression on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
in
Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is in the list of given values.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
-
in
Likein(java.util.Collection)
but the values will be wrapped in aCollection
.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
-
inLiterals
Finishes the IN predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is in the list of given values rendered as literals.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
inLiterals
LikeinLiterals(java.util.Collection)
but the values will be wrapped in aCollection
.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
notInExpressions
LikeinExpressions(String...)
but the result is wrapped in a NOT predicate.- Parameters:
parameterOrLiteralExpressions
- The parameter- or literal-expressions on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.1.0
-
notInCollectionExpression
LikeinCollectionExpression(String)
but the result is wrapped in a NOT predicate.- Parameters:
collectionParameterExpression
- The collection parameter-expression on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
notIn
Likein(java.util.Collection)
but the result is wrapped in a NOT predicate.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
-
notIn
LikenotIn(java.util.Collection)
but the values will be wrapped in aCollection
.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
-
notInLiterals
LikeinLiterals(java.util.Collection)
but the result is wrapped in a NOT predicate.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
notInLiterals
LikenotInLiterals(java.util.Collection)
but the values will be wrapped in aCollection
.- Parameters:
values
- The values on the right hand side- Returns:
- The parent predicate container builder
- Since:
- 1.4.0
-
isNull
T isNull()Finishes the IS NULL predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is null.- Returns:
- The parent predicate container builder
-
isNotNull
T isNotNull()LikeisNull()
but the result is wrapped in a NOT predicate.- Returns:
- The parent predicate container builder
-
isEmpty
T isEmpty()Finishes the IS EMPTY predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is empty.- Returns:
- The parent predicate container builder
-
isNotEmpty
T isNotEmpty()LikeisEmpty()
but the result is wrapped in a NOT predicate.- Returns:
- The parent predicate container builder
-
isMemberOf
Finishes the MEMBER OF predicate and adds it to the parent predicate container represented by the typeT
. The predicate checks if the left hand side is of the given expression.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
isNotMemberOf
LikeisMemberOf(java.lang.String)
but the result is wrapped in a NOT predicate.- Parameters:
expression
- The expression on the right hand side- Returns:
- The parent predicate container builder
-
like
Creates aLikeBuilder
for building a like predicate.The predicate checks if the left hand side is like the pattern delivered by the
LikeBuilder
while respecting the case sensitivity according to thecaseSensitive
parameter.Once the
LikeBuilder
is finished, the predicate is added to the parent predicate container represented by the typeT
.- Parameters:
caseSensitive
- If true, the comparison of the left hand side expression with the pattern respects is performed case sensitive, else it is performed case insensitive.- Returns:
- The
LikeBuilder
for building the comparison pattern.
-
like
LikeBuilder<T> like()Likelike(boolean)
withcaseSensitive = true
.- Returns:
- The
LikeBuilder
for building the comparison pattern.
-
notLike
Likelike(boolean)
but the resulting like predicate is negated.- Parameters:
caseSensitive
- If true, the comparison of the left hand side expression with the pattern respects is performed case sensitive, else it is performed case insensitive.- Returns:
- The
LikeBuilder
for building the comparison pattern.
-
notLike
LikeBuilder<T> notLike()LikenotLike(boolean)
withcaseSensitive = true
.- Returns:
- The
LikeBuilder
for building the comparison pattern.
-
nonPortable
RestrictionBuilderExperimental<T> nonPortable()Switch to the non portable mode which might to be portable to other JPA providers.- Returns:
- this restriction builder in the non portable mode
-