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
All Methods Instance Methods Abstract Methods Default Methods Modifier and Type Method Description <N extends Number>
JpaExpression<N>abs(jakarta.persistence.criteria.Expression<N> x)
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 ofy
overx
.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 anavg
aggregate function expression.<N extends Number>
JpaExpression<Double>avg(jakarta.persistence.criteria.Expression<N> argument, JpaWindow window)
<Y extends Comparable<? super Y>>
JpaPredicatebetween(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>>
JpaPredicatebetween(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 acount
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 emptyJpaWindow
to use with window and aggregate functions.JpaExpression<Double>
cumeDist(JpaWindow window)
Create acume_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 theTemporalUnit.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 adense_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 afirst_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 typeFrameKind.OFFSET_FOLLOWING
to use withJpaWindow
s.JpaWindowFrame
frameBetweenPreceding(int offset)
JpaWindowFrame
frameBetweenPreceding(jakarta.persistence.criteria.Expression<?> offset)
Create window frame of typeFrameKind.OFFSET_PRECEDING
to use withJpaWindow
s.JpaWindowFrame
frameCurrentRow()
Create a window frame of typeFrameKind.CURRENT_ROW
to use withJpaWindow
s.JpaWindowFrame
frameUnboundedFollowing()
Create a window frame of typeFrameKind.UNBOUNDED_FOLLOWING
to use withJpaWindow
s.JpaWindowFrame
frameUnboundedPreceding()
Create a window frame of typeFrameKind.UNBOUNDED_PRECEDING
to use withJpaWindow
s.<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>>
JpaPredicategreaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>>
JpaPredicategreaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>>
JpaPredicategreaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>>
JpaPredicategreaterThanOrEqualTo(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 theTemporalUnit.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<?>>
JpaPredicateisEmpty(jakarta.persistence.criteria.Expression<C> collection)
JpaPredicate
isFalse(jakarta.persistence.criteria.Expression<Boolean> x)
<M extends Map<?,?>>
JpaPredicateisMapEmpty(JpaExpression<M> mapExpression)
Create a predicate that tests whether a Map is empty.<M extends Map<?,?>>
JpaPredicateisMapNotEmpty(JpaExpression<M> mapExpression)
Create a predicate that tests whether a Map is not empty.<E,C extends Collection<E>>
JpaPredicateisMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>>
JpaPredicateisMember(jakarta.persistence.criteria.Expression<E> elem, jakarta.persistence.criteria.Expression<C> collection)
<C extends Collection<?>>
JpaPredicateisNotEmpty(jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>>
JpaPredicateisNotMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
<E,C extends Collection<E>>
JpaPredicateisNotMember(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 alast_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 thelength
leftmost characters of a string.JpaFunction<Integer>
length(jakarta.persistence.criteria.Expression<String> x)
<Y extends Comparable<? super Y>>
JpaPredicatelessThan(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>>
JpaPredicatelessThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>>
JpaPredicatelessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, jakarta.persistence.criteria.Expression<? extends Y> y)
<Y extends Comparable<? super Y>>
JpaPredicatelessThanOrEqualTo(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 alistagg
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 ofx
to the baseb
.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 theTemporalUnit.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 amode
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 theTemporalUnit.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 anth_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 thestring
expression with thereplacement
expression, starting from indexstart
and substituting a number of characters corresponding to the length of thereplacement
expression or thelength
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 thepadChar
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 apercentile_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 apercentile_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 apercent_rank
ordered set-aggregate function expression.JpaExpression<Double>
percentRank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Double>
percentRank(JpaWindow window)
Create apercent_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 arank
ordered set-aggregate function expression.JpaExpression<Long>
rank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
JpaExpression<Long>
rank(JpaWindow window)
Create arank
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 ofpattern
within the original string withreplacement
.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 thelength
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 arow_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 theTemporalUnit.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, or0
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 nativepattern
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 asum
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>
Tunwrap(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 specifiedwindow
.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 theTemporalUnit.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
createQuery
<T> JpaCriteriaQuery<T> createQuery(Class<T> resultClass)
- Specified by:
createQuery
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
createTupleQuery
JpaCriteriaQuery<jakarta.persistence.Tuple> createTupleQuery()
- Specified by:
createTupleQuery
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
createCriteriaUpdate
<T> JpaCriteriaUpdate<T> createCriteriaUpdate(Class<T> targetEntity)
- Specified by:
createCriteriaUpdate
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
createCriteriaDelete
<T> JpaCriteriaDelete<T> createCriteriaDelete(Class<T> targetEntity)
- Specified by:
createCriteriaDelete
in interfacejakarta.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, or0
if its argument is exactly zero.- Specified by:
sign
in interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
- Parameters:
x
- basey
- 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 interfacejakarta.persistence.criteria.CriteriaBuilder
- Parameters:
x
- basey
- 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 interfacejakarta.persistence.criteria.CriteriaBuilder
- Parameters:
x
- basen
- 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
- basen
- number of decimal places- Returns:
- the truncated value
-
localDate
JpaExpression<LocalDate> localDate()
Create expression to return current local date.- Specified by:
localDate
in interfacejakarta.persistence.criteria.CriteriaBuilder
- Returns:
- expression for current date
-
localDateTime
JpaExpression<LocalDateTime> localDateTime()
Create expression to return current local datetime.- Specified by:
localDateTime
in interfacejakarta.persistence.criteria.CriteriaBuilder
- Returns:
- expression for current timestamp
-
localTime
JpaExpression<LocalTime> localTime()
Create expression to return current local time.- Specified by:
localTime
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
treat
<X,T extends X> JpaRoot<T> treat(jakarta.persistence.criteria.Root<X> root, Class<T> type)
- Specified by:
treat
in interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
construct
<Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass, jakarta.persistence.criteria.Selection<?>[] selections)
- Specified by:
construct
in interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
sum
<N extends Number> JpaExpression<N> sum(jakarta.persistence.criteria.Expression<N> argument)
- Specified by:
sum
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
sumAsLong
JpaExpression<Long> sumAsLong(jakarta.persistence.criteria.Expression<Integer> argument)
- Specified by:
sumAsLong
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
sumAsDouble
JpaExpression<Double> sumAsDouble(jakarta.persistence.criteria.Expression<Float> argument)
- Specified by:
sumAsDouble
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
max
<N extends Number> JpaExpression<N> max(jakarta.persistence.criteria.Expression<N> argument)
- Specified by:
max
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
min
<N extends Number> JpaExpression<N> min(jakarta.persistence.criteria.Expression<N> argument)
- Specified by:
min
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
greatest
<X extends Comparable<? super X>> JpaExpression<X> greatest(jakarta.persistence.criteria.Expression<X> argument)
- Specified by:
greatest
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
least
<X extends Comparable<? super X>> JpaExpression<X> least(jakarta.persistence.criteria.Expression<X> argument)
- Specified by:
least
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
count
JpaExpression<Long> count(jakarta.persistence.criteria.Expression<?> argument)
- Specified by:
count
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
countDistinct
JpaExpression<Long> countDistinct(jakarta.persistence.criteria.Expression<?> x)
- Specified by:
countDistinct
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
neg
<N extends Number> JpaExpression<N> neg(jakarta.persistence.criteria.Expression<N> x)
- Specified by:
neg
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
abs
<N extends Number> JpaExpression<N> abs(jakarta.persistence.criteria.Expression<N> x)
- Specified by:
abs
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
sum
<N extends Number> JpaExpression<N> sum(jakarta.persistence.criteria.Expression<? extends N> x, N y)
- Specified by:
sum
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
sum
<N extends Number> JpaExpression<N> sum(N x, jakarta.persistence.criteria.Expression<? extends N> y)
- Specified by:
sum
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
prod
<N extends Number> JpaExpression<N> prod(jakarta.persistence.criteria.Expression<? extends N> x, N y)
- Specified by:
prod
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
prod
<N extends Number> JpaExpression<N> prod(N x, jakarta.persistence.criteria.Expression<? extends N> y)
- Specified by:
prod
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
diff
<N extends Number> JpaExpression<N> diff(jakarta.persistence.criteria.Expression<? extends N> x, N y)
- Specified by:
diff
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
diff
<N extends Number> JpaExpression<N> diff(N x, jakarta.persistence.criteria.Expression<? extends N> y)
- Specified by:
diff
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
quot
JpaExpression<Number> quot(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
- Specified by:
quot
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
quot
JpaExpression<Number> quot(Number x, jakarta.persistence.criteria.Expression<? extends Number> y)
- Specified by:
quot
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
mod
JpaExpression<Integer> mod(jakarta.persistence.criteria.Expression<Integer> x, jakarta.persistence.criteria.Expression<Integer> y)
- Specified by:
mod
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
mod
JpaExpression<Integer> mod(jakarta.persistence.criteria.Expression<Integer> x, Integer y)
- Specified by:
mod
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
mod
JpaExpression<Integer> mod(Integer x, jakarta.persistence.criteria.Expression<Integer> y)
- Specified by:
mod
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
sqrt
JpaExpression<Double> sqrt(jakarta.persistence.criteria.Expression<? extends Number> x)
- Specified by:
sqrt
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toLong
JpaExpression<Long> toLong(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toLong
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toInteger
JpaExpression<Integer> toInteger(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toInteger
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toFloat
JpaExpression<Float> toFloat(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toFloat
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toDouble
JpaExpression<Double> toDouble(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toDouble
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toBigDecimal
JpaExpression<BigDecimal> toBigDecimal(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toBigDecimal
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toBigInteger
JpaExpression<BigInteger> toBigInteger(jakarta.persistence.criteria.Expression<? extends Number> number)
- Specified by:
toBigInteger
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
toString
JpaExpression<String> toString(jakarta.persistence.criteria.Expression<Character> character)
- Specified by:
toString
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
literal
<T> JpaExpression<T> literal(T value)
- Specified by:
literal
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
parameter
<T> JpaParameterExpression<T> parameter(Class<T> paramClass)
- Specified by:
parameter
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
parameter
<T> JpaParameterExpression<T> parameter(Class<T> paramClass, String name)
- Specified by:
parameter
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
concat
JpaExpression<String> concat(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> y)
- Specified by:
concat
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
concat
JpaExpression<String> concat(jakarta.persistence.criteria.Expression<String> x, String y)
- Specified by:
concat
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
concat
JpaExpression<String> concat(String x, jakarta.persistence.criteria.Expression<String> y)
- Specified by:
concat
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
substring
JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x, int from)
- Specified by:
substring
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
substring
JpaFunction<String> substring(jakarta.persistence.criteria.Expression<String> x, int from, int len)
- Specified by:
substring
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
trim
JpaFunction<String> trim(jakarta.persistence.criteria.Expression<String> x)
- Specified by:
trim
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
trim
JpaFunction<String> trim(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x)
- Specified by:
trim
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
trim
JpaFunction<String> trim(jakarta.persistence.criteria.Expression<Character> t, jakarta.persistence.criteria.Expression<String> x)
- Specified by:
trim
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
trim
JpaFunction<String> trim(char t, jakarta.persistence.criteria.Expression<String> x)
- Specified by:
trim
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
lower
JpaFunction<String> lower(jakarta.persistence.criteria.Expression<String> x)
- Specified by:
lower
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
upper
JpaFunction<String> upper(jakarta.persistence.criteria.Expression<String> x)
- Specified by:
upper
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
length
JpaFunction<Integer> length(jakarta.persistence.criteria.Expression<String> x)
- Specified by:
length
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
locate
JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
- Specified by:
locate
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
locate
JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x, String pattern)
- Specified by:
locate
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
locate
JpaFunction<Integer> locate(jakarta.persistence.criteria.Expression<String> x, String pattern, int from)
- Specified by:
locate
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
currentDate
JpaFunction<Date> currentDate()
- Specified by:
currentDate
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
currentTime
JpaFunction<Time> currentTime()
- Specified by:
currentTime
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
currentTimestamp
JpaFunction<Timestamp> currentTimestamp()
- Specified by:
currentTimestamp
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
all
<Y> JpaExpression<Y> all(jakarta.persistence.criteria.Subquery<Y> subquery)
- Specified by:
all
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
some
<Y> JpaExpression<Y> some(jakarta.persistence.criteria.Subquery<Y> subquery)
- Specified by:
some
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
any
<Y> JpaExpression<Y> any(jakarta.persistence.criteria.Subquery<Y> subquery)
- Specified by:
any
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
keys
<K,M extends Map<K,?>> JpaExpression<Set<K>> keys(M map)
- Specified by:
keys
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
size
<C extends Collection<?>> JpaExpression<Integer> size(jakarta.persistence.criteria.Expression<C> collection)
- Specified by:
size
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
size
<C extends Collection<?>> JpaExpression<Integer> size(C collection)
- Specified by:
size
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
coalesce
<T> JpaCoalesce<T> coalesce()
- Specified by:
coalesce
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
coalesce
<Y> JpaCoalesce<Y> coalesce(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
- Specified by:
coalesce
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
nullif
<Y> JpaExpression<Y> nullif(jakarta.persistence.criteria.Expression<Y> x, jakarta.persistence.criteria.Expression<?> y)
- Specified by:
nullif
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
nullif
<Y> JpaExpression<Y> nullif(jakarta.persistence.criteria.Expression<Y> x, Y y)
- Specified by:
nullif
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
selectCase
<C,R> JpaSimpleCase<C,R> selectCase(jakarta.persistence.criteria.Expression<? extends C> expression)
- Specified by:
selectCase
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
selectCase
<R> JpaSearchedCase<R> selectCase()
- Specified by:
selectCase
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
and
JpaPredicate and(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)
- Specified by:
and
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
and
JpaPredicate and(jakarta.persistence.criteria.Predicate... restrictions)
- Specified by:
and
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
or
JpaPredicate or(jakarta.persistence.criteria.Expression<Boolean> x, jakarta.persistence.criteria.Expression<Boolean> y)
- Specified by:
or
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
or
JpaPredicate or(jakarta.persistence.criteria.Predicate... restrictions)
- Specified by:
or
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
not
JpaPredicate not(jakarta.persistence.criteria.Expression<Boolean> restriction)
- Specified by:
not
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
conjunction
JpaPredicate conjunction()
- Specified by:
conjunction
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
disjunction
JpaPredicate disjunction()
- Specified by:
disjunction
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isTrue
JpaPredicate isTrue(jakarta.persistence.criteria.Expression<Boolean> x)
- Specified by:
isTrue
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isFalse
JpaPredicate isFalse(jakarta.persistence.criteria.Expression<Boolean> x)
- Specified by:
isFalse
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isNull
JpaPredicate isNull(jakarta.persistence.criteria.Expression<?> x)
- Specified by:
isNull
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isNotNull
JpaPredicate isNotNull(jakarta.persistence.criteria.Expression<?> x)
- Specified by:
isNotNull
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
equal
JpaPredicate equal(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
- Specified by:
equal
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
equal
JpaPredicate equal(jakarta.persistence.criteria.Expression<?> x, Object y)
- Specified by:
equal
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
notEqual
JpaPredicate notEqual(jakarta.persistence.criteria.Expression<?> x, jakarta.persistence.criteria.Expression<?> y)
- Specified by:
notEqual
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
notEqual
JpaPredicate notEqual(jakarta.persistence.criteria.Expression<?> x, Object y)
- Specified by:
notEqual
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
greaterThan
<Y extends Comparable<? super Y>> JpaPredicate greaterThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
- Specified by:
greaterThan
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
greaterThanOrEqualTo
<Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
- Specified by:
greaterThanOrEqualTo
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
lessThan
<Y extends Comparable<? super Y>> JpaPredicate lessThan(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
- Specified by:
lessThan
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
lessThanOrEqualTo
<Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(jakarta.persistence.criteria.Expression<? extends Y> x, Y y)
- Specified by:
lessThanOrEqualTo
in interfacejakarta.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 interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
gt
JpaPredicate gt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
- Specified by:
gt
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
gt
JpaPredicate gt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
- Specified by:
gt
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
ge
JpaPredicate ge(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
- Specified by:
ge
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
ge
JpaPredicate ge(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
- Specified by:
ge
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
lt
JpaPredicate lt(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
- Specified by:
lt
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
lt
JpaPredicate lt(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
- Specified by:
lt
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
le
JpaPredicate le(jakarta.persistence.criteria.Expression<? extends Number> x, jakarta.persistence.criteria.Expression<? extends Number> y)
- Specified by:
le
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
le
JpaPredicate le(jakarta.persistence.criteria.Expression<? extends Number> x, Number y)
- Specified by:
le
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isEmpty
<C extends Collection<?>> JpaPredicate isEmpty(jakarta.persistence.criteria.Expression<C> collection)
- Specified by:
isEmpty
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
isNotEmpty
<C extends Collection<?>> JpaPredicate isNotEmpty(jakarta.persistence.criteria.Expression<C> collection)
- Specified by:
isNotEmpty
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
isMember
<E,C extends Collection<E>> JpaPredicate isMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
- Specified by:
isMember
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
isNotMember
<E,C extends Collection<E>> JpaPredicate isNotMember(E elem, jakarta.persistence.criteria.Expression<C> collection)
- Specified by:
isNotMember
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
like
JpaPredicate like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern)
- Specified by:
like
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
like
JpaPredicate like(jakarta.persistence.criteria.Expression<String> x, String pattern)
- Specified by:
like
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
like
JpaPredicate like(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
- Specified by:
like
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
like
JpaPredicate like(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
- Specified by:
like
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
like
JpaPredicate like(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
- Specified by:
like
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
notLike
JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x, String pattern)
- Specified by:
notLike
in interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
notLike
JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, char escapeChar)
- Specified by:
notLike
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
notLike
JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<Character> escapeChar)
- Specified by:
notLike
in interfacejakarta.persistence.criteria.CriteriaBuilder
-
notLike
JpaPredicate notLike(jakarta.persistence.criteria.Expression<String> x, String pattern, char escapeChar)
- Specified by:
notLike
in interfacejakarta.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 interfacejakarta.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 interfacejakarta.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 interfacejakarta.persistence.criteria.CriteriaBuilder
-
desc
JpaOrder desc(jakarta.persistence.criteria.Expression<?> x)
- Specified by:
desc
in interfacejakarta.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 orderingnullsFirst
- Whethernull
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 orderingnullsFirst
- Whethernull
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 orderingsortOrder
- The sort ordernullPrecedence
- 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 orderingsortOrder
- 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 orderingnullsFirst
- Whethernull
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 orderingnullsFirst
- Whethernull
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 nativepattern
that will be unquoted and embedded in the generated SQL. Occurrences of?
in the pattern are replaced with the remainingarguments
of the function.- Type Parameters:
T
- type of this expression- Parameters:
pattern
- native SQL patterntype
- type of this expressionarguments
- 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’sDateTimeFormatter
.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 formatpattern
- the pattern to use for formatting- Returns:
- format expression
-
year
JpaFunction<Integer> year(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.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 theTemporalUnit.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 theTemporalUnit.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 theTemporalUnit.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 theTemporalUnit.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 theTemporalUnit.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)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, jakarta.persistence.criteria.Expression<Integer> start)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, int start, int length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start, int length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start, int length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, jakarta.persistence.criteria.Expression<Integer> start, int length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, int start, jakarta.persistence.criteria.Expression<Integer> length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, jakarta.persistence.criteria.Expression<String> replacement, int start, jakarta.persistence.criteria.Expression<Integer> length)
-
overlay
JpaFunction<String> overlay(jakarta.persistence.criteria.Expression<String> string, String replacement, jakarta.persistence.criteria.Expression<Integer> start, jakarta.persistence.criteria.Expression<Integer> length)
-
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 thestring
expression with thereplacement
expression, starting from indexstart
and substituting a number of characters corresponding to the length of thereplacement
expression or thelength
parameter if specified.- Parameters:
string
- string expression to be manipulatedreplacement
- string expression to replace in originalstart
- start positionlength
- optional, number of characters to substitute- Returns:
- overlay expression
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, int length)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, int length, char padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length, char padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, char padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, char padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, int length, jakarta.persistence.criteria.Expression<Character> padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts, jakarta.persistence.criteria.Expression<String> x, int length, jakarta.persistence.criteria.Expression<Character> padChar)
-
pad
JpaFunction<String> pad(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<Integer> length, jakarta.persistence.criteria.Expression<Character> padChar)
-
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 thepadChar
character if specified. Optionally pass aCriteriaBuilder.Trimspec
to pad the string expression withLEADING
orTRAILING
(default) characters.- Parameters:
ts
- optionalCriteriaBuilder.Trimspec
x
- string expression to padlength
- length of the result string after paddingpadChar
- 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 thelength
leftmost characters of a string.- Parameters:
x
- original stringlength
- 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 thelength
rightmost characters of a string.- Parameters:
x
- original stringlength
- number of characters- Returns:
- left expression
-
replace
JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x, String pattern, String replacement)
-
replace
JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x, String pattern, jakarta.persistence.criteria.Expression<String> replacement)
-
replace
JpaFunction<String> replace(jakarta.persistence.criteria.Expression<String> x, jakarta.persistence.criteria.Expression<String> pattern, String replacement)
-
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 ofpattern
within the original string withreplacement
.- Parameters:
x
- original stringpattern
- the string to be replacedreplacement
- 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 ofx
to the baseb
.- Parameters:
b
- basex
- 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 ofy
overx
.- Parameters:
y
- y coordinatex
- 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 emptyJpaWindow
to use with window and aggregate functions.- Returns:
- the empty window
-
frameUnboundedPreceding
JpaWindowFrame frameUnboundedPreceding()
Create a window frame of typeFrameKind.UNBOUNDED_PRECEDING
to use withJpaWindow
s.- 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 typeFrameKind.OFFSET_PRECEDING
to use withJpaWindow
s.- Parameters:
offset
- theoffset
expression- Returns:
- the window frame
-
frameCurrentRow
JpaWindowFrame frameCurrentRow()
Create a window frame of typeFrameKind.CURRENT_ROW
to use withJpaWindow
s.- 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 typeFrameKind.OFFSET_FOLLOWING
to use withJpaWindow
s.- Parameters:
offset
- theoffset
expression- Returns:
- the window frame
-
frameUnboundedFollowing
JpaWindowFrame frameUnboundedFollowing()
Create a window frame of typeFrameKind.UNBOUNDED_FOLLOWING
to use withJpaWindow
s.- 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 specifiedwindow
.- Type Parameters:
T
- type of this expression- Parameters:
name
- name of the window functiontype
- type of this expressionwindow
- window over which the function will be appliedargs
- arguments to the function- Returns:
- window function expression
-
rowNumber
JpaExpression<Long> rowNumber(JpaWindow window)
Create arow_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 afirst_value
window function expression.- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tofirst_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 alast_value
window function expression.- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tolast_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 anth_value
window function expression.- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tonth_value
n
- theN
argument for the functionwindow
- 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 arank
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 adense_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 apercent_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 acume_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)
-
functionAggregate
<T> JpaExpression<T> functionAggregate(String name, Class<T> type, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)
-
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 functiontype
- type of this expressionfilter
- optional filter clausewindow
- optional window over which to apply the functionargs
- 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 asum
aggregate function expression.- Type Parameters:
N
- type of the input expression- Parameters:
argument
- argument to the functionfilter
- optional filter clausewindow
- 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 anavg
aggregate function expression.- Type Parameters:
N
- type of the input expression- Parameters:
argument
- argument to the functionfilter
- optional filter clausewindow
- 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)
-
count
JpaExpression<Long> count(jakarta.persistence.criteria.Expression<?> argument, JpaWindow window)
-
count
JpaExpression<Long> count(jakarta.persistence.criteria.Expression<?> argument, JpaPredicate filter, JpaWindow window)
Create acount
aggregate function expression.- Parameters:
argument
- argument to the functionfilter
- optional filter clausewindow
- 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)
-
functionWithinGroup
<T> JpaExpression<T> functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... args)
-
functionWithinGroup
<T> JpaExpression<T> functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... args)
-
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 functiontype
- type of this expressionorder
- order by clause used in within groupfilter
- optional filter clausewindow
- optional window over which to apply the functionargs
- 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)
-
listagg
JpaExpression<String> listagg(JpaOrder order, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<String> argument, String separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, String separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, String separator)
-
listagg
JpaExpression<String> listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<String> argument, jakarta.persistence.criteria.Expression<String> separator)
Create alistagg
ordered set-aggregate function expression.- Parameters:
order
- order by clause used in within groupfilter
- optional filter clausewindow
- optional window over which to apply the functionargument
- values to joinseparator
- 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)
-
mode
<T> JpaExpression<T> mode(JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
-
mode
<T> JpaExpression<T> mode(JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
-
mode
<T> JpaExpression<T> mode(JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence nullPrecedence)
Create amode
ordered set-aggregate function expression.- Type Parameters:
T
- type of this expression- Parameters:
filter
- optional filter clausewindow
- optional window over which to apply the functionsortExpression
- the sort expressionsortOrder
- the sort ordernullPrecedence
- 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)
-
percentileCont
<T> JpaExpression<T> percentileCont(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence 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)
-
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 apercentile_cont
ordered set-aggregate function expression.- Parameters:
argument
- argument to the functionfilter
- optional filter clausewindow
- optional window over which to apply the functionsortExpression
- the sort expressionsortOrder
- the sort ordernullPrecedence
- 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)
-
percentileDisc
<T> JpaExpression<T> percentileDisc(jakarta.persistence.criteria.Expression<? extends Number> argument, JpaPredicate filter, jakarta.persistence.criteria.Expression<T> sortExpression, SortOrder sortOrder, NullPrecedence 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)
-
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 apercentile_disc
ordered set-aggregate function expression.- Parameters:
argument
- argument to the functionfilter
- optional filter clausewindow
- optional window over which to apply the functionsortExpression
- the sort expressionsortOrder
- the sort ordernullPrecedence
- 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)
-
rank
JpaExpression<Long> rank(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... arguments)
-
rank
JpaExpression<Long> rank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
-
rank
JpaExpression<Long> rank(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
Create arank
ordered set-aggregate function expression.- Parameters:
order
- order by clause used in within groupfilter
- optional filter clausewindow
- optional window over which to apply the functionarguments
- 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)
-
percentRank
JpaExpression<Double> percentRank(JpaOrder order, JpaPredicate filter, jakarta.persistence.criteria.Expression<?>... arguments)
-
percentRank
JpaExpression<Double> percentRank(JpaOrder order, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
-
percentRank
JpaExpression<Double> percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, jakarta.persistence.criteria.Expression<?>... arguments)
Create apercent_rank
ordered set-aggregate function expression.- Parameters:
order
- order by clause used in within groupfilter
- optional filter clausewindow
- optional window over which to apply the functionarguments
- arguments to the function- Returns:
- ordered set-aggregate expression
- See Also:
functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
-