All Superinterfaces:

jakarta.persistence.criteria.CriteriaBuilder

All Known Subinterfaces:

NodeBuilder

All Known Implementing Classes:

SqmCriteriaNodeBuilder
```
public interface HibernateCriteriaBuilder
extends jakarta.persistence.criteria.CriteriaBuilder
```
Hibernate extensions to the JPA CriteriaBuilder.

Nested Class Summary
- Nested classes/interfaces inherited from interface jakarta.persistence.criteria.CriteriaBuilder
  jakarta.persistence.criteria.CriteriaBuilder.Case<R extends Object>, jakarta.persistence.criteria.CriteriaBuilder.Coalesce<T extends Object>, jakarta.persistence.criteria.CriteriaBuilder.In<T extends Object>, jakarta.persistence.criteria.CriteriaBuilder.SimpleCase<C extends Object,R extends Object>, jakarta.persistence.criteria.CriteriaBuilder.Trimspec

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method	Description
`<N extends Number> JpaExpression<N>`	`abs(jakarta.persistence.criteria.Expression<N> x)`
`<Y> JpaExpression<Y>`	`all(jakarta.persistence.criteria.Subquery<Y> subquery)`
`JpaPredicate`	`and(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)`
`JpaPredicate`	`and(jakarta.persistence.criteria.Predicate... restrictions)`
`<Y> JpaExpression<Y>`	`any(jakarta.persistence.criteria.Subquery<Y> subquery)`
`JpaCompoundSelection<Object[]>`	`array(jakarta.persistence.criteria.Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, jakarta.persistence.criteria.Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)`
`JpaCompoundSelection<Object[]>`	`array(List<? extends JpaSelection<?>> selections)`
`JpaOrder`	`asc(jakarta.persistence.criteria.Expression<?> x)`
`JpaOrder`	`asc(jakarta.persistence.criteria.Expression<?> x, boolean nullsFirst)`	Create an ordering by the ascending value of the expression.
`<N extends Number> JpaExpression<Double>`	`avg(jakarta.persistence.criteria.Expression<N> argument)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`between(jakarta.persistence.criteria.Expression<? extends Y> value, jakarta.persistence.criteria.Expression<? extends Y> lower, jakarta.persistence.criteria.Expression<? extends Y> upper)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`between(jakarta.persistence.criteria.Expression<? extends Y> value, Y lower, Y upper)`
`<X,T> JpaExpression<X>`	`cast(JpaExpression<T> expression, Class<X> castTargetJavaType)`
`<N extends Number> JpaExpression<N>`	`ceiling(jakarta.persistence.criteria.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.
`<T> JpaCoalesce<T>`	`coalesce()`
`<Y> JpaCoalesce<Y>`	`coalesce(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)`
`<Y> JpaCoalesce<Y>`	`coalesce(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)`
`JpaExpression<String>`	`concat(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> y)`
`JpaExpression<String>`	`concat(jakarta.persistence.criteria.Expression<String> x, String y)`
`JpaExpression<String>`	`concat(String x, jakarta.persistence.criteria.Expression<String> y)`
`JpaExpression<String>`	`concat(String x, String y)`
`JpaPredicate`	`conjunction()`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, jakarta.persistence.criteria.Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)`
`JpaExpression<Long>`	`count(jakarta.persistence.criteria.Expression<?> argument)`
`JpaExpression<Long>`	`countDistinct(jakarta.persistence.criteria.Expression<?> x)`
`<T> JpaCriteriaDelete<T>`	`createCriteriaDelete(Class<T> targetEntity)`
`<T> JpaCriteriaInsertSelect<T>`	`createCriteriaInsertSelect(Class<T> targetEntity)`
`<T> JpaCriteriaUpdate<T>`	`createCriteriaUpdate(Class<T> targetEntity)`
`JpaCriteriaQuery<Object>`	`createQuery()`
`<T> JpaCriteriaQuery<T>`	`createQuery(Class<T> resultClass)`
`JpaCriteriaQuery<jakarta.persistence.Tuple>`	`createTupleQuery()`
`JpaFunction<Date>`	`currentDate()`
`JpaFunction<Instant>`	`currentInstant()`
`JpaFunction<Time>`	`currentTime()`
`JpaFunction<Timestamp>`	`currentTimestamp()`
`JpaOrder`	`desc(jakarta.persistence.criteria.Expression<?> x)`
`JpaOrder`	`desc(jakarta.persistence.criteria.Expression<?> x, boolean nullsFirst)`	Create an ordering by the descending value of the expression.
`<N extends Number> JpaExpression<N>`	`diff(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`diff(jakarta.persistence.criteria.Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`diff(N x, jakarta.persistence.criteria.Expression<? extends N> y)`
`JpaPredicate`	`disjunction()`
`JpaPredicate`	`distinctFrom(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)`
`JpaPredicate`	`distinctFrom(jakarta.persistence.criteria.Expression<?> x, Object y)`
`JpaPredicate`	`equal(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)`
`JpaPredicate`	`equal(jakarta.persistence.criteria.Expression<?> x, Object y)`
`<T> JpaCriteriaQuery<T>`	`except(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`except(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`exceptAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`JpaPredicate`	`exists(jakarta.persistence.criteria.Subquery<?> subquery)`
`JpaExpression<Double>`	`exp(jakarta.persistence.criteria.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.
`<P,F> JpaExpression<F>`	`fk(jakarta.persistence.criteria.Path<P> path)`
`<N extends Number> JpaExpression<N>`	`floor(jakarta.persistence.criteria.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> JpaFunction<T>`	`function(String name, Class<T> type, jakarta.persistence.criteria.Expression<?>[] args)`
`JpaPredicate`	`ge(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`JpaPredicate`	`ge(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)`
`<X extends Comparable<? super X>> JpaExpression<X>`	`greatest(jakarta.persistence.criteria.Expression<X> argument)`
`JpaPredicate`	`gt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`JpaPredicate`	`gt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, String pattern)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`ilike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`<T> JpaInPredicate<T>`	`in(jakarta.persistence.criteria.Expression<? extends T> expression)`
`<T> JpaInPredicate<T>`	`in(jakarta.persistence.criteria.Expression<? extends T> expression, jakarta.persistence.criteria.Expression<? extends T>... values)`
`<T> JpaInPredicate<T>`	`in(jakarta.persistence.criteria.Expression<? extends T> expression, Collection<T> values)`
`<T> JpaInPredicate<T>`	`in(jakarta.persistence.criteria.Expression<? extends T> expression, T... values)`
`<K,L extends List<?>> JpaExpression<Set<K>>`	`indexes(L list)`
`<T> JpaCriteriaQuery<T>`	`intersect(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`intersect(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`intersectAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`<C extends Collection<?>> JpaPredicate`	`isEmpty(jakarta.persistence.criteria.Expression<C> collection)`
`JpaPredicate`	`isFalse(jakarta.persistence.criteria.Expression<Boolean> x)`
`<M extends Map<?,?>> JpaPredicate`	`isMapEmpty(JpaExpression<M> mapExpression)`	Create a predicate that tests whether a Map is empty.
`<M extends Map<?,?>> JpaPredicate`	`isMapNotEmpty(JpaExpression<M> mapExpression)`	Create a predicate that tests whether a Map is not empty.
`<E,C extends Collection<E>> JpaPredicate`	`isMember(E elem, jakarta.persistence.criteria.Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isMember(jakarta.persistence.criteria.Expression<E> elem, jakarta.persistence.criteria.Expression<C> collection)`
`<C extends Collection<?>> JpaPredicate`	`isNotEmpty(jakarta.persistence.criteria.Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isNotMember(E elem, jakarta.persistence.criteria.Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isNotMember(jakarta.persistence.criteria.Expression<E> elem, jakarta.persistence.criteria.Expression<C> collection)`
`JpaPredicate`	`isNotNull(jakarta.persistence.criteria.Expression<?> x)`
`JpaPredicate`	`isNull(jakarta.persistence.criteria.Expression<?> x)`
`JpaPredicate`	`isTrue(jakarta.persistence.criteria.Expression<Boolean> x)`
`<K,M extends Map<K,?>> JpaExpression<Set<K>>`	`keys(M map)`
`JpaPredicate`	`le(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`JpaPredicate`	`le(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)`
`<X extends Comparable<? super X>> JpaExpression<X>`	`least(jakarta.persistence.criteria.Expression<X> argument)`
`JpaFunction<Integer>`	`length(jakarta.persistence.criteria.Expression<String> x)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, String pattern)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`like(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`<T> JpaExpression<T>`	`literal(T value)`
`<T> SqmExpression<T>`	`literal(T value, SqmExpression<? extends T> typeInferenceSource)`
`<T> List<? extends JpaExpression<T>>`	`literals(List<T> values)`
`<T> List<? extends JpaExpression<T>>`	`literals(T[] values)`
`JpaExpression<Double>`	`ln(jakarta.persistence.criteria.Expression<? extends Number> x)`	Create an expression that returns the natural logarithm of its argument.
`JpaExpression<LocalDate>`	`localDate()`	Create expression to return current local date.
`JpaExpression<LocalDateTime>`	`localDateTime()`	Create expression to return current local datetime.
`JpaExpression<LocalTime>`	`localTime()`	Create expression to return current local time.
`JpaFunction<Integer>`	`locate(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)`
`JpaFunction<Integer>`	`locate(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Integer> from)`
`JpaFunction<Integer>`	`locate(jakarta.persistence.criteria.Expression<String> x, String pattern)`
`JpaFunction<Integer>`	`locate(jakarta.persistence.criteria.Expression<String> x, String pattern, int from)`
`JpaFunction<String>`	`lower(jakarta.persistence.criteria.Expression<String> x)`
`JpaPredicate`	`lt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`JpaPredicate`	`lt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)`
`<M extends Map<?,?>> JpaExpression<Integer>`	`mapSize(M map)`	Create an expression that tests the size of a map.
`<M extends Map<?,?>> JpaExpression<Integer>`	`mapSize(JpaExpression<M> mapExpression)`	Create an expression that tests the size of a map.
`<N extends Number> JpaExpression<N>`	`max(jakarta.persistence.criteria.Expression<N> argument)`
`<N extends Number> JpaExpression<N>`	`min(jakarta.persistence.criteria.Expression<N> argument)`
`JpaExpression<Integer>`	`mod(jakarta.persistence.criteria.Expression<Integer> x, jakarta.persistence.criteria.Expression<Integer> y)`
`JpaExpression<Integer>`	`mod(jakarta.persistence.criteria.Expression<Integer> x, Integer y)`
`JpaExpression<Integer>`	`mod(Integer x, jakarta.persistence.criteria.Expression<Integer> y)`
`<N extends Number> JpaExpression<N>`	`neg(jakarta.persistence.criteria.Expression<N> x)`
`JpaPredicate`	`not(jakarta.persistence.criteria.Expression<Boolean> restriction)`
`JpaPredicate`	`notDistinctFrom(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)`
`JpaPredicate`	`notDistinctFrom(jakarta.persistence.criteria.Expression<?> x, Object y)`
`JpaPredicate`	`notEqual(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)`
`JpaPredicate`	`notEqual(jakarta.persistence.criteria.Expression<?> x, Object y)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, String pattern)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)`
`<Y> JpaExpression<Y>`	`nullif(jakarta.persistence.criteria.Expression<Y> x, jakarta.persistence.criteria.Expression<?> y)`
`<Y> JpaExpression<Y>`	`nullif(jakarta.persistence.criteria.Expression<Y> x, Y y)`
`<T> JpaExpression<T>`	`nullLiteral(Class<T> resultClass)`
`JpaPredicate`	`or(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)`
`JpaPredicate`	`or(jakarta.persistence.criteria.Predicate... restrictions)`
`<T> JpaParameterExpression<T>`	`parameter(Class<T> paramClass)`
`<T> JpaParameterExpression<T>`	`parameter(Class<T> paramClass, String name)`
`JpaExpression<Double>`	`power(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`	Create an expression that returns the first argument raised to the power of its second argument.
`JpaExpression<Double>`	`power(jakarta.persistence.criteria.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> JpaExpression<N>`	`prod(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`prod(jakarta.persistence.criteria.Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`prod(N x, jakarta.persistence.criteria.Expression<? extends N> y)`
`JpaExpression<Number>`	`quot(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`JpaExpression<Number>`	`quot(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)`
`JpaExpression<Number>`	`quot(Number x, jakarta.persistence.criteria.Expression<? extends Number> y)`
`<T extends Number> JpaExpression<T>`	`round(jakarta.persistence.criteria.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.
`<R> JpaSearchedCase<R>`	`selectCase()`
`<C,R> JpaSimpleCase<C,R>`	`selectCase(jakarta.persistence.criteria.Expression<? extends C> expression)`
`JpaExpression<Integer>`	`sign(jakarta.persistence.criteria.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, or `0` if its argument is exactly zero.
`<C extends Collection<?>> JpaExpression<Integer>`	`size(C collection)`
`<C extends Collection<?>> JpaExpression<Integer>`	`size(jakarta.persistence.criteria.Expression<C> collection)`
`<Y> JpaExpression<Y>`	`some(jakarta.persistence.criteria.Subquery<Y> subquery)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`JpaExpression<Double>`	`sqrt(jakarta.persistence.criteria.Expression<? extends Number> x)`
`JpaFunction<String>`	`substring(jakarta.persistence.criteria.Expression<String> x, int from)`
`JpaFunction<String>`	`substring(jakarta.persistence.criteria.Expression<String> x, int from, int len)`
`JpaFunction<String>`	`substring(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> from)`
`JpaFunction<String>`	`substring(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> from, jakarta.persistence.criteria.Expression<Integer> len)`
`<N extends Number> JpaExpression<N>`	`sum(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`sum(jakarta.persistence.criteria.Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`sum(jakarta.persistence.criteria.Expression<N> argument)`
`<N extends Number> JpaExpression<N>`	`sum(N x, jakarta.persistence.criteria.Expression<? extends N> y)`
`JpaExpression<Double>`	`sumAsDouble(jakarta.persistence.criteria.Expression<Float> argument)`
`JpaExpression<Long>`	`sumAsLong(jakarta.persistence.criteria.Expression<Integer> argument)`
`JpaExpression<BigDecimal>`	`toBigDecimal(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<BigInteger>`	`toBigInteger(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<Double>`	`toDouble(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<Float>`	`toFloat(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<Integer>`	`toInteger(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<Long>`	`toLong(jakarta.persistence.criteria.Expression<? extends Number> number)`
`JpaExpression<String>`	`toString(jakarta.persistence.criteria.Expression<Character> character)`
`<X,T,E extends T> JpaCollectionJoin<X,E>`	`treat(jakarta.persistence.criteria.CollectionJoin<X,T> join, Class<E> type)`
`<X,T,V extends T> JpaJoin<X,V>`	`treat(jakarta.persistence.criteria.Join<X,T> join, Class<V> type)`
`<X,T,E extends T> JpaListJoin<X,E>`	`treat(jakarta.persistence.criteria.ListJoin<X,T> join, Class<E> type)`
`<X,K,T,V extends T> JpaMapJoin<X,K,V>`	`treat(jakarta.persistence.criteria.MapJoin<X,K,T> join, Class<V> type)`
`<X,T extends X> JpaPath<T>`	`treat(jakarta.persistence.criteria.Path<X> path, Class<T> type)`
`<X,T extends X> JpaRoot<T>`	`treat(jakarta.persistence.criteria.Root<X> root, Class<T> type)`
`<X,T,E extends T> JpaSetJoin<X,E>`	`treat(jakarta.persistence.criteria.SetJoin<X,T> join, Class<E> type)`
`JpaFunction<String>`	`trim(char t, jakarta.persistence.criteria.Expression<String> x)`
`JpaFunction<String>`	`trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, char t, jakarta.persistence.criteria.Expression<String> x)`
`JpaFunction<String>`	`trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<Character> t, jakarta.persistence.criteria.Expression<String> x)`
`JpaFunction<String>`	`trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x)`
`JpaFunction<String>`	`trim(jakarta.persistence.criteria.Expression<Character> t, jakarta.persistence.criteria.Expression<String> x)`
`JpaFunction<String>`	`trim(jakarta.persistence.criteria.Expression<String> x)`
`JpaCompoundSelection<jakarta.persistence.Tuple>`	`tuple(jakarta.persistence.criteria.Selection<?>[] selections)`
`JpaCompoundSelection<jakarta.persistence.Tuple>`	`tuple(List<? extends JpaSelection<?>> selections)`
`<T> JpaCriteriaQuery<T>`	`union(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`union(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`default <T> JpaCriteriaQuery<T>`	`unionAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)`
`JpaFunction<String>`	`upper(jakarta.persistence.criteria.Expression<String> x)`
`<T> SqmExpression<T>`	`value(T value)`
`<T> SqmExpression<T>`	`value(T value, SqmExpression<? extends T> typeInferenceSource)`
`<V,C extends Collection<V>> JpaExpression<Collection<V>>`	`values(C collection)`
`<V,M extends Map<?,V>> jakarta.persistence.criteria.Expression<Collection<V>>`	`values(M map)`
`JpaPredicate`	`wrap(jakarta.persistence.criteria.Expression<Boolean> expression)`
`JpaPredicate`	`wrap(jakarta.persistence.criteria.Expression<Boolean>... expressions)`

Method Detail

cast

<X,T> JpaExpression<X> cast(JpaExpression<T> expression,
                                  Class<X> castTargetJavaType)

wrap

JpaPredicate wrap(jakarta.persistence.criteria.Expression<Boolean> expression)

wrap

JpaPredicate wrap(jakarta.persistence.criteria.Expression<Boolean>... expressions)

createQuery
```
JpaCriteriaQuery<Object> createQuery()
```
Specified by:

createQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createQuery
```
<T> JpaCriteriaQuery<T> createQuery(Class<T> resultClass)
```
Specified by:

createQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createTupleQuery
```
JpaCriteriaQuery<jakarta.persistence.Tuple> createTupleQuery()
```
Specified by:

createTupleQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaUpdate
```
<T> JpaCriteriaUpdate<T> createCriteriaUpdate(Class<T> targetEntity)
```
Specified by:

createCriteriaUpdate in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaDelete
```
<T> JpaCriteriaDelete<T> createCriteriaDelete(Class<T> targetEntity)
```
Specified by:

createCriteriaDelete in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaInsertSelect

<T> JpaCriteriaInsertSelect<T> createCriteriaInsertSelect(Class<T> targetEntity)

unionAll

default <T> JpaCriteriaQuery<T> unionAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                         jakarta.persistence.criteria.CriteriaQuery<?>... queries)

union

default <T> JpaCriteriaQuery<T> union(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                      jakarta.persistence.criteria.CriteriaQuery<?>... queries)

union

<T> JpaCriteriaQuery<T> union(boolean all,
                              jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                              jakarta.persistence.criteria.CriteriaQuery<?>... queries)

intersectAll

default <T> JpaCriteriaQuery<T> intersectAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                             jakarta.persistence.criteria.CriteriaQuery<?>... queries)

intersect

default <T> JpaCriteriaQuery<T> intersect(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                          jakarta.persistence.criteria.CriteriaQuery<?>... queries)

intersect

<T> JpaCriteriaQuery<T> intersect(boolean all,
                                  jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                  jakarta.persistence.criteria.CriteriaQuery<?>... queries)

exceptAll

default <T> JpaCriteriaQuery<T> exceptAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                          jakarta.persistence.criteria.CriteriaQuery<?>... queries)

except

default <T> JpaCriteriaQuery<T> except(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                       jakarta.persistence.criteria.CriteriaQuery<?>... queries)

except

<T> JpaCriteriaQuery<T> except(boolean all,
                               jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                               jakarta.persistence.criteria.CriteriaQuery<?>... queries)

sign
```
JpaExpression<Integer> sign(jakarta.persistence.criteria.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, or 0 if its argument is exactly zero.

Parameters:

x - expression

Returns:

sign

ceiling
```
<N extends Number> JpaExpression<N> ceiling(jakarta.persistence.criteria.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.

Parameters:

x - expression

Returns:

ceiling

floor
```
<N extends Number> JpaExpression<N> floor(jakarta.persistence.criteria.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.

Parameters:

x - expression

Returns:

floor

exp
```
JpaExpression<Double> exp(jakarta.persistence.criteria.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.

Parameters:

x - expression

Returns:

exponential

ln
```
JpaExpression<Double> ln(jakarta.persistence.criteria.Expression<? extends Number> x)
```
Create an expression that returns the natural logarithm of its argument.

Parameters:

x - expression

Returns:

natural logarithm

power

JpaExpression<Double> power(jakarta.persistence.criteria.Expression<? extends Number> x,
                            jakarta.persistence.criteria.Expression<? extends Number> y)

Create an expression that returns the first argument raised to the power of its second argument.

Parameters:: x - base; y - exponent
Returns:: the base raised to the power of the exponent

power
```
JpaExpression<Double> power(jakarta.persistence.criteria.Expression<? extends Number> x,
                            Number y)
```
Create an expression that returns the first argument raised to the power of its second argument.

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

round
```
<T extends Number> JpaExpression<T> round(jakarta.persistence.criteria.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.

Parameters:

x - base

n - number of decimal places

Returns:

the rounded value

localDate
```
JpaExpression<LocalDate> localDate()
```
Create expression to return current local date.

Returns:

expression for current date

localDateTime
```
JpaExpression<LocalDateTime> localDateTime()
```
Create expression to return current local datetime.

Returns:

expression for current timestamp

localTime
```
JpaExpression<LocalTime> localTime()
```
Create expression to return current local time.

Returns:

expression for current time

fk

<P,F> JpaExpression<F> fk(jakarta.persistence.criteria.Path<P> path)

treat

<X,T extends X> JpaPath<T> treat(jakarta.persistence.criteria.Path<X> path,
                                       Class<T> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,T extends X> JpaRoot<T> treat(jakarta.persistence.criteria.Root<X> root,
                                       Class<T> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,T,V extends T> JpaJoin<X,V> treat(jakarta.persistence.criteria.Join<X,T> join,
                                                       Class<V> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,T,E extends T> JpaCollectionJoin<X,E> treat(jakarta.persistence.criteria.CollectionJoin<X,T> join,
                                                                 Class<E> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,T,E extends T> JpaSetJoin<X,E> treat(jakarta.persistence.criteria.SetJoin<X,T> join,
                                                          Class<E> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,T,E extends T> JpaListJoin<X,E> treat(jakarta.persistence.criteria.ListJoin<X,T> join,
                                                           Class<E> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

<X,K,T,V extends T> JpaMapJoin<X,K,V> treat(jakarta.persistence.criteria.MapJoin<X,K,T> join,
                                                                          Class<V> type)

Specified by:: treat in interface jakarta.persistence.criteria.CriteriaBuilder

construct

<Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
                                      jakarta.persistence.criteria.Selection<?>[] selections)

Specified by:: construct in interface jakarta.persistence.criteria.CriteriaBuilder

construct

<Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
                                      List<? extends JpaSelection<?>> arguments)

tuple

JpaCompoundSelection<jakarta.persistence.Tuple> tuple(jakarta.persistence.criteria.Selection<?>[] selections)

Specified by:: tuple in interface jakarta.persistence.criteria.CriteriaBuilder

tuple

JpaCompoundSelection<jakarta.persistence.Tuple> tuple(List<? extends JpaSelection<?>> selections)

array

JpaCompoundSelection<Object[]> array(jakarta.persistence.criteria.Selection<?>[] selections)

Specified by:: array in interface jakarta.persistence.criteria.CriteriaBuilder

array

JpaCompoundSelection<Object[]> array(List<? extends JpaSelection<?>> selections)

array

<Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
                                  jakarta.persistence.criteria.Selection<?>[] selections)

array

<Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
                                  List<? extends JpaSelection<?>> selections)

avg

<N extends Number> JpaExpression<Double> avg(jakarta.persistence.criteria.Expression<N> argument)

Specified by:: avg in interface jakarta.persistence.criteria.CriteriaBuilder

sum

<N extends Number> JpaExpression<N> sum(jakarta.persistence.criteria.Expression<N> argument)

Specified by:: sum in interface jakarta.persistence.criteria.CriteriaBuilder

sumAsLong

JpaExpression<Long> sumAsLong(jakarta.persistence.criteria.Expression<Integer> argument)

Specified by:: sumAsLong in interface jakarta.persistence.criteria.CriteriaBuilder

sumAsDouble

JpaExpression<Double> sumAsDouble(jakarta.persistence.criteria.Expression<Float> argument)

Specified by:: sumAsDouble in interface jakarta.persistence.criteria.CriteriaBuilder

max

<N extends Number> JpaExpression<N> max(jakarta.persistence.criteria.Expression<N> argument)

Specified by:: max in interface jakarta.persistence.criteria.CriteriaBuilder

min

<N extends Number> JpaExpression<N> min(jakarta.persistence.criteria.Expression<N> argument)

Specified by:: min in interface jakarta.persistence.criteria.CriteriaBuilder

greatest

<X extends Comparable<? super X>> JpaExpression<X> greatest(jakarta.persistence.criteria.Expression<X> argument)

Specified by:: greatest in interface jakarta.persistence.criteria.CriteriaBuilder

least

<X extends Comparable<? super X>> JpaExpression<X> least(jakarta.persistence.criteria.Expression<X> argument)

Specified by:: least in interface jakarta.persistence.criteria.CriteriaBuilder

count

JpaExpression<Long> count(jakarta.persistence.criteria.Expression<?> argument)

Specified by:: count in interface jakarta.persistence.criteria.CriteriaBuilder

countDistinct
```
JpaExpression<Long> countDistinct(jakarta.persistence.criteria.Expression<?> x)
```
Specified by:

countDistinct in interface jakarta.persistence.criteria.CriteriaBuilder

neg

<N extends Number> JpaExpression<N> neg(jakarta.persistence.criteria.Expression<N> x)

Specified by:: neg in interface jakarta.persistence.criteria.CriteriaBuilder

abs

<N extends Number> JpaExpression<N> abs(jakarta.persistence.criteria.Expression<N> x)

Specified by:: abs in interface jakarta.persistence.criteria.CriteriaBuilder

sum

<N extends Number> JpaExpression<N> sum(jakarta.persistence.criteria.Expression<? extends N> x,
                                        jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: sum in interface jakarta.persistence.criteria.CriteriaBuilder

sum

<N extends Number> JpaExpression<N> sum(jakarta.persistence.criteria.Expression<? extends N> x,
                                        N y)

Specified by:: sum in interface jakarta.persistence.criteria.CriteriaBuilder

sum

<N extends Number> JpaExpression<N> sum(N x,
                                        jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: sum in interface jakarta.persistence.criteria.CriteriaBuilder

prod

<N extends Number> JpaExpression<N> prod(jakarta.persistence.criteria.Expression<? extends N> x,
                                         jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: prod in interface jakarta.persistence.criteria.CriteriaBuilder

prod

<N extends Number> JpaExpression<N> prod(jakarta.persistence.criteria.Expression<? extends N> x,
                                         N y)

Specified by:: prod in interface jakarta.persistence.criteria.CriteriaBuilder

prod

<N extends Number> JpaExpression<N> prod(N x,
                                         jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: prod in interface jakarta.persistence.criteria.CriteriaBuilder

diff

<N extends Number> JpaExpression<N> diff(jakarta.persistence.criteria.Expression<? extends N> x,
                                         jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: diff in interface jakarta.persistence.criteria.CriteriaBuilder

diff

<N extends Number> JpaExpression<N> diff(jakarta.persistence.criteria.Expression<? extends N> x,
                                         N y)

Specified by:: diff in interface jakarta.persistence.criteria.CriteriaBuilder

diff

<N extends Number> JpaExpression<N> diff(N x,
                                         jakarta.persistence.criteria.Expression<? extends N> y)

Specified by:: diff in interface jakarta.persistence.criteria.CriteriaBuilder

quot

JpaExpression<Number> quot(jakarta.persistence.criteria.Expression<? extends Number> x,
                           jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: quot in interface jakarta.persistence.criteria.CriteriaBuilder

quot

JpaExpression<Number> quot(jakarta.persistence.criteria.Expression<? extends Number> x,
                           Number y)

Specified by:: quot in interface jakarta.persistence.criteria.CriteriaBuilder

quot

JpaExpression<Number> quot(Number x,
                           jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: quot in interface jakarta.persistence.criteria.CriteriaBuilder

mod

JpaExpression<Integer> mod(jakarta.persistence.criteria.Expression<Integer> x,
                           jakarta.persistence.criteria.Expression<Integer> y)

Specified by:: mod in interface jakarta.persistence.criteria.CriteriaBuilder

mod

JpaExpression<Integer> mod(jakarta.persistence.criteria.Expression<Integer> x,
                           Integer y)

Specified by:: mod in interface jakarta.persistence.criteria.CriteriaBuilder

mod

JpaExpression<Integer> mod(Integer x,
                           jakarta.persistence.criteria.Expression<Integer> y)

Specified by:: mod in interface jakarta.persistence.criteria.CriteriaBuilder

sqrt

JpaExpression<Double> sqrt(jakarta.persistence.criteria.Expression<? extends Number> x)

Specified by:: sqrt in interface jakarta.persistence.criteria.CriteriaBuilder

toLong

JpaExpression<Long> toLong(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toLong in interface jakarta.persistence.criteria.CriteriaBuilder

toInteger

JpaExpression<Integer> toInteger(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toInteger in interface jakarta.persistence.criteria.CriteriaBuilder

toFloat

JpaExpression<Float> toFloat(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toFloat in interface jakarta.persistence.criteria.CriteriaBuilder

toDouble

JpaExpression<Double> toDouble(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toDouble in interface jakarta.persistence.criteria.CriteriaBuilder

toBigDecimal

JpaExpression<BigDecimal> toBigDecimal(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toBigDecimal in interface jakarta.persistence.criteria.CriteriaBuilder

toBigInteger

JpaExpression<BigInteger> toBigInteger(jakarta.persistence.criteria.Expression<? extends Number> number)

Specified by:: toBigInteger in interface jakarta.persistence.criteria.CriteriaBuilder

toString

JpaExpression<String> toString(jakarta.persistence.criteria.Expression<Character> character)

Specified by:: toString in interface jakarta.persistence.criteria.CriteriaBuilder

literal
```
<T> JpaExpression<T> literal(T value)
```
Specified by:

literal in interface jakarta.persistence.criteria.CriteriaBuilder

literal

<T> SqmExpression<T> literal(T value,
                             SqmExpression<? extends T> typeInferenceSource)

literals

<T> List<? extends JpaExpression<T>> literals(T[] values)

literals

<T> List<? extends JpaExpression<T>> literals(List<T> values)

nullLiteral
```
<T> JpaExpression<T> nullLiteral(Class<T> resultClass)
```
Specified by:

nullLiteral in interface jakarta.persistence.criteria.CriteriaBuilder

parameter
```
<T> JpaParameterExpression<T> parameter(Class<T> paramClass)
```
Specified by:

parameter in interface jakarta.persistence.criteria.CriteriaBuilder

parameter

<T> JpaParameterExpression<T> parameter(Class<T> paramClass,
                                        String name)

Specified by:: parameter in interface jakarta.persistence.criteria.CriteriaBuilder

concat

JpaExpression<String> concat(jakarta.persistence.criteria.Expression<String> x,
                             jakarta.persistence.criteria.Expression<String> y)

Specified by:: concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

JpaExpression<String> concat(jakarta.persistence.criteria.Expression<String> x,
                             String y)

Specified by:: concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

JpaExpression<String> concat(String x,
                             jakarta.persistence.criteria.Expression<String> y)

Specified by:: concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

JpaExpression<String> concat(String x,
                             String y)

substring

JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x,
                              jakarta.persistence.criteria.Expression<Integer> from)

Specified by:: substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x,
                              int from)

Specified by:: substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x,
                              jakarta.persistence.criteria.Expression<Integer> from,
                              jakarta.persistence.criteria.Expression<Integer> len)

Specified by:: substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x,
                              int from,
                              int len)

Specified by:: substring in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                         jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(jakarta.persistence.criteria.Expression<Character> t,
                         jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                         jakarta.persistence.criteria.Expression<Character> t,
                         jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(char t,
                         jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

JpaFunction<String> trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                         char t,
                         jakarta.persistence.criteria.Expression<String> x)

Specified by:: trim in interface jakarta.persistence.criteria.CriteriaBuilder

lower

JpaFunction<String> lower(jakarta.persistence.criteria.Expression<String> x)

Specified by:: lower in interface jakarta.persistence.criteria.CriteriaBuilder

upper

JpaFunction<String> upper(jakarta.persistence.criteria.Expression<String> x)

Specified by:: upper in interface jakarta.persistence.criteria.CriteriaBuilder

length

JpaFunction<Integer> length(jakarta.persistence.criteria.Expression<String> x)

Specified by:: length in interface jakarta.persistence.criteria.CriteriaBuilder

locate

JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x,
                            jakarta.persistence.criteria.Expression<String> pattern)

Specified by:: locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x,
                            String pattern)

Specified by:: locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x,
                            jakarta.persistence.criteria.Expression<String> pattern,
                            jakarta.persistence.criteria.Expression<Integer> from)

Specified by:: locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x,
                            String pattern,
                            int from)

Specified by:: locate in interface jakarta.persistence.criteria.CriteriaBuilder

currentDate
```
JpaFunction<Date> currentDate()
```
Specified by:

currentDate in interface jakarta.persistence.criteria.CriteriaBuilder

currentTime
```
JpaFunction<Time> currentTime()
```
Specified by:

currentTime in interface jakarta.persistence.criteria.CriteriaBuilder

currentTimestamp
```
JpaFunction<Timestamp> currentTimestamp()
```
Specified by:

currentTimestamp in interface jakarta.persistence.criteria.CriteriaBuilder

currentInstant
```
JpaFunction<Instant> currentInstant()
```

function

<T> JpaFunction<T> function(String name,
                            Class<T> type,
                            jakarta.persistence.criteria.Expression<?>[] args)

Specified by:: function in interface jakarta.persistence.criteria.CriteriaBuilder

all

<Y> JpaExpression<Y> all(jakarta.persistence.criteria.Subquery<Y> subquery)

Specified by:: all in interface jakarta.persistence.criteria.CriteriaBuilder

some

<Y> JpaExpression<Y> some(jakarta.persistence.criteria.Subquery<Y> subquery)

Specified by:: some in interface jakarta.persistence.criteria.CriteriaBuilder

any

<Y> JpaExpression<Y> any(jakarta.persistence.criteria.Subquery<Y> subquery)

Specified by:: any in interface jakarta.persistence.criteria.CriteriaBuilder

keys
```
<K,M extends Map<K,?>> JpaExpression<Set<K>> keys(M map)
```
Specified by:

keys in interface jakarta.persistence.criteria.CriteriaBuilder

indexes

<K,L extends List<?>> JpaExpression<Set<K>> indexes(L list)

value

<T> SqmExpression<T> value(T value)

value

<T> SqmExpression<T> value(T value,
                           SqmExpression<? extends T> typeInferenceSource)

values

<V,C extends Collection<V>> JpaExpression<Collection<V>> values(C collection)

values

<V,M extends Map<?,V>> jakarta.persistence.criteria.Expression<Collection<V>> values(M map)

Specified by:: values in interface jakarta.persistence.criteria.CriteriaBuilder

size

<C extends Collection<?>> JpaExpression<Integer> size(jakarta.persistence.criteria.Expression<C> collection)

Specified by:: size in interface jakarta.persistence.criteria.CriteriaBuilder

size
```
<C extends Collection<?>> JpaExpression<Integer> size(C collection)
```
Specified by:

size in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce
```
<T> JpaCoalesce<T> coalesce()
```
Specified by:

coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce

<Y> JpaCoalesce<Y> coalesce(jakarta.persistence.criteria.Expression<? extends Y> x,
                            jakarta.persistence.criteria.Expression<? extends Y> y)

Specified by:: coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce

<Y> JpaCoalesce<Y> coalesce(jakarta.persistence.criteria.Expression<? extends Y> x,
                            Y y)

Specified by:: coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

nullif

<Y> JpaExpression<Y> nullif(jakarta.persistence.criteria.Expression<Y> x,
                            jakarta.persistence.criteria.Expression<?> y)

Specified by:: nullif in interface jakarta.persistence.criteria.CriteriaBuilder

nullif

<Y> JpaExpression<Y> nullif(jakarta.persistence.criteria.Expression<Y> x,
                            Y y)

Specified by:: nullif in interface jakarta.persistence.criteria.CriteriaBuilder

selectCase

<C,R> JpaSimpleCase<C,R> selectCase(jakarta.persistence.criteria.Expression<? extends C> expression)

Specified by:: selectCase in interface jakarta.persistence.criteria.CriteriaBuilder

selectCase
```
<R> JpaSearchedCase<R> selectCase()
```
Specified by:

selectCase in interface jakarta.persistence.criteria.CriteriaBuilder

and

JpaPredicate and(jakarta.persistence.criteria.Expression<Boolean> x,
                 jakarta.persistence.criteria.Expression<Boolean> y)

Specified by:: and in interface jakarta.persistence.criteria.CriteriaBuilder

and

JpaPredicate and(jakarta.persistence.criteria.Predicate... restrictions)

Specified by:: and in interface jakarta.persistence.criteria.CriteriaBuilder

or

JpaPredicate or(jakarta.persistence.criteria.Expression<Boolean> x,
                jakarta.persistence.criteria.Expression<Boolean> y)

Specified by:: or in interface jakarta.persistence.criteria.CriteriaBuilder

or

JpaPredicate or(jakarta.persistence.criteria.Predicate... restrictions)

Specified by:: or in interface jakarta.persistence.criteria.CriteriaBuilder

not

JpaPredicate not(jakarta.persistence.criteria.Expression<Boolean> restriction)

Specified by:: not in interface jakarta.persistence.criteria.CriteriaBuilder

conjunction
```
JpaPredicate conjunction()
```
Specified by:

conjunction in interface jakarta.persistence.criteria.CriteriaBuilder

disjunction
```
JpaPredicate disjunction()
```
Specified by:

disjunction in interface jakarta.persistence.criteria.CriteriaBuilder

isTrue
```
JpaPredicate isTrue(jakarta.persistence.criteria.Expression<Boolean> x)
```
Specified by:

isTrue in interface jakarta.persistence.criteria.CriteriaBuilder

isFalse
```
JpaPredicate isFalse(jakarta.persistence.criteria.Expression<Boolean> x)
```
Specified by:

isFalse in interface jakarta.persistence.criteria.CriteriaBuilder

isNull
```
JpaPredicate isNull(jakarta.persistence.criteria.Expression<?> x)
```
Specified by:

isNull in interface jakarta.persistence.criteria.CriteriaBuilder

isNotNull
```
JpaPredicate isNotNull(jakarta.persistence.criteria.Expression<?> x)
```
Specified by:

isNotNull in interface jakarta.persistence.criteria.CriteriaBuilder

equal

JpaPredicate equal(jakarta.persistence.criteria.Expression<?> x,
                   jakarta.persistence.criteria.Expression<?> y)

Specified by:: equal in interface jakarta.persistence.criteria.CriteriaBuilder

equal

JpaPredicate equal(jakarta.persistence.criteria.Expression<?> x,
                   Object y)

Specified by:: equal in interface jakarta.persistence.criteria.CriteriaBuilder

notEqual

JpaPredicate notEqual(jakarta.persistence.criteria.Expression<?> x,
                      jakarta.persistence.criteria.Expression<?> y)

Specified by:: notEqual in interface jakarta.persistence.criteria.CriteriaBuilder

notEqual

JpaPredicate notEqual(jakarta.persistence.criteria.Expression<?> x,
                      Object y)

Specified by:: notEqual in interface jakarta.persistence.criteria.CriteriaBuilder

distinctFrom

JpaPredicate distinctFrom(jakarta.persistence.criteria.Expression<?> x,
                          jakarta.persistence.criteria.Expression<?> y)

distinctFrom

JpaPredicate distinctFrom(jakarta.persistence.criteria.Expression<?> x,
                          Object y)

notDistinctFrom

JpaPredicate notDistinctFrom(jakarta.persistence.criteria.Expression<?> x,
                             jakarta.persistence.criteria.Expression<?> y)

notDistinctFrom

JpaPredicate notDistinctFrom(jakarta.persistence.criteria.Expression<?> x,
                             Object y)

greaterThan

<Y extends Comparable<? super Y>> JpaPredicate greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                           jakarta.persistence.criteria.Expression<? extends Y> y)

Specified by:: greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThan

<Y extends Comparable<? super Y>> JpaPredicate greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                           Y y)

Specified by:: greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThanOrEqualTo

<Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                    jakarta.persistence.criteria.Expression<? extends Y> y)

Specified by:: greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThanOrEqualTo

<Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                    Y y)

Specified by:: greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

lessThan

<Y extends Comparable<? super Y>> JpaPredicate lessThan(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                        jakarta.persistence.criteria.Expression<? extends Y> y)

Specified by:: lessThan in interface jakarta.persistence.criteria.CriteriaBuilder

lessThan

<Y extends Comparable<? super Y>> JpaPredicate lessThan(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                        Y y)

Specified by:: lessThan in interface jakarta.persistence.criteria.CriteriaBuilder

lessThanOrEqualTo

<Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                 jakarta.persistence.criteria.Expression<? extends Y> y)

Specified by:: lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

lessThanOrEqualTo

<Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                 Y y)

Specified by:: lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

between

<Y extends Comparable<? super Y>> JpaPredicate between(jakarta.persistence.criteria.Expression<? extends Y> value,
                                                       jakarta.persistence.criteria.Expression<? extends Y> lower,
                                                       jakarta.persistence.criteria.Expression<? extends Y> upper)

Specified by:: between in interface jakarta.persistence.criteria.CriteriaBuilder

between

<Y extends Comparable<? super Y>> JpaPredicate between(jakarta.persistence.criteria.Expression<? extends Y> value,
                                                       Y lower,
                                                       Y upper)

Specified by:: between in interface jakarta.persistence.criteria.CriteriaBuilder

gt

JpaPredicate gt(jakarta.persistence.criteria.Expression<? extends Number> x,
                jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: gt in interface jakarta.persistence.criteria.CriteriaBuilder

gt

JpaPredicate gt(jakarta.persistence.criteria.Expression<? extends Number> x,
                Number y)

Specified by:: gt in interface jakarta.persistence.criteria.CriteriaBuilder

ge

JpaPredicate ge(jakarta.persistence.criteria.Expression<? extends Number> x,
                jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: ge in interface jakarta.persistence.criteria.CriteriaBuilder

ge

JpaPredicate ge(jakarta.persistence.criteria.Expression<? extends Number> x,
                Number y)

Specified by:: ge in interface jakarta.persistence.criteria.CriteriaBuilder

lt

JpaPredicate lt(jakarta.persistence.criteria.Expression<? extends Number> x,
                jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: lt in interface jakarta.persistence.criteria.CriteriaBuilder

lt

JpaPredicate lt(jakarta.persistence.criteria.Expression<? extends Number> x,
                Number y)

Specified by:: lt in interface jakarta.persistence.criteria.CriteriaBuilder

le

JpaPredicate le(jakarta.persistence.criteria.Expression<? extends Number> x,
                jakarta.persistence.criteria.Expression<? extends Number> y)

Specified by:: le in interface jakarta.persistence.criteria.CriteriaBuilder

le

JpaPredicate le(jakarta.persistence.criteria.Expression<? extends Number> x,
                Number y)

Specified by:: le in interface jakarta.persistence.criteria.CriteriaBuilder

isEmpty

<C extends Collection<?>> JpaPredicate isEmpty(jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isEmpty in interface jakarta.persistence.criteria.CriteriaBuilder

isNotEmpty

<C extends Collection<?>> JpaPredicate isNotEmpty(jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isNotEmpty in interface jakarta.persistence.criteria.CriteriaBuilder

isMember

<E,C extends Collection<E>> JpaPredicate isMember(jakarta.persistence.criteria.Expression<E> elem,
                                                        jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isMember in interface jakarta.persistence.criteria.CriteriaBuilder

isMember

<E,C extends Collection<E>> JpaPredicate isMember(E elem,
                                                        jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isMember in interface jakarta.persistence.criteria.CriteriaBuilder

isNotMember

<E,C extends Collection<E>> JpaPredicate isNotMember(jakarta.persistence.criteria.Expression<E> elem,
                                                           jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder

isNotMember

<E,C extends Collection<E>> JpaPredicate isNotMember(E elem,
                                                           jakarta.persistence.criteria.Expression<C> collection)

Specified by:: isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  jakarta.persistence.criteria.Expression<String> pattern)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  String pattern)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  jakarta.persistence.criteria.Expression<String> pattern,
                  jakarta.persistence.criteria.Expression<Character> escapeChar)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  jakarta.persistence.criteria.Expression<String> pattern,
                  char escapeChar)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  String pattern,
                  jakarta.persistence.criteria.Expression<Character> escapeChar)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

like

JpaPredicate like(jakarta.persistence.criteria.Expression<String> x,
                  String pattern,
                  char escapeChar)

Specified by:: like in interface jakarta.persistence.criteria.CriteriaBuilder

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   jakarta.persistence.criteria.Expression<String> pattern)

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   String pattern)

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   jakarta.persistence.criteria.Expression<String> pattern,
                   jakarta.persistence.criteria.Expression<Character> escapeChar)

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   jakarta.persistence.criteria.Expression<String> pattern,
                   char escapeChar)

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   String pattern,
                   jakarta.persistence.criteria.Expression<Character> escapeChar)

ilike

JpaPredicate ilike(jakarta.persistence.criteria.Expression<String> x,
                   String pattern,
                   char escapeChar)

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     jakarta.persistence.criteria.Expression<String> pattern)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     String pattern)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     jakarta.persistence.criteria.Expression<String> pattern,
                     jakarta.persistence.criteria.Expression<Character> escapeChar)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     jakarta.persistence.criteria.Expression<String> pattern,
                     char escapeChar)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     String pattern,
                     jakarta.persistence.criteria.Expression<Character> escapeChar)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x,
                     String pattern,
                     char escapeChar)

Specified by:: notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      jakarta.persistence.criteria.Expression<String> pattern)

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      String pattern)

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      jakarta.persistence.criteria.Expression<String> pattern,
                      jakarta.persistence.criteria.Expression<Character> escapeChar)

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      jakarta.persistence.criteria.Expression<String> pattern,
                      char escapeChar)

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      String pattern,
                      jakarta.persistence.criteria.Expression<Character> escapeChar)

notIlike

JpaPredicate notIlike(jakarta.persistence.criteria.Expression<String> x,
                      String pattern,
                      char escapeChar)

in

<T> JpaInPredicate<T> in(jakarta.persistence.criteria.Expression<? extends T> expression)

Specified by:: in in interface jakarta.persistence.criteria.CriteriaBuilder

in

<T> JpaInPredicate<T> in(jakarta.persistence.criteria.Expression<? extends T> expression,
                         jakarta.persistence.criteria.Expression<? extends T>... values)

in

<T> JpaInPredicate<T> in(jakarta.persistence.criteria.Expression<? extends T> expression,
                         T... values)

in

<T> JpaInPredicate<T> in(jakarta.persistence.criteria.Expression<? extends T> expression,
                         Collection<T> values)

exists
```
JpaPredicate exists(jakarta.persistence.criteria.Subquery<?> subquery)
```
Specified by:

exists in interface jakarta.persistence.criteria.CriteriaBuilder

isMapEmpty
```
<M extends Map<?,?>> JpaPredicate isMapEmpty(JpaExpression<M> mapExpression)
```
Create a predicate that tests whether a Map is empty.
NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isEmpty(jakarta.persistence.criteria.Expression<C>)

Parameters:

mapExpression - The expression resolving to a Map which we want to check for emptiness

Returns:

is-empty predicate

isMapNotEmpty
```
<M extends Map<?,?>> JpaPredicate isMapNotEmpty(JpaExpression<M> mapExpression)
```
Create a predicate that tests whether a Map is not empty.
NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isNotEmpty(jakarta.persistence.criteria.Expression<C>)

Parameters:

mapExpression - The expression resolving to a Map which we want to check for non-emptiness

Returns:

is-not-empty predicate

mapSize
```
<M extends Map<?,?>> JpaExpression<Integer> mapSize(JpaExpression<M> mapExpression)
```
Create an expression that tests the size of a map.
NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.size(jakarta.persistence.criteria.Expression<C>)

Parameters:

mapExpression - The expression resolving to a Map for which we want to know the size

Returns:

size expression

mapSize
```
<M extends Map<?,?>> JpaExpression<Integer> mapSize(M map)
```
Create an expression that tests the size of a map.

Parameters:

map - The Map for which we want to know the size

Returns:

size expression

sort

JpaOrder sort(JpaExpression<?> sortExpression,
              SortOrder sortOrder,
              NullPrecedence nullPrecedence)

sort

JpaOrder sort(JpaExpression<?> sortExpression,
              SortOrder sortOrder)

sort

JpaOrder sort(JpaExpression<?> sortExpression)

asc
```
JpaOrder asc(jakarta.persistence.criteria.Expression<?> x)
```
Specified by:

asc in interface jakarta.persistence.criteria.CriteriaBuilder

desc
```
JpaOrder desc(jakarta.persistence.criteria.Expression<?> x)
```
Specified by:

desc in interface jakarta.persistence.criteria.CriteriaBuilder

asc
```
JpaOrder asc(jakarta.persistence.criteria.Expression<?> x,
             boolean nullsFirst)
```
Create an ordering by the ascending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc
```
JpaOrder desc(jakarta.persistence.criteria.Expression<?> x,
              boolean nullsFirst)
```
Create an ordering by the descending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

Interface HibernateCriteriaBuilder

Nested Class Summary

Nested classes/interfaces inherited from interface jakarta.persistence.criteria.CriteriaBuilder

Method Summary

Method Detail

cast

wrap

wrap

createQuery

createQuery

createTupleQuery

createCriteriaUpdate

createCriteriaDelete

createCriteriaInsertSelect

unionAll

union

union

intersectAll

intersect

intersect

exceptAll

except

except

sign

ceiling

floor

exp

ln

power

power

round

localDate

localDateTime

localTime

fk

treat

treat

treat

treat

treat

treat

treat

construct

construct

tuple

tuple

array

array

array

array

avg

sum

sumAsLong

sumAsDouble

max

min

greatest

least

count

countDistinct

neg

abs

sum

sum

sum

prod

prod

prod

diff

diff

diff

quot

quot

quot

mod

mod

mod

sqrt

toLong

toInteger