Package org.hibernate.query.criteria

Interface HibernateCriteriaBuilder

All Superinterfaces:

jakarta.persistence.criteria.CriteriaBuilder

All Known Subinterfaces:

GeolatteSpatialCriteriaBuilder, JTSSpatialCriteriaBuilder, NodeBuilder, SpatialCriteriaBuilder<T>

All Known Implementing Classes:

GeolatteSpatialCriteriaBuilderImpl, HibernateCriteriaBuilderDelegate, JTSSpatialCriteriaBuilderImpl, SpatialCriteriaBuilderImpl, SqmCriteriaNodeBuilder

public interface HibernateCriteriaBuilder
extends jakarta.persistence.criteria.CriteriaBuilder

Hibernate extensions to the JPA CriteriaBuilder.

Nested Class Summary

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

jakarta.persistence.criteria.CriteriaBuilder.Case<R extends Object>, jakarta.persistence.criteria.CriteriaBuilder.Coalesce<T extends Object>, jakarta.persistence.criteria.CriteriaBuilder.In<T extends Object>, jakarta.persistence.criteria.CriteriaBuilder.SimpleCase<C extends Object,R extends Object>, jakarta.persistence.criteria.CriteriaBuilder.Trimspec

Method Summary

Modifier and Type	Method	Description
<N extends Number> JpaExpression<N>	abs(jakarta.persistence.criteria.Expression<N> x)
JpaExpression<Double>	acos(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the inverse cosine of its argument.
<Y> JpaExpression<Y>	all(jakarta.persistence.criteria.Subquery<Y> subquery)
JpaPredicate	and(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)
JpaPredicate	and(jakarta.persistence.criteria.Predicate... restrictions)
<Y> JpaExpression<Y>	any(jakarta.persistence.criteria.Subquery<Y> subquery)
JpaCompoundSelection<Object[]>	array(jakarta.persistence.criteria.Selection<?>[] selections)
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, jakarta.persistence.criteria.Selection<?>[] selections)
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
JpaCompoundSelection<Object[]>	array(List<? extends JpaSelection<?>> selections)
JpaOrder	asc(jakarta.persistence.criteria.Expression<?> x)
JpaOrder	asc(jakarta.persistence.criteria.Expression<?> x, boolean nullsFirst)	Create an ordering by the ascending value of the expression.
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(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the inverse sine of its argument.
JpaExpression<Double>	atan(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the inverse tangent of its argument.
JpaExpression<Double>	atan2(jakarta.persistence.criteria.Expression<? extends Number> y, jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the inverse tangent of y over x.
JpaExpression<Double>	atan2(jakarta.persistence.criteria.Expression<? extends Number> y, Number x)
JpaExpression<Double>	atan2(Number y, jakarta.persistence.criteria.Expression<? extends Number> x)
<N extends Number> JpaExpression<Double>	avg(jakarta.persistence.criteria.Expression<N> argument)
<N extends Number> JpaExpression<Double>	avg(jakarta.persistence.criteria.Expression<N> argument, JpaPredicate filter)
<N extends Number> JpaExpression<Double>	avg(jakarta.persistence.criteria.Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create an avg aggregate function expression.
<N extends Number> JpaExpression<Double>	avg(jakarta.persistence.criteria.Expression<N> argument, JpaWindow window)
<Y extends Comparable<? super Y>> JpaPredicate	between(jakarta.persistence.criteria.Expression<? extends Y> value, jakarta.persistence.criteria.Expression<? extends Y> lower, jakarta.persistence.criteria.Expression<? extends Y> upper)
<Y extends Comparable<? super Y>> JpaPredicate	between(jakarta.persistence.criteria.Expression<? extends Y> value, Y lower, Y upper)
<X,T> JpaExpression<X>	cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
<N extends Number> JpaExpression<N>	ceiling(jakarta.persistence.criteria.Expression<N> x)	Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
<T> JpaCoalesce<T>	coalesce()
<Y> JpaCoalesce<Y>	coalesce(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y> JpaCoalesce<Y>	coalesce(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
JpaFunction<String>	collate(jakarta.persistence.criteria.Expression<String> x, String collation)
JpaExpression<String>	concat(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> y)
JpaExpression<String>	concat(jakarta.persistence.criteria.Expression<String> x, String y)
JpaExpression<String>	concat(String x, jakarta.persistence.criteria.Expression<String> y)
JpaExpression<String>	concat(String x, String y)
JpaPredicate	conjunction()
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, jakarta.persistence.criteria.Selection<?>[] selections)
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
JpaExpression<Double>	cos(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the cosine of its argument.
JpaExpression<Double>	cosh(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the hyperbolic cosine of its argument.
JpaExpression<Long>	count(jakarta.persistence.criteria.Expression<?> argument)
JpaExpression<Long>	count(jakarta.persistence.criteria.Expression<?> argument, JpaPredicate filter)
JpaExpression<Long>	count(jakarta.persistence.criteria.Expression<?> argument, JpaPredicate filter, JpaWindow window)	Create a count aggregate function expression.
JpaExpression<Long>	count(jakarta.persistence.criteria.Expression<?> argument, JpaWindow window)
JpaExpression<Long>	countDistinct(jakarta.persistence.criteria.Expression<?> x)
<T> JpaCriteriaDelete<T>	createCriteriaDelete(Class<T> targetEntity)
<T> JpaCriteriaInsertSelect<T>	createCriteriaInsertSelect(Class<T> targetEntity)
<T> JpaCriteriaUpdate<T>	createCriteriaUpdate(Class<T> targetEntity)
JpaCriteriaQuery<Object>	createQuery()
<T> JpaCriteriaQuery<T>	createQuery(Class<T> resultClass)
JpaCriteriaQuery<jakarta.persistence.Tuple>	createTupleQuery()
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(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.DAY of a date, time, or datetime expression.
JpaExpression<Double>	degrees(jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<?> x)
JpaOrder	desc(jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)
<N extends Number> JpaExpression<N>	diff(jakarta.persistence.criteria.Expression<? extends N> x, N y)
<N extends Number> JpaExpression<N>	diff(N x, jakarta.persistence.criteria.Expression<? extends N> y)
JpaPredicate	disjunction()
JpaPredicate	distinctFrom(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
JpaPredicate	distinctFrom(jakarta.persistence.criteria.Expression<?> x, Object y)
JpaPredicate	equal(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
JpaPredicate	equal(jakarta.persistence.criteria.Expression<?> x, Object y)
<T> JpaCriteriaQuery<T>	except(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	except(boolean all, jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	except(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	except(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	exceptAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	exceptAll(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
JpaPredicate	exists(jakarta.persistence.criteria.Subquery<?> subquery)
JpaExpression<Double>	exp(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
<T> JpaExpression<T>	firstValue(jakarta.persistence.criteria.Expression<T> argument, JpaWindow window)	Create a first_value window function expression.
<P,F> JpaExpression<F>	fk(jakarta.persistence.criteria.Path<P> path)
<N extends Number> JpaExpression<N>	floor(jakarta.persistence.criteria.Expression<N> x)	Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
JpaFunction<String>	format(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime, String pattern)	Format a date, time, or datetime according to a pattern.
JpaWindowFrame	frameBetweenFollowing(int offset)
JpaWindowFrame	frameBetweenFollowing(jakarta.persistence.criteria.Expression<?> offset)	Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.
JpaWindowFrame	frameBetweenPreceding(int offset)
JpaWindowFrame	frameBetweenPreceding(jakarta.persistence.criteria.Expression<?> offset)	Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.
JpaWindowFrame	frameCurrentRow()	Create a window frame of type FrameKind.CURRENT_ROW to use with JpaWindows.
JpaWindowFrame	frameUnboundedFollowing()	Create a window frame of type FrameKind.UNBOUNDED_FOLLOWING to use with JpaWindows.
JpaWindowFrame	frameUnboundedPreceding()	Create a window frame of type FrameKind.UNBOUNDED_PRECEDING to use with JpaWindows.
<T> JpaFunction<T>	function(String name, Class<T> type, jakarta.persistence.criteria.Expression<?>[] args)
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... args)
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)	Create a generic aggregate function expression.
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, jakarta.persistence.criteria.Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)	Create a generic ordered set-aggregate function expression.
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)
JpaPredicate	ge(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaPredicate	ge(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
<X extends Comparable<? super X>> JpaExpression<X>	greatest(jakarta.persistence.criteria.Expression<X> argument)
JpaPredicate	gt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaPredicate	gt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
JpaFunction<Integer>	hour(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, String pattern)
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
JpaPredicate	ilike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
<T> JpaInPredicate<T>	in(jakarta.persistence.criteria.Expression<? extends T> expression)
<T> JpaInPredicate<T>	in(jakarta.persistence.criteria.Expression<? extends T> expression, jakarta.persistence.criteria.Expression<? extends T>... values)
<T> JpaInPredicate<T>	in(jakarta.persistence.criteria.Expression<? extends T> expression, Collection<T> values)
<T> JpaInPredicate<T>	in(jakarta.persistence.criteria.Expression<? extends T> expression, T... values)
<K,L extends List<?>> JpaExpression<Set<K>>	indexes(L list)
<T> JpaCriteriaQuery<T>	intersect(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	intersect(boolean all, jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	intersect(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	intersect(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	intersectAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	intersectAll(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
<C extends Collection<?>> JpaPredicate	isEmpty(jakarta.persistence.criteria.Expression<C> collection)
JpaPredicate	isFalse(jakarta.persistence.criteria.Expression<Boolean> x)
<M extends Map<?,?>> JpaPredicate	isMapEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is empty.
<M extends Map<?,?>> JpaPredicate	isMapNotEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is not empty.
<E,C extends Collection<E>> JpaPredicate	isMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>> JpaPredicate	isMember(jakarta.persistence.criteria.Expression<E> elem, jakarta.persistence.criteria.Expression<C> collection)
<C extends Collection<?>> JpaPredicate	isNotEmpty(jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>> JpaPredicate	isNotMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>> JpaPredicate	isNotMember(jakarta.persistence.criteria.Expression<E> elem, jakarta.persistence.criteria.Expression<C> collection)
JpaPredicate	isNotNull(jakarta.persistence.criteria.Expression<?> x)
JpaPredicate	isNull(jakarta.persistence.criteria.Expression<?> x)
JpaPredicate	isTrue(jakarta.persistence.criteria.Expression<Boolean> x)
<K,M extends Map<K,?>> JpaExpression<Set<K>>	keys(M map)
<T> JpaExpression<T>	lastValue(jakarta.persistence.criteria.Expression<T> argument, JpaWindow window)	Create a last_value window function expression.
JpaPredicate	le(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaPredicate	le(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
<X extends Comparable<? super X>> JpaExpression<X>	least(jakarta.persistence.criteria.Expression<X> argument)
JpaFunction<String>	left(jakarta.persistence.criteria.Expression<String> x, int length)
JpaFunction<String>	left(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)	Extract the length leftmost characters of a string.
JpaFunction<Integer>	length(jakarta.persistence.criteria.Expression<String> x)
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, String pattern)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
JpaPredicate	like(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaExpression<String>	listagg(JpaOrder order, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, jakarta.persistence.criteria.Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)	Create a listagg ordered set-aggregate function expression.
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the natural logarithm of its argument.
JpaExpression<LocalDate>	localDate()	Create expression to return current local date.
JpaExpression<LocalDateTime>	localDateTime()	Create expression to return current local datetime.
JpaExpression<LocalTime>	localTime()	Create expression to return current local time.
JpaFunction<Integer>	locate(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
JpaFunction<Integer>	locate(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Integer> from)
JpaFunction<Integer>	locate(jakarta.persistence.criteria.Expression<String> x, String pattern)
JpaFunction<Integer>	locate(jakarta.persistence.criteria.Expression<String> x, String pattern, int from)
JpaExpression<Double>	log(jakarta.persistence.criteria.Expression<? extends Number> b, jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the logarithm of x to the base b.
JpaExpression<Double>	log(Number b, jakarta.persistence.criteria.Expression<? extends Number> x)
JpaExpression<Double>	log10(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the base-10 logarithm of its argument.
JpaFunction<String>	lower(jakarta.persistence.criteria.Expression<String> x)
JpaPredicate	lt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaPredicate	lt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
<M extends Map<?,?>> JpaExpression<Integer>	mapSize(M map)	Create an expression that tests the size of a map.
<M extends Map<?,?>> JpaExpression<Integer>	mapSize(JpaExpression<M> mapExpression)	Create an expression that tests the size of a map.
<N extends Number> JpaExpression<N>	max(jakarta.persistence.criteria.Expression<N> argument)
<N extends Number> JpaExpression<N>	min(jakarta.persistence.criteria.Expression<N> argument)
JpaFunction<Integer>	minute(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.
JpaExpression<Integer>	mod(jakarta.persistence.criteria.Expression<Integer> x, jakarta.persistence.criteria.Expression<Integer> y)
JpaExpression<Integer>	mod(jakarta.persistence.criteria.Expression<Integer> x, Integer y)
JpaExpression<Integer>	mod(Integer x, jakarta.persistence.criteria.Expression<Integer> y)
<T> JpaExpression<T>	mode(jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)	Create a mode ordered set-aggregate function expression.
<T> JpaExpression<T>	mode(JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
JpaFunction<Integer>	month(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
<N extends Number> JpaExpression<N>	neg(jakarta.persistence.criteria.Expression<N> x)
JpaPredicate	not(jakarta.persistence.criteria.Expression<Boolean> restriction)
JpaPredicate	notDistinctFrom(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
JpaPredicate	notDistinctFrom(jakarta.persistence.criteria.Expression<?> x, Object y)
JpaPredicate	notEqual(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
JpaPredicate	notEqual(jakarta.persistence.criteria.Expression<?> x, Object y)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
JpaPredicate	notIlike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, String pattern)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
JpaPredicate	notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
<T> JpaExpression<T>	nthValue(jakarta.persistence.criteria.Expression<T> argument, int n, JpaWindow window)
<T> JpaExpression<T>	nthValue(jakarta.persistence.criteria.Expression<T> argument, jakarta.persistence.criteria.Expression<Integer> n, JpaWindow window)	Create a nth_value window function expression.
<Y> JpaExpression<Y>	nullif(jakarta.persistence.criteria.Expression<Y> x, jakarta.persistence.criteria.Expression<?> y)
<Y> JpaExpression<Y>	nullif(jakarta.persistence.criteria.Expression<Y> x, Y y)
<T> JpaExpression<T>	nullLiteral(Class<T> resultClass)
JpaPredicate	or(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)
JpaPredicate	or(jakarta.persistence.criteria.Predicate... restrictions)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start, int length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start, jakarta.persistence.criteria.Expression<Integer> length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, jakarta.persistence.criteria.Expression<Integer> start)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, jakarta.persistence.criteria.Expression<Integer> start, int length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, jakarta.persistence.criteria.Expression<Integer> start, jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<String> string, String replacement, int start)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, int start, int length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, int start, jakarta.persistence.criteria.Expression<Integer> length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start, int length)
JpaFunction<String>	overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start, jakarta.persistence.criteria.Expression<Integer> length)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length, char padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length, jakarta.persistence.criteria.Expression<Character> padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, char padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, jakarta.persistence.criteria.Expression<Character> padChar)	Pad the specified string expression with whitespace or with the padChar character if specified.
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, int length)
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, int length, char padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, int length, jakarta.persistence.criteria.Expression<Character> padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, char padChar)
JpaFunction<String>	pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, jakarta.persistence.criteria.Expression<Character> padChar)
<T> JpaParameterExpression<T>	parameter(Class<T> paramClass)
<T> JpaParameterExpression<T>	parameter(Class<T> paramClass, String name)
<T> JpaExpression<T>	percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)	Create a percentile_cont ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)	Create a percentile_disc ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
JpaExpression<Double>	percentRank(JpaOrder order, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)	Create a percent_rank ordered set-aggregate function expression.
JpaExpression<Double>	percentRank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)	Create an expression that returns the first argument raised to the power of its second argument.
JpaExpression<Double>	power(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)	Create an expression that returns the first argument raised to the power of its second argument.
<N extends Number> JpaExpression<N>	prod(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)
<N extends Number> JpaExpression<N>	prod(jakarta.persistence.criteria.Expression<? extends N> x, N y)
<N extends Number> JpaExpression<N>	prod(N x, jakarta.persistence.criteria.Expression<? extends N> y)
JpaExpression<Number>	quot(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaExpression<Number>	quot(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
JpaExpression<Number>	quot(Number x, jakarta.persistence.criteria.Expression<? extends Number> y)
JpaExpression<Double>	radians(jakarta.persistence.criteria.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, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Long>	rank(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Long>	rank(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)	Create a rank ordered set-aggregate function expression.
JpaExpression<Long>	rank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Long>	rank(JpaWindow window)	Create a rank window function expression.
JpaFunction<String>	replace(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, jakarta.persistence.criteria.Expression<String> replacement)	Replace all occurrences of pattern within the original string with replacement.
JpaFunction<String>	replace(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, String replacement)
JpaFunction<String>	replace(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<String> replacement)
JpaFunction<String>	replace(jakarta.persistence.criteria.Expression<String> x, String pattern, String replacement)
JpaFunction<String>	right(jakarta.persistence.criteria.Expression<String> x, int length)
JpaFunction<String>	right(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)	Extract the length rightmost characters of a string.
<T extends Number> JpaExpression<T>	round(jakarta.persistence.criteria.Expression<T> x, Integer n)	Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
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(jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<? extends C> expression)
JpaExpression<Integer>	sign(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
JpaExpression<Double>	sin(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the sine of its argument.
JpaExpression<Double>	sinh(jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<C> collection)
<Y> JpaExpression<Y>	some(jakarta.persistence.criteria.Subquery<Y> subquery)
JpaOrder	sort(JpaExpression<?> sortExpression)
JpaOrder	sort(JpaExpression<?> sortExpression, SortOrder sortOrder)
JpaOrder	sort(JpaExpression<?> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	sql(String pattern, Class<T> type, jakarta.persistence.criteria.Expression<?>... arguments)	Embed native pattern that will be unquoted and embedded in the generated SQL.
JpaExpression<Double>	sqrt(jakarta.persistence.criteria.Expression<? extends Number> x)
JpaFunction<String>	substring(jakarta.persistence.criteria.Expression<String> x, int from)
JpaFunction<String>	substring(jakarta.persistence.criteria.Expression<String> x, int from, int len)
JpaFunction<String>	substring(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> from)
JpaFunction<String>	substring(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> from, jakarta.persistence.criteria.Expression<Integer> len)
<N extends Number> JpaExpression<N>	sum(jakarta.persistence.criteria.Expression<? extends N> x, jakarta.persistence.criteria.Expression<? extends N> y)
<N extends Number> JpaExpression<N>	sum(jakarta.persistence.criteria.Expression<? extends N> x, N y)
<N extends Number> JpaExpression<N>	sum(jakarta.persistence.criteria.Expression<N> argument)
<N extends Number> JpaExpression<Number>	sum(jakarta.persistence.criteria.Expression<N> argument, JpaPredicate filter)
<N extends Number> JpaExpression<Number>	sum(jakarta.persistence.criteria.Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create a sum aggregate function expression.
<N extends Number> JpaExpression<Number>	sum(jakarta.persistence.criteria.Expression<N> argument, JpaWindow window)
<N extends Number> JpaExpression<N>	sum(N x, jakarta.persistence.criteria.Expression<? extends N> y)
JpaExpression<Double>	sumAsDouble(jakarta.persistence.criteria.Expression<Float> argument)
JpaExpression<Long>	sumAsLong(jakarta.persistence.criteria.Expression<Integer> argument)
JpaExpression<Double>	tan(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the tangent of its argument.
JpaExpression<Double>	tanh(jakarta.persistence.criteria.Expression<? extends Number> x)	Create an expression that returns the hyperbolic tangent of its argument.
JpaExpression<BigDecimal>	toBigDecimal(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<BigInteger>	toBigInteger(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<Double>	toDouble(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<Float>	toFloat(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<Integer>	toInteger(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<Long>	toLong(jakarta.persistence.criteria.Expression<? extends Number> number)
JpaExpression<String>	toString(jakarta.persistence.criteria.Expression<Character> character)
<X,T,E extends T> JpaCollectionJoin<X,E>	treat(jakarta.persistence.criteria.CollectionJoin<X,T> join, Class<E> type)
<X,T,V extends T> JpaJoin<X,V>	treat(jakarta.persistence.criteria.Join<X,T> join, Class<V> type)
<X,T,E extends T> JpaListJoin<X,E>	treat(jakarta.persistence.criteria.ListJoin<X,T> join, Class<E> type)
<X,K,T,V extends T> JpaMapJoin<X,K,V>	treat(jakarta.persistence.criteria.MapJoin<X,K,T> join, Class<V> type)
<X,T extends X> JpaPath<T>	treat(jakarta.persistence.criteria.Path<X> path, Class<T> type)
<X,T extends X> JpaRoot<T>	treat(jakarta.persistence.criteria.Root<X> root, Class<T> type)
<X,T,E extends T> JpaSetJoin<X,E>	treat(jakarta.persistence.criteria.SetJoin<X,T> join, Class<E> type)
JpaFunction<String>	trim(char t, jakarta.persistence.criteria.Expression<String> x)
JpaFunction<String>	trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, char t, jakarta.persistence.criteria.Expression<String> x)
JpaFunction<String>	trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<Character> t, jakarta.persistence.criteria.Expression<String> x)
JpaFunction<String>	trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x)
JpaFunction<String>	trim(jakarta.persistence.criteria.Expression<Character> t, jakarta.persistence.criteria.Expression<String> x)
JpaFunction<String>	trim(jakarta.persistence.criteria.Expression<String> x)
<T extends Number> JpaExpression<T>	truncate(jakarta.persistence.criteria.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(jakarta.persistence.criteria.Expression<T> datetime, TemporalUnit temporalUnit)	Truncates a date, time or datetime expression to the given TemporalUnit.
JpaCompoundSelection<jakarta.persistence.Tuple>	tuple(jakarta.persistence.criteria.Selection<?>[] selections)
JpaCompoundSelection<jakarta.persistence.Tuple>	tuple(List<? extends JpaSelection<?>> selections)
<T> JpaCriteriaQuery<T>	union(boolean all, jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	union(boolean all, jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	union(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	union(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	unionAll(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1, jakarta.persistence.criteria.CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	unionAll(jakarta.persistence.criteria.Subquery<? extends T> query1, jakarta.persistence.criteria.Subquery<?>... queries)
<T extends HibernateCriteriaBuilder> T	unwrap(Class<T> clazz)
JpaFunction<String>	upper(jakarta.persistence.criteria.Expression<String> x)
<T> SqmExpression<T>	value(T value)
<T> SqmExpression<T>	value(T value, SqmExpression<? extends T> typeInferenceSource)
<V,C extends Collection<V>> JpaExpression<Collection<V>>	values(C collection)
<V,M extends Map<?,V>> jakarta.persistence.criteria.Expression<Collection<V>>	values(M map)
<T> JpaExpression<T>	windowFunction(String name, Class<T> type, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)	Create a generic window function expression that will be applied over the specified window.
JpaPredicate	wrap(jakarta.persistence.criteria.Expression<Boolean> expression)
JpaPredicate	wrap(jakarta.persistence.criteria.Expression<Boolean>... expressions)
JpaFunction<Integer>	year(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.

Method Detail

cast

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

wrap

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

wrap

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

unwrap

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

createQuery

JpaCriteriaQuery<Object> createQuery()

Specified by:

createQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createQuery

<T> JpaCriteriaQuery<T> createQuery(Class<T> resultClass)

Specified by:

createQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createTupleQuery

JpaCriteriaQuery<jakarta.persistence.Tuple> createTupleQuery()

Specified by:

createTupleQuery in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaUpdate

<T> JpaCriteriaUpdate<T> createCriteriaUpdate(Class<T> targetEntity)

Specified by:

createCriteriaUpdate in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaDelete

<T> JpaCriteriaDelete<T> createCriteriaDelete(Class<T> targetEntity)

Specified by:

createCriteriaDelete in interface jakarta.persistence.criteria.CriteriaBuilder

createCriteriaInsertSelect

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

unionAll

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

union

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

union

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

intersectAll

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

intersect

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

intersect

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

exceptAll

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

except

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

except

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

unionAll

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

union

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

union

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

intersectAll

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

intersect

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

intersect

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

exceptAll

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

except

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

except

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

sign

JpaExpression<Integer> sign(jakarta.persistence.criteria.Expression<? extends Number> x)

Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.

Specified by:

sign in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - expression

Returns:

sign

ceiling

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

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

Specified by:

ceiling in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - expression

Returns:

ceiling

floor

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

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

Specified by:

floor in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - expression

Returns:

floor

exp

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

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

Specified by:

exp in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - expression

Returns:

exponential

ln

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

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

Specified by:

ln in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - expression

Returns:

natural logarithm

power

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

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

Specified by:

power in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

power

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

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

Specified by:

power in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

round

<T extends Number> JpaExpression<T> round(jakarta.persistence.criteria.Expression<T> x,
                                          Integer n)

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

Specified by:

round in interface jakarta.persistence.criteria.CriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the rounded value

truncate

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

Parameters:

x - base

n - number of decimal places

Returns:

the truncated value

localDate

JpaExpression<LocalDate> localDate()

Create expression to return current local date.

Specified by:

localDate in interface jakarta.persistence.criteria.CriteriaBuilder

Returns:

expression for current date

localDateTime

JpaExpression<LocalDateTime> localDateTime()

Create expression to return current local datetime.

Specified by:

localDateTime in interface jakarta.persistence.criteria.CriteriaBuilder

Returns:

expression for current timestamp

localTime

JpaExpression<LocalTime> localTime()

Create expression to return current local time.

Specified by:

localTime in interface jakarta.persistence.criteria.CriteriaBuilder

Returns:

expression for current time

fk

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

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

treat

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

Specified by:

treat in interface jakarta.persistence.criteria.CriteriaBuilder

construct

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

Specified by:

construct in interface jakarta.persistence.criteria.CriteriaBuilder

construct

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

tuple

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

Specified by:

tuple in interface jakarta.persistence.criteria.CriteriaBuilder

tuple

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

array

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

Specified by:

array in interface jakarta.persistence.criteria.CriteriaBuilder

array

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

array

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

array

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

avg

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

Specified by:

avg in interface jakarta.persistence.criteria.CriteriaBuilder

sum

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

Specified by:

sum in interface jakarta.persistence.criteria.CriteriaBuilder

sumAsLong

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

Specified by:

sumAsLong in interface jakarta.persistence.criteria.CriteriaBuilder

sumAsDouble

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

Specified by:

sumAsDouble in interface jakarta.persistence.criteria.CriteriaBuilder

max

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

Specified by:

max in interface jakarta.persistence.criteria.CriteriaBuilder

min

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

Specified by:

min in interface jakarta.persistence.criteria.CriteriaBuilder

greatest

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

Specified by:

greatest in interface jakarta.persistence.criteria.CriteriaBuilder

least

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

Specified by:

least in interface jakarta.persistence.criteria.CriteriaBuilder

count

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

Specified by:

count in interface jakarta.persistence.criteria.CriteriaBuilder

countDistinct

JpaExpression<Long> countDistinct(jakarta.persistence.criteria.Expression<?> x)

Specified by:

countDistinct in interface jakarta.persistence.criteria.CriteriaBuilder

neg

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

Specified by:

neg in interface jakarta.persistence.criteria.CriteriaBuilder

abs

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

Specified by:

abs in interface jakarta.persistence.criteria.CriteriaBuilder

sum

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

Specified by:

sum in interface jakarta.persistence.criteria.CriteriaBuilder

sum

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

Specified by:

sum in interface jakarta.persistence.criteria.CriteriaBuilder

sum

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

Specified by:

sum in interface jakarta.persistence.criteria.CriteriaBuilder

prod

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

Specified by:

prod in interface jakarta.persistence.criteria.CriteriaBuilder

prod

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

Specified by:

prod in interface jakarta.persistence.criteria.CriteriaBuilder

prod

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

Specified by:

prod in interface jakarta.persistence.criteria.CriteriaBuilder

diff

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

Specified by:

diff in interface jakarta.persistence.criteria.CriteriaBuilder

diff

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

Specified by:

diff in interface jakarta.persistence.criteria.CriteriaBuilder

diff

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

Specified by:

diff in interface jakarta.persistence.criteria.CriteriaBuilder

quot

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

Specified by:

quot in interface jakarta.persistence.criteria.CriteriaBuilder

quot

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

Specified by:

quot in interface jakarta.persistence.criteria.CriteriaBuilder

quot

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

Specified by:

quot in interface jakarta.persistence.criteria.CriteriaBuilder

mod

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

Specified by:

mod in interface jakarta.persistence.criteria.CriteriaBuilder

mod

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

Specified by:

mod in interface jakarta.persistence.criteria.CriteriaBuilder

mod

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

Specified by:

mod in interface jakarta.persistence.criteria.CriteriaBuilder

sqrt

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

Specified by:

sqrt in interface jakarta.persistence.criteria.CriteriaBuilder

toLong

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

Specified by:

toLong in interface jakarta.persistence.criteria.CriteriaBuilder

toInteger

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

Specified by:

toInteger in interface jakarta.persistence.criteria.CriteriaBuilder

toFloat

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

Specified by:

toFloat in interface jakarta.persistence.criteria.CriteriaBuilder

toDouble

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

Specified by:

toDouble in interface jakarta.persistence.criteria.CriteriaBuilder

toBigDecimal

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

Specified by:

toBigDecimal in interface jakarta.persistence.criteria.CriteriaBuilder

toBigInteger

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

Specified by:

toBigInteger in interface jakarta.persistence.criteria.CriteriaBuilder

toString

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

Specified by:

toString in interface jakarta.persistence.criteria.CriteriaBuilder

literal

<T> JpaExpression<T> literal(T value)

Specified by:

literal in interface jakarta.persistence.criteria.CriteriaBuilder

literal

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

literals

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

literals

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

nullLiteral

<T> JpaExpression<T> nullLiteral(Class<T> resultClass)

Specified by:

nullLiteral in interface jakarta.persistence.criteria.CriteriaBuilder

parameter

<T> JpaParameterExpression<T> parameter(Class<T> paramClass)

Specified by:

parameter in interface jakarta.persistence.criteria.CriteriaBuilder

parameter

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

Specified by:

parameter in interface jakarta.persistence.criteria.CriteriaBuilder

concat

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

Specified by:

concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

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

Specified by:

concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

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

Specified by:

concat in interface jakarta.persistence.criteria.CriteriaBuilder

concat

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

substring

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

Specified by:

substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

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

Specified by:

substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

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

Specified by:

substring in interface jakarta.persistence.criteria.CriteriaBuilder

substring

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

Specified by:

substring in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

trim

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

Specified by:

trim in interface jakarta.persistence.criteria.CriteriaBuilder

lower

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

Specified by:

lower in interface jakarta.persistence.criteria.CriteriaBuilder

upper

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

Specified by:

upper in interface jakarta.persistence.criteria.CriteriaBuilder

length

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

Specified by:

length in interface jakarta.persistence.criteria.CriteriaBuilder

locate

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

Specified by:

locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

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

Specified by:

locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

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

Specified by:

locate in interface jakarta.persistence.criteria.CriteriaBuilder

locate

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

Specified by:

locate in interface jakarta.persistence.criteria.CriteriaBuilder

currentDate

JpaFunction<Date> currentDate()

Specified by:

currentDate in interface jakarta.persistence.criteria.CriteriaBuilder

currentTime

JpaFunction<Time> currentTime()

Specified by:

currentTime in interface jakarta.persistence.criteria.CriteriaBuilder

currentTimestamp

JpaFunction<Timestamp> currentTimestamp()

Specified by:

currentTimestamp in interface jakarta.persistence.criteria.CriteriaBuilder

currentInstant

JpaFunction<Instant> currentInstant()

function

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

Specified by:

function in interface jakarta.persistence.criteria.CriteriaBuilder

all

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

Specified by:

all in interface jakarta.persistence.criteria.CriteriaBuilder

some

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

Specified by:

some in interface jakarta.persistence.criteria.CriteriaBuilder

any

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

Specified by:

any in interface jakarta.persistence.criteria.CriteriaBuilder

keys

<K,M extends Map<K,?>> JpaExpression<Set<K>> keys(M map)

Specified by:

keys in interface jakarta.persistence.criteria.CriteriaBuilder

indexes

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

value

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

value

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

values

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

values

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

Specified by:

values in interface jakarta.persistence.criteria.CriteriaBuilder

size

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

Specified by:

size in interface jakarta.persistence.criteria.CriteriaBuilder

size

<C extends Collection<?>> JpaExpression<Integer> size(C collection)

Specified by:

size in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce

<T> JpaCoalesce<T> coalesce()

Specified by:

coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce

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

Specified by:

coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

coalesce

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

Specified by:

coalesce in interface jakarta.persistence.criteria.CriteriaBuilder

nullif

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

Specified by:

nullif in interface jakarta.persistence.criteria.CriteriaBuilder

nullif

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

Specified by:

nullif in interface jakarta.persistence.criteria.CriteriaBuilder

selectCase

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

Specified by:

selectCase in interface jakarta.persistence.criteria.CriteriaBuilder

selectCase

<R> JpaSearchedCase<R> selectCase()

Specified by:

selectCase in interface jakarta.persistence.criteria.CriteriaBuilder

and

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

Specified by:

and in interface jakarta.persistence.criteria.CriteriaBuilder

and

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

Specified by:

and in interface jakarta.persistence.criteria.CriteriaBuilder

or

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

Specified by:

or in interface jakarta.persistence.criteria.CriteriaBuilder

or

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

Specified by:

or in interface jakarta.persistence.criteria.CriteriaBuilder

not

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

Specified by:

not in interface jakarta.persistence.criteria.CriteriaBuilder

conjunction

JpaPredicate conjunction()

Specified by:

conjunction in interface jakarta.persistence.criteria.CriteriaBuilder

disjunction

JpaPredicate disjunction()

Specified by:

disjunction in interface jakarta.persistence.criteria.CriteriaBuilder

isTrue

JpaPredicate isTrue(jakarta.persistence.criteria.Expression<Boolean> x)

Specified by:

isTrue in interface jakarta.persistence.criteria.CriteriaBuilder

isFalse

JpaPredicate isFalse(jakarta.persistence.criteria.Expression<Boolean> x)

Specified by:

isFalse in interface jakarta.persistence.criteria.CriteriaBuilder

isNull

JpaPredicate isNull(jakarta.persistence.criteria.Expression<?> x)

Specified by:

isNull in interface jakarta.persistence.criteria.CriteriaBuilder

isNotNull

JpaPredicate isNotNull(jakarta.persistence.criteria.Expression<?> x)

Specified by:

isNotNull in interface jakarta.persistence.criteria.CriteriaBuilder

equal

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

Specified by:

equal in interface jakarta.persistence.criteria.CriteriaBuilder

equal

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

Specified by:

equal in interface jakarta.persistence.criteria.CriteriaBuilder

notEqual

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

Specified by:

notEqual in interface jakarta.persistence.criteria.CriteriaBuilder

notEqual

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

Specified by:

notEqual in interface jakarta.persistence.criteria.CriteriaBuilder

distinctFrom

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

distinctFrom

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

notDistinctFrom

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

notDistinctFrom

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

greaterThan

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

Specified by:

greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThan

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

Specified by:

greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThanOrEqualTo

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

Specified by:

greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

greaterThanOrEqualTo

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

Specified by:

greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

lessThan

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

Specified by:

lessThan in interface jakarta.persistence.criteria.CriteriaBuilder

lessThan

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

Specified by:

lessThan in interface jakarta.persistence.criteria.CriteriaBuilder

lessThanOrEqualTo

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

Specified by:

lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

lessThanOrEqualTo

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

Specified by:

lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder

between

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

Specified by:

between in interface jakarta.persistence.criteria.CriteriaBuilder

between

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

Specified by:

between in interface jakarta.persistence.criteria.CriteriaBuilder

gt

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

Specified by:

gt in interface jakarta.persistence.criteria.CriteriaBuilder

gt

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

Specified by:

gt in interface jakarta.persistence.criteria.CriteriaBuilder

ge

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

Specified by:

ge in interface jakarta.persistence.criteria.CriteriaBuilder

ge

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

Specified by:

ge in interface jakarta.persistence.criteria.CriteriaBuilder

lt

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

Specified by:

lt in interface jakarta.persistence.criteria.CriteriaBuilder

lt

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

Specified by:

lt in interface jakarta.persistence.criteria.CriteriaBuilder

le

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

Specified by:

le in interface jakarta.persistence.criteria.CriteriaBuilder

le

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

Specified by:

le in interface jakarta.persistence.criteria.CriteriaBuilder

isEmpty

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

Specified by:

isEmpty in interface jakarta.persistence.criteria.CriteriaBuilder

isNotEmpty

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

Specified by:

isNotEmpty in interface jakarta.persistence.criteria.CriteriaBuilder

isMember

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

Specified by:

isMember in interface jakarta.persistence.criteria.CriteriaBuilder

isMember

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

Specified by:

isMember in interface jakarta.persistence.criteria.CriteriaBuilder

isNotMember

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

Specified by:

isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder

isNotMember

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

Specified by:

isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

like

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

Specified by:

like in interface jakarta.persistence.criteria.CriteriaBuilder

ilike

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

ilike

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

ilike

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

ilike

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

ilike

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

ilike

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

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notLike

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

Specified by:

notLike in interface jakarta.persistence.criteria.CriteriaBuilder

notIlike

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

notIlike

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

notIlike

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

notIlike

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

notIlike

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

notIlike

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

in

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

Specified by:

in in interface jakarta.persistence.criteria.CriteriaBuilder

in

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

in

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

in

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

exists

JpaPredicate exists(jakarta.persistence.criteria.Subquery<?> subquery)

Specified by:

exists in interface jakarta.persistence.criteria.CriteriaBuilder

isMapEmpty

<M extends Map<?,?>> JpaPredicate isMapEmpty(JpaExpression<M> mapExpression)

Create a predicate that tests whether a Map is empty.

Parameters:

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

Returns:

is-empty predicate

isMapNotEmpty

<M extends Map<?,?>> JpaPredicate isMapNotEmpty(JpaExpression<M> mapExpression)

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

Parameters:

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

Returns:

is-not-empty predicate

mapSize

<M extends Map<?,?>> JpaExpression<Integer> mapSize(JpaExpression<M> mapExpression)

Create an expression that tests the size of a map.

Parameters:

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

Returns:

size expression

mapSize

<M extends Map<?,?>> JpaExpression<Integer> mapSize(M map)

Create an expression that tests the size of a map.

Parameters:

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

Returns:

size expression

sort

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

sort

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

sort

JpaOrder sort(JpaExpression<?> sortExpression)

asc

JpaOrder asc(jakarta.persistence.criteria.Expression<?> x)

Specified by:

asc in interface jakarta.persistence.criteria.CriteriaBuilder

desc

JpaOrder desc(jakarta.persistence.criteria.Expression<?> x)

Specified by:

desc in interface jakarta.persistence.criteria.CriteriaBuilder

asc

JpaOrder asc(jakarta.persistence.criteria.Expression<?> x,
             boolean nullsFirst)

Create an ordering by the ascending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc

JpaOrder desc(jakarta.persistence.criteria.Expression<?> x,
              boolean nullsFirst)

Create an ordering by the descending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

search

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.

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

JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute,
                      SortOrder sortOrder)

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

Parameters:

cteAttribute - CTE attribute used to define the ordering

sortOrder - The sort order

Returns:

ordering corresponding to the CTE attribute

search

JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute)

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

Parameters:

cteAttribute - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

asc

JpaSearchOrder asc(JpaCteCriteriaAttribute x)

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

Parameters:

x - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

desc

JpaSearchOrder desc(JpaCteCriteriaAttribute x)

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

Parameters:

x - CTE attribute used to define the ordering

Returns:

descending ordering corresponding to the CTE attribute

asc

JpaSearchOrder asc(JpaCteCriteriaAttribute x,
                   boolean nullsFirst)

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

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

JpaSearchOrder desc(JpaCteCriteriaAttribute x,
                    boolean nullsFirst)

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

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

<T> JpaExpression<T> sql(String pattern,
                         Class<T> type,
                         jakarta.persistence.criteria.Expression<?>... arguments)

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.

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

JpaFunction<String> format(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime,
                           String pattern)

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.

Parameters:

datetime - the datetime expression to format

pattern - the pattern to use for formatting

Returns:

format expression

year

JpaFunction<Integer> year(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

month

JpaFunction<Integer> month(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

day

JpaFunction<Integer> day(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

hour

JpaFunction<Integer> hour(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

minute

JpaFunction<Integer> minute(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

second

JpaFunction<Float> second(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

truncate

<T extends TemporalAccessor> JpaFunction<T> truncate(jakarta.persistence.criteria.Expression<T> datetime,
                                                     TemporalUnit temporalUnit)

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.

Parameters:

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

temporalUnit - the temporal unit for truncation

Returns:

the truncated value

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            int start)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            int start)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            jakarta.persistence.criteria.Expression<Integer> start)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            jakarta.persistence.criteria.Expression<Integer> start)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            int start,
                            int length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            int start,
                            int length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            jakarta.persistence.criteria.Expression<Integer> start,
                            int length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            jakarta.persistence.criteria.Expression<Integer> start,
                            int length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            int start,
                            jakarta.persistence.criteria.Expression<Integer> length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            int start,
                            jakarta.persistence.criteria.Expression<Integer> length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            String replacement,
                            jakarta.persistence.criteria.Expression<Integer> start,
                            jakarta.persistence.criteria.Expression<Integer> length)

See Also:

overlay(Expression, Expression, Expression, Expression)

overlay

JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string,
                            jakarta.persistence.criteria.Expression<String> replacement,
                            jakarta.persistence.criteria.Expression<Integer> start,
                            jakarta.persistence.criteria.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.

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

JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x,
                        int length)

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x,
                        int length,
                        char padChar)

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x,
                        jakarta.persistence.criteria.Expression<Integer> length,
                        char padChar)

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x,
                        int length,
                        jakarta.persistence.criteria.Expression<Character> padChar)

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x,
                        jakarta.persistence.criteria.Expression<Integer> length,
                        jakarta.persistence.criteria.Expression<Character> padChar)

See Also:

pad(Trimspec, Expression, Expression, Expression)

pad

JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                        jakarta.persistence.criteria.Expression<String> x,
                        jakarta.persistence.criteria.Expression<Integer> length,
                        jakarta.persistence.criteria.Expression<Character> padChar)

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.

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

JpaFunction<String> left(jakarta.persistence.criteria.Expression<String> x,
                         int length)

See Also:

left(Expression, Expression)

left

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

Extract the length leftmost characters of a string.

Parameters:

x - original string

length - number of characters

Returns:

left expression

right

JpaFunction<String> right(jakarta.persistence.criteria.Expression<String> x,
                          int length)

See Also:

right(Expression, Expression)

right

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

Extract the length rightmost characters of a string.

Parameters:

x - original string

length - number of characters

Returns:

left expression

replace

JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x,
                            String pattern,
                            String replacement)

See Also:

replace(Expression, Expression, Expression)

replace

JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x,
                            String pattern,
                            jakarta.persistence.criteria.Expression<String> replacement)

See Also:

replace(Expression, Expression, Expression)

replace

JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x,
                            jakarta.persistence.criteria.Expression<String> pattern,
                            String replacement)

See Also:

replace(Expression, Expression, Expression)

replace

JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x,
                            jakarta.persistence.criteria.Expression<String> pattern,
                            jakarta.persistence.criteria.Expression<String> replacement)

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

Parameters:

x - original string

pattern - the string to be replaced

replacement - the new replacement string

Returns:

replace expression

collate

JpaFunction<String> collate(jakarta.persistence.criteria.Expression<String> x,
                            String collation)

log10

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

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

Parameters:

x - expression

Returns:

base-10 logarithm

log

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

See Also:

log(Expression, Expression)

log

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

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

Parameters:

b - base

x - expression

Returns:

arbitrary-base logarithm

pi

JpaExpression<Double> pi()

Literal expression corresponding to the value of pi.

Returns:

pi expression

sin

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

Create an expression that returns the sine of its argument.

Parameters:

x - expression

Returns:

sine

cos

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

Create an expression that returns the cosine of its argument.

Parameters:

x - expression

Returns:

cosine

tan

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

Create an expression that returns the tangent of its argument.

Parameters:

x - expression

Returns:

tangent

asin

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

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

Parameters:

x - expression

Returns:

inverse sine

acos

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

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

Parameters:

x - expression

Returns:

inverse cosine

atan

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

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

Parameters:

x - expression

Returns:

inverse tangent

atan2

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

See Also:

atan2(Expression, Expression)

atan2

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

See Also:

atan2(Expression, Expression)

atan2

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

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

Parameters:

y - y coordinate

x - x coordinate

Returns:

2-argument inverse tangent

sinh

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

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

Parameters:

x - expression

Returns:

hyperbolic sine

cosh

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

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

Parameters:

x - expression

Returns:

hyperbolic cosine

tanh

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

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

Parameters:

x - expression

Returns:

hyperbolic tangent

degrees

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

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

Parameters:

x - expression

Returns:

degrees

radians

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

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

Parameters:

x - expression

Returns:

radians

createWindow

JpaWindow createWindow()

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

Returns:

the empty window

frameUnboundedPreceding

JpaWindowFrame frameUnboundedPreceding()

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

Returns:

the window frame

frameBetweenPreceding

JpaWindowFrame frameBetweenPreceding(int offset)

See Also:

frameBetweenPreceding(Expression)

frameBetweenPreceding

JpaWindowFrame frameBetweenPreceding(jakarta.persistence.criteria.Expression<?> offset)

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

Parameters:

offset - the offset expression

Returns:

the window frame

frameCurrentRow

JpaWindowFrame frameCurrentRow()

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

Returns:

the window frame

frameBetweenFollowing

JpaWindowFrame frameBetweenFollowing(int offset)

See Also:

frameBetweenFollowing(Expression)

frameBetweenFollowing

JpaWindowFrame frameBetweenFollowing(jakarta.persistence.criteria.Expression<?> offset)

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

Parameters:

offset - the offset expression

Returns:

the window frame

frameUnboundedFollowing

JpaWindowFrame frameUnboundedFollowing()

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

Returns:

the window frame

windowFunction

<T> JpaExpression<T> windowFunction(String name,
                                    Class<T> type,
                                    JpaWindow window,
                                    jakarta.persistence.criteria.Expression<?>... args)

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

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

JpaExpression<Long> rowNumber(JpaWindow window)

Create a row_number window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

firstValue

<T> JpaExpression<T> firstValue(jakarta.persistence.criteria.Expression<T> argument,
                                JpaWindow window)

Create a first_value window function expression.

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:

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

lastValue

<T> JpaExpression<T> lastValue(jakarta.persistence.criteria.Expression<T> argument,
                               JpaWindow window)

Create a last_value window function expression.

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:

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

nthValue

<T> JpaExpression<T> nthValue(jakarta.persistence.criteria.Expression<T> argument,
                              int n,
                              JpaWindow window)

See Also:

nthValue

nthValue

<T> JpaExpression<T> nthValue(jakarta.persistence.criteria.Expression<T> argument,
                              jakarta.persistence.criteria.Expression<Integer> n,
                              JpaWindow window)

Create a nth_value window function expression.

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:

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

rank

JpaExpression<Long> rank(JpaWindow window)

Create a rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

denseRank

JpaExpression<Long> denseRank(JpaWindow window)

Create a dense_rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

percentRank

JpaExpression<Double> percentRank(JpaWindow window)

Create a percent_rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

cumeDist

JpaExpression<Double> cumeDist(JpaWindow window)

Create a cume_dist window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

functionAggregate

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

See Also:

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

functionAggregate

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

See Also:

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

functionAggregate

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

Create a generic aggregate function expression.

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

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

See Also:

sum(Expression, JpaPredicate, JpaWindow)

sum

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

See Also:

sum(Expression, JpaPredicate, JpaWindow)

sum

<N extends Number> JpaExpression<Number> sum(jakarta.persistence.criteria.Expression<N> argument,
                                             JpaPredicate filter,
                                             JpaWindow window)

Create a sum aggregate function expression.

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:

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

avg

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

See Also:

avg(Expression, JpaPredicate, JpaWindow)

avg

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

See Also:

avg(Expression, JpaPredicate, JpaWindow)

avg

<N extends Number> JpaExpression<Double> avg(jakarta.persistence.criteria.Expression<N> argument,
                                             JpaPredicate filter,
                                             JpaWindow window)

Create an avg aggregate function expression.

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:

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

count

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

See Also:

count(Expression, JpaPredicate, JpaWindow)

count

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

See Also:

count(Expression, JpaPredicate, JpaWindow)

count

JpaExpression<Long> count(jakarta.persistence.criteria.Expression<?> argument,
                          JpaPredicate filter,
                          JpaWindow window)

Create a count aggregate function 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:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

Create a generic ordered set-aggregate function expression.

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

JpaExpression<String> listagg(JpaOrder order,
                              jakarta.persistence.criteria.Expression<String> argument,
                              String separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              jakarta.persistence.criteria.Expression<String> argument,
                              jakarta.persistence.criteria.Expression<String> separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaPredicate filter,
                              jakarta.persistence.criteria.Expression<String> argument,
                              String separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaPredicate filter,
                              jakarta.persistence.criteria.Expression<String> argument,
                              jakarta.persistence.criteria.Expression<String> separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaWindow window,
                              jakarta.persistence.criteria.Expression<String> argument,
                              String separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaWindow window,
                              jakarta.persistence.criteria.Expression<String> argument,
                              jakarta.persistence.criteria.Expression<String> separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaPredicate filter,
                              JpaWindow window,
                              jakarta.persistence.criteria.Expression<String> argument,
                              String separator)

See Also:

listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)

listagg

JpaExpression<String> listagg(JpaOrder order,
                              JpaPredicate filter,
                              JpaWindow window,
                              jakarta.persistence.criteria.Expression<String> argument,
                              jakarta.persistence.criteria.Expression<String> separator)

Create a listagg ordered set-aggregate function expression.

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:

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

mode

<T> JpaExpression<T> mode(jakarta.persistence.criteria.Expression<T> sortExpression,
                          SortOrder sortOrder,
                          NullPrecedence nullPrecedence)

See Also:

mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode

<T> JpaExpression<T> mode(JpaPredicate filter,
                          jakarta.persistence.criteria.Expression<T> sortExpression,
                          SortOrder sortOrder,
                          NullPrecedence nullPrecedence)

See Also:

mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode

<T> JpaExpression<T> mode(JpaWindow window,
                          jakarta.persistence.criteria.Expression<T> sortExpression,
                          SortOrder sortOrder,
                          NullPrecedence nullPrecedence)

See Also:

mode(JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

mode

<T> JpaExpression<T> mode(JpaPredicate filter,
                          JpaWindow window,
                          jakarta.persistence.criteria.Expression<T> sortExpression,
                          SortOrder sortOrder,
                          NullPrecedence nullPrecedence)

Create a mode ordered set-aggregate function expression.

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:

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

percentileCont

<T> JpaExpression<T> percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument,
                                    jakarta.persistence.criteria.Expression<T> sortExpression,
                                    SortOrder sortOrder,
                                    NullPrecedence nullPrecedence)

See Also:

percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

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

See Also:

percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

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

See Also:

percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileCont

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

Create a percentile_cont ordered set-aggregate function expression.

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:

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

percentileDisc

<T> JpaExpression<T> percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument,
                                    jakarta.persistence.criteria.Expression<T> sortExpression,
                                    SortOrder sortOrder,
                                    NullPrecedence nullPrecedence)

See Also:

percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

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

See Also:

percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

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

See Also:

percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortOrder, NullPrecedence)

percentileDisc

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

Create a percentile_disc ordered set-aggregate function expression.

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:

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

rank

JpaExpression<Long> rank(JpaOrder order,
                         jakarta.persistence.criteria.Expression<?>... arguments)

See Also:

rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

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

See Also:

rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

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

See Also:

rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

rank

JpaExpression<Long> rank(JpaOrder order,
                         JpaPredicate filter,
                         JpaWindow window,
                         jakarta.persistence.criteria.Expression<?>... arguments)

Create a rank ordered set-aggregate function expression.

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:

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

percentRank

JpaExpression<Double> percentRank(JpaOrder order,
                                  jakarta.persistence.criteria.Expression<?>... arguments)

See Also:

percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

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

See Also:

percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

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

See Also:

percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)

percentRank

JpaExpression<Double> percentRank(JpaOrder order,
                                  JpaPredicate filter,
                                  JpaWindow window,
                                  jakarta.persistence.criteria.Expression<?>... arguments)

Create a percent_rank ordered set-aggregate function expression.

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:

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