java.lang.Object
- org.hibernate.query.criteria.spi.HibernateCriteriaBuilderDelegate

All Implemented Interfaces:

CriteriaBuilder, HibernateCriteriaBuilder

Direct Known Subclasses:

SpatialCriteriaBuilderImpl
```
public class HibernateCriteriaBuilderDelegate
extends Object
implements HibernateCriteriaBuilder
```

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

Constructor Summary

Constructors
Constructor Description

HibernateCriteriaBuilderDelegate(HibernateCriteriaBuilder criteriaBuilder)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`<N extends Number> JpaExpression<N>`	`abs(Expression<N> x)`
`JpaExpression<Double>`	`acos(Expression<? extends Number> x)`	Create an expression that returns the inverse cosine of its argument.
`<Y> JpaExpression<Y>`	`all(Subquery<Y> subquery)`
`JpaPredicate`	`and(Expression<Boolean> x, Expression<Boolean> y)`
`JpaPredicate`	`and(Predicate... restrictions)`
`<Y> JpaExpression<Y>`	`any(Subquery<Y> subquery)`
`JpaCompoundSelection<Object[]>`	`array(Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)`
`JpaCompoundSelection<Object[]>`	`array(List<? extends JpaSelection<?>> selections)`
`JpaOrder`	`asc(Expression<?> x)`
`JpaOrder`	`asc(Expression<?> x, boolean nullsFirst)`	Create an ordering by the ascending value of the expression.
`JpaSearchOrder`	`asc(JpaCteCriteriaAttribute x)`	Create a search ordering by the ascending value of the CTE attribute.
`JpaSearchOrder`	`asc(JpaCteCriteriaAttribute x, boolean nullsFirst)`	Create a search ordering by the ascending value of the CTE attribute.
`JpaExpression<Double>`	`asin(Expression<? extends Number> x)`	Create an expression that returns the inverse sine of its argument.
`JpaExpression<Double>`	`atan(Expression<? extends Number> x)`	Create an expression that returns the inverse tangent of its argument.
`JpaExpression<Double>`	`atan2(Expression<? extends Number> y, Expression<? extends Number> x)`	Create an expression that returns the inverse tangent of `y` over `x`.
`JpaExpression<Double>`	`atan2(Expression<? extends Number> y, Number x)`
`JpaExpression<Double>`	`atan2(Number y, Expression<? extends Number> x)`
`<N extends Number> JpaExpression<Double>`	`avg(Expression<N> argument)`
`<N extends Number> JpaExpression<Double>`	`avg(Expression<N> argument, JpaPredicate filter)`
`<N extends Number> JpaExpression<Double>`	`avg(Expression<N> argument, JpaPredicate filter, JpaWindow window)`	Create an `avg` aggregate function expression.
`<N extends Number> JpaExpression<Double>`	`avg(Expression<N> argument, JpaWindow window)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`between(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(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(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y> JpaCoalesce<Y>`	`coalesce(Expression<? extends Y> x, Y y)`
`JpaFunction<String>`	`collate(Expression<String> x, String collation)`
`JpaExpression<String>`	`concat(Expression<String> x, Expression<String> y)`
`JpaExpression<String>`	`concat(Expression<String> x, String y)`
`JpaExpression<String>`	`concat(String x, Expression<String> y)`
`JpaExpression<String>`	`concat(String x, String y)`
`JpaPredicate`	`conjunction()`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, Selection<?>[] selections)`
`<Y> JpaCompoundSelection<Y>`	`construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)`
`JpaExpression<Double>`	`cos(Expression<? extends Number> x)`	Create an expression that returns the cosine of its argument.
`JpaExpression<Double>`	`cosh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic cosine of its argument.
`JpaExpression<Long>`	`count(Expression<?> argument)`
`JpaExpression<Long>`	`count(Expression<?> argument, JpaPredicate filter)`
`JpaExpression<Long>`	`count(Expression<?> argument, JpaPredicate filter, JpaWindow window)`	Create a `count` aggregate function expression.
`JpaExpression<Long>`	`count(Expression<?> argument, JpaWindow window)`
`JpaExpression<Long>`	`countDistinct(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<Tuple>`	`createTupleQuery()`
`JpaWindow`	`createWindow()`	Create an empty `JpaWindow` to use with window and aggregate functions.
`JpaExpression<Double>`	`cumeDist(JpaWindow window)`	Create a `cume_dist` window function expression.
`JpaFunction<Date>`	`currentDate()`
`JpaFunction<Instant>`	`currentInstant()`
`JpaFunction<Time>`	`currentTime()`
`JpaFunction<Timestamp>`	`currentTimestamp()`
`JpaFunction<Integer>`	`day(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.DAY` of a date, time, or datetime expression.
`JpaExpression<Double>`	`degrees(Expression<? extends Number> x)`	Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
`JpaExpression<Long>`	`denseRank(JpaWindow window)`	Create a `dense_rank` window function expression.
`JpaOrder`	`desc(Expression<?> x)`
`JpaOrder`	`desc(Expression<?> x, boolean nullsFirst)`	Create an ordering by the descending value of the expression.
`JpaSearchOrder`	`desc(JpaCteCriteriaAttribute x)`	Create a search ordering by the descending value of the CTE attribute.
`JpaSearchOrder`	`desc(JpaCteCriteriaAttribute x, boolean nullsFirst)`	Create a search ordering by the descending value of the CTE attribute.
`<N extends Number> JpaExpression<N>`	`diff(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`diff(Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`diff(N x, Expression<? extends N> y)`
`JpaPredicate`	`disjunction()`
`JpaPredicate`	`distinctFrom(Expression<?> x, Expression<?> y)`
`JpaPredicate`	`distinctFrom(Expression<?> x, Object y)`
`JpaPredicate`	`equal(Expression<?> x, Expression<?> y)`
`JpaPredicate`	`equal(Expression<?> x, Object y)`
`<T> JpaCriteriaQuery<T>`	`except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`except(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`except(Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`exceptAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`exceptAll(Subquery<? extends T> query1, Subquery<?>... queries)`
`JpaPredicate`	`exists(Subquery<?> subquery)`
`JpaExpression<Double>`	`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.
`<T> JpaExpression<T>`	`firstValue(Expression<T> argument, JpaWindow window)`	Create a `first_value` window function expression.
`<P,F> JpaExpression<F>`	`fk(Path<P> path)`
`<N extends Number> JpaExpression<N>`	`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.
`JpaFunction<String>`	`format(Expression<? extends TemporalAccessor> datetime, String pattern)`	Format a date, time, or datetime according to a pattern.
`JpaWindowFrame`	`frameBetweenFollowing(int offset)`
`JpaWindowFrame`	`frameBetweenFollowing(Expression<?> offset)`	Create a window frame of type `FrameKind.OFFSET_FOLLOWING` to use with `JpaWindow`s.
`JpaWindowFrame`	`frameBetweenPreceding(int offset)`
`JpaWindowFrame`	`frameBetweenPreceding(Expression<?> offset)`	Create window frame of type `FrameKind.OFFSET_PRECEDING` to use with `JpaWindow`s.
`JpaWindowFrame`	`frameCurrentRow()`	Create a window frame of type `FrameKind.CURRENT_ROW` to use with `JpaWindow`s.
`JpaWindowFrame`	`frameUnboundedFollowing()`	Create a window frame of type `FrameKind.UNBOUNDED_FOLLOWING` to use with `JpaWindow`s.
`JpaWindowFrame`	`frameUnboundedPreceding()`	Create a window frame of type `FrameKind.UNBOUNDED_PRECEDING` to use with `JpaWindow`s.
`<T> JpaFunction<T>`	`function(String name, Class<T> type, Expression<?>... args)`
`<T> JpaExpression<T>`	`functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)`
`<T> JpaExpression<T>`	`functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args)`	Create a generic aggregate function expression.
`<T> JpaExpression<T>`	`functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)`
`<T> JpaExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)`
`<T> JpaExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)`
`<T> JpaExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args)`	Create a generic ordered set-aggregate function expression.
`<T> JpaExpression<T>`	`functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)`
`JpaPredicate`	`ge(Expression<? extends Number> x, Expression<? extends Number> y)`
`JpaPredicate`	`ge(Expression<? extends Number> x, Number y)`
`protected HibernateCriteriaBuilder`	`getCriteriaBuilder()`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThan(Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Y y)`
`<X extends Comparable<? super X>> JpaExpression<X>`	`greatest(Expression<X> argument)`
`JpaPredicate`	`gt(Expression<? extends Number> x, Expression<? extends Number> y)`
`JpaPredicate`	`gt(Expression<? extends Number> x, Number y)`
`JpaFunction<Integer>`	`hour(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.HOUR` of a date, time, or datetime expression.
`JpaPredicate`	`ilike(Expression<String> x, Expression<String> pattern)`
`JpaPredicate`	`ilike(Expression<String> x, Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`ilike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`JpaPredicate`	`ilike(Expression<String> x, String pattern)`
`JpaPredicate`	`ilike(Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`ilike(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`<T> JpaInPredicate<T>`	`in(Expression<? extends T> expression)`
`<T> JpaInPredicate<T>`	`in(Expression<? extends T> expression, Expression<? extends T>... values)`
`<T> JpaInPredicate<T>`	`in(Expression<? extends T> expression, Collection<T> values)`
`<T> JpaInPredicate<T>`	`in(Expression<? extends T> expression, T... values)`
`<K,L extends List<?>> JpaExpression<Set<K>>`	`indexes(L list)`
`<T> JpaCriteriaQuery<T>`	`intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`intersect(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`intersect(Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`intersectAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`intersectAll(Subquery<? extends T> query1, Subquery<?>... queries)`
`<C extends Collection<?>> JpaPredicate`	`isEmpty(Expression<C> collection)`
`JpaPredicate`	`isFalse(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, Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isMember(Expression<E> elem, Expression<C> collection)`
`<C extends Collection<?>> JpaPredicate`	`isNotEmpty(Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isNotMember(E elem, Expression<C> collection)`
`<E,C extends Collection<E>> JpaPredicate`	`isNotMember(Expression<E> elem, Expression<C> collection)`
`JpaPredicate`	`isNotNull(Expression<?> x)`
`JpaPredicate`	`isNull(Expression<?> x)`
`JpaPredicate`	`isTrue(Expression<Boolean> x)`
`<K,M extends Map<K,?>> JpaExpression<Set<K>>`	`keys(M map)`
`<T> JpaExpression<T>`	`lastValue(Expression<T> argument, JpaWindow window)`	Create a `last_value` window function expression.
`JpaPredicate`	`le(Expression<? extends Number> x, Expression<? extends Number> y)`
`JpaPredicate`	`le(Expression<? extends Number> x, Number y)`
`<X extends Comparable<? super X>> JpaExpression<X>`	`least(Expression<X> argument)`
`JpaFunction<String>`	`left(Expression<String> x, int length)`
`JpaFunction<String>`	`left(Expression<String> x, Expression<Integer> length)`	Extract the `length` leftmost characters of a string.
`JpaFunction<Integer>`	`length(Expression<String> x)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThan(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThan(Expression<? extends Y> x, Y y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)`
`<Y extends Comparable<? super Y>> JpaPredicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Y y)`
`JpaPredicate`	`like(Expression<String> x, Expression<String> pattern)`
`JpaPredicate`	`like(Expression<String> x, Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`like(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`JpaPredicate`	`like(Expression<String> x, String pattern)`
`JpaPredicate`	`like(Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`like(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`JpaExpression<String>`	`listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, Expression<String> argument, String separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)`	Create a `listagg` ordered set-aggregate function expression.
`JpaExpression<String>`	`listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)`
`JpaExpression<String>`	`listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)`
`<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(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(Expression<String> x, Expression<String> pattern)`
`JpaFunction<Integer>`	`locate(Expression<String> x, Expression<String> pattern, Expression<Integer> from)`
`JpaFunction<Integer>`	`locate(Expression<String> x, String pattern)`
`JpaFunction<Integer>`	`locate(Expression<String> x, String pattern, int from)`
`JpaExpression<Double>`	`log(Expression<? extends Number> b, Expression<? extends Number> x)`	Create an expression that returns the logarithm of `x` to the base `b`.
`JpaExpression<Double>`	`log(Number b, Expression<? extends Number> x)`
`JpaExpression<Double>`	`log10(Expression<? extends Number> x)`	Create an expression that returns the base-10 logarithm of its argument.
`JpaFunction<String>`	`lower(Expression<String> x)`
`JpaPredicate`	`lt(Expression<? extends Number> x, Expression<? extends Number> y)`
`JpaPredicate`	`lt(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(Expression<N> argument)`
`<N extends Number> JpaExpression<N>`	`min(Expression<N> argument)`
`JpaFunction<Integer>`	`minute(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.MINUTE` of a date, time, or datetime expression.
`JpaExpression<Integer>`	`mod(Expression<Integer> x, Expression<Integer> y)`
`JpaExpression<Integer>`	`mod(Expression<Integer> x, Integer y)`
`JpaExpression<Integer>`	`mod(Integer x, Expression<Integer> y)`
`<T> JpaExpression<T>`	`mode(Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`mode(JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `mode` ordered set-aggregate function expression.
`<T> JpaExpression<T>`	`mode(JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`JpaFunction<Integer>`	`month(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.MONTH` of a date, time, or datetime expression.
`<N extends Number> JpaExpression<N>`	`neg(Expression<N> x)`
`JpaPredicate`	`not(Expression<Boolean> restriction)`
`JpaPredicate`	`notDistinctFrom(Expression<?> x, Expression<?> y)`
`JpaPredicate`	`notDistinctFrom(Expression<?> x, Object y)`
`JpaPredicate`	`notEqual(Expression<?> x, Expression<?> y)`
`JpaPredicate`	`notEqual(Expression<?> x, Object y)`
`JpaPredicate`	`notIlike(Expression<String> x, Expression<String> pattern)`
`JpaPredicate`	`notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`JpaPredicate`	`notIlike(Expression<String> x, String pattern)`
`JpaPredicate`	`notIlike(Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`JpaPredicate`	`notLike(Expression<String> x, Expression<String> pattern)`
`JpaPredicate`	`notLike(Expression<String> x, Expression<String> pattern, char escapeChar)`
`JpaPredicate`	`notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)`
`JpaPredicate`	`notLike(Expression<String> x, String pattern)`
`JpaPredicate`	`notLike(Expression<String> x, String pattern, char escapeChar)`
`JpaPredicate`	`notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)`
`<T> JpaExpression<T>`	`nthValue(Expression<T> argument, int n, JpaWindow window)`
`<T> JpaExpression<T>`	`nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)`	Create a `nth_value` window function expression.
`<Y> JpaExpression<Y>`	`nullif(Expression<Y> x, Expression<?> y)`
`<Y> JpaExpression<Y>`	`nullif(Expression<Y> x, Y y)`
`<T> JpaExpression<T>`	`nullLiteral(Class<T> resultClass)`
`JpaPredicate`	`or(Expression<Boolean> x, Expression<Boolean> y)`
`JpaPredicate`	`or(Predicate... restrictions)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start, int length)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, int start, Expression<Integer> length)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, int length)`
`JpaFunction<String>`	`overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, Expression<Integer> length)`	Overlay the `string` expression with the `replacement` expression, starting from index `start` and substituting a number of characters corresponding to the length of the `replacement` expression or the `length` parameter if specified.
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, int start)`
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, int start, int length)`
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, int start, Expression<Integer> length)`
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start)`
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start, int length)`
`JpaFunction<String>`	`overlay(Expression<String> string, String replacement, Expression<Integer> start, Expression<Integer> length)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, char padChar)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, Expression<Character> padChar)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, char padChar)`
`JpaFunction<String>`	`pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, Expression<Character> padChar)`	Pad the specified string expression with whitespace or with the `padChar` character if specified.
`JpaFunction<String>`	`pad(Expression<String> x, int length)`
`JpaFunction<String>`	`pad(Expression<String> x, int length, char padChar)`
`JpaFunction<String>`	`pad(Expression<String> x, int length, Expression<Character> padChar)`
`JpaFunction<String>`	`pad(Expression<String> x, Expression<Integer> length)`
`JpaFunction<String>`	`pad(Expression<String> x, Expression<Integer> length, char padChar)`
`JpaFunction<String>`	`pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)`
`<T> JpaParameterExpression<T>`	`parameter(Class<T> paramClass)`
`<T> JpaParameterExpression<T>`	`parameter(Class<T> paramClass, String name)`
`<T> JpaExpression<T>`	`percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `percentile_cont` ordered set-aggregate function expression.
`<T> JpaExpression<T>`	`percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a `percentile_disc` ordered set-aggregate function expression.
`<T> JpaExpression<T>`	`percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`JpaExpression<Double>`	`percentRank(JpaOrder order, Expression<?>... arguments)`
`JpaExpression<Double>`	`percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)`
`JpaExpression<Double>`	`percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)`	Create a `percent_rank` ordered set-aggregate function expression.
`JpaExpression<Double>`	`percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)`
`JpaExpression<Double>`	`percentRank(JpaWindow window)`	Create a `percent_rank` window function expression.
`JpaExpression<Double>`	`pi()`	Literal expression corresponding to the value of pi.
`JpaExpression<Double>`	`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.
`JpaExpression<Double>`	`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> JpaExpression<N>`	`prod(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`prod(Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`prod(N x, Expression<? extends N> y)`
`JpaExpression<Number>`	`quot(Expression<? extends Number> x, Expression<? extends Number> y)`
`JpaExpression<Number>`	`quot(Expression<? extends Number> x, Number y)`
`JpaExpression<Number>`	`quot(Number x, Expression<? extends Number> y)`
`JpaExpression<Double>`	`radians(Expression<? extends Number> x)`	Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
`JpaExpression<Long>`	`rank(JpaOrder order, Expression<?>... arguments)`
`JpaExpression<Long>`	`rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)`
`JpaExpression<Long>`	`rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)`	Create a `rank` ordered set-aggregate function expression.
`JpaExpression<Long>`	`rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)`
`JpaExpression<Long>`	`rank(JpaWindow window)`	Create a `rank` window function expression.
`JpaFunction<String>`	`replace(Expression<String> x, Expression<String> pattern, Expression<String> replacement)`	Replace all occurrences of `pattern` within the original string with `replacement`.
`JpaFunction<String>`	`replace(Expression<String> x, Expression<String> pattern, String replacement)`
`JpaFunction<String>`	`replace(Expression<String> x, String pattern, Expression<String> replacement)`
`JpaFunction<String>`	`replace(Expression<String> x, String pattern, String replacement)`
`JpaFunction<String>`	`right(Expression<String> x, int length)`
`JpaFunction<String>`	`right(Expression<String> x, Expression<Integer> length)`	Extract the `length` rightmost characters of a string.
`<T extends Number> JpaExpression<T>`	`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.
`JpaExpression<Long>`	`rowNumber(JpaWindow window)`	Create a `row_number` window function expression.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute cteAttribute)`	Create a search ordering based on the ascending value of the CTE attribute.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute cteAttribute, SortOrder sortOrder)`	Create a search ordering based on the sort order of the value of the CTE attribute.
`JpaSearchOrder`	`search(JpaCteCriteriaAttribute cteAttribute, SortOrder sortOrder, NullPrecedence nullPrecedence)`	Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
`JpaFunction<Float>`	`second(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.SECOND` of a date, time, or datetime expression.
`<R> JpaSearchedCase<R>`	`selectCase()`
`<C,R> JpaSimpleCase<C,R>`	`selectCase(Expression<? extends C> expression)`
`JpaExpression<Integer>`	`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, or `0` if its argument is exactly zero.
`JpaExpression<Double>`	`sin(Expression<? extends Number> x)`	Create an expression that returns the sine of its argument.
`JpaExpression<Double>`	`sinh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic sine of its argument.
`<C extends Collection<?>> JpaExpression<Integer>`	`size(C collection)`
`<C extends Collection<?>> JpaExpression<Integer>`	`size(Expression<C> collection)`
`<Y> JpaExpression<Y>`	`some(Subquery<Y> subquery)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder)`
`JpaOrder`	`sort(JpaExpression<?> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)`
`<T> JpaExpression<T>`	`sql(String pattern, Class<T> type, Expression<?>... arguments)`	Embed native `pattern` that will be unquoted and embedded in the generated SQL.
`JpaExpression<Double>`	`sqrt(Expression<? extends Number> x)`
`JpaFunction<String>`	`substring(Expression<String> x, int from)`
`JpaFunction<String>`	`substring(Expression<String> x, int from, int len)`
`JpaFunction<String>`	`substring(Expression<String> x, Expression<Integer> from)`
`JpaFunction<String>`	`substring(Expression<String> x, Expression<Integer> from, Expression<Integer> len)`
`<N extends Number> JpaExpression<N>`	`sum(Expression<? extends N> x, Expression<? extends N> y)`
`<N extends Number> JpaExpression<N>`	`sum(Expression<? extends N> x, N y)`
`<N extends Number> JpaExpression<N>`	`sum(Expression<N> argument)`
`<N extends Number> JpaExpression<Number>`	`sum(Expression<N> argument, JpaPredicate filter)`
`<N extends Number> JpaExpression<Number>`	`sum(Expression<N> argument, JpaPredicate filter, JpaWindow window)`	Create a `sum` aggregate function expression.
`<N extends Number> JpaExpression<Number>`	`sum(Expression<N> argument, JpaWindow window)`
`<N extends Number> JpaExpression<N>`	`sum(N x, Expression<? extends N> y)`
`JpaExpression<Double>`	`sumAsDouble(Expression<Float> argument)`
`JpaExpression<Long>`	`sumAsLong(Expression<Integer> argument)`
`JpaExpression<Double>`	`tan(Expression<? extends Number> x)`	Create an expression that returns the tangent of its argument.
`JpaExpression<Double>`	`tanh(Expression<? extends Number> x)`	Create an expression that returns the hyperbolic tangent of its argument.
`JpaExpression<BigDecimal>`	`toBigDecimal(Expression<? extends Number> number)`
`JpaExpression<BigInteger>`	`toBigInteger(Expression<? extends Number> number)`
`JpaExpression<Double>`	`toDouble(Expression<? extends Number> number)`
`JpaExpression<Float>`	`toFloat(Expression<? extends Number> number)`
`JpaExpression<Integer>`	`toInteger(Expression<? extends Number> number)`
`JpaExpression<Long>`	`toLong(Expression<? extends Number> number)`
`JpaExpression<String>`	`toString(Expression<Character> character)`
`<X,T,E extends T> JpaCollectionJoin<X,E>`	`treat(CollectionJoin<X,T> join, Class<E> type)`
`<X,T,V extends T> JpaJoin<X,V>`	`treat(Join<X,T> join, Class<V> type)`
`<X,T,E extends T> JpaListJoin<X,E>`	`treat(ListJoin<X,T> join, Class<E> type)`
`<X,K,T,V extends T> JpaMapJoin<X,K,V>`	`treat(MapJoin<X,K,T> join, Class<V> type)`
`<X,T extends X> JpaPath<T>`	`treat(Path<X> path, Class<T> type)`
`<X,T extends X> JpaRoot<T>`	`treat(Root<X> root, Class<T> type)`
`<X,T,E extends T> JpaSetJoin<X,E>`	`treat(SetJoin<X,T> join, Class<E> type)`
`JpaFunction<String>`	`trim(char t, Expression<String> x)`
`JpaFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, char t, Expression<String> x)`
`JpaFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, Expression<Character> t, Expression<String> x)`
`JpaFunction<String>`	`trim(CriteriaBuilder.Trimspec ts, Expression<String> x)`
`JpaFunction<String>`	`trim(Expression<Character> t, Expression<String> x)`
`JpaFunction<String>`	`trim(Expression<String> x)`
`<T extends Number> JpaExpression<T>`	`truncate(Expression<T> x, Integer n)`	Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
`<T extends TemporalAccessor> JpaFunction<T>`	`truncate(Expression<T> datetime, TemporalUnit temporalUnit)`	Truncates a date, time or datetime expression to the given `TemporalUnit`.
`JpaCompoundSelection<Tuple>`	`tuple(Selection<?>[] selections)`
`JpaCompoundSelection<Tuple>`	`tuple(List<? extends JpaSelection<?>> selections)`
`<T> JpaCriteriaQuery<T>`	`union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`union(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`union(Subquery<? extends T> query1, Subquery<?>... queries)`
`<T> JpaCriteriaQuery<T>`	`unionAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)`
`<T> JpaSubQuery<T>`	`unionAll(Subquery<? extends T> query1, Subquery<?>... queries)`
`<T extends HibernateCriteriaBuilder> T`	`unwrap(Class<T> clazz)`
`JpaFunction<String>`	`upper(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>> Expression<Collection<V>>`	`values(M map)`
`<T> JpaExpression<T>`	`windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)`	Create a generic window function expression that will be applied over the specified `window`.
`JpaPredicate`	`wrap(Expression<Boolean> expression)`
`JpaPredicate`	`wrap(Expression<Boolean>... expressions)`
`JpaFunction<Integer>`	`year(Expression<? extends TemporalAccessor> datetime)`	Extracts the `TemporalUnit.YEAR` of a date, time, or datetime expression.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

HibernateCriteriaBuilderDelegate

public HibernateCriteriaBuilderDelegate(HibernateCriteriaBuilder criteriaBuilder)

Method Detail

getCriteriaBuilder

protected HibernateCriteriaBuilder getCriteriaBuilder()

cast

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

Specified by:: cast in interface HibernateCriteriaBuilder

wrap

public JpaPredicate wrap(Expression<Boolean> expression)

Specified by:: wrap in interface HibernateCriteriaBuilder

wrap

public JpaPredicate wrap(Expression<Boolean>... expressions)

Specified by:: wrap in interface HibernateCriteriaBuilder

unwrap

public <T extends HibernateCriteriaBuilder> T unwrap(Class<T> clazz)

Specified by:: unwrap in interface HibernateCriteriaBuilder

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

createQuery in interface CriteriaBuilder

Specified by:

createQuery in interface HibernateCriteriaBuilder

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

createQuery in interface CriteriaBuilder

Specified by:

createQuery in interface HibernateCriteriaBuilder

createTupleQuery
```
public JpaCriteriaQuery<Tuple> createTupleQuery()
```
Specified by:

createTupleQuery in interface CriteriaBuilder

Specified by:

createTupleQuery in interface HibernateCriteriaBuilder

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

createCriteriaUpdate in interface CriteriaBuilder

Specified by:

createCriteriaUpdate in interface HibernateCriteriaBuilder

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

createCriteriaDelete in interface CriteriaBuilder

Specified by:

createCriteriaDelete in interface HibernateCriteriaBuilder

createCriteriaInsertSelect
```
public <T> JpaCriteriaInsertSelect<T> createCriteriaInsertSelect(Class<T> targetEntity)
```
Specified by:

createCriteriaInsertSelect in interface HibernateCriteriaBuilder

unionAll

public <T> JpaCriteriaQuery<T> unionAll(CriteriaQuery<? extends T> query1,
                                        CriteriaQuery<?>... queries)

Specified by:: unionAll in interface HibernateCriteriaBuilder

union

public <T> JpaCriteriaQuery<T> union(CriteriaQuery<? extends T> query1,
                                     CriteriaQuery<?>... queries)

Specified by:: union in interface HibernateCriteriaBuilder

union

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

Specified by:: union in interface HibernateCriteriaBuilder

intersectAll

public <T> JpaCriteriaQuery<T> intersectAll(CriteriaQuery<? extends T> query1,
                                            CriteriaQuery<?>... queries)

Specified by:: intersectAll in interface HibernateCriteriaBuilder

intersect

public <T> JpaCriteriaQuery<T> intersect(CriteriaQuery<? extends T> query1,
                                         CriteriaQuery<?>... queries)

Specified by:: intersect in interface HibernateCriteriaBuilder

intersect

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

Specified by:: intersect in interface HibernateCriteriaBuilder

exceptAll

public <T> JpaCriteriaQuery<T> exceptAll(CriteriaQuery<? extends T> query1,
                                         CriteriaQuery<?>... queries)

Specified by:: exceptAll in interface HibernateCriteriaBuilder

except

public <T> JpaCriteriaQuery<T> except(CriteriaQuery<? extends T> query1,
                                      CriteriaQuery<?>... queries)

Specified by:: except in interface HibernateCriteriaBuilder

except

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

Specified by:: except in interface HibernateCriteriaBuilder

unionAll

public <T> JpaSubQuery<T> unionAll(Subquery<? extends T> query1,
                                   Subquery<?>... queries)

Specified by:: unionAll in interface HibernateCriteriaBuilder

union

public <T> JpaSubQuery<T> union(Subquery<? extends T> query1,
                                Subquery<?>... queries)

Specified by:: union in interface HibernateCriteriaBuilder

union

public <T> JpaSubQuery<T> union(boolean all,
                                Subquery<? extends T> query1,
                                Subquery<?>... queries)

Specified by:: union in interface HibernateCriteriaBuilder

intersectAll

public <T> JpaSubQuery<T> intersectAll(Subquery<? extends T> query1,
                                       Subquery<?>... queries)

Specified by:: intersectAll in interface HibernateCriteriaBuilder

intersect

public <T> JpaSubQuery<T> intersect(Subquery<? extends T> query1,
                                    Subquery<?>... queries)

Specified by:: intersect in interface HibernateCriteriaBuilder

intersect

public <T> JpaSubQuery<T> intersect(boolean all,
                                    Subquery<? extends T> query1,
                                    Subquery<?>... queries)

Specified by:: intersect in interface HibernateCriteriaBuilder

exceptAll

public <T> JpaSubQuery<T> exceptAll(Subquery<? extends T> query1,
                                    Subquery<?>... queries)

Specified by:: exceptAll in interface HibernateCriteriaBuilder

except

public <T> JpaSubQuery<T> except(Subquery<? extends T> query1,
                                 Subquery<?>... queries)

Specified by:: except in interface HibernateCriteriaBuilder

except

public <T> JpaSubQuery<T> except(boolean all,
                                 Subquery<? extends T> query1,
                                 Subquery<?>... queries)

Specified by:: except in interface HibernateCriteriaBuilder

sign
```
public JpaExpression<Integer> sign(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

sign in interface CriteriaBuilder

Specified by:

sign in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

sign

ceiling
```
public <N extends Number> JpaExpression<N> ceiling(Expression<N> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.

Specified by:

ceiling in interface CriteriaBuilder

Specified by:

ceiling in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

ceiling

floor
```
public <N extends Number> JpaExpression<N> floor(Expression<N> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.

Specified by:

floor in interface CriteriaBuilder

Specified by:

floor in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

floor

exp
```
public JpaExpression<Double> exp(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.

Specified by:

exp in interface CriteriaBuilder

Specified by:

exp in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

exponential

ln
```
public JpaExpression<Double> ln(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the natural logarithm of its argument.

Specified by:

ln in interface CriteriaBuilder

Specified by:

ln in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

natural logarithm

power
```
public JpaExpression<Double> power(Expression<? extends Number> x,
                                   Expression<? extends Number> y)
```
Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

power in interface CriteriaBuilder

Specified by:

power in interface HibernateCriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

power
```
public JpaExpression<Double> power(Expression<? extends Number> x,
                                   Number y)
```
Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

power in interface CriteriaBuilder

Specified by:

power in interface HibernateCriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

round
```
public <T extends Number> JpaExpression<T> round(Expression<T> x,
                                                 Integer n)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.

Specified by:

round in interface CriteriaBuilder

Specified by:

round in interface HibernateCriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the rounded value

truncate
```
public <T extends Number> JpaExpression<T> truncate(Expression<T> x,
                                                    Integer n)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.

Specified by:

truncate in interface HibernateCriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the truncated value

localDate
```
public JpaExpression<LocalDate> localDate()
```
Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local date.

Specified by:

localDate in interface CriteriaBuilder

Specified by:

localDate in interface HibernateCriteriaBuilder

Returns:

expression for current date

localDateTime
```
public JpaExpression<LocalDateTime> localDateTime()
```
Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local datetime.

Specified by:

localDateTime in interface CriteriaBuilder

Specified by:

localDateTime in interface HibernateCriteriaBuilder

Returns:

expression for current timestamp

localTime
```
public JpaExpression<LocalTime> localTime()
```
Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local time.

Specified by:

localTime in interface CriteriaBuilder

Specified by:

localTime in interface HibernateCriteriaBuilder

Returns:

expression for current time

fk

public <P,F> JpaExpression<F> fk(Path<P> path)

Specified by:: fk in interface HibernateCriteriaBuilder

treat

public <X,T extends X> JpaPath<T> treat(Path<X> path,
                                              Class<T> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,T extends X> JpaRoot<T> treat(Root<X> root,
                                              Class<T> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,T,V extends T> JpaJoin<X,V> treat(Join<X,T> join,
                                                              Class<V> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,T,E extends T> JpaCollectionJoin<X,E> treat(CollectionJoin<X,T> join,
                                                                        Class<E> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,T,E extends T> JpaSetJoin<X,E> treat(SetJoin<X,T> join,
                                                                 Class<E> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,T,E extends T> JpaListJoin<X,E> treat(ListJoin<X,T> join,
                                                                  Class<E> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

treat

public <X,K,T,V extends T> JpaMapJoin<X,K,V> treat(MapJoin<X,K,T> join,
                                                                                 Class<V> type)

Specified by:: treat in interface CriteriaBuilder
Specified by:: treat in interface HibernateCriteriaBuilder

construct

public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
                                             Selection<?>[] selections)

Specified by:: construct in interface CriteriaBuilder
Specified by:: construct in interface HibernateCriteriaBuilder

construct

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

Specified by:: construct in interface HibernateCriteriaBuilder

tuple
```
public JpaCompoundSelection<Tuple> tuple(Selection<?>[] selections)
```
Specified by:

tuple in interface CriteriaBuilder

Specified by:

tuple in interface HibernateCriteriaBuilder

tuple

public JpaCompoundSelection<Tuple> tuple(List<? extends JpaSelection<?>> selections)

Specified by:: tuple in interface HibernateCriteriaBuilder

array
```
public JpaCompoundSelection<Object[]> array(Selection<?>[] selections)
```
Specified by:

array in interface CriteriaBuilder

Specified by:

array in interface HibernateCriteriaBuilder

array

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

Specified by:: array in interface HibernateCriteriaBuilder

array

public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
                                         Selection<?>[] selections)

Specified by:: array in interface HibernateCriteriaBuilder

array

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

Specified by:: array in interface HibernateCriteriaBuilder

avg
```
public <N extends Number> JpaExpression<Double> avg(Expression<N> argument)
```
Specified by:

avg in interface CriteriaBuilder

Specified by:

avg in interface HibernateCriteriaBuilder

sum
```
public <N extends Number> JpaExpression<N> sum(Expression<N> argument)
```
Specified by:

sum in interface CriteriaBuilder

Specified by:

sum in interface HibernateCriteriaBuilder

sumAsLong
```
public JpaExpression<Long> sumAsLong(Expression<Integer> argument)
```
Specified by:

sumAsLong in interface CriteriaBuilder

Specified by:

sumAsLong in interface HibernateCriteriaBuilder

sumAsDouble
```
public JpaExpression<Double> sumAsDouble(Expression<Float> argument)
```
Specified by:

sumAsDouble in interface CriteriaBuilder

Specified by:

sumAsDouble in interface HibernateCriteriaBuilder

max
```
public <N extends Number> JpaExpression<N> max(Expression<N> argument)
```
Specified by:

max in interface CriteriaBuilder

Specified by:

max in interface HibernateCriteriaBuilder

min
```
public <N extends Number> JpaExpression<N> min(Expression<N> argument)
```
Specified by:

min in interface CriteriaBuilder

Specified by:

min in interface HibernateCriteriaBuilder

greatest
```
public <X extends Comparable<? super X>> JpaExpression<X> greatest(Expression<X> argument)
```
Specified by:

greatest in interface CriteriaBuilder

Specified by:

greatest in interface HibernateCriteriaBuilder

least
```
public <X extends Comparable<? super X>> JpaExpression<X> least(Expression<X> argument)
```
Specified by:

least in interface CriteriaBuilder

Specified by:

least in interface HibernateCriteriaBuilder

count
```
public JpaExpression<Long> count(Expression<?> argument)
```
Specified by:

count in interface CriteriaBuilder

Specified by:

count in interface HibernateCriteriaBuilder

countDistinct
```
public JpaExpression<Long> countDistinct(Expression<?> x)
```
Specified by:

countDistinct in interface CriteriaBuilder

Specified by:

countDistinct in interface HibernateCriteriaBuilder

neg
```
public <N extends Number> JpaExpression<N> neg(Expression<N> x)
```
Specified by:

neg in interface CriteriaBuilder

Specified by:

neg in interface HibernateCriteriaBuilder

abs
```
public <N extends Number> JpaExpression<N> abs(Expression<N> x)
```
Specified by:

abs in interface CriteriaBuilder

Specified by:

abs in interface HibernateCriteriaBuilder

sum

public <N extends Number> JpaExpression<N> sum(Expression<? extends N> x,
                                               Expression<? extends N> y)

Specified by:: sum in interface CriteriaBuilder
Specified by:: sum in interface HibernateCriteriaBuilder

sum

public <N extends Number> JpaExpression<N> sum(Expression<? extends N> x,
                                               N y)

Specified by:: sum in interface CriteriaBuilder
Specified by:: sum in interface HibernateCriteriaBuilder

sum

public <N extends Number> JpaExpression<N> sum(N x,
                                               Expression<? extends N> y)

Specified by:: sum in interface CriteriaBuilder
Specified by:: sum in interface HibernateCriteriaBuilder

prod

public <N extends Number> JpaExpression<N> prod(Expression<? extends N> x,
                                                Expression<? extends N> y)

Specified by:: prod in interface CriteriaBuilder
Specified by:: prod in interface HibernateCriteriaBuilder

prod

public <N extends Number> JpaExpression<N> prod(Expression<? extends N> x,
                                                N y)

Specified by:: prod in interface CriteriaBuilder
Specified by:: prod in interface HibernateCriteriaBuilder

prod

public <N extends Number> JpaExpression<N> prod(N x,
                                                Expression<? extends N> y)

Specified by:: prod in interface CriteriaBuilder
Specified by:: prod in interface HibernateCriteriaBuilder

diff

public <N extends Number> JpaExpression<N> diff(Expression<? extends N> x,
                                                Expression<? extends N> y)

Specified by:: diff in interface CriteriaBuilder
Specified by:: diff in interface HibernateCriteriaBuilder

diff

public <N extends Number> JpaExpression<N> diff(Expression<? extends N> x,
                                                N y)

Specified by:: diff in interface CriteriaBuilder
Specified by:: diff in interface HibernateCriteriaBuilder

diff

public <N extends Number> JpaExpression<N> diff(N x,
                                                Expression<? extends N> y)

Specified by:: diff in interface CriteriaBuilder
Specified by:: diff in interface HibernateCriteriaBuilder

quot

public JpaExpression<Number> quot(Expression<? extends Number> x,
                                  Expression<? extends Number> y)

Specified by:: quot in interface CriteriaBuilder
Specified by:: quot in interface HibernateCriteriaBuilder

quot

public JpaExpression<Number> quot(Expression<? extends Number> x,
                                  Number y)

Specified by:: quot in interface CriteriaBuilder
Specified by:: quot in interface HibernateCriteriaBuilder

quot

public JpaExpression<Number> quot(Number x,
                                  Expression<? extends Number> y)

Specified by:: quot in interface CriteriaBuilder
Specified by:: quot in interface HibernateCriteriaBuilder

mod

public JpaExpression<Integer> mod(Expression<Integer> x,
                                  Expression<Integer> y)

Specified by:: mod in interface CriteriaBuilder
Specified by:: mod in interface HibernateCriteriaBuilder

mod

public JpaExpression<Integer> mod(Expression<Integer> x,
                                  Integer y)

Specified by:: mod in interface CriteriaBuilder
Specified by:: mod in interface HibernateCriteriaBuilder

mod

public JpaExpression<Integer> mod(Integer x,
                                  Expression<Integer> y)

Specified by:: mod in interface CriteriaBuilder
Specified by:: mod in interface HibernateCriteriaBuilder

sqrt
```
public JpaExpression<Double> sqrt(Expression<? extends Number> x)
```
Specified by:

sqrt in interface CriteriaBuilder

Specified by:

sqrt in interface HibernateCriteriaBuilder

toLong
```
public JpaExpression<Long> toLong(Expression<? extends Number> number)
```
Specified by:

toLong in interface CriteriaBuilder

Specified by:

toLong in interface HibernateCriteriaBuilder

toInteger
```
public JpaExpression<Integer> toInteger(Expression<? extends Number> number)
```
Specified by:

toInteger in interface CriteriaBuilder

Specified by:

toInteger in interface HibernateCriteriaBuilder

toFloat
```
public JpaExpression<Float> toFloat(Expression<? extends Number> number)
```
Specified by:

toFloat in interface CriteriaBuilder

Specified by:

toFloat in interface HibernateCriteriaBuilder

toDouble
```
public JpaExpression<Double> toDouble(Expression<? extends Number> number)
```
Specified by:

toDouble in interface CriteriaBuilder

Specified by:

toDouble in interface HibernateCriteriaBuilder

toBigDecimal
```
public JpaExpression<BigDecimal> toBigDecimal(Expression<? extends Number> number)
```
Specified by:

toBigDecimal in interface CriteriaBuilder

Specified by:

toBigDecimal in interface HibernateCriteriaBuilder

toBigInteger
```
public JpaExpression<BigInteger> toBigInteger(Expression<? extends Number> number)
```
Specified by:

toBigInteger in interface CriteriaBuilder

Specified by:

toBigInteger in interface HibernateCriteriaBuilder

toString
```
public JpaExpression<String> toString(Expression<Character> character)
```
Specified by:

toString in interface CriteriaBuilder

Specified by:

toString in interface HibernateCriteriaBuilder

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

literal in interface CriteriaBuilder

Specified by:

literal in interface HibernateCriteriaBuilder

literal

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

Specified by:: literal in interface HibernateCriteriaBuilder

literals

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

Specified by:: literals in interface HibernateCriteriaBuilder

literals

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

Specified by:: literals in interface HibernateCriteriaBuilder

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

nullLiteral in interface CriteriaBuilder

Specified by:

nullLiteral in interface HibernateCriteriaBuilder

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

parameter in interface CriteriaBuilder

Specified by:

parameter in interface HibernateCriteriaBuilder

parameter

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

Specified by:: parameter in interface CriteriaBuilder
Specified by:: parameter in interface HibernateCriteriaBuilder

concat

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

Specified by:: concat in interface CriteriaBuilder
Specified by:: concat in interface HibernateCriteriaBuilder

concat

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

Specified by:: concat in interface CriteriaBuilder
Specified by:: concat in interface HibernateCriteriaBuilder

concat

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

Specified by:: concat in interface CriteriaBuilder
Specified by:: concat in interface HibernateCriteriaBuilder

concat

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

Specified by:: concat in interface HibernateCriteriaBuilder

substring

public JpaFunction<String> substring(Expression<String> x,
                                     Expression<Integer> from)

Specified by:: substring in interface CriteriaBuilder
Specified by:: substring in interface HibernateCriteriaBuilder

substring
```
public JpaFunction<String> substring(Expression<String> x,
                                     int from)
```
Specified by:

substring in interface CriteriaBuilder

Specified by:

substring in interface HibernateCriteriaBuilder

substring

public JpaFunction<String> substring(Expression<String> x,
                                     Expression<Integer> from,
                                     Expression<Integer> len)

Specified by:: substring in interface CriteriaBuilder
Specified by:: substring in interface HibernateCriteriaBuilder

substring

public JpaFunction<String> substring(Expression<String> x,
                                     int from,
                                     int len)

Specified by:: substring in interface CriteriaBuilder
Specified by:: substring in interface HibernateCriteriaBuilder

trim
```
public JpaFunction<String> trim(Expression<String> x)
```
Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

trim

public JpaFunction<String> trim(CriteriaBuilder.Trimspec ts,
                                Expression<String> x)

Specified by:: trim in interface CriteriaBuilder
Specified by:: trim in interface HibernateCriteriaBuilder

trim

public JpaFunction<String> trim(Expression<Character> t,
                                Expression<String> x)

Specified by:: trim in interface CriteriaBuilder
Specified by:: trim in interface HibernateCriteriaBuilder

trim

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

Specified by:: trim in interface CriteriaBuilder
Specified by:: trim in interface HibernateCriteriaBuilder

trim

public JpaFunction<String> trim(char t,
                                Expression<String> x)

Specified by:: trim in interface CriteriaBuilder
Specified by:: trim in interface HibernateCriteriaBuilder

trim

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

Specified by:: trim in interface CriteriaBuilder
Specified by:: trim in interface HibernateCriteriaBuilder

lower
```
public JpaFunction<String> lower(Expression<String> x)
```
Specified by:

lower in interface CriteriaBuilder

Specified by:

lower in interface HibernateCriteriaBuilder

upper
```
public JpaFunction<String> upper(Expression<String> x)
```
Specified by:

upper in interface CriteriaBuilder

Specified by:

upper in interface HibernateCriteriaBuilder

length
```
public JpaFunction<Integer> length(Expression<String> x)
```
Specified by:

length in interface CriteriaBuilder

Specified by:

length in interface HibernateCriteriaBuilder

locate

public JpaFunction<Integer> locate(Expression<String> x,
                                   Expression<String> pattern)

Specified by:: locate in interface CriteriaBuilder
Specified by:: locate in interface HibernateCriteriaBuilder

locate

public JpaFunction<Integer> locate(Expression<String> x,
                                   String pattern)

Specified by:: locate in interface CriteriaBuilder
Specified by:: locate in interface HibernateCriteriaBuilder

locate

public JpaFunction<Integer> locate(Expression<String> x,
                                   Expression<String> pattern,
                                   Expression<Integer> from)

Specified by:: locate in interface CriteriaBuilder
Specified by:: locate in interface HibernateCriteriaBuilder

locate

public JpaFunction<Integer> locate(Expression<String> x,
                                   String pattern,
                                   int from)

Specified by:: locate in interface CriteriaBuilder
Specified by:: locate in interface HibernateCriteriaBuilder

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

currentDate in interface CriteriaBuilder

Specified by:

currentDate in interface HibernateCriteriaBuilder

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

currentTime in interface CriteriaBuilder

Specified by:

currentTime in interface HibernateCriteriaBuilder

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

currentTimestamp in interface CriteriaBuilder

Specified by:

currentTimestamp in interface HibernateCriteriaBuilder

currentInstant
```
public JpaFunction<Instant> currentInstant()
```
Specified by:

currentInstant in interface HibernateCriteriaBuilder

function

public <T> JpaFunction<T> function(String name,
                                   Class<T> type,
                                   Expression<?>... args)

Specified by:: function in interface CriteriaBuilder
Specified by:: function in interface HibernateCriteriaBuilder

all
```
public <Y> JpaExpression<Y> all(Subquery<Y> subquery)
```
Specified by:

all in interface CriteriaBuilder

Specified by:

all in interface HibernateCriteriaBuilder

some
```
public <Y> JpaExpression<Y> some(Subquery<Y> subquery)
```
Specified by:

some in interface CriteriaBuilder

Specified by:

some in interface HibernateCriteriaBuilder

any
```
public <Y> JpaExpression<Y> any(Subquery<Y> subquery)
```
Specified by:

any in interface CriteriaBuilder

Specified by:

any in interface HibernateCriteriaBuilder

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

keys in interface CriteriaBuilder

Specified by:

keys in interface HibernateCriteriaBuilder

indexes

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

Specified by:: indexes in interface HibernateCriteriaBuilder

value
```
public <T> SqmExpression<T> value(T value)
```
Specified by:

value in interface HibernateCriteriaBuilder

value

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

Specified by:: value in interface HibernateCriteriaBuilder

values

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

Specified by:: values in interface HibernateCriteriaBuilder

values
```
public <V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
```
Specified by:

values in interface CriteriaBuilder

Specified by:

values in interface HibernateCriteriaBuilder

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

size in interface CriteriaBuilder

Specified by:

size in interface HibernateCriteriaBuilder

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

size in interface CriteriaBuilder

Specified by:

size in interface HibernateCriteriaBuilder

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

coalesce in interface CriteriaBuilder

Specified by:

coalesce in interface HibernateCriteriaBuilder

coalesce

public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x,
                                   Expression<? extends Y> y)

Specified by:: coalesce in interface CriteriaBuilder
Specified by:: coalesce in interface HibernateCriteriaBuilder

coalesce
```
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x,
                                   Y y)
```
Specified by:

coalesce in interface CriteriaBuilder

Specified by:

coalesce in interface HibernateCriteriaBuilder

nullif

public <Y> JpaExpression<Y> nullif(Expression<Y> x,
                                   Expression<?> y)

Specified by:: nullif in interface CriteriaBuilder
Specified by:: nullif in interface HibernateCriteriaBuilder

nullif
```
public <Y> JpaExpression<Y> nullif(Expression<Y> x,
                                   Y y)
```
Specified by:

nullif in interface CriteriaBuilder

Specified by:

nullif in interface HibernateCriteriaBuilder

selectCase
```
public <C,R> JpaSimpleCase<C,R> selectCase(Expression<? extends C> expression)
```
Specified by:

selectCase in interface CriteriaBuilder

Specified by:

selectCase in interface HibernateCriteriaBuilder

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

selectCase in interface CriteriaBuilder

Specified by:

selectCase in interface HibernateCriteriaBuilder

and

public JpaPredicate and(Expression<Boolean> x,
                        Expression<Boolean> y)

Specified by:: and in interface CriteriaBuilder
Specified by:: and in interface HibernateCriteriaBuilder

and
```
public JpaPredicate and(Predicate... restrictions)
```
Specified by:

and in interface CriteriaBuilder

Specified by:

and in interface HibernateCriteriaBuilder

or

public JpaPredicate or(Expression<Boolean> x,
                       Expression<Boolean> y)

Specified by:: or in interface CriteriaBuilder
Specified by:: or in interface HibernateCriteriaBuilder

or
```
public JpaPredicate or(Predicate... restrictions)
```
Specified by:

or in interface CriteriaBuilder

Specified by:

or in interface HibernateCriteriaBuilder

not
```
public JpaPredicate not(Expression<Boolean> restriction)
```
Specified by:

not in interface CriteriaBuilder

Specified by:

not in interface HibernateCriteriaBuilder

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

conjunction in interface CriteriaBuilder

Specified by:

conjunction in interface HibernateCriteriaBuilder

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

disjunction in interface CriteriaBuilder

Specified by:

disjunction in interface HibernateCriteriaBuilder

isTrue
```
public JpaPredicate isTrue(Expression<Boolean> x)
```
Specified by:

isTrue in interface CriteriaBuilder

Specified by:

isTrue in interface HibernateCriteriaBuilder

isFalse
```
public JpaPredicate isFalse(Expression<Boolean> x)
```
Specified by:

isFalse in interface CriteriaBuilder

Specified by:

isFalse in interface HibernateCriteriaBuilder

isNull
```
public JpaPredicate isNull(Expression<?> x)
```
Specified by:

isNull in interface CriteriaBuilder

Specified by:

isNull in interface HibernateCriteriaBuilder

isNotNull
```
public JpaPredicate isNotNull(Expression<?> x)
```
Specified by:

isNotNull in interface CriteriaBuilder

Specified by:

isNotNull in interface HibernateCriteriaBuilder

equal

public JpaPredicate equal(Expression<?> x,
                          Expression<?> y)

Specified by:: equal in interface CriteriaBuilder
Specified by:: equal in interface HibernateCriteriaBuilder

equal

public JpaPredicate equal(Expression<?> x,
                          Object y)

Specified by:: equal in interface CriteriaBuilder
Specified by:: equal in interface HibernateCriteriaBuilder

notEqual

public JpaPredicate notEqual(Expression<?> x,
                             Expression<?> y)

Specified by:: notEqual in interface CriteriaBuilder
Specified by:: notEqual in interface HibernateCriteriaBuilder

notEqual

public JpaPredicate notEqual(Expression<?> x,
                             Object y)

Specified by:: notEqual in interface CriteriaBuilder
Specified by:: notEqual in interface HibernateCriteriaBuilder

distinctFrom

public JpaPredicate distinctFrom(Expression<?> x,
                                 Expression<?> y)

Specified by:: distinctFrom in interface HibernateCriteriaBuilder

distinctFrom

public JpaPredicate distinctFrom(Expression<?> x,
                                 Object y)

Specified by:: distinctFrom in interface HibernateCriteriaBuilder

notDistinctFrom

public JpaPredicate notDistinctFrom(Expression<?> x,
                                    Expression<?> y)

Specified by:: notDistinctFrom in interface HibernateCriteriaBuilder

notDistinctFrom

public JpaPredicate notDistinctFrom(Expression<?> x,
                                    Object y)

Specified by:: notDistinctFrom in interface HibernateCriteriaBuilder

greaterThan

public <Y extends Comparable<? super Y>> JpaPredicate greaterThan(Expression<? extends Y> x,
                                                                  Expression<? extends Y> y)

Specified by:: greaterThan in interface CriteriaBuilder
Specified by:: greaterThan in interface HibernateCriteriaBuilder

greaterThan

public <Y extends Comparable<? super Y>> JpaPredicate greaterThan(Expression<? extends Y> x,
                                                                  Y y)

Specified by:: greaterThan in interface CriteriaBuilder
Specified by:: greaterThan in interface HibernateCriteriaBuilder

greaterThanOrEqualTo

public <Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Expression<? extends Y> y)

Specified by:: greaterThanOrEqualTo in interface CriteriaBuilder
Specified by:: greaterThanOrEqualTo in interface HibernateCriteriaBuilder

greaterThanOrEqualTo

public <Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Y y)

Specified by:: greaterThanOrEqualTo in interface CriteriaBuilder
Specified by:: greaterThanOrEqualTo in interface HibernateCriteriaBuilder

lessThan

public <Y extends Comparable<? super Y>> JpaPredicate lessThan(Expression<? extends Y> x,
                                                               Expression<? extends Y> y)

Specified by:: lessThan in interface CriteriaBuilder
Specified by:: lessThan in interface HibernateCriteriaBuilder

lessThan

public <Y extends Comparable<? super Y>> JpaPredicate lessThan(Expression<? extends Y> x,
                                                               Y y)

Specified by:: lessThan in interface CriteriaBuilder
Specified by:: lessThan in interface HibernateCriteriaBuilder

lessThanOrEqualTo

public <Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Expression<? extends Y> y)

Specified by:: lessThanOrEqualTo in interface CriteriaBuilder
Specified by:: lessThanOrEqualTo in interface HibernateCriteriaBuilder

lessThanOrEqualTo

public <Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Y y)

Specified by:: lessThanOrEqualTo in interface CriteriaBuilder
Specified by:: lessThanOrEqualTo in interface HibernateCriteriaBuilder

between

public <Y extends Comparable<? super Y>> JpaPredicate between(Expression<? extends Y> value,
                                                              Expression<? extends Y> lower,
                                                              Expression<? extends Y> upper)

Specified by:: between in interface CriteriaBuilder
Specified by:: between in interface HibernateCriteriaBuilder

between

public <Y extends Comparable<? super Y>> JpaPredicate between(Expression<? extends Y> value,
                                                              Y lower,
                                                              Y upper)

Specified by:: between in interface CriteriaBuilder
Specified by:: between in interface HibernateCriteriaBuilder

gt

public JpaPredicate gt(Expression<? extends Number> x,
                       Expression<? extends Number> y)

Specified by:: gt in interface CriteriaBuilder
Specified by:: gt in interface HibernateCriteriaBuilder

gt

public JpaPredicate gt(Expression<? extends Number> x,
                       Number y)

Specified by:: gt in interface CriteriaBuilder
Specified by:: gt in interface HibernateCriteriaBuilder

ge

public JpaPredicate ge(Expression<? extends Number> x,
                       Expression<? extends Number> y)

Specified by:: ge in interface CriteriaBuilder
Specified by:: ge in interface HibernateCriteriaBuilder

ge

public JpaPredicate ge(Expression<? extends Number> x,
                       Number y)

Specified by:: ge in interface CriteriaBuilder
Specified by:: ge in interface HibernateCriteriaBuilder

lt

public JpaPredicate lt(Expression<? extends Number> x,
                       Expression<? extends Number> y)

Specified by:: lt in interface CriteriaBuilder
Specified by:: lt in interface HibernateCriteriaBuilder

lt

public JpaPredicate lt(Expression<? extends Number> x,
                       Number y)

Specified by:: lt in interface CriteriaBuilder
Specified by:: lt in interface HibernateCriteriaBuilder

le

public JpaPredicate le(Expression<? extends Number> x,
                       Expression<? extends Number> y)

Specified by:: le in interface CriteriaBuilder
Specified by:: le in interface HibernateCriteriaBuilder

le

public JpaPredicate le(Expression<? extends Number> x,
                       Number y)

Specified by:: le in interface CriteriaBuilder
Specified by:: le in interface HibernateCriteriaBuilder

isEmpty
```
public <C extends Collection<?>> JpaPredicate isEmpty(Expression<C> collection)
```
Specified by:

isEmpty in interface CriteriaBuilder

Specified by:

isEmpty in interface HibernateCriteriaBuilder

isNotEmpty
```
public <C extends Collection<?>> JpaPredicate isNotEmpty(Expression<C> collection)
```
Specified by:

isNotEmpty in interface CriteriaBuilder

Specified by:

isNotEmpty in interface HibernateCriteriaBuilder

isMember

public <E,C extends Collection<E>> JpaPredicate isMember(Expression<E> elem,
                                                               Expression<C> collection)

Specified by:: isMember in interface CriteriaBuilder
Specified by:: isMember in interface HibernateCriteriaBuilder

isMember

public <E,C extends Collection<E>> JpaPredicate isMember(E elem,
                                                               Expression<C> collection)

Specified by:: isMember in interface CriteriaBuilder
Specified by:: isMember in interface HibernateCriteriaBuilder

isNotMember

public <E,C extends Collection<E>> JpaPredicate isNotMember(Expression<E> elem,
                                                                  Expression<C> collection)

Specified by:: isNotMember in interface CriteriaBuilder
Specified by:: isNotMember in interface HibernateCriteriaBuilder

isNotMember

public <E,C extends Collection<E>> JpaPredicate isNotMember(E elem,
                                                                  Expression<C> collection)

Specified by:: isNotMember in interface CriteriaBuilder
Specified by:: isNotMember in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         Expression<String> pattern)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         String pattern)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         Expression<String> pattern,
                         Expression<Character> escapeChar)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         Expression<String> pattern,
                         char escapeChar)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         String pattern,
                         Expression<Character> escapeChar)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

like

public JpaPredicate like(Expression<String> x,
                         String pattern,
                         char escapeChar)

Specified by:: like in interface CriteriaBuilder
Specified by:: like in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          Expression<String> pattern)

Specified by:: ilike in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          String pattern)

Specified by:: ilike in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          Expression<String> pattern,
                          Expression<Character> escapeChar)

Specified by:: ilike in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          Expression<String> pattern,
                          char escapeChar)

Specified by:: ilike in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          String pattern,
                          Expression<Character> escapeChar)

Specified by:: ilike in interface HibernateCriteriaBuilder

ilike

public JpaPredicate ilike(Expression<String> x,
                          String pattern,
                          char escapeChar)

Specified by:: ilike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            Expression<String> pattern)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            String pattern)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            Expression<String> pattern,
                            Expression<Character> escapeChar)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            Expression<String> pattern,
                            char escapeChar)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            String pattern,
                            Expression<Character> escapeChar)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notLike

public JpaPredicate notLike(Expression<String> x,
                            String pattern,
                            char escapeChar)

Specified by:: notLike in interface CriteriaBuilder
Specified by:: notLike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             Expression<String> pattern)

Specified by:: notIlike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             String pattern)

Specified by:: notIlike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             Expression<String> pattern,
                             Expression<Character> escapeChar)

Specified by:: notIlike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             Expression<String> pattern,
                             char escapeChar)

Specified by:: notIlike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             String pattern,
                             Expression<Character> escapeChar)

Specified by:: notIlike in interface HibernateCriteriaBuilder

notIlike

public JpaPredicate notIlike(Expression<String> x,
                             String pattern,
                             char escapeChar)

Specified by:: notIlike in interface HibernateCriteriaBuilder

in
```
public <T> JpaInPredicate<T> in(Expression<? extends T> expression)
```
Specified by:

in in interface CriteriaBuilder

Specified by:

in in interface HibernateCriteriaBuilder

in

public <T> JpaInPredicate<T> in(Expression<? extends T> expression,
                                Expression<? extends T>... values)

Specified by:: in in interface HibernateCriteriaBuilder

in

public <T> JpaInPredicate<T> in(Expression<? extends T> expression,
                                T... values)

Specified by:: in in interface HibernateCriteriaBuilder

in

public <T> JpaInPredicate<T> in(Expression<? extends T> expression,
                                Collection<T> values)

Specified by:: in in interface HibernateCriteriaBuilder

exists
```
public JpaPredicate exists(Subquery<?> subquery)
```
Specified by:

exists in interface CriteriaBuilder

Specified by:

exists in interface HibernateCriteriaBuilder

isMapEmpty
```
public <M extends Map<?,?>> JpaPredicate isMapEmpty(JpaExpression<M> mapExpression)
```
Description copied from interface: HibernateCriteriaBuilder

Create a predicate that tests whether a Map is empty.

Specified by:

isMapEmpty in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

is-empty predicate

isMapNotEmpty
```
public <M extends Map<?,?>> JpaPredicate isMapNotEmpty(JpaExpression<M> mapExpression)
```
Description copied from interface: HibernateCriteriaBuilder

Create a predicate that tests whether a Map is not empty.

Specified by:

isMapNotEmpty in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

is-not-empty predicate

mapSize
```
public <M extends Map<?,?>> JpaExpression<Integer> mapSize(JpaExpression<M> mapExpression)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that tests the size of a map.

Specified by:

mapSize in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

size expression

mapSize
```
public <M extends Map<?,?>> JpaExpression<Integer> mapSize(M map)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that tests the size of a map.

Specified by:

mapSize in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

size expression

sort

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

Specified by:: sort in interface HibernateCriteriaBuilder

sort

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

Specified by:: sort in interface HibernateCriteriaBuilder

sort

public JpaOrder sort(JpaExpression<?> sortExpression)

Specified by:: sort in interface HibernateCriteriaBuilder

asc
```
public JpaOrder asc(Expression<?> x)
```
Specified by:

asc in interface CriteriaBuilder

Specified by:

asc in interface HibernateCriteriaBuilder

desc
```
public JpaOrder desc(Expression<?> x)
```
Specified by:

desc in interface CriteriaBuilder

Specified by:

desc in interface HibernateCriteriaBuilder

asc
```
public JpaOrder asc(Expression<?> x,
                    boolean nullsFirst)
```
Description copied from interface: HibernateCriteriaBuilder

Create an ordering by the ascending value of the expression.

Specified by:

asc in interface HibernateCriteriaBuilder

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc
```
public JpaOrder desc(Expression<?> x,
                     boolean nullsFirst)
```
Description copied from interface: HibernateCriteriaBuilder

Create an ordering by the descending value of the expression.

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

search
```
@Incubating
public JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute,
                             SortOrder sortOrder,
                             NullPrecedence nullPrecedence)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

cteAttribute - CTE attribute used to define the ordering

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

ordering corresponding to the CTE attribute

search
```
@Incubating
public JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute,
                             SortOrder sortOrder)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering based on the sort order of the value of the CTE attribute.

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

cteAttribute - CTE attribute used to define the ordering

sortOrder - The sort order

Returns:

ordering corresponding to the CTE attribute

search
```
@Incubating
public JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering based on the ascending value of the CTE attribute.

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

cteAttribute - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

asc
```
@Incubating
public JpaSearchOrder asc(JpaCteCriteriaAttribute x)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering by the ascending value of the CTE attribute.

Specified by:

asc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

desc
```
@Incubating
public JpaSearchOrder desc(JpaCteCriteriaAttribute x)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering by the descending value of the CTE attribute.

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

Returns:

descending ordering corresponding to the CTE attribute

asc
```
@Incubating
public JpaSearchOrder asc(JpaCteCriteriaAttribute x,
                          boolean nullsFirst)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering by the ascending value of the CTE attribute.

Specified by:

asc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the CTE attribute

desc
```
@Incubating
public JpaSearchOrder desc(JpaCteCriteriaAttribute x,
                           boolean nullsFirst)
```
Description copied from interface: HibernateCriteriaBuilder

Create a search ordering by the descending value of the CTE attribute.

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the CTE attribute

sql
```
public <T> JpaExpression<T> sql(String pattern,
                                Class<T> type,
                                Expression<?>... arguments)
```
Description copied from interface: HibernateCriteriaBuilder

Embed native pattern that will be unquoted and embedded in the generated SQL. Occurrences of ? in the pattern are replaced with the remaining arguments of the function.

Specified by:

sql in interface HibernateCriteriaBuilder

Type Parameters:

T - type of this expression

Parameters:

pattern - native SQL pattern

type - type of this expression

arguments - optional arguments to the SQL pattern

Returns:

native SQL expression

format
```
public JpaFunction<String> format(Expression<? extends TemporalAccessor> datetime,
                                  String pattern)
```
Description copied from interface: HibernateCriteriaBuilder

Format a date, time, or datetime according to a pattern. The pattern must be written in a subset of the pattern language defined by Java’s DateTimeFormatter.
See Dialect.appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender, java.lang.String) for a full list of pattern elements.

Specified by:

format in interface HibernateCriteriaBuilder

Parameters:

datetime - the datetime expression to format

pattern - the pattern to use for formatting

Returns:

format expression

year
```
public JpaFunction<Integer> year(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.

Specified by:

year in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

month
```
public JpaFunction<Integer> month(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.

Specified by:

month in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

day
```
public JpaFunction<Integer> day(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.DAY of a date, time, or datetime expression.

Specified by:

day in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

hour
```
public JpaFunction<Integer> hour(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.

Specified by:

hour in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

minute
```
public JpaFunction<Integer> minute(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.

Specified by:

minute in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

second
```
public JpaFunction<Float> second(Expression<? extends TemporalAccessor> datetime)
```
Description copied from interface: HibernateCriteriaBuilder

Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.

Specified by:

second in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time, or datetime to extract the value from

Returns:

the extracted value

truncate
```
public <T extends TemporalAccessor> JpaFunction<T> truncate(Expression<T> datetime,
                                                            TemporalUnit temporalUnit)
```
Description copied from interface: HibernateCriteriaBuilder

Truncates a date, time or datetime expression to the given TemporalUnit. Supported units are: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.
Truncating translates to obtaining a value of the same type in which all temporal units smaller than field have been pruned. For hours, minutes and second this means setting them to 00. For months and days, this means setting them to 01.

Specified by:

truncate in interface HibernateCriteriaBuilder

Parameters:

datetime - the date, time or datetime expression to be truncated

temporalUnit - the temporal unit for truncation

Returns:

the truncated value

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start,
                                   int length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start,
                                   int length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start,
                                   int length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start,
                                   int length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   int start,
                                   Expression<Integer> length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   int start,
                                   Expression<Integer> length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public JpaFunction<String> overlay(Expression<String> string,
                                   String replacement,
                                   Expression<Integer> start,
                                   Expression<Integer> length)

Specified by:: overlay in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay
```
public JpaFunction<String> overlay(Expression<String> string,
                                   Expression<String> replacement,
                                   Expression<Integer> start,
                                   Expression<Integer> length)
```
Description copied from interface: HibernateCriteriaBuilder

Overlay the string expression with the replacement expression, starting from index start and substituting a number of characters corresponding to the length of the replacement expression or the length parameter if specified.

Specified by:

overlay in interface HibernateCriteriaBuilder

Parameters:

string - string expression to be manipulated

replacement - string expression to replace in original

start - start position

length - optional, number of characters to substitute

Returns:

overlay expression

pad
```
public JpaFunction<String> pad(Expression<String> x,
                               int length)
```
Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(Expression<String> x,
                               Expression<Integer> length)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(Expression<String> x,
                               int length,
                               char padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length,
                               char padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(Expression<String> x,
                               Expression<Integer> length,
                               char padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length,
                               char padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(Expression<String> x,
                               int length,
                               Expression<Character> padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               int length,
                               Expression<Character> padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public JpaFunction<String> pad(Expression<String> x,
                               Expression<Integer> length,
                               Expression<Character> padChar)

Specified by:: pad in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad
```
public JpaFunction<String> pad(CriteriaBuilder.Trimspec ts,
                               Expression<String> x,
                               Expression<Integer> length,
                               Expression<Character> padChar)
```
Description copied from interface: HibernateCriteriaBuilder

Pad the specified string expression with whitespace or with the padChar character if specified. Optionally pass a CriteriaBuilder.Trimspec to pad the string expression with LEADING or TRAILING (default) characters.

Specified by:

pad in interface HibernateCriteriaBuilder

Parameters:

ts - optional CriteriaBuilder.Trimspec

x - string expression to pad

length - length of the result string after padding

padChar - optional pad character

Returns:

pad expression

left
```
public JpaFunction<String> left(Expression<String> x,
                                int length)
```
Specified by:

left in interface HibernateCriteriaBuilder

See Also:

HibernateCriteriaBuilder.left(Expression, Expression)

left
```
public JpaFunction<String> left(Expression<String> x,
                                Expression<Integer> length)
```
Description copied from interface: HibernateCriteriaBuilder

Extract the length leftmost characters of a string.

Specified by:

left in interface HibernateCriteriaBuilder

Parameters:

x - original string

length - number of characters

Returns:

left expression

right
```
public JpaFunction<String> right(Expression<String> x,
                                 int length)
```
Specified by:

right in interface HibernateCriteriaBuilder

See Also:

HibernateCriteriaBuilder.right(Expression, Expression)

right
```
public JpaFunction<String> right(Expression<String> x,
                                 Expression<Integer> length)
```
Description copied from interface: HibernateCriteriaBuilder

Extract the length rightmost characters of a string.

Specified by:

right in interface HibernateCriteriaBuilder

Parameters:

x - original string

length - number of characters

Returns:

left expression

replace

public JpaFunction<String> replace(Expression<String> x,
                                   String pattern,
                                   String replacement)

Specified by:: replace in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace

public JpaFunction<String> replace(Expression<String> x,
                                   String pattern,
                                   Expression<String> replacement)

Specified by:: replace in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace

public JpaFunction<String> replace(Expression<String> x,
                                   Expression<String> pattern,
                                   String replacement)

Specified by:: replace in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace
```
public JpaFunction<String> replace(Expression<String> x,
                                   Expression<String> pattern,
                                   Expression<String> replacement)
```
Description copied from interface: HibernateCriteriaBuilder

Replace all occurrences of pattern within the original string with replacement.

Specified by:

replace in interface HibernateCriteriaBuilder

Parameters:

x - original string

pattern - the string to be replaced

replacement - the new replacement string

Returns:

replace expression

collate

public JpaFunction<String> collate(Expression<String> x,
                                   String collation)

Specified by:: collate in interface HibernateCriteriaBuilder

log10
```
public JpaExpression<Double> log10(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the base-10 logarithm of its argument.

Specified by:

log10 in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

base-10 logarithm

log

public JpaExpression<Double> log(Number b,
                                 Expression<? extends Number> x)

Specified by:: log in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.log(Expression, Expression)

log
```
public JpaExpression<Double> log(Expression<? extends Number> b,
                                 Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the logarithm of x to the base b.

Specified by:

log in interface HibernateCriteriaBuilder

Parameters:

b - base

x - expression

Returns:

arbitrary-base logarithm

pi
```
public JpaExpression<Double> pi()
```
Description copied from interface: HibernateCriteriaBuilder

Literal expression corresponding to the value of pi.

Specified by:

pi in interface HibernateCriteriaBuilder

Returns:

pi expression

sin
```
public JpaExpression<Double> sin(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the sine of its argument.

Specified by:

sin in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

sine

cos
```
public JpaExpression<Double> cos(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the cosine of its argument.

Specified by:

cos in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

cosine

tan
```
public JpaExpression<Double> tan(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the tangent of its argument.

Specified by:

tan in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

tangent

asin
```
public JpaExpression<Double> asin(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the inverse sine of its argument.

Specified by:

asin in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse sine

acos
```
public JpaExpression<Double> acos(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the inverse cosine of its argument.

Specified by:

acos in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse cosine

atan
```
public JpaExpression<Double> atan(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the inverse tangent of its argument.

Specified by:

atan in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse tangent

atan2

public JpaExpression<Double> atan2(Number y,
                                   Expression<? extends Number> x)

Specified by:: atan2 in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.atan2(Expression, Expression)

atan2

public JpaExpression<Double> atan2(Expression<? extends Number> y,
                                   Number x)

Specified by:: atan2 in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.atan2(Expression, Expression)

atan2
```
public JpaExpression<Double> atan2(Expression<? extends Number> y,
                                   Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the inverse tangent of y over x.

Specified by:

atan2 in interface HibernateCriteriaBuilder

Parameters:

y - y coordinate

x - x coordinate

Returns:

2-argument inverse tangent

sinh
```
public JpaExpression<Double> sinh(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the hyperbolic sine of its argument.

Specified by:

sinh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic sine

cosh
```
public JpaExpression<Double> cosh(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the hyperbolic cosine of its argument.

Specified by:

cosh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic cosine

tanh
```
public JpaExpression<Double> tanh(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the hyperbolic tangent of its argument.

Specified by:

tanh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic tangent

degrees
```
public JpaExpression<Double> degrees(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.

Specified by:

degrees in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

degrees

radians
```
public JpaExpression<Double> radians(Expression<? extends Number> x)
```
Description copied from interface: HibernateCriteriaBuilder

Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.

Specified by:

radians in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

radians

createWindow
```
public JpaWindow createWindow()
```
Description copied from interface: HibernateCriteriaBuilder

Create an empty JpaWindow to use with window and aggregate functions.

Specified by:

createWindow in interface HibernateCriteriaBuilder

Returns:

the empty window

frameUnboundedPreceding
```
public JpaWindowFrame frameUnboundedPreceding()
```
Description copied from interface: HibernateCriteriaBuilder

Create a window frame of type FrameKind.UNBOUNDED_PRECEDING to use with JpaWindows.

Specified by:

frameUnboundedPreceding in interface HibernateCriteriaBuilder

Returns:

the window frame

frameBetweenPreceding
```
public JpaWindowFrame frameBetweenPreceding(int offset)
```
Specified by:

frameBetweenPreceding in interface HibernateCriteriaBuilder

See Also:

HibernateCriteriaBuilder.frameBetweenPreceding(Expression)

frameBetweenPreceding
```
public JpaWindowFrame frameBetweenPreceding(Expression<?> offset)
```
Description copied from interface: HibernateCriteriaBuilder

Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.

Specified by:

frameBetweenPreceding in interface HibernateCriteriaBuilder

Parameters:

offset - the offset expression

Returns:

the window frame

frameCurrentRow
```
public JpaWindowFrame frameCurrentRow()
```
Description copied from interface: HibernateCriteriaBuilder

Create a window frame of type FrameKind.CURRENT_ROW to use with JpaWindows.

Specified by:

frameCurrentRow in interface HibernateCriteriaBuilder

Returns:

the window frame

frameBetweenFollowing
```
public JpaWindowFrame frameBetweenFollowing(int offset)
```
Specified by:

frameBetweenFollowing in interface HibernateCriteriaBuilder

See Also:

HibernateCriteriaBuilder.frameBetweenFollowing(Expression)

frameBetweenFollowing
```
public JpaWindowFrame frameBetweenFollowing(Expression<?> offset)
```
Description copied from interface: HibernateCriteriaBuilder

Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.

Specified by:

frameBetweenFollowing in interface HibernateCriteriaBuilder

Parameters:

offset - the offset expression

Returns:

the window frame

frameUnboundedFollowing
```
public JpaWindowFrame frameUnboundedFollowing()
```
Description copied from interface: HibernateCriteriaBuilder

Create a window frame of type FrameKind.UNBOUNDED_FOLLOWING to use with JpaWindows.

Specified by:

frameUnboundedFollowing in interface HibernateCriteriaBuilder

Returns:

the window frame

windowFunction
```
public <T> JpaExpression<T> windowFunction(String name,
                                           Class<T> type,
                                           JpaWindow window,
                                           Expression<?>... args)
```
Description copied from interface: HibernateCriteriaBuilder

Create a generic window function expression that will be applied over the specified window.

Specified by:

windowFunction in interface HibernateCriteriaBuilder

Type Parameters:

T - type of this expression

Parameters:

name - name of the window function

type - type of this expression

window - window over which the function will be applied

args - arguments to the function

Returns:

window function expression

rowNumber
```
public JpaExpression<Long> rowNumber(JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a row_number window function expression.

Specified by:

rowNumber in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

firstValue
```
public <T> JpaExpression<T> firstValue(Expression<T> argument,
                                       JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a first_value window function expression.

Specified by:

firstValue in interface HibernateCriteriaBuilder

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to first_value

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

lastValue
```
public <T> JpaExpression<T> lastValue(Expression<T> argument,
                                      JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a last_value window function expression.

Specified by:

lastValue in interface HibernateCriteriaBuilder

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to last_value

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

nthValue

public <T> JpaExpression<T> nthValue(Expression<T> argument,
                                     int n,
                                     JpaWindow window)

Specified by:: nthValue in interface HibernateCriteriaBuilder
See Also:: nthValue

nthValue
```
public <T> JpaExpression<T> nthValue(Expression<T> argument,
                                     Expression<Integer> n,
                                     JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a nth_value window function expression.

Specified by:

nthValue in interface HibernateCriteriaBuilder

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to nth_value

n - the N argument for the function

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

rank
```
public JpaExpression<Long> rank(JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a rank window function expression.

Specified by:

rank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

denseRank
```
public JpaExpression<Long> denseRank(JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a dense_rank window function expression.

Specified by:

denseRank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

percentRank
```
public JpaExpression<Double> percentRank(JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a percent_rank window function expression.

Specified by:

percentRank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

cumeDist
```
public JpaExpression<Double> cumeDist(JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a cume_dist window function expression.

Specified by:

cumeDist in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)

functionAggregate

public <T> JpaExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaPredicate filter,
                                              Expression<?>... args)

Specified by:: functionAggregate in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)

functionAggregate

public <T> JpaExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaWindow window,
                                              Expression<?>... args)

Specified by:: functionAggregate in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)

functionAggregate

public <T> JpaExpression<T> functionAggregate(String name,
                                              Class<T> type,
                                              JpaPredicate filter,
                                              JpaWindow window,
                                              Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

Create a generic aggregate function expression.

Specified by:: functionAggregate in interface HibernateCriteriaBuilder
Type Parameters:: T - type of this expression
Parameters:: name - name of the ordered set-aggregate function; type - type of this expression; filter - optional filter clause; window - optional window over which to apply the function; args - optional arguments to the function
Returns:: aggregate function expression

sum

public <N extends Number> JpaExpression<Number> sum(Expression<N> argument,
                                                    JpaPredicate filter)

Specified by:: sum in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)

sum

public <N extends Number> JpaExpression<Number> sum(Expression<N> argument,
                                                    JpaWindow window)

Specified by:: sum in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)

sum
```
public <N extends Number> JpaExpression<Number> sum(Expression<N> argument,
                                                    JpaPredicate filter,
                                                    JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a sum aggregate function expression.

Specified by:

sum in interface HibernateCriteriaBuilder

Type Parameters:

N - type of the input expression

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)

avg

public <N extends Number> JpaExpression<Double> avg(Expression<N> argument,
                                                    JpaPredicate filter)

Specified by:: avg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)

avg

public <N extends Number> JpaExpression<Double> avg(Expression<N> argument,
                                                    JpaWindow window)

Specified by:: avg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)

avg
```
public <N extends Number> JpaExpression<Double> avg(Expression<N> argument,
                                                    JpaPredicate filter,
                                                    JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create an avg aggregate function expression.

Specified by:

avg in interface HibernateCriteriaBuilder

Type Parameters:

N - type of the input expression

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)

count

public JpaExpression<Long> count(Expression<?> argument,
                                 JpaPredicate filter)

Specified by:: count in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)

count

public JpaExpression<Long> count(Expression<?> argument,
                                 JpaWindow window)

Specified by:: count in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)

count
```
public JpaExpression<Long> count(Expression<?> argument,
                                 JpaPredicate filter,
                                 JpaWindow window)
```
Description copied from interface: HibernateCriteriaBuilder

Create a count aggregate function expression.

Specified by:

count in interface HibernateCriteriaBuilder

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)

functionWithinGroup

public <T> JpaExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                Expression<?>... args)

Specified by:: functionWithinGroup in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

functionWithinGroup

public <T> JpaExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaPredicate filter,
                                                Expression<?>... args)

Specified by:: functionWithinGroup in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

functionWithinGroup

public <T> JpaExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaWindow window,
                                                Expression<?>... args)

Specified by:: functionWithinGroup in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

functionWithinGroup

public <T> JpaExpression<T> functionWithinGroup(String name,
                                                Class<T> type,
                                                JpaOrder order,
                                                JpaPredicate filter,
                                                JpaWindow window,
                                                Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

Create a generic ordered set-aggregate function expression.

Specified by:: functionWithinGroup in interface HibernateCriteriaBuilder
Type Parameters:: T - type of this expression
Parameters:: name - name of the ordered set-aggregate function; type - type of this expression; order - order by clause used in within group; filter - optional filter clause; window - optional window over which to apply the function; args - optional arguments to the function
Returns:: ordered set-aggregate function expression

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     Expression<String> argument,
                                     String separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     Expression<String> argument,
                                     Expression<String> separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     Expression<String> argument,
                                     String separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     Expression<String> argument,
                                     Expression<String> separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     String separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     Expression<String> separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

public JpaExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     String separator)

Specified by:: listagg in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg
```
public JpaExpression<String> listagg(JpaOrder order,
                                     JpaPredicate filter,
                                     JpaWindow window,
                                     Expression<String> argument,
                                     Expression<String> separator)
```
Description copied from interface: HibernateCriteriaBuilder

Create a listagg ordered set-aggregate function expression.

Specified by:

listagg in interface HibernateCriteriaBuilder

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

argument - values to join

separator - the separator used to join the values

Returns:

ordered set-aggregate expression

See Also:

HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

mode

public <T> JpaExpression<T> mode(Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)

Specified by:: mode in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode

public <T> JpaExpression<T> mode(JpaPredicate filter,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)

Specified by:: mode in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode

public <T> JpaExpression<T> mode(JpaWindow window,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)

Specified by:: mode in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode
```
public <T> JpaExpression<T> mode(JpaPredicate filter,
                                 JpaWindow window,
                                 Expression<T> sortExpression,
                                 SortOrder sortOrder,
                                 NullPrecedence nullPrecedence)
```
Description copied from interface: HibernateCriteriaBuilder

Create a mode ordered set-aggregate function expression.

Specified by:

mode in interface HibernateCriteriaBuilder

Type Parameters:

T - type of this expression

Parameters:

filter - optional filter clause

window - optional window over which to apply the function

sortExpression - the sort expression

sortOrder - the sort order

nullPrecedence - the null precedence

Returns:

ordered set-aggregate expression

See Also:

HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentileCont

public <T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileCont in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

public <T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileCont in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

public <T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileCont in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

public <T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Description copied from interface: HibernateCriteriaBuilder

Create a percentile_cont ordered set-aggregate function expression.

Specified by:: percentileCont in interface HibernateCriteriaBuilder
Parameters:: argument - argument to the function; filter - optional filter clause; window - optional window over which to apply the function; sortExpression - the sort expression; sortOrder - the sort order; nullPrecedence - the null precedence
Returns:: ordered set-aggregate expression
See Also:: HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentileDisc

public <T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileDisc in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

public <T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileDisc in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

public <T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Specified by:: percentileDisc in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

public <T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
                                           JpaPredicate filter,
                                           JpaWindow window,
                                           Expression<T> sortExpression,
                                           SortOrder sortOrder,
                                           NullPrecedence nullPrecedence)

Description copied from interface: HibernateCriteriaBuilder

Create a percentile_disc ordered set-aggregate function expression.

Specified by:: percentileDisc in interface HibernateCriteriaBuilder
Parameters:: argument - argument to the function; filter - optional filter clause; window - optional window over which to apply the function; sortExpression - the sort expression; sortOrder - the sort order; nullPrecedence - the null precedence
Returns:: ordered set-aggregate expression
See Also:: HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

public JpaExpression<Long> rank(JpaOrder order,
                                Expression<?>... arguments)

Specified by:: rank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

public JpaExpression<Long> rank(JpaOrder order,
                                JpaPredicate filter,
                                Expression<?>... arguments)

Specified by:: rank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

public JpaExpression<Long> rank(JpaOrder order,
                                JpaWindow window,
                                Expression<?>... arguments)

Specified by:: rank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank
```
public JpaExpression<Long> rank(JpaOrder order,
                                JpaPredicate filter,
                                JpaWindow window,
                                Expression<?>... arguments)
```
Description copied from interface: HibernateCriteriaBuilder

Create a rank ordered set-aggregate function expression.

Specified by:

rank in interface HibernateCriteriaBuilder

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

arguments - arguments to the function

Returns:

ordered set-aggregate expression

See Also:

HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

public JpaExpression<Double> percentRank(JpaOrder order,
                                         Expression<?>... arguments)

Specified by:: percentRank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

public JpaExpression<Double> percentRank(JpaOrder order,
                                         JpaPredicate filter,
                                         Expression<?>... arguments)

Specified by:: percentRank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

public JpaExpression<Double> percentRank(JpaOrder order,
                                         JpaWindow window,
                                         Expression<?>... arguments)

Specified by:: percentRank in interface HibernateCriteriaBuilder
See Also:: HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank
```
public JpaExpression<Double> percentRank(JpaOrder order,
                                         JpaPredicate filter,
                                         JpaWindow window,
                                         Expression<?>... arguments)
```
Description copied from interface: HibernateCriteriaBuilder

Create a percent_rank ordered set-aggregate function expression.

Specified by:

percentRank in interface HibernateCriteriaBuilder

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

arguments - arguments to the function

Returns:

ordered set-aggregate expression

See Also:

HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)

Class HibernateCriteriaBuilderDelegate

Nested Class Summary

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

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

HibernateCriteriaBuilderDelegate

Method Detail

getCriteriaBuilder

cast

wrap

wrap

unwrap

createQuery

createQuery

createTupleQuery

createCriteriaUpdate

createCriteriaDelete

createCriteriaInsertSelect

unionAll

union

union

intersectAll

intersect

intersect

exceptAll

except

except

unionAll

union

union

intersectAll

intersect

intersect

exceptAll

except

except

sign

ceiling

floor

exp

ln

power

power

round

truncate

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