Uses of Interface
jakarta.persistence.criteria.Expression
-
Uses of Expression in jakarta.persistence.criteria
Modifier and TypeInterfaceDescriptioninterface
CollectionJoin<Z,
E> TheCollectionJoin
interface is the type of the result of joining to a collection over an association or element collection that has been specified as aCollection
.static interface
Interface used to build general case expressions.static interface
Interface used to build coalesce expressions.static interface
Interface used to build in predicates.static interface
Interface used to build simple case expressions.interface
From<Z,
X> Represents a bound type, usually an entity that appears in the from clause, but may also be an embeddable belonging to an entity in the from clause.interface
Join<Z,
X> A join to an entity, embeddable, or basic type.interface
ListJoin<Z,
E> TheListJoin
interface is the type of the result of joining to a collection over an association or element collection that has been specified as aList
.interface
MapJoin<Z,
K, V> TheMapJoin
interface is the type of the result of joining to a collection over an association or element collection that has been specified as aMap
.interface
Type of criteria query parameter expressions.interface
Path<X>
Represents a simple or compound attribute path from a bound type or collection, and is a "primitive" expression.interface
PluralJoin<Z,
C, E> ThePluralJoin
interface defines functionality that is common to joins to all collection types.interface
The type of a simple or compound predicate: a conjunction or disjunction of restrictions.interface
Root<X>
A root type in the from clause.interface
SetJoin<Z,
E> TheSetJoin
interface is the type of the result of joining to a collection over an association or element collection that has been specified as aSet
.interface
Subquery<T>
TheSubquery
interface defines functionality that is specific to subqueries.Modifier and TypeMethodDescription<N extends Number>
Expression<N> CriteriaBuilder.abs
(Expression<N> x) Create an expression that returns the absolute value of its argument.<Y> Expression
<Y> Create an all expression over the subquery results.<Y> Expression
<Y> Create an any expression over the subquery results.<X> Expression
<X> Perform a typecast upon the expression, returning a new expression object.<N extends Number>
Expression<Double> CriteriaBuilder.avg
(Expression<N> x) Create an aggregate expression applying the avg operation.<X> Expression
<X> Cast this expression to the specified type, returning a new expression object.<N extends Number>
Expression<N> CriteriaBuilder.ceiling
(Expression<N> x) Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.<Y> Expression
<Y> CriteriaBuilder.coalesce
(Expression<? extends Y> x, Expression<? extends Y> y) Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.<Y> Expression
<Y> CriteriaBuilder.coalesce
(Expression<? extends Y> x, Y y) Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.CriteriaBuilder.concat
(Expression<String> x, Expression<String> y) Create an expression for string concatenation.CriteriaBuilder.concat
(Expression<String> x, String y) Create an expression for string concatenation.CriteriaBuilder.concat
(String x, Expression<String> y) Create an expression for string concatenation.CriteriaBuilder.concat
(List<Expression<String>> expressions) Create an expression for string concatenation.CriteriaBuilder.count
(Expression<?> x) Create an aggregate expression applying the count operation.CriteriaBuilder.countDistinct
(Expression<?> x) Create an aggregate expression applying the count distinct operation.CriteriaBuilder.currentDate()
Create expression to return current date.CriteriaBuilder.currentTime()
Create expression to return current time.CriteriaBuilder.currentTimestamp()
Create expression to return current timestamp.<N extends Number>
Expression<N> CriteriaBuilder.diff
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the difference between its arguments.<N extends Number>
Expression<N> CriteriaBuilder.diff
(Expression<? extends N> x, N y) Create an expression that returns the difference between its arguments.<N extends Number>
Expression<N> CriteriaBuilder.diff
(N x, Expression<? extends N> y) Create an expression that returns the difference between its arguments.MapJoin.entry()
Create an expression that corresponds to the map entry.CriteriaBuilder.exp
(Expression<? extends Number> x) Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.<N,
T extends Temporal>
Expression<N> CriteriaBuilder.extract
(TemporalField<N, T> field, Expression<T> temporal) Create an expression that returns the value of a field extracted from a date, time, or datetime.<N extends Number>
Expression<N> CriteriaBuilder.floor
(Expression<N> x) Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.<T> Expression
<T> CriteriaBuilder.function
(String name, Class<T> type, Expression<?>... args) Create an expression for the execution of a database function.<K,
V, M extends Map<K, V>>
Expression<M> Path.get
(MapAttribute<? super X, K, V> map) Create a path corresponding to the referenced map-valued attribute.<E,
C extends Collection<E>>
Expression<C> Path.get
(PluralAttribute<? super X, C, E> collection) Create a path corresponding to the referenced collection-valued attribute.CriteriaBuilder.In.getExpression()
Return the expression to be tested against the list of values.CriteriaBuilder.SimpleCase.getExpression()
Return the expression to be tested against the conditions.Expression
<?> Order.getExpression()
Return the expression that is used for ordering.Subquery.getSelection()
Return the selection expression.<X extends Comparable<? super X>>
Expression<X> CriteriaBuilder.greatest
(Expression<X> x) Create an aggregate expression for finding the greatest of the values (strings, dates, etc).ListJoin.index()
Create an expression that corresponds to the index of the object in the referenced association or element collection.<K,
M extends Map<K, ?>>
Expression<Set<K>> CriteriaBuilder.keys
(M map) Create an expression that returns the keys of a map.<X extends Comparable<? super X>>
Expression<X> CriteriaBuilder.least
(Expression<X> x) Create an aggregate expression for finding the least of the values (strings, dates, etc).CriteriaBuilder.left
(Expression<String> x, int len) Create an expression for the leftmost substring of a string,CriteriaBuilder.left
(Expression<String> x, Expression<Integer> len) Create an expression for the leftmost substring of a string,CriteriaBuilder.length
(Expression<String> x) Create expression to return length of a string.<T> Expression
<T> CriteriaBuilder.literal
(T value) Create an expression for a literal.CriteriaBuilder.ln
(Expression<? extends Number> x) Create an expression that returns the natural logarithm of its argument.CriteriaBuilder.localDate()
Create expression to return current local date.CriteriaBuilder.localDateTime()
Create expression to return current local datetime.CriteriaBuilder.localTime()
Create expression to return current local time.CriteriaBuilder.locate
(Expression<String> x, Expression<String> pattern) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, Expression<String> pattern, Expression<Integer> from) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, String pattern) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, String pattern, int from) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.lower
(Expression<String> x) Create expression for converting a string to lowercase.<N extends Number>
Expression<N> CriteriaBuilder.max
(Expression<N> x) Create an aggregate expression applying the numerical max operation.<N extends Number>
Expression<N> CriteriaBuilder.min
(Expression<N> x) Create an aggregate expression applying the numerical min operation.CriteriaBuilder.mod
(Expression<Integer> x, Expression<Integer> y) Create an expression that returns the modulus (remainder under integer division) of its arguments.CriteriaBuilder.mod
(Expression<Integer> x, Integer y) Create an expression that returns the modulus (remainder under integer division) of its arguments.CriteriaBuilder.mod
(Integer x, Expression<Integer> y) Create an expression that returns the modulus (remainder under integer division) of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.neg
(Expression<N> x) Create an expression that returns the arithmetic negation of its argument.<Y> Expression
<Y> CriteriaBuilder.nullif
(Expression<Y> x, Expression<?> y) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.<Y> Expression
<Y> CriteriaBuilder.nullif
(Expression<Y> x, Y y) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.<T> Expression
<T> CriteriaBuilder.nullLiteral
(Class<T> resultClass) Create an expression for a null literal with the given type.CriteriaBuilder.Case.otherwise
(Expression<? extends R> result) Add an "else" clause to the case expression.Add an "else" clause to the case expression.CriteriaBuilder.SimpleCase.otherwise
(Expression<? extends R> result) Add an "else" clause to the case expression.Add an "else" clause to the case expression.CriteriaBuilder.power
(Expression<? extends Number> x, Expression<? extends Number> y) Create an expression that returns the first argument raised to the power of its second argument.CriteriaBuilder.power
(Expression<? extends Number> x, Number y) Create an expression that returns the first argument raised to the power of its second argument.<N extends Number>
Expression<N> CriteriaBuilder.prod
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the product of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.prod
(Expression<? extends N> x, N y) Create an expression that returns the product of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.prod
(N x, Expression<? extends N> y) Create an expression that returns the product of its arguments.CriteriaBuilder.quot
(Expression<? extends Number> x, Expression<? extends Number> y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.quot
(Expression<? extends Number> x, Number y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.quot
(Number x, Expression<? extends Number> y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.replace
(Expression<String> x, Expression<String> substring, Expression<String> replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, Expression<String> substring, String replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, String substring, Expression<String> replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, String substring, String replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.right
(Expression<String> x, int len) Create an expression for the rightmost substring of a string,CriteriaBuilder.right
(Expression<String> x, Expression<Integer> len) Create an expression for the rightmost substring of a string,<T extends Number>
Expression<T> CriteriaBuilder.round
(Expression<T> x, Integer n) Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.CriteriaBuilder.sign
(Expression<? extends Number> x) Create an expression that returns the sign of its argument, that is,1
if its argument is positive,-1
if its argument is negative, or0
if its argument is exactly zero.<C extends Collection<?>>
Expression<Integer> CriteriaBuilder.size
(C collection) Create an expression that tests the size of a collection.<C extends Collection<?>>
Expression<Integer> CriteriaBuilder.size
(Expression<C> collection) Create an expression that tests the size of a collection.<Y> Expression
<Y> Create a some expression over the subquery results.CriteriaBuilder.sqrt
(Expression<? extends Number> x) Create an expression that returns the square root of its argument.CriteriaBuilder.substring
(Expression<String> x, int from) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, int from, int len) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, Expression<Integer> from) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, Expression<Integer> from, Expression<Integer> len) Create an expression for substring extraction.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the sum of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<? extends N> x, N y) Create an expression that returns the sum of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<N> x) Create an aggregate expression applying the sum operation.<N extends Number>
Expression<N> CriteriaBuilder.sum
(N x, Expression<? extends N> y) Create an expression that returns the sum of its arguments.CriteriaBuilder.sumAsDouble
(Expression<Float> x) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.CriteriaBuilder.sumAsLong
(Expression<Integer> x) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.CriteriaBuilder.toBigDecimal
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toBigInteger
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toDouble
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toFloat
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toInteger
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toLong
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toString
(Expression<Character> character) Typecast.CriteriaBuilder.trim
(char t, Expression<String> x) Create expression to trim character from both ends of a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, char t, Expression<String> x) Create expression to trim character from a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, Expression<Character> t, Expression<String> x) Create expression to trim character from a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, Expression<String> x) Create expression to trim blanks from a string.CriteriaBuilder.trim
(Expression<Character> t, Expression<String> x) Create expression to trim character from both ends of a string.CriteriaBuilder.trim
(Expression<String> x) Create expression to trim blanks from both ends of a string.Expression
<Class<? extends X>> Path.type()
Create an expression corresponding to the type of the path.CriteriaBuilder.upper
(Expression<String> x) Create expression for converting a string to uppercase.<V,
M extends Map<?, V>>
Expression<Collection<V>> CriteriaBuilder.values
(M map) Create an expression that returns the values of a map.Modifier and TypeMethodDescriptionPredicate.getExpressions()
Return the top-level conjuncts or disjuncts of the predicate.List
<Expression<?>> AbstractQuery.getGroupList()
Return a list of the grouping expressions.Modifier and TypeMethodDescription<N extends Number>
Expression<N> CriteriaBuilder.abs
(Expression<N> x) Create an expression that returns the absolute value of its argument.CriteriaBuilder.and
(Expression<Boolean> x, Expression<Boolean> y) Create a conjunction of the given boolean expressions.CriteriaBuilder.asc
(Expression<?> expression) Create an ordering by the ascending value of the expression.CriteriaBuilder.asc
(Expression<?> expression, Nulls nullPrecedence) Create an ordering by the ascending value of the expression.<N extends Number>
Expression<Double> CriteriaBuilder.avg
(Expression<N> x) Create an aggregate expression applying the avg operation.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.between
(Expression<? extends Y> v, Expression<? extends Y> x, Expression<? extends Y> y) Create a predicate for testing whether the first argument is between the second and third arguments in value.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.between
(Expression<? extends Y> v, Y x, Y y) Create a predicate for testing whether the first argument is between the second and third arguments in value.<N extends Number>
Expression<N> CriteriaBuilder.ceiling
(Expression<N> x) Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.<Y> Expression
<Y> CriteriaBuilder.coalesce
(Expression<? extends Y> x, Expression<? extends Y> y) Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.<Y> Expression
<Y> CriteriaBuilder.coalesce
(Expression<? extends Y> x, Y y) Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.CriteriaBuilder.concat
(Expression<String> x, Expression<String> y) Create an expression for string concatenation.CriteriaBuilder.concat
(Expression<String> x, String y) Create an expression for string concatenation.CriteriaBuilder.concat
(String x, Expression<String> y) Create an expression for string concatenation.CriteriaBuilder.count
(Expression<?> x) Create an aggregate expression applying the count operation.CriteriaBuilder.countDistinct
(Expression<?> x) Create an aggregate expression applying the count distinct operation.CriteriaBuilder.desc
(Expression<?> expression) Create an ordering by the descending value of the expression.CriteriaBuilder.desc
(Expression<?> expression, Nulls nullPrecedence) Create an ordering by the descending value of the expression.<N extends Number>
Expression<N> CriteriaBuilder.diff
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the difference between its arguments.<N extends Number>
Expression<N> CriteriaBuilder.diff
(Expression<? extends N> x, N y) Create an expression that returns the difference between its arguments.<N extends Number>
Expression<N> CriteriaBuilder.diff
(N x, Expression<? extends N> y) Create an expression that returns the difference between its arguments.CriteriaBuilder.equal
(Expression<?> x, Expression<?> y) Create a predicate for testing the arguments for equality.CriteriaBuilder.equal
(Expression<?> x, Object y) Create a predicate for testing the arguments for equality.Expression.equalTo
(Expression<?> value) Create a predicate to test whether the expression is equal to the argument.CriteriaBuilder.exp
(Expression<? extends Number> x) Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.<N,
T extends Temporal>
Expression<N> CriteriaBuilder.extract
(TemporalField<N, T> field, Expression<T> temporal) Create an expression that returns the value of a field extracted from a date, time, or datetime.<N extends Number>
Expression<N> CriteriaBuilder.floor
(Expression<N> x) Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.<T> Expression
<T> CriteriaBuilder.function
(String name, Class<T> type, Expression<?>... args) Create an expression for the execution of a database function.CriteriaBuilder.ge
(Expression<? extends Number> x, Expression<? extends Number> y) Create a predicate for testing whether the first argument is greater than or equal to the second.CriteriaBuilder.ge
(Expression<? extends Number> x, Number y) Create a predicate for testing whether the first argument is greater than or equal to the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.greaterThan
(Expression<? extends Y> x, Expression<? extends Y> y) Create a predicate for testing whether the first argument is greater than the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.greaterThan
(Expression<? extends Y> x, Y y) Create a predicate for testing whether the first argument is greater than the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.greaterThanOrEqualTo
(Expression<? extends Y> x, Expression<? extends Y> y) Create a predicate for testing whether the first argument is greater than or equal to the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.greaterThanOrEqualTo
(Expression<? extends Y> x, Y y) Create a predicate for testing whether the first argument is greater than or equal to the second.<X extends Comparable<? super X>>
Expression<X> CriteriaBuilder.greatest
(Expression<X> x) Create an aggregate expression for finding the greatest of the values (strings, dates, etc).AbstractQuery.groupBy
(Expression<?>... grouping) Specify the expressions that are used to form groups over the query results.CriteriaQuery.groupBy
(Expression<?>... grouping) Specify the expressions that are used to form groups over the query results.Subquery.groupBy
(Expression<?>... grouping) Specify the expressions that are used to form groups over the subquery results.CriteriaBuilder.gt
(Expression<? extends Number> x, Expression<? extends Number> y) Create a predicate for testing whether the first argument is greater than the second.CriteriaBuilder.gt
(Expression<? extends Number> x, Number y) Create a predicate for testing whether the first argument is greater than the second.AbstractQuery.having
(Expression<Boolean> restriction) Specify a restriction over the groups of the query.CriteriaQuery.having
(Expression<Boolean> restriction) Specify a restriction over the groups of the query.Subquery.having
(Expression<Boolean> restriction) Specify a restriction over the groups of the subquery.<T> CriteriaBuilder.In
<T> CriteriaBuilder.in
(Expression<? extends T> expression) Create predicate to test whether given expression is contained in a list of values.Expression.in
(Expression<?>... values) Create a predicate to test whether the expression is a member of the argument list.Expression.in
(Expression<Collection<?>> values) Create a predicate to test whether the expression is a member of the collection.<C extends Collection<?>>
PredicateCriteriaBuilder.isEmpty
(Expression<C> collection) Create a predicate that tests whether a collection is empty.CriteriaBuilder.isFalse
(Expression<Boolean> x) Create a predicate testing for a false value.<E,
C extends Collection<E>>
PredicateCriteriaBuilder.isMember
(E elem, Expression<C> collection) Create a predicate that tests whether an element is a member of a collection.<E,
C extends Collection<E>>
PredicateCriteriaBuilder.isMember
(Expression<E> elem, Expression<C> collection) Create a predicate that tests whether an element is a member of a collection.<C extends Collection<?>>
PredicateCriteriaBuilder.isNotEmpty
(Expression<C> collection) Create a predicate that tests whether a collection is not empty.<E,
C extends Collection<E>>
PredicateCriteriaBuilder.isNotMember
(E elem, Expression<C> collection) Create a predicate that tests whether an element is not a member of a collection.<E,
C extends Collection<E>>
PredicateCriteriaBuilder.isNotMember
(Expression<E> elem, Expression<C> collection) Create a predicate that tests whether an element is not a member of a collection.CriteriaBuilder.isNotNull
(Expression<?> x) Create a predicate to test whether the expression is not null.CriteriaBuilder.isNull
(Expression<?> x) Create a predicate to test whether the expression is null.CriteriaBuilder.isTrue
(Expression<Boolean> x) Create a predicate testing for a true value.CriteriaBuilder.le
(Expression<? extends Number> x, Expression<? extends Number> y) Create a predicate for testing whether the first argument is less than or equal to the second.CriteriaBuilder.le
(Expression<? extends Number> x, Number y) Create a predicate for testing whether the first argument is less than or equal to the second.<X extends Comparable<? super X>>
Expression<X> CriteriaBuilder.least
(Expression<X> x) Create an aggregate expression for finding the least of the values (strings, dates, etc).CriteriaBuilder.left
(Expression<String> x, int len) Create an expression for the leftmost substring of a string,CriteriaBuilder.left
(Expression<String> x, Expression<Integer> len) Create an expression for the leftmost substring of a string,CriteriaBuilder.length
(Expression<String> x) Create expression to return length of a string.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.lessThan
(Expression<? extends Y> x, Expression<? extends Y> y) Create a predicate for testing whether the first argument is less than the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.lessThan
(Expression<? extends Y> x, Y y) Create a predicate for testing whether the first argument is less than the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.lessThanOrEqualTo
(Expression<? extends Y> x, Expression<? extends Y> y) Create a predicate for testing whether the first argument is less than or equal to the second.<Y extends Comparable<? super Y>>
PredicateCriteriaBuilder.lessThanOrEqualTo
(Expression<? extends Y> x, Y y) Create a predicate for testing whether the first argument is less than or equal to the second.CriteriaBuilder.like
(Expression<String> x, Expression<String> pattern) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.like
(Expression<String> x, Expression<String> pattern, char escapeChar) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.like
(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.like
(Expression<String> x, String pattern) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.like
(Expression<String> x, String pattern, char escapeChar) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.like
(Expression<String> x, String pattern, Expression<Character> escapeChar) Create a predicate for testing whether the expression satisfies the given pattern.CriteriaBuilder.ln
(Expression<? extends Number> x) Create an expression that returns the natural logarithm of its argument.CriteriaBuilder.locate
(Expression<String> x, Expression<String> pattern) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, Expression<String> pattern, Expression<Integer> from) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, String pattern) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.locate
(Expression<String> x, String pattern, int from) Create expression to locate the position of one string within another, returning position of first character if found.CriteriaBuilder.lower
(Expression<String> x) Create expression for converting a string to lowercase.CriteriaBuilder.lt
(Expression<? extends Number> x, Expression<? extends Number> y) Create a predicate for testing whether the first argument is less than the second.CriteriaBuilder.lt
(Expression<? extends Number> x, Number y) Create a predicate for testing whether the first argument is less than the second.<N extends Number>
Expression<N> CriteriaBuilder.max
(Expression<N> x) Create an aggregate expression applying the numerical max operation.<N extends Number>
Expression<N> CriteriaBuilder.min
(Expression<N> x) Create an aggregate expression applying the numerical min operation.CriteriaBuilder.mod
(Expression<Integer> x, Expression<Integer> y) Create an expression that returns the modulus (remainder under integer division) of its arguments.CriteriaBuilder.mod
(Expression<Integer> x, Integer y) Create an expression that returns the modulus (remainder under integer division) of its arguments.CriteriaBuilder.mod
(Integer x, Expression<Integer> y) Create an expression that returns the modulus (remainder under integer division) of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.neg
(Expression<N> x) Create an expression that returns the arithmetic negation of its argument.CriteriaBuilder.not
(Expression<Boolean> restriction) Create a negation of the given restriction.CriteriaBuilder.notEqual
(Expression<?> x, Expression<?> y) Create a predicate for testing the arguments for inequality.CriteriaBuilder.notEqual
(Expression<?> x, Object y) Create a predicate for testing the arguments for inequality.Expression.notEqualTo
(Expression<?> value) Create a predicate to test whether the expression is unequal to the argument.CriteriaBuilder.notLike
(Expression<String> x, Expression<String> pattern) Create a predicate for testing whether the expression does not satisfy the given pattern.CriteriaBuilder.notLike
(Expression<String> x, Expression<String> pattern, char escapeChar) Create a predicate for testing whether the expression does not satisfy the given pattern.CriteriaBuilder.notLike
(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar) Create a predicate for testing whether the expression does not satisfy the given pattern.CriteriaBuilder.notLike
(Expression<String> x, String pattern) Create a predicate for testing whether the expression does not satisfy the given pattern.CriteriaBuilder.notLike
(Expression<String> x, String pattern, char escapeChar) Create a predicate for testing whether the expression does not satisfy the given pattern.CriteriaBuilder.notLike
(Expression<String> x, String pattern, Expression<Character> escapeChar) Create a predicate for testing whether the expression does not satisfy the given pattern.<Y> Expression
<Y> CriteriaBuilder.nullif
(Expression<Y> x, Expression<?> y) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.<Y> Expression
<Y> CriteriaBuilder.nullif
(Expression<Y> x, Y y) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.CollectionJoin.on
(Expression<Boolean> restriction) Modify the join to restrict the result according to the specified ON condition and return the join object.Join.on
(Expression<Boolean> restriction) Modify the join to restrict the result according to the specified ON condition and return the join object.ListJoin.on
(Expression<Boolean> restriction) Modify the join to restrict the result according to the specified ON condition and return the join object.MapJoin.on
(Expression<Boolean> restriction) Modify the join to restrict the result according to the specified ON condition and return the join object.SetJoin.on
(Expression<Boolean> restriction) Modify the join to restrict the result according to the specified ON condition and return the join object.CriteriaBuilder.or
(Expression<Boolean> x, Expression<Boolean> y) Create a disjunction of the given boolean expressions.CriteriaBuilder.Case.otherwise
(Expression<? extends R> result) Add an "else" clause to the case expression.CriteriaBuilder.SimpleCase.otherwise
(Expression<? extends R> result) Add an "else" clause to the case expression.CriteriaBuilder.power
(Expression<? extends Number> x, Expression<? extends Number> y) Create an expression that returns the first argument raised to the power of its second argument.CriteriaBuilder.power
(Expression<? extends Number> x, Number y) Create an expression that returns the first argument raised to the power of its second argument.<N extends Number>
Expression<N> CriteriaBuilder.prod
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the product of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.prod
(Expression<? extends N> x, N y) Create an expression that returns the product of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.prod
(N x, Expression<? extends N> y) Create an expression that returns the product of its arguments.CriteriaBuilder.quot
(Expression<? extends Number> x, Expression<? extends Number> y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.quot
(Expression<? extends Number> x, Number y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.quot
(Number x, Expression<? extends Number> y) Create an expression that returns the quotient of its arguments.CriteriaBuilder.replace
(Expression<String> x, Expression<String> substring, Expression<String> replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, Expression<String> substring, String replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, String substring, Expression<String> replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.replace
(Expression<String> x, String substring, String replacement) Create an expression replacing every occurrence of a substring within a string.CriteriaBuilder.right
(Expression<String> x, int len) Create an expression for the rightmost substring of a string,CriteriaBuilder.right
(Expression<String> x, Expression<Integer> len) Create an expression for the rightmost substring of a string,<T extends Number>
Expression<T> CriteriaBuilder.round
(Expression<T> x, Integer n) Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.Subquery.select
(Expression<T> expression) Specify the item that is to be returned as the subquery result.<C,
R> CriteriaBuilder.SimpleCase <C, R> CriteriaBuilder.selectCase
(Expression<? extends C> expression) Create a simple case expression.<Y> CriteriaUpdate
<T> CriteriaUpdate.set
(Path<Y> attribute, Expression<? extends Y> value) Update the value of the specified attribute.<Y> CriteriaUpdate
<T> CriteriaUpdate.set
(SingularAttribute<? super T, Y> attribute, Expression<? extends Y> value) Update the value of the specified attribute.CriteriaBuilder.sign
(Expression<? extends Number> x) Create an expression that returns the sign of its argument, that is,1
if its argument is positive,-1
if its argument is negative, or0
if its argument is exactly zero.<C extends Collection<?>>
Expression<Integer> CriteriaBuilder.size
(Expression<C> collection) Create an expression that tests the size of a collection.CriteriaBuilder.sqrt
(Expression<? extends Number> x) Create an expression that returns the square root of its argument.CriteriaBuilder.substring
(Expression<String> x, int from) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, int from, int len) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, Expression<Integer> from) Create an expression for substring extraction.CriteriaBuilder.substring
(Expression<String> x, Expression<Integer> from, Expression<Integer> len) Create an expression for substring extraction.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<? extends N> x, Expression<? extends N> y) Create an expression that returns the sum of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<? extends N> x, N y) Create an expression that returns the sum of its arguments.<N extends Number>
Expression<N> CriteriaBuilder.sum
(Expression<N> x) Create an aggregate expression applying the sum operation.<N extends Number>
Expression<N> CriteriaBuilder.sum
(N x, Expression<? extends N> y) Create an expression that returns the sum of its arguments.CriteriaBuilder.sumAsDouble
(Expression<Float> x) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.CriteriaBuilder.sumAsLong
(Expression<Integer> x) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.CriteriaBuilder.toBigDecimal
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toBigInteger
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toDouble
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toFloat
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toInteger
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toLong
(Expression<? extends Number> number) Typecast.CriteriaBuilder.toString
(Expression<Character> character) Typecast.CriteriaBuilder.trim
(char t, Expression<String> x) Create expression to trim character from both ends of a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, char t, Expression<String> x) Create expression to trim character from a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, Expression<Character> t, Expression<String> x) Create expression to trim character from a string.CriteriaBuilder.trim
(CriteriaBuilder.Trimspec ts, Expression<String> x) Create expression to trim blanks from a string.CriteriaBuilder.trim
(Expression<Character> t, Expression<String> x) Create expression to trim character from both ends of a string.CriteriaBuilder.trim
(Expression<String> x) Create expression to trim blanks from both ends of a string.CriteriaBuilder.upper
(Expression<String> x) Create expression for converting a string to uppercase.CriteriaBuilder.Coalesce.value
(Expression<? extends T> value) Add an argument to the coalesce expression.CriteriaBuilder.In.value
(Expression<? extends T> value) Add to list of values to be tested against.CriteriaBuilder.Case.when
(Expression<Boolean> condition, Expression<? extends R> result) Add a when/then clause to the case expression.CriteriaBuilder.Case.when
(Expression<Boolean> condition, R result) Add a when/then clause to the case expression.CriteriaBuilder.SimpleCase.when
(C condition, Expression<? extends R> result) Add a when/then clause to the case expression.CriteriaBuilder.SimpleCase.when
(Expression<? extends C> condition, Expression<? extends R> result) Add a when/then clause to the case expression.CriteriaBuilder.SimpleCase.when
(Expression<? extends C> condition, R result) Add a when/then clause to the case expression.AbstractQuery.where
(Expression<Boolean> restriction) Modify the query to restrict the query results according to the specified boolean expression.CriteriaDelete.where
(Expression<Boolean> restriction) Modify the DELETE query to restrict the target of the deletion according to the specified boolean expression.CriteriaQuery.where
(Expression<Boolean> restriction) Modify the query to restrict the query result according to the specified boolean expression.CriteriaUpdate.where
(Expression<Boolean> restriction) Modify the update query to restrict the target of the update according to the specified boolean expression.Subquery.where
(Expression<Boolean> restriction) Modify the subquery to restrict the result according to the specified boolean expression.Modifier and TypeMethodDescriptionCriteriaBuilder.concat
(List<Expression<String>> expressions) Create an expression for string concatenation.AbstractQuery.groupBy
(List<Expression<?>> grouping) Specify the expressions that are used to form groups over the query results.CriteriaQuery.groupBy
(List<Expression<?>> grouping) Specify the expressions that are used to form groups over the query results.Subquery.groupBy
(List<Expression<?>> grouping) Specify the expressions that are used to form groups over the subquery results.