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.
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.

NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isEmpty(jakarta.persistence.criteria.Expression<C>)

Parameters:

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

Returns:

is-empty predicate

isMapNotEmpty

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

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

NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isNotEmpty(jakarta.persistence.criteria.Expression<C>)

Parameters:

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

Returns:

is-not-empty predicate

mapSize

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

Create an expression that tests the size of a map.

NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.size(jakarta.persistence.criteria.Expression<C>)

Parameters:

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

Returns:

size expression

mapSize

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

Create an expression that tests the size of a map.

Parameters:

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

Returns:

size expression

sort

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

sort

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

sort

JpaOrder sort(JpaExpression<?> sortExpression)

asc

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

Specified by:

asc in interface jakarta.persistence.criteria.CriteriaBuilder

desc

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

Specified by:

desc in interface jakarta.persistence.criteria.CriteriaBuilder

asc

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

Create an ordering by the ascending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc

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

Create an ordering by the descending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

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

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...)