Interface HibernateCriteriaBuilder

All Superinterfaces:

CriteriaBuilder

All Known Subinterfaces:

GeolatteSpatialCriteriaBuilder, JTSSpatialCriteriaBuilder, NodeBuilder, SpatialCriteriaBuilder<T>

All Known Implementing Classes:

CriteriaDefinition, HibernateCriteriaBuilderDelegate

@Incubating(since="6.3")
public interface HibernateCriteriaBuilder
extends CriteriaBuilder

A JPA CriteriaBuilder is a source of objects which may be composed to express a criteria query. The JPA-standard API defines all the operations needed to express any query written in standard JPQL. This interface extends CriteriaBuilder, adding operations needed to express features of HQL which are not available in standard JPQL. For example:

• JPQL does not have a format() function, so format(Expression, String) is declared here, and
• since JPQL does not have insert statements, this interface defines the operations createCriteriaInsertSelect(Class) and createCriteriaInsertValues(Class).

Furthermore, the operations of this interface return types defined in the package org.hibernate.query.criteria, which extend the equivalent types in jakarta.persistence.criteria with additional operations. For example JpaCriteriaQuery adds the methods:

• JpaSelectCriteria.from(Subquery), which allows the use of a subquery in the from clause of the query, and
• JpaCteContainer.with(AbstractQuery), which allows the creation of common table expressions.

Finally, the method createQuery(String, Class) allows a query written in HQL to be translated to a tree of criteria objects for further manipulation and execution.

An instance of this interface may be obtained by calling SessionFactory.getCriteriaBuilder().

Since:

6.0

See Also:

• SessionFactory.getCriteriaBuilder()
• JpaCriteriaQuery
• JpaCriteriaUpdate
• JpaCriteriaDelete
• JpaCriteriaInsertValues
• JpaCriteriaInsertSelect
• JpaCteCriteria
• JpaSubQuery
• JpaExpression

Nested Class Summary

Nested classes/interfaces inherited from interface CriteriaBuilder

CriteriaBuilder.Case<R>, CriteriaBuilder.Coalesce<T>, CriteriaBuilder.In<T>, CriteriaBuilder.SimpleCase<C,R>, CriteriaBuilder.Trimspec

Method Summary

Modifier and Type	Method	Description
<N extends Number> JpaExpression<N>	abs(Expression<N> x)	Create an expression returning the absolute value of its argument.
JpaExpression<Double>	acos(Expression<? extends Number> x)	Create an expression that returns the inverse cosine of its argument.
<T extends Temporal> JpaExpression<T>	addDuration(Expression<T> datetime, Expression<Duration> duration)	Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.
<T extends Temporal> JpaExpression<T>	addDuration(Expression<T> datetime, Duration duration)	Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.
<T extends Temporal> JpaExpression<T>	addDuration(T datetime, Expression<Duration> duration)	Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.
<Y> JpaExpression<Y>	all(Subquery<Y> subquery)	Create an all quantified expression over a subquery.
JpaPredicate	and(BooleanExpression... restrictions)	Create a conjunction predicate.
JpaPredicate	and(Expression<Boolean> x, Expression<Boolean> y)	Create a conjunction predicate.
JpaPredicate	and(Predicate... restrictions)	Deprecated. Prefer and(BooleanExpression...) instead.
JpaPredicate	and(List<? extends Expression<Boolean>> restrictions)	Create a conjunction predicate.
<Y> JpaExpression<Y>	any(Subquery<Y> subquery)	Create an any quantified expression over a subquery.
JpaCompoundSelection<Object[]>	array(Selection<?>... selections)	Create an array-valued compound selection.
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, Selection<?>... selections)	Create an array-valued compound selection with the given result array type.
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, List<? extends Selection<?>> selections)	Create an array-valued compound selection with the given result array type.
JpaCompoundSelection<Object[]>	array(List<Selection<?>> selections)	Create an array-valued compound selection from a list of selections.
<T> JpaExpression<T[]>	arrayAgg(JpaOrder order, Expression<? extends T> argument)
<T> JpaExpression<T[]>	arrayAgg(JpaOrder order, JpaPredicate filter, Expression<? extends T> argument)
<T> JpaExpression<T[]>	arrayAgg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument)	Create a array_agg ordered set-aggregate function expression.
<T> JpaExpression<T[]>	arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)
<T> JpaExpression<T[]>	arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Appends element to array.
<T> JpaExpression<T[]>	arrayAppend(Expression<T[]> arrayExpression, T element)	Appends element to array.
<T> JpaExpression<T[]>	arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Concatenates arrays with each other in order.
<T> JpaExpression<T[]>	arrayConcat(Expression<T[]> arrayExpression1, T[] array2)	Concatenates arrays with each other in order.
<T> JpaExpression<T[]>	arrayConcat(T[] array1, Expression<T[]> arrayExpression2)	Concatenates arrays with each other in order.
<T> JpaPredicate	arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Whether an array contains an element.
<T> JpaPredicate	arrayContains(Expression<T[]> arrayExpression, T element)	Whether an array contains an element.
<T> JpaPredicate	arrayContains(T[] array, Expression<T> elementExpression)	Whether an array contains an element.
<T> JpaPredicate	arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Whether an array contains a nullable element.
<T> JpaPredicate	arrayContainsNullable(Expression<T[]> arrayExpression, T element)	Whether an array contains a nullable element.
<T> JpaPredicate	arrayContainsNullable(T[] array, Expression<T> elementExpression)	Whether an array contains a nullable element.
<T> JpaExpression<T[]>	arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)	Creates array with the same element N times, as specified by the arguments.
<T> JpaExpression<T[]>	arrayFill(Expression<T> elementExpression, Integer elementCount)	Creates array with the same element N times, as specified by the arguments.
<T> JpaExpression<T[]>	arrayFill(T element, Expression<Integer> elementCountExpression)	Creates array with the same element N times, as specified by the arguments.
<T> JpaExpression<T[]>	arrayFill(T element, Integer elementCount)	Creates array with the same element N times, as specified by the arguments.
<T> JpaExpression<T>	arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)	Accesses the element of an array by 1-based index.
<T> JpaExpression<T>	arrayGet(Expression<T[]> arrayExpression, Integer index)	Accesses the element of an array by 1-based index.
<T> JpaPredicate	arrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array.
<T> JpaPredicate	arrayIncludes(Expression<T[]> arrayExpression, T[] subArray)	Whether an array is a subset of another array.
<T> JpaPredicate	arrayIncludes(T[] array, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array.
<T> JpaPredicate	arrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array with nullable elements.
<T> JpaPredicate	arrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)	Whether an array is a subset of another array with nullable elements.
<T> JpaPredicate	arrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array with nullable elements.
<T> JpaPredicate	arrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array.
<T> JpaPredicate	arrayIntersects(Expression<T[]> arrayExpression1, T[] array2)	Whether one array has any elements common with another array.
<T> JpaPredicate	arrayIntersects(T[] array1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array.
<T> JpaPredicate	arrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array, supporting null elements.
<T> JpaPredicate	arrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)	Whether one array has any elements common with another array, supporting null elements.
<T> JpaPredicate	arrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array, supporting null elements.
<T> JpaExpression<Integer>	arrayLength(Expression<T[]> arrayExpression)	Determines the length of an array.
<T> JpaExpression<T[]>	arrayLiteral(T... elements)	Creates an array literal with the array constructor function.
<T> JpaExpression<Integer>	arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines the 1-based position of an element in an array.
<T> JpaExpression<Integer>	arrayPosition(Expression<T[]> arrayExpression, T element)	Determines the 1-based position of an element in an array.
<T> JpaExpression<int[]>	arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in an array.
<T> JpaExpression<int[]>	arrayPositions(Expression<T[]> arrayExpression, T element)	Determines all 1-based positions of an element in an array.
<T> JpaExpression<List<Integer>>	arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in an array.
<T> JpaExpression<List<Integer>>	arrayPositionsList(Expression<T[]> arrayExpression, T element)	Determines all 1-based positions of an element in an array.
<T> JpaExpression<T[]>	arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)	Prepends element to array.
<T> JpaExpression<T[]>	arrayPrepend(T element, Expression<T[]> arrayExpression)	Prepends element to array.
<T> JpaExpression<T[]>	arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Creates array copy with given element removed.
<T> JpaExpression<T[]>	arrayRemove(Expression<T[]> arrayExpression, T element)	Creates array copy with given element removed.
<T> JpaExpression<T[]>	arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)	Creates array copy with the element at the given 1-based index removed.
<T> JpaExpression<T[]>	arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)	Creates array copy with the element at the given 1-based index removed.
<T> JpaExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)	Creates array copy replacing a given element with another.
<T> JpaExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)	Creates array copy replacing a given element with another.
<T> JpaExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)	Creates array copy replacing a given element with another.
<T> JpaExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)	Creates array copy replacing a given element with another.
<T> JpaExpression<T[]>	arrayReverse(Expression<T[]> arrayExpression)	Reverses the order of elements in an array.
<T> JpaExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)	Creates array copy with given element at given 1-based index.
<T> JpaExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)	Creates array copy with given element at given 1-based index.
<T> JpaExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)	Creates array copy with given element at given 1-based index.
<T> JpaExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Integer index, T element)	Creates array copy with given element at given 1-based index.
<T> JpaExpression<T[]>	arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)	Creates a sub-array of the based on 1-based lower and upper index.
<T> JpaExpression<T[]>	arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)	Creates a sub-array of the based on 1-based lower and upper index.
<T> JpaExpression<T[]>	arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)	Creates a sub-array of the based on 1-based lower and upper index.
<T> JpaExpression<T[]>	arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)	Creates a sub-array of the based on 1-based lower and upper index.
<T> JpaExpression<T[]>	arraySort(Expression<T[]> arrayExpression)	Sorts the elements of an array in ascending order.
<T> JpaExpression<T[]>	arraySort(Expression<T[]> arrayExpression, boolean descending)	Sorts the elements of an array in the specified order.
<T> JpaExpression<T[]>	arraySort(Expression<T[]> arrayExpression, boolean descending, boolean nullsFirst)	Create an expression that sorts the given array with explicit null ordering.
<T> JpaExpression<T[]>	arraySort(Expression<T[]> arrayExpression, Expression<Boolean> descendingExpression)	Sorts the elements of an array in the specified order.
<T> JpaExpression<T[]>	arraySort(Expression<T[]> arrayExpression, Expression<Boolean> descendingExpression, Expression<Boolean> nullsFirstExpression)	Create an expression that sorts the given array with explicit null ordering.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)	Concatenates the non-null array elements with a separator, as specified by the arguments.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression, Expression<String> defaultExpression)	Concatenates the array elements with a separator, as specified by the arguments.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression, String defaultValue)	Concatenates the array elements with a separator, as specified by the arguments.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, String separator)	Concatenates the non-null array elements with a separator, as specified by the arguments.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, String separator, Expression<String> defaultExpression)	Concatenates the array elements with a separator, as specified by the arguments.
JpaExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, String separator, String defaultValue)	Concatenates the array elements with a separator, as specified by the arguments.
<T> JpaExpression<T[]>	arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)	Creates array copy without the last N elements, specified by the second argument.
<T> JpaExpression<T[]>	arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)	Creates array copy without the last N elements, specified by the second argument.
JpaOrder	asc(Expression<?> x)	Create an ascending ordering for the given expression.
JpaOrder	asc(Expression<?> x, boolean nullsFirst)	Create an ordering by the ascending value of the expression.
JpaSearchOrder	asc(JpaCteCriteriaAttribute x)	Create a search ordering by the ascending value of the CTE attribute.
JpaSearchOrder	asc(JpaCteCriteriaAttribute x, boolean nullsFirst)	Create a search ordering by the ascending value of the CTE attribute.
JpaExpression<Double>	asin(Expression<? extends Number> x)	Create an expression that returns the inverse sine of its argument.
JpaExpression<Double>	atan(Expression<? extends Number> x)	Create an expression that returns the inverse tangent of its argument.
JpaExpression<Double>	atan2(Expression<? extends Number> y, Expression<? extends Number> x)	Create an expression that returns the inverse tangent of y over x.
JpaExpression<Double>	atan2(Expression<? extends Number> y, Number x)
JpaExpression<Double>	atan2(Number y, Expression<? extends Number> x)
<N extends Number> JpaExpression<Double>	avg(Expression<N> argument)	Create an aggregate expression returning the average of numeric values.
<N extends Number> JpaExpression<Double>	avg(Expression<N> argument, JpaPredicate filter)
<N extends Number> JpaExpression<Double>	avg(Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create an avg aggregate function expression.
<N extends Number> JpaExpression<Double>	avg(Expression<N> argument, JpaWindow window)
<Y extends Comparable<? super Y>> JpaPredicate	between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)	Create a predicate testing whether a value is between two bounds.
<Y extends Comparable<? super Y>> JpaPredicate	between(Expression<? extends Y> value, Y lower, Y upper)	Create a predicate testing whether a value is between two bounds.
<Y extends Comparable<? super Y>> JpaPredicate	between(Y value, Expression<? extends Y> lower, Expression<? extends Y> upper)	Create a predicate testing whether a value is between two bounds.
<X,T> JpaExpression<X>	cast(JpaExpression<T> expression, Class<X> castTargetJavaType)	Create an expression that casts the given expression to the specified Java type.
<X,T> JpaExpression<X>	cast(JpaExpression<T> expression, JpaCastTarget<X> castTarget)	Create an expression that casts the given expression to the specified cast target.
<X> JpaCastTarget<X>	castTarget(Class<X> castTargetJavaType)	Create a cast target for the given Java type.
<X> JpaCastTarget<X>	castTarget(Class<X> castTargetJavaType, int precision, int scale)	Create a cast target for the given Java type, precision, and scale.
<X> JpaCastTarget<X>	castTarget(Class<X> castTargetJavaType, long length)	Create a cast target for the given Java type and SQL type length.
<N extends Number> JpaExpression<N>	ceiling(Expression<N> x)	Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
<T> JpaCoalesce<T>	coalesce()	Create a coalesce expression.
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Expression<? extends Y> y)	Create a coalesce expression.
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Y y)	Create a coalesce expression.
JpaFunction<String>	collate(Expression<String> x, String collation)	Create an expression that applies the named collation to a string expression.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionAppend(Expression<C> collectionExpression, E element)	Appends element to basic collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)	Appends element to basic collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Concatenates basic collections with each other in order.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionConcat(Expression<C> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)	Concatenates basic collections with each other in order.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)	Concatenates basic collections with each other in order.
<E> JpaPredicate	collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)	Whether a basic collection contains an element.
<E> JpaPredicate	collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)	Whether a basic collection contains an element.
<E> JpaPredicate	collectionContains(Collection<E> collection, Expression<E> elementExpression)	Whether a basic collection contains an element.
<E> JpaPredicate	collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)	Whether a basic collection contains a nullable element.
<E> JpaPredicate	collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)	Whether a basic collection contains a nullable element.
<E> JpaPredicate	collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)	Whether a basic collection contains a nullable element.
<T> JpaExpression<Collection<T>>	collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)	Creates basic collection with the same element N times, as specified by the arguments.
<T> JpaExpression<Collection<T>>	collectionFill(Expression<T> elementExpression, Integer elementCount)	Creates basic collection with the same element N times, as specified by the arguments.
<T> JpaExpression<Collection<T>>	collectionFill(T element, Expression<Integer> elementCountExpression)	Creates basic collection with the same element N times, as specified by the arguments.
<T> JpaExpression<Collection<T>>	collectionFill(T element, Integer elementCount)	Creates basic collection with the same element N times, as specified by the arguments.
<E> JpaExpression<E>	collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)	Accesses the element of the basic collection by 1-based index.
<E> JpaExpression<E>	collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)	Accesses the element of the basic collection by 1-based index.
<E> JpaPredicate	collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection.
<E> JpaPredicate	collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)	Whether a basic collection is a subset of another basic collection.
<E> JpaPredicate	collectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection.
<E> JpaPredicate	collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection with nullable elements.
<E> JpaPredicate	collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)	Whether a basic collection is a subset of another basic collection with nullable elements.
<E> JpaPredicate	collectionIncludesNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection with nullable elements.
<E> JpaPredicate	collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)	Whether one basic collection has any elements common with another basic collection.
<E> JpaPredicate	collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)	Whether one basic collection has any elements common with another basic collection.
<E> JpaPredicate	collectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Whether one basic collection has any elements common with another basic collection.
<E> JpaPredicate	collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)	Whether one basic collection has any elements common with another basic collection, supporting null elements.
<E> JpaPredicate	collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)	Whether one basic collection has any elements common with another basic collection, supporting null elements.
<E> JpaPredicate	collectionIntersectsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Whether one basic collection has any elements common with another basic collection, supporting null elements.
JpaExpression<Integer>	collectionLength(Expression<? extends Collection<?>> collectionExpression)	Determines the length of a basic collection.
<E, C extends Collection<E>> JpaExpression<C>	collectionLiteral(E... elements)	Creates a basic collection literal with the array constructor function.
<E> JpaExpression<Integer>	collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)	Determines the 1-based position of an element in a basic collection.
<E> JpaExpression<Integer>	collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)	Determines the 1-based position of an element in a basic collection.
<T> JpaExpression<int[]>	collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in a basic collection.
<T> JpaExpression<int[]>	collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)	Determines all 1-based positions of an element in a basic collection.
<T> JpaExpression<List<Integer>>	collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in a basic collection.
<T> JpaExpression<List<Integer>>	collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)	Determines all 1-based positions of an element in a basic collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionPrepend(E element, Expression<C> collectionExpression)	Prepends element to basic collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)	Prepends element to basic collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionRemove(Expression<C> collectionExpression, E element)	Creates basic collection copy with given element removed.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)	Creates basic collection copy with given element removed.
<C extends Collection<?>> JpaExpression<C>	collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)	Creates basic collection copy with the element at the given 1-based index removed.
<C extends Collection<?>> JpaExpression<C>	collectionRemoveIndex(Expression<C> collectionExpression, Integer index)	Creates basic collection copy with the element at the given 1-based index removed.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)	Creates basic collection copy replacing a given element with another.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionReplace(Expression<C> collectionExpression, E oldElement, Expression<? extends E> newElementExpression)	Creates basic collection copy replacing a given element with another.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, E newElement)	Creates basic collection copy replacing a given element with another.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, Expression<? extends E> newElementExpression)	Creates basic collection copy replacing a given element with another.
<C extends Collection<?>> JpaExpression<C>	collectionReverse(Expression<C> collectionExpression)	Create an expression that reverses the order of the elements of a collection.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)	Creates basic collection copy with given element at given 1-based index.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, Expression<? extends E> elementExpression)	Creates basic collection copy with given element at given 1-based index.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionSet(Expression<C> collectionExpression, Integer index, E element)	Creates basic collection copy with given element at given 1-based index.
<E, C extends Collection<? super E>> JpaExpression<C>	collectionSet(Expression<C> collectionExpression, Integer index, Expression<? extends E> elementExpression)	Creates basic collection copy with given element at given 1-based index.
<C extends Collection<?>> JpaExpression<C>	collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)	Creates a sub-collection of the based on 1-based lower and upper index.
<C extends Collection<?>> JpaExpression<C>	collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)	Creates a sub-collection of the based on 1-based lower and upper index.
<C extends Collection<?>> JpaExpression<C>	collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)	Creates a sub-collection of the based on 1-based lower and upper index.
<C extends Collection<?>> JpaExpression<C>	collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)	Creates a sub-collection of the based on 1-based lower and upper index.
<C extends Collection<?>> JpaExpression<C>	collectionSort(Expression<C> collectionExpression)	Create an expression that sorts the elements of a collection.
<C extends Collection<?>> JpaExpression<C>	collectionSort(Expression<C> collectionExpression, boolean descending)	Create an expression that sorts the given collection in specified order.
<C extends Collection<?>> JpaExpression<C>	collectionSort(Expression<C> collectionExpression, boolean descending, boolean nullsFirst)	Create an expression that sorts the given collection with explicit null ordering.
<C extends Collection<?>> JpaExpression<C>	collectionSort(Expression<C> collectionExpression, Expression<Boolean> descendingExpression)	Create an expression that sorts the given collection in specified order.
<C extends Collection<?>> JpaExpression<C>	collectionSort(Expression<C> collectionExpression, Expression<Boolean> descendingExpression, Expression<Boolean> nullsFirstExpression)	Create an expression that sorts the given collection with explicit null ordering.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)	Concatenates the non-null basic collection elements with a separator, as specified by the arguments.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression, Expression<String> defaultExpression)	Concatenates the collection elements with a separator, as specified by the arguments.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression, String defaultValue)	Concatenates the collection elements with a separator, as specified by the arguments.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)	Concatenates the non-null basic collection elements with a separator, as specified by the arguments.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator, Expression<String> defaultExpression)	Concatenates the collection elements with a separator, as specified by the arguments.
JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator, String defaultValue)	Concatenates the collection elements with a separator, as specified by the arguments.
<C extends Collection<?>> JpaExpression<C>	collectionTrim(Expression<C> arrayExpression, Expression<Integer> elementCountExpression)	Creates basic collection copy without the last N elements, specified by the second argument.
<C extends Collection<?>> JpaExpression<C>	collectionTrim(Expression<C> arrayExpression, Integer elementCount)	Creates basic collection copy without the last N elements, specified by the second argument.
JpaExpression<String>	concat(Expression<String> x, Expression<String> y)	Create a string concatenation expression.
JpaExpression<String>	concat(Expression<String> x, String y)	Create a string concatenation expression.
JpaExpression<String>	concat(String x, Expression<String> y)	Create a string concatenation expression.
JpaExpression<String>	concat(String x, String y)	Create an expression that concatenates two string literals.
JpaExpression<String>	concat(List<Expression<String>> expressions)	Create a string concatenation expression from a list of expressions.
JpaPredicate	conjunction()	Create a predicate that is always true.
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, Selection<?>... selections)	Create a compound selection using the specified result type constructor.
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, List<? extends Selection<?>> arguments)	Create a compound selection whose arguments are supplied as a list.
JpaExpression<Double>	cos(Expression<? extends Number> x)	Create an expression that returns the cosine of its argument.
JpaExpression<Double>	cosh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic cosine of its argument.
JpaExpression<Long>	count()	Equivalent to HQL count(*).
JpaExpression<Long>	count(Expression<?> argument)	Create an aggregate expression returning a row count.
JpaExpression<Long>	count(Expression<?> argument, JpaPredicate filter)
JpaExpression<Long>	count(Expression<?> argument, JpaPredicate filter, JpaWindow window)	Create a count aggregate function expression.
JpaExpression<Long>	count(Expression<?> argument, JpaWindow window)
JpaExpression<Long>	countDistinct(Expression<?> x)	Create an aggregate expression returning the count of distinct values.
<T> JpaCriteriaDelete<T>	createCriteriaDelete(Class<T> targetEntity)	Create a criteria delete statement for the given entity type.
<T> JpaCriteriaInsertSelect<T>	createCriteriaInsertSelect(Class<T> targetEntity)	Create a criteria insert statement which obtains inserted values from a select query.
<T> JpaCriteriaInsertValues<T>	createCriteriaInsertValues(Class<T> targetEntity)	Create a criteria insert statement which supplies explicit values.
<T> JpaCriteriaUpdate<T>	createCriteriaUpdate(Class<T> targetEntity)	Create a criteria update statement for the given entity type.
JpaCriteriaQuery<Object>	createQuery()	Create a criteria query.
<T> JpaCriteriaQuery<T>	createQuery(Class<T> resultClass)	Create a criteria query for the given result type.
<T> JpaCriteriaQuery<T>	createQuery(String hql, Class<T> resultClass)	Transform the given HQL select query to an equivalent criteria query.
JpaCriteriaQuery<Tuple>	createTupleQuery()	Create a tuple-valued criteria query.
JpaWindow	createWindow()	Create an empty JpaWindow to use with window and aggregate functions.
JpaExpression<Double>	cumeDist(JpaWindow window)	Create a cume_dist window function expression.
JpaFunction<Date>	currentDate()	Create an expression for the current SQL date.
JpaFunction<Instant>	currentInstant()	Create an expression for the current instant.
JpaFunction<Time>	currentTime()	Create an expression for the current SQL time.
JpaFunction<Timestamp>	currentTimestamp()	Create an expression for the current SQL timestamp.
JpaFunction<Integer>	day(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.DAY of a date, time, or datetime expression.
JpaExpression<Double>	degrees(Expression<? extends Number> x)	Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
JpaExpression<Long>	denseRank(JpaWindow window)	Create a dense_rank window function expression.
JpaOrder	desc(Expression<?> x)	Create a descending ordering for the given expression.
JpaOrder	desc(Expression<?> x, boolean nullsFirst)	Create an ordering by the descending value of the expression.
JpaSearchOrder	desc(JpaCteCriteriaAttribute x)	Create a search ordering by the descending value of the CTE attribute.
JpaSearchOrder	desc(JpaCteCriteriaAttribute x, boolean nullsFirst)	Create a search ordering by the descending value of the CTE attribute.
<N extends Number> JpaExpression<N>	diff(Expression<? extends N> x, Expression<? extends N> y)	Create an expression returning a numeric difference.
<N extends Number> JpaExpression<N>	diff(Expression<? extends N> x, N y)	Create an expression returning a numeric difference.
<N extends Number> JpaExpression<N>	diff(N x, Expression<? extends N> y)	Create an expression returning a numeric difference.
JpaPredicate	disjunction()	Create a predicate that is always false.
JpaPredicate	distinctFrom(Expression<?> x, Expression<?> y)	Create a predicate testing whether two expressions are distinct, treating nulls as comparable values.
JpaPredicate	distinctFrom(Expression<?> x, Object y)	Create a predicate testing whether an expression and a value are distinct, treating nulls as comparable values.
JpaExpression<Duration>	duration(long magnitude, TemporalUnit unit)	A literal Duration, for example, "five days" or "30 minutes".
<T extends Temporal> JpaExpression<Duration>	durationBetween(Expression<T> x, Expression<T> y)	Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.
<T extends Temporal> JpaExpression<Duration>	durationBetween(Expression<T> x, T y)	Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.
JpaExpression<Long>	durationByUnit(TemporalUnit unit, Expression<Duration> duration)	Convert a Duration to a numeric magnitude in the given units.
JpaExpression<Duration>	durationDiff(Expression<Duration> x, Expression<Duration> y)	Subtract one duration from another.
JpaExpression<Duration>	durationDiff(Expression<Duration> x, Duration y)	Subtract one duration from another.
JpaExpression<Duration>	durationScaled(Expression<? extends Number> number, Expression<Duration> duration)	Scale a duration by a number.
JpaExpression<Duration>	durationScaled(Expression<? extends Number> number, Duration duration)	Scale a duration by a number.
JpaExpression<Duration>	durationScaled(Number number, Expression<Duration> duration)	Scale a duration by a number.
JpaExpression<Duration>	durationSum(Expression<Duration> x, Expression<Duration> y)	Add two durations.
JpaExpression<Duration>	durationSum(Expression<Duration> x, Duration y)	Add two durations.
JpaPredicate	equal(Expression<?> x, Expression<?> y)	Create an equality predicate.
JpaPredicate	equal(Expression<?> x, Object y)	Create an equality predicate.
<T> JpaCriteriaQuery<T>	except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an except or except all set operation over the given criteria queries.
<T> JpaSubQuery<T>	except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)	Create an except or except all set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	except(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an except set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	except(CriteriaQuery<T> left, CriteriaQuery<?> right)	Create an except set operation over two criteria queries.
<T> CriteriaSelect<T>	except(CriteriaSelect<T> left, CriteriaSelect<?> right)	Create a except set operation over two criteria selects.
default <T> JpaSubQuery<T>	except(Subquery<? extends T> query1, Subquery<?>... queries)	Create an except set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	exceptAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an except all set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	exceptAll(CriteriaQuery<T> left, CriteriaQuery<?> right)	Create an except all set operation over two criteria queries.
<T> CriteriaSelect<T>	exceptAll(CriteriaSelect<T> left, CriteriaSelect<?> right)	Create a except all set operation over two criteria selects.
default <T> JpaSubQuery<T>	exceptAll(Subquery<? extends T> query1, Subquery<?>... queries)	Create an except all set operation over the given subqueries.
JpaPredicate	exists(Subquery<?> subquery)	Create a predicate testing whether a subquery returns results.
JpaExpression<Double>	exp(Expression<? extends Number> x)	Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
<N, T extends Temporal> JpaExpression<N>	extract(TemporalField<N,T> field, Expression<T> temporal)	Create an expression extracting the given temporal field from a temporal expression.
<T> JpaExpression<T>	firstValue(Expression<T> argument, JpaWindow window)	Create a first_value window function expression.
JpaExpression<?>	fk(Path<?> path)	Create an expression representing the foreign key of the given association path.
<N extends Number> JpaExpression<N>	floor(Expression<N> x)	Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
JpaFunction<String>	format(Expression<? extends TemporalAccessor> datetime, String pattern)	Format a date, time, or datetime according to a pattern.
JpaWindowFrame	frameBetweenFollowing(int offset)
JpaWindowFrame	frameBetweenFollowing(Expression<?> offset)	Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.
JpaWindowFrame	frameBetweenPreceding(int offset)
JpaWindowFrame	frameBetweenPreceding(Expression<?> offset)	Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.
JpaWindowFrame	frameCurrentRow()	Create a window frame of type FrameKind.CURRENT_ROW to use with JpaWindows.
JpaWindowFrame	frameUnboundedFollowing()	Create a window frame of type FrameKind.UNBOUNDED_FOLLOWING to use with JpaWindows.
JpaWindowFrame	frameUnboundedPreceding()	Create a window frame of type FrameKind.UNBOUNDED_PRECEDING to use with JpaWindows.
<T> JpaFunction<T>	function(String name, Class<T> type, Expression<?>... args)	Create an expression invoking a database function.
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args)	Create a generic aggregate function expression.
<T> JpaExpression<T>	functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args)	Create a generic ordered set-aggregate function expression.
<T> JpaExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)
JpaPredicate	ge(Expression<? extends Number> x, Expression<? extends Number> y)	Create a greater-than-or-equal predicate for numeric expressions.
JpaPredicate	ge(Expression<? extends Number> x, Number y)	Create a greater-than-or-equal predicate for numeric expressions.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, E stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, E stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, E stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, Expression<E> stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, Expression<E> stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(E start, Expression<E> stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, E stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, E stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, E stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> JpaSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(E start, E stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(E start, E stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(E start, Expression<E> stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(E start, Expression<E> stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(Expression<E> start, E stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(Expression<E> start, E stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(Expression<E> start, Expression<E> stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> JpaSetReturningFunction<E>	generateTimeSeries(Expression<E> start, Expression<E> stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)	Create a greater-than predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(Expression<? extends Y> x, Y y)	Create a greater-than predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)	Create a greater-than-or-equal predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Y y)	Create a greater-than-or-equal predicate for comparable expressions.
<X extends Comparable<? super X>> JpaExpression<X>	greatest(Expression<X> argument)	Create an aggregate expression returning the greatest comparable value.
JpaPredicate	gt(Expression<? extends Number> x, Expression<? extends Number> y)	Create a greater-than predicate for numeric expressions.
JpaPredicate	gt(Expression<? extends Number> x, Number y)	Create a greater-than predicate for numeric expressions.
JpaFunction<Integer>	hour(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
JpaExpression<?>	id(Path<?> path)	Create an expression representing the identifier of the given path.
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern)	Create a case-insensitive like predicate.
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a case-insensitive like predicate with an escape character.
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a case-insensitive like predicate with an escape character expression.
JpaPredicate	ilike(Expression<String> x, String pattern)	Create a case-insensitive like predicate.
JpaPredicate	ilike(Expression<String> x, String pattern, char escapeChar)	Create a case-insensitive like predicate with an escape character.
JpaPredicate	ilike(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a case-insensitive like predicate with an escape character expression.
JpaPredicate	ilikeRegexp(Expression<String> x, String pattern)	Create a case-insensitive predicate testing whether a string expression matches a regular expression.
<T> JpaInPredicate<T>	in(Expression<? extends T> expression)	Create an in predicate builder for the given expression.
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, Expression<? extends T>... values)	Create an in predicate with expression values.
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, Collection<T> values)	Create an in predicate with values supplied as a collection.
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, T... values)	Create an in predicate with literal values.
<K, L extends List<?>> JpaExpression<Set<K>>	indexes(L list)	Create an expression representing the indexes of the given list.
<T> JpaCriteriaQuery<T>	intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an intersect or intersect all set operation over the given criteria queries.
<T> JpaSubQuery<T>	intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)	Create an intersect or intersect all set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	intersect(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an intersect set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	intersect(CriteriaQuery<? super T> left, CriteriaQuery<? super T> right)	Create an intersect set operation over two criteria queries.
<T> CriteriaSelect<T>	intersect(CriteriaSelect<? super T> left, CriteriaSelect<? super T> right)	Create a intersect set operation over two criteria selects.
default <T> JpaSubQuery<T>	intersect(Subquery<? extends T> query1, Subquery<?>... queries)	Create an intersect set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	intersectAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create an intersect all set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	intersectAll(CriteriaQuery<? super T> left, CriteriaQuery<? super T> right)	Create an intersect all set operation over two criteria queries.
<T> CriteriaSelect<T>	intersectAll(CriteriaSelect<? super T> left, CriteriaSelect<? super T> right)	Create a intersect all set operation over two criteria selects.
default <T> JpaSubQuery<T>	intersectAll(Subquery<? extends T> query1, Subquery<?>... queries)	Create an intersect all set operation over the given subqueries.
<C extends Collection<?>> JpaPredicate	isEmpty(Expression<C> collection)	Create a predicate testing whether a collection is empty.
JpaPredicate	isFalse(Expression<Boolean> x)	Create a predicate testing whether an expression is false.
<M extends Map<?,?>> JpaPredicate	isMapEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is empty.
<M extends Map<?,?>> JpaPredicate	isMapNotEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is not empty.
<E, C extends Collection<E>> JpaPredicate	isMember(E elem, Expression<C> collection)	Create a predicate testing whether an element is a member of a collection.
<E, C extends Collection<E>> JpaPredicate	isMember(Expression<E> elem, Expression<C> collection)	Create a predicate testing whether an element is a member of a collection.
<C extends Collection<?>> JpaPredicate	isNotEmpty(Expression<C> collection)	Create a predicate testing whether a collection is not empty.
<E, C extends Collection<E>> JpaPredicate	isNotMember(E elem, Expression<C> collection)	Create a predicate testing whether an element is not a member of a collection.
<E, C extends Collection<E>> JpaPredicate	isNotMember(Expression<E> elem, Expression<C> collection)	Create a predicate testing whether an element is not a member of a collection.
JpaPredicate	isNotNull(Expression<?> x)	Create a predicate testing whether an expression is not null.
JpaPredicate	isNull(Expression<?> x)	Create a predicate testing whether an expression is null.
JpaPredicate	isTrue(Expression<Boolean> x)	Create a predicate testing whether an expression is true.
JpaExpression<String>	jsonArray(Expression<?>... values)	Create a JSON array from the array of values.
JpaExpression<String>	jsonArrayAgg(Expression<?> value)	Aggregates the given value into a JSON array.
JpaExpression<String>	jsonArrayAgg(Expression<?> value, Predicate filter)	Aggregates the given value into a JSON array.
JpaExpression<String>	jsonArrayAgg(Expression<?> value, Predicate filter, JpaOrder... orderBy)	Aggregates the given value into a JSON array.
JpaExpression<String>	jsonArrayAgg(Expression<?> value, JpaOrder... orderBy)	Aggregates the given value into a JSON array.
JpaExpression<String>	jsonArrayAggWithNulls(Expression<?> value)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
JpaExpression<String>	jsonArrayAggWithNulls(Expression<?> value, Predicate filter)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
JpaExpression<String>	jsonArrayAggWithNulls(Expression<?> value, Predicate filter, JpaOrder... orderBy)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
JpaExpression<String>	jsonArrayAggWithNulls(Expression<?> value, JpaOrder... orderBy)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
JpaExpression<String>	jsonArrayWithNulls(Expression<?>... values)	Create a JSON object from the given array of values, retaining null values in the JSON array.
JpaJsonExistsExpression	jsonExists(Expression<?> jsonDocument, Expression<String> jsonPath)	Checks if a JSON document contains a node for the given JSON path.
JpaJsonExistsExpression	jsonExists(Expression<?> jsonDocument, String jsonPath)	Checks if a JSON document contains a node for the given JSON path.
JpaExpression<String>	jsonInsert(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Inserts a value by JSON path within a JSON document.
JpaExpression<String>	jsonInsert(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Inserts a value by JSON path within a JSON document.
JpaExpression<String>	jsonInsert(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Inserts a value by JSON path within a JSON document.
JpaExpression<String>	jsonInsert(Expression<?> jsonDocument, String jsonPath, Object value)	Inserts a value by JSON path within a JSON document.
JpaExpression<String>	jsonMergepatch(Expression<?> document, Expression<?> patch)	Applies the patch JSON document onto the other JSON document and returns that.
JpaExpression<String>	jsonMergepatch(Expression<?> document, String patch)	Applies the patch JSON document onto the other JSON document and returns that.
JpaExpression<String>	jsonMergepatch(String document, Expression<?> patch)	Applies the patch JSON document onto the other JSON document and returns that.
JpaExpression<String>	jsonObject(Map<?, ? extends Expression<?>> keyValues)	Create a JSON object from the given map of key values.
JpaExpression<String>	jsonObjectAgg(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object.
JpaExpression<String>	jsonObjectAgg(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object.
JpaExpression<String>	jsonObjectAggWithNulls(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
JpaExpression<String>	jsonObjectAggWithNulls(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
JpaExpression<String>	jsonObjectAggWithUniqueKeys(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object.
JpaExpression<String>	jsonObjectAggWithUniqueKeys(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object.
JpaExpression<String>	jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
JpaExpression<String>	jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
JpaExpression<String>	jsonObjectWithNulls(Map<?, ? extends Expression<?>> keyValues)	Create a JSON object from the given map of key values, retaining null values in the JSON.
JpaJsonQueryExpression	jsonQuery(Expression<?> jsonDocument, Expression<String> jsonPath)	Queries values by JSON path from a JSON document.
JpaJsonQueryExpression	jsonQuery(Expression<?> jsonDocument, String jsonPath)
JpaExpression<String>	jsonRemove(Expression<?> jsonDocument, Expression<String> jsonPath)	Removes a value by JSON path within a JSON document.
JpaExpression<String>	jsonRemove(Expression<?> jsonDocument, String jsonPath)	Removes a value by JSON path within a JSON document.
JpaExpression<String>	jsonReplace(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonReplace(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonReplace(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonReplace(Expression<?> jsonDocument, String jsonPath, Object value)	Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonSet(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Inserts/Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonSet(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Inserts/Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonSet(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Inserts/Replaces a value by JSON path within a JSON document.
JpaExpression<String>	jsonSet(Expression<?> jsonDocument, String jsonPath, Object value)	Inserts/Replaces a value by JSON path within a JSON document.
JpaJsonTableFunction	jsonTable(Expression<?> jsonDocument)	Creates a json_table function expression to generate rows from JSON array elements.
JpaJsonTableFunction	jsonTable(Expression<?> jsonDocument, Expression<String> jsonPath)	Creates a json_table function expression to generate rows from JSON array elements.
JpaJsonTableFunction	jsonTable(Expression<?> jsonDocument, String jsonPath)	Creates a json_table function expression to generate rows from JSON array elements.
JpaJsonValueExpression<String>	jsonValue(Expression<?> jsonDocument, Expression<String> jsonPath)
<T> JpaJsonValueExpression<T>	jsonValue(Expression<?> jsonDocument, Expression<String> jsonPath, Class<T> returningType)	Extracts a value by JSON path from a JSON document.
JpaJsonValueExpression<String>	jsonValue(Expression<?> jsonDocument, String jsonPath)
<T> JpaJsonValueExpression<T>	jsonValue(Expression<?> jsonDocument, String jsonPath, Class<T> returningType)	Extracts a value by JSON path from a JSON document.
<T> JpaExpression<T>	lastValue(Expression<T> argument, JpaWindow window)	Create a last_value window function expression.
JpaPredicate	le(Expression<? extends Number> x, Expression<? extends Number> y)	Create a less-than-or-equal predicate for numeric expressions.
JpaPredicate	le(Expression<? extends Number> x, Number y)	Create a less-than-or-equal predicate for numeric expressions.
<X extends Comparable<? super X>> JpaExpression<X>	least(Expression<X> argument)	Create an aggregate expression returning the least comparable value.
JpaFunction<String>	left(Expression<String> x, int length)
JpaFunction<String>	left(Expression<String> x, Expression<Integer> length)	Extract the length leftmost characters of a string.
JpaFunction<Integer>	length(Expression<String> x)	Create an expression returning the length of a string.
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(Expression<? extends Y> x, Expression<? extends Y> y)	Create a less-than predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(Expression<? extends Y> x, Y y)	Create a less-than predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)	Create a less-than-or-equal predicate for comparable expressions.
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Y y)	Create a less-than-or-equal predicate for comparable expressions.
JpaPredicate	like(Expression<String> x, Expression<String> pattern)	Create a like predicate.
JpaPredicate	like(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a like predicate.
JpaPredicate	like(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a like predicate.
JpaPredicate	like(Expression<String> x, String pattern)	Create a like predicate.
JpaPredicate	like(Expression<String> x, String pattern, char escapeChar)	Create a like predicate.
JpaPredicate	like(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a like predicate.
JpaPredicate	likeRegexp(Expression<String> x, String pattern)	Create a predicate testing whether a string expression matches a regular expression.
JpaExpression<String>	listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)	Create a listagg ordered set-aggregate function expression.
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)
<T> JpaParameterExpression<List<T>>	listParameter(Class<T> paramClass)	Create a multivalued parameter accepting multiple arguments packaged together as a List.
<T> JpaParameterExpression<List<T>>	listParameter(Class<T> paramClass, String name)	Create a multivalued parameter accepting multiple arguments packaged together as a List.
<T> JpaExpression<T>	literal(T value)	Create a literal expression for the given value.
<T> List<? extends JpaExpression<T>>	literals(List<T> values)	Create literal expressions for each value in the given list.
<T> List<? extends JpaExpression<T>>	literals(T... values)	Create literal expressions for each of the given values.
JpaExpression<Double>	ln(Expression<? extends Number> x)	Create an expression that returns the natural logarithm of its argument.
JpaExpression<LocalDate>	localDate()	Create expression to return current local date.
JpaExpression<LocalDateTime>	localDateTime()	Create expression to return current local datetime.
JpaExpression<LocalTime>	localTime()	Create expression to return current local time.
JpaFunction<Integer>	locate(Expression<String> x, Expression<String> pattern)	Create an expression returning the position of a substring.
JpaFunction<Integer>	locate(Expression<String> x, Expression<String> pattern, Expression<Integer> from)	Create an expression returning the position of a substring.
JpaFunction<Integer>	locate(Expression<String> x, String pattern)	Create an expression returning the position of a substring.
JpaFunction<Integer>	locate(Expression<String> x, String pattern, int from)	Create an expression returning the position of a substring.
JpaExpression<Double>	log(Expression<? extends Number> b, Expression<? extends Number> x)	Create an expression that returns the logarithm of x to the base b.
JpaExpression<Double>	log(Number b, Expression<? extends Number> x)
JpaExpression<Double>	log10(Expression<? extends Number> x)	Create an expression that returns the base-10 logarithm of its argument.
JpaFunction<String>	lower(Expression<String> x)	Create an expression returning a lowercase string.
JpaPredicate	lt(Expression<? extends Number> x, Expression<? extends Number> y)	Create a less-than predicate for numeric expressions.
JpaPredicate	lt(Expression<? extends Number> x, Number y)	Create a less-than predicate for numeric expressions.
<M extends Map<?,?>> JpaExpression<Integer>	mapSize(M map)	Create an expression that tests the size of a map.
<M extends Map<?,?>> JpaExpression<Integer>	mapSize(JpaExpression<M> mapExpression)	Create an expression that tests the size of a map.
<N extends Number> JpaExpression<N>	max(Expression<N> argument)	Create an aggregate expression returning the maximum numeric value.
<N extends Number> JpaExpression<N>	min(Expression<N> argument)	Create an aggregate expression returning the minimum numeric value.
JpaFunction<Integer>	minute(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.
JpaExpression<Integer>	mod(Expression<Integer> x, Expression<Integer> y)	Create an expression returning the remainder of integer division.
JpaExpression<Integer>	mod(Expression<Integer> x, Integer y)	Create an expression returning the remainder of integer division.
JpaExpression<Integer>	mod(Integer x, Expression<Integer> y)	Create an expression returning the remainder of integer division.
<T> JpaExpression<T>	mode(Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)	Create a mode ordered set-aggregate function expression.
<T> JpaExpression<T>	mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
JpaFunction<Integer>	month(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
<T> JpaExpression<T>	named(Expression<T> expression, String name)	Creates a named expression.
<N extends Number> JpaExpression<N>	neg(Expression<N> x)	Create an expression returning the arithmetic negation of its argument.
JpaPredicate	not(Expression<Boolean> restriction)	Create a negated predicate.
JpaPredicate	notDistinctFrom(Expression<?> x, Expression<?> y)	Create a predicate testing whether two expressions are not distinct, treating nulls as comparable values.
JpaPredicate	notDistinctFrom(Expression<?> x, Object y)	Create a predicate testing whether an expression and a value are not distinct, treating nulls as comparable values.
JpaPredicate	notEqual(Expression<?> x, Expression<?> y)	Create an inequality predicate.
JpaPredicate	notEqual(Expression<?> x, Object y)	Create an inequality predicate.
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern)	Create a negated case-insensitive like predicate.
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a negated case-insensitive like predicate with an escape character.
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a negated case-insensitive like predicate with an escape character expression.
JpaPredicate	notIlike(Expression<String> x, String pattern)	Create a negated case-insensitive like predicate.
JpaPredicate	notIlike(Expression<String> x, String pattern, char escapeChar)	Create a negated case-insensitive like predicate with an escape character.
JpaPredicate	notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a negated case-insensitive like predicate with an escape character expression.
JpaPredicate	notIlikeRegexp(Expression<String> x, String pattern)	Create a negated case-insensitive predicate testing whether a string expression matches a regular expression.
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern)	Create a negated like predicate.
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a negated like predicate.
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a negated like predicate.
JpaPredicate	notLike(Expression<String> x, String pattern)	Create a negated like predicate.
JpaPredicate	notLike(Expression<String> x, String pattern, char escapeChar)	Create a negated like predicate.
JpaPredicate	notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a negated like predicate.
JpaPredicate	notLikeRegexp(Expression<String> x, String pattern)	Create a negated predicate testing whether a string expression matches a regular expression.
<T> JpaExpression<T>	nthValue(Expression<T> argument, int n, JpaWindow window)
<T> JpaExpression<T>	nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)	Create a nth_value window function expression.
<Y> JpaExpression<Y>	nullif(Expression<Y> x, Expression<?> y)	Create a nullif expression.
<Y> JpaExpression<Y>	nullif(Expression<Y> x, Y y)	Create a nullif expression.
<T> JpaExpression<T>	nullLiteral(Class<T> resultClass)	Create a null literal expression of the given type.
JpaPredicate	or(BooleanExpression... restrictions)	Create a disjunction predicate.
JpaPredicate	or(Expression<Boolean> x, Expression<Boolean> y)	Create a disjunction predicate.
JpaPredicate	or(Predicate... restrictions)	Deprecated. Prefer or(BooleanExpression...) instead.
JpaPredicate	or(List<? extends Expression<Boolean>> restrictions)	Create a disjunction predicate.
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start)
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start, int length)
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start, Expression<Integer> length)
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, int length)
JpaFunction<String>	overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, Expression<Integer> length)	Overlay the string expression with the replacement expression, starting from index start and substituting a number of characters corresponding to the length of the replacement expression or the length parameter if specified.
JpaFunction<String>	overlay(Expression<String> string, String replacement, int start)
JpaFunction<String>	overlay(Expression<String> string, String replacement, int start, int length)
JpaFunction<String>	overlay(Expression<String> string, String replacement, int start, Expression<Integer> length)
JpaFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start)
JpaFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start, int length)
JpaFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start, Expression<Integer> length)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, char padChar)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, Expression<Character> padChar)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, char padChar)
JpaFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, Expression<Character> padChar)	Pad the specified string expression with whitespace or with the padChar character if specified.
JpaFunction<String>	pad(Expression<String> x, int length)
JpaFunction<String>	pad(Expression<String> x, int length, char padChar)
JpaFunction<String>	pad(Expression<String> x, int length, Expression<Character> padChar)
JpaFunction<String>	pad(Expression<String> x, Expression<Integer> length)
JpaFunction<String>	pad(Expression<String> x, Expression<Integer> length, char padChar)
JpaFunction<String>	pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)
<T> JpaParameterExpression<T>	parameter(Class<T> paramClass)	Create a parameter expression.
<T> JpaParameterExpression<T>	parameter(Class<T> paramClass, String name)	Create a parameter expression.
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)	Create a percentile_cont ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)	Create a percentile_disc ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
JpaExpression<Double>	percentRank(JpaOrder order, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)	Create a percent_rank ordered set-aggregate function expression.
JpaExpression<Double>	percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaWindow window)	Create a percent_rank window function expression.
JpaExpression<Double>	pi()	Literal expression corresponding to the value of pi.
JpaExpression<Double>	power(Expression<? extends Number> x, Expression<? extends Number> y)	Create an expression that returns the first argument raised to the power of its second argument.
JpaExpression<Double>	power(Expression<? extends Number> x, Number y)	Create an expression that returns the first argument raised to the power of its second argument.
<N extends Number> JpaExpression<N>	prod(Expression<? extends N> x, Expression<? extends N> y)	Create an expression returning a numeric product.
<N extends Number> JpaExpression<N>	prod(Expression<? extends N> x, N y)	Create an expression returning a numeric product.
<N extends Number> JpaExpression<N>	prod(N x, Expression<? extends N> y)	Create an expression returning a numeric product.
JpaExpression<Number>	quot(Expression<? extends Number> x, Expression<? extends Number> y)	Create an expression returning a numeric quotient.
JpaExpression<Number>	quot(Expression<? extends Number> x, Number y)	Create an expression returning a numeric quotient.
JpaExpression<Number>	quot(Number x, Expression<? extends Number> y)	Create an expression returning a numeric quotient.
JpaExpression<Double>	radians(Expression<? extends Number> x)	Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
JpaExpression<Long>	rank(JpaOrder order, Expression<?>... arguments)
JpaExpression<Long>	rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
JpaExpression<Long>	rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)	Create a rank ordered set-aggregate function expression.
JpaExpression<Long>	rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Long>	rank(JpaWindow window)	Create a rank window function expression.
JpaFunction<String>	repeat(Expression<String> x, int times)	Concatenate the given string expression with itself the given number of times.
JpaFunction<String>	repeat(Expression<String> x, Expression<Integer> times)	Concatenate the given string expression with itself the given number of times.
JpaFunction<String>	repeat(String x, Expression<Integer> times)	Concatenate the given string expression with itself the given number of times.
JpaFunction<String>	replace(Expression<String> x, Expression<String> pattern, Expression<String> replacement)	Replace all occurrences of pattern within the original string with replacement.
JpaFunction<String>	replace(Expression<String> x, Expression<String> pattern, String replacement)
JpaFunction<String>	replace(Expression<String> x, String pattern, Expression<String> replacement)
JpaFunction<String>	replace(Expression<String> x, String pattern, String replacement)
JpaFunction<String>	right(Expression<String> x, int length)
JpaFunction<String>	right(Expression<String> x, Expression<Integer> length)	Extract the length rightmost characters of a string.
<T extends Number> JpaExpression<T>	round(Expression<T> x, Integer n)	Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
JpaExpression<Long>	rowNumber(JpaWindow window)	Create a row_number window function expression.
JpaSearchOrder	search(JpaCteCriteriaAttribute cteAttribute)	Create a search ordering based on the ascending value of the CTE attribute.
JpaSearchOrder	search(JpaCteCriteriaAttribute cteAttribute, SortDirection sortOrder)	Create a search ordering based on the sort order of the value of the CTE attribute.
JpaSearchOrder	search(JpaCteCriteriaAttribute cteAttribute, SortDirection sortOrder, Nulls nullPrecedence)	Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
JpaFunction<Float>	second(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.
<R> JpaSearchedCase<R>	selectCase()	Create a searched case expression.
<C,R> JpaSimpleCase<C,R>	selectCase(Expression<? extends C> expression)	Create a simple case expression.
<C,R> JpaSimpleCase<C,R>	selectCase(Expression<? extends C> expression, Class<R> resultType)	Create a case expression with the given result type.
<R> JpaSearchedCase<R>	selectCase(Class<R> resultType)	Create a case expression with the given result type.
<E> JpaSetReturningFunction<E>	setReturningFunction(String name, Expression<?>... args)	Create a new set-returning function expression.
JpaExpression<Integer>	sign(Expression<? extends Number> x)	Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
JpaExpression<Double>	sin(Expression<? extends Number> x)	Create an expression that returns the sine of its argument.
JpaExpression<Double>	sinh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic sine of its argument.
<C extends Collection<?>> JpaExpression<Integer>	size(C collection)	Create an expression returning the size of a collection.
<C extends Collection<?>> JpaExpression<Integer>	size(Expression<C> collection)	Create an expression returning the size of a collection.
<Y> JpaExpression<Y>	some(Subquery<Y> subquery)	Create a some quantified expression over a subquery.
JpaOrder	sort(JpaExpression<?> sortExpression)	Create an ordering for the given sort expression.
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder)	Create an ordering for the given sort expression and direction.
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)	Create an ordering for the given sort expression, direction, and null precedence.
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, Nulls nullPrecedence, boolean ignoreCase)	Create an ordering for the given sort expression with optional case-insensitive comparison.
<T> JpaExpression<T>	sql(String pattern, Class<T> type, Expression<?>... arguments)	Embed native pattern that will be unquoted and embedded in the generated SQL.
JpaExpression<Double>	sqrt(Expression<? extends Number> x)	Create an expression returning the square root of its argument.
JpaFunction<String>	substring(Expression<String> x, int from)	Create a substring expression.
JpaFunction<String>	substring(Expression<String> x, int from, int len)	Create a substring expression.
JpaFunction<String>	substring(Expression<String> x, Expression<Integer> from)	Create a substring expression.
JpaFunction<String>	substring(Expression<String> x, Expression<Integer> from, Expression<Integer> len)	Create a substring expression.
<T extends Temporal> JpaExpression<T>	subtractDuration(Expression<T> datetime, Expression<Duration> duration)	Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.
<T extends Temporal> JpaExpression<T>	subtractDuration(Expression<T> datetime, Duration duration)	Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.
<T extends Temporal> JpaExpression<T>	subtractDuration(T datetime, Expression<Duration> duration)	Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.
<N extends Number> JpaExpression<N>	sum(Expression<? extends N> x, Expression<? extends N> y)	Create an expression returning a numeric sum.
<N extends Number> JpaExpression<N>	sum(Expression<? extends N> x, N y)	Create an expression returning a numeric sum.
<N extends Number> JpaExpression<N>	sum(Expression<N> argument)	Create an expression returning a numeric sum.
<N extends Number> JpaExpression<Number>	sum(Expression<N> argument, JpaPredicate filter)
<N extends Number> JpaExpression<Number>	sum(Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create a sum aggregate function expression.
<N extends Number> JpaExpression<Number>	sum(Expression<N> argument, JpaWindow window)
<N extends Number> JpaExpression<N>	sum(N x, Expression<? extends N> y)	Create an expression returning a numeric sum.
JpaExpression<Double>	sumAsDouble(Expression<Float> argument)	Create an aggregate expression returning the sum as a Double.
JpaExpression<Long>	sumAsLong(Expression<Integer> argument)	Create an aggregate expression returning the sum as a Long.
JpaExpression<Double>	tan(Expression<? extends Number> x)	Create an expression that returns the tangent of its argument.
JpaExpression<Double>	tanh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic tangent of its argument.
JpaExpression<BigDecimal>	toBigDecimal(Expression<? extends Number> number)	Create an expression converted to BigDecimal.
JpaExpression<BigInteger>	toBigInteger(Expression<? extends Number> number)	Create an expression converted to BigInteger.
JpaExpression<Double>	toDouble(Expression<? extends Number> number)	Create an expression converted to Double.
JpaExpression<Float>	toFloat(Expression<? extends Number> number)	Create an expression converted to Float.
JpaExpression<Integer>	toInteger(Expression<? extends Number> number)	Create an expression converted to Integer.
JpaExpression<Long>	toLong(Expression<? extends Number> number)	Create an expression converted to Long.
JpaExpression<String>	toString(Expression<Character> character)	Create an expression converted to String.
<X, T, E extends T> JpaCollectionJoin<X,E>	treat(CollectionJoin<X,T> join, Class<E> type)	Downcast the given collection join to the specified subtype.
<X, Y, T extends Y> JpaFrom<X,T>	treat(From<X,Y> from, Class<T> type)	Downcast the given from element to the specified subtype.
<X, T, V extends T> JpaJoin<X,V>	treat(Join<X,T> join, Class<V> type)	Downcast the given join to the specified subtype.
<X, T, E extends T> JpaListJoin<X,E>	treat(ListJoin<X,T> join, Class<E> type)	Downcast the given list join to the specified subtype.
<X, K, T, V extends T> JpaMapJoin<X,K,V>	treat(MapJoin<X,K,T> join, Class<V> type)	Downcast the given map join to the specified subtype.
<X, T extends X> JpaPath<T>	treat(Path<X> path, Class<T> type)	Downcast the given path to the specified subtype.
<X, T extends X> JpaRoot<T>	treat(Root<X> root, Class<T> type)	Downcast the given root to the specified subtype.
<X, T, E extends T> JpaSetJoin<X,E>	treat(SetJoin<X,T> join, Class<E> type)	Downcast the given set join to the specified subtype.
JpaFunction<String>	trim(char t, Expression<String> x)	Create a trim expression.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, char t, Expression<String> x)	Create a trim expression.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<Character> t, Expression<String> x)	Create a trim expression.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<String> x)	Create a trim expression.
JpaFunction<String>	trim(Expression<Character> t, Expression<String> x)	Create a trim expression.
JpaFunction<String>	trim(Expression<String> x)	Create a trim expression.
<T extends Number> JpaExpression<T>	truncate(Expression<T> x, Integer n)	Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
<T extends TemporalAccessor> JpaFunction<T>	truncate(Expression<T> datetime, TemporalUnit temporalUnit)	Truncates a date, time or datetime expression to the given TemporalUnit.
JpaCompoundSelection<Tuple>	tuple(Selection<?>... selections)	Create a tuple-valued compound selection.
JpaCompoundSelection<Tuple>	tuple(List<Selection<?>> selections)	Create a tuple-valued compound selection from a list of selections.
<T> JpaCriteriaQuery<T>	union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create a union or union all set operation over the given criteria queries.
<T> JpaSubQuery<T>	union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)	Create a union or union all set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	union(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create a union set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	union(CriteriaQuery<? extends T> left, CriteriaQuery<? extends T> right)	Create a union set operation over two criteria queries.
<T> CriteriaSelect<T>	union(CriteriaSelect<? extends T> left, CriteriaSelect<? extends T> right)	Create a union set operation over two criteria selects.
default <T> JpaSubQuery<T>	union(Subquery<? extends T> query1, Subquery<?>... queries)	Create a union set operation over the given subqueries.
default <T> JpaCriteriaQuery<T>	unionAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)	Create a union all set operation over the given criteria queries.
<T> JpaCriteriaQuery<T>	unionAll(CriteriaQuery<? extends T> left, CriteriaQuery<? extends T> right)	Create a union all set operation over two criteria queries.
<T> CriteriaSelect<T>	unionAll(CriteriaSelect<? extends T> left, CriteriaSelect<? extends T> right)	Create a union all set operation over two criteria selects.
default <T> JpaSubQuery<T>	unionAll(JpaSubQuery<? extends T> query1, JpaSubQuery<? extends T> query2)	Create a union all set operation over two subqueries.
<E> JpaSetReturningFunction<E>	unnestArray(Expression<E[]> array)	Creates an unnest function expression to turn an array into a set of rows.
<E> JpaSetReturningFunction<E>	unnestCollection(Expression<? extends Collection<E>> collection)	Creates an unnest function expression to turn an array into a set of rows.
<T extends HibernateCriteriaBuilder> T	unwrap(Class<T> clazz)	Unwrap this criteria builder to a Hibernate criteria builder extension.
JpaFunction<String>	upper(Expression<String> x)	Create an expression returning an uppercase string.
<T> JpaExpression<T>	value(T value)	Create an expression for a Java value, using the configured value handling mode.
JpaValues	values(Expression<?>... expressions)	Create a row of values for an insert-values criteria statement.
JpaValues	values(List<? extends Expression<?>> expressions)	Create a row of values for an insert-values criteria statement.
JpaExpression<?>	version(Path<?> path)	Create an expression representing the version of the given path.
<T> JpaExpression<T>	windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)	Create a generic window function expression that will be applied over the specified window.
JpaPredicate	wrap(BooleanExpression... expressions)	Wrap boolean expressions as predicates and combine them with conjunction.
JpaPredicate	wrap(Expression<Boolean> expression)	Wrap a boolean expression as a predicate.
JpaPredicate	wrap(Expression<Boolean>... expressions)	Wrap boolean expressions as predicates and combine them with conjunction.
JpaExpression<String>	xmlagg(JpaOrder order, Expression<?> argument)
JpaExpression<String>	xmlagg(JpaOrder order, JpaPredicate filter, Expression<?> argument)
JpaExpression<String>	xmlagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument)	Create a xmlagg ordered set-aggregate function expression.
JpaExpression<String>	xmlagg(JpaOrder order, JpaWindow window, Expression<?> argument)
JpaExpression<String>	xmlcomment(String comment)	Creates an XML comment with the given argument as content.
JpaExpression<String>	xmlconcat(Expression<?>... elements)	Concatenates the given XML element expressions.
JpaExpression<String>	xmlconcat(List<? extends Expression<?>> elements)	Concatenates the given XML element expressions.
JpaXmlElementExpression	xmlelement(String elementName)	Creates an XML element with the given element name.
JpaExpression<Boolean>	xmlexists(Expression<String> query, Expression<?> xmlDocument)	Checks if the given XPath or XQuery query exists in the given XML document.
JpaExpression<Boolean>	xmlexists(String query, Expression<?> xmlDocument)	Checks if the given XPath or XQuery query exists in the given XML document.
JpaExpression<String>	xmlforest(Expression<?>... elements)	Creates an XML forest from the given XML element expressions.
JpaExpression<String>	xmlforest(List<? extends Expression<?>> elements)	Creates an XML forest from the given XML element expressions.
JpaExpression<String>	xmlpi(String elementName)	Creates an XML processing with the given name.
JpaExpression<String>	xmlpi(String elementName, Expression<String> content)	Creates an XML processing with the given name and content.
JpaExpression<String>	xmlquery(Expression<String> query, Expression<?> xmlDocument)	Queries the given XML document with the given XPath or XQuery query.
JpaExpression<String>	xmlquery(String query, Expression<?> xmlDocument)	Queries the given XML document with the given XPath or XQuery query.
JpaXmlTableFunction	xmlTable(Expression<String> xpath, Expression<?> xmlDocument)	Creates a xmltable function expression to generate rows from XML elements.
JpaXmlTableFunction	xmlTable(String xpath, Expression<?> xmlDocument)	Creates a xmltable function expression to generate rows from XML elements.
JpaFunction<Integer>	year(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.

Methods inherited from interface CriteriaBuilder

asc, augment, augment, augment, booleanLiteral, convertedParameter, createCriteriaDelete, createCriteriaDelete, createCriteriaUpdate, createCriteriaUpdate, createQuery, createQuery, desc, greatest, greatest, least, least, numericLiteral, stringLiteral, temporalLiteral

Method Details

cast

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

Create an expression that casts the given expression to the specified Java type.

Type Parameters:

X - The target expression type

T - The source expression type

Parameters:

expression - The expression to cast

castTargetJavaType - The target Java type

Returns:

the cast expression

cast

@Nonnull
<X,T> JpaExpression<X> cast(@Nonnull
 JpaExpression<T> expression,
 @Nonnull
 JpaCastTarget<X> castTarget)

Create an expression that casts the given expression to the specified cast target.

Type Parameters:

X - The target expression type

T - The source expression type

Parameters:

expression - The expression to cast

castTarget - The cast target descriptor

Returns:

the cast expression

castTarget

@Nonnull
<X> JpaCastTarget<X> castTarget(@Nonnull
 Class<X> castTargetJavaType)

Create a cast target for the given Java type.

Type Parameters:

X - The target type

Parameters:

castTargetJavaType - The target Java type

Returns:

the cast target descriptor

castTarget

@Nonnull
<X> JpaCastTarget<X> castTarget(@Nonnull
 Class<X> castTargetJavaType,
 long length)

Create a cast target for the given Java type and SQL type length.

Type Parameters:

X - The target type

Parameters:

castTargetJavaType - The target Java type

length - The SQL type length

Returns:

the cast target descriptor

castTarget

@Nonnull
<X> JpaCastTarget<X> castTarget(@Nonnull
 Class<X> castTargetJavaType,
 int precision,
 int scale)

Create a cast target for the given Java type, precision, and scale.

Type Parameters:

X - The target type

Parameters:

castTargetJavaType - The target Java type

precision - The SQL type precision

scale - The SQL type scale

Returns:

the cast target descriptor

wrap

@Nonnull
JpaPredicate wrap(@Nonnull
 Expression<Boolean> expression)

Wrap a boolean expression as a predicate.

Parameters:

expression - The boolean expression

Returns:

the predicate representing the expression

wrap

@Nonnull
JpaPredicate wrap(@Nonnull
 Expression<Boolean>... expressions)

Wrap boolean expressions as predicates and combine them with conjunction.

Parameters:

expressions - The boolean expressions

Returns:

the conjunction of the wrapped predicates

wrap

@Nonnull
JpaPredicate wrap(@Nonnull
 BooleanExpression... expressions)

Wrap boolean expressions as predicates and combine them with conjunction.

Parameters:

expressions - The boolean expressions

Returns:

the conjunction of the wrapped predicates

unwrap

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

Unwrap this criteria builder to a Hibernate criteria builder extension.

Type Parameters:

T - The extension type

Parameters:

clazz - The extension type to obtain

Returns:

the requested extension

createQuery

@Nonnull
JpaCriteriaQuery<Object> createQuery()

Create a criteria query.

Specified by:

createQuery in interface CriteriaBuilder

createQuery

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

Create a criteria query for the given result type.

Specified by:

createQuery in interface CriteriaBuilder

createTupleQuery

@Nonnull
JpaCriteriaQuery<Tuple> createTupleQuery()

Create a tuple-valued criteria query.

Specified by:

createTupleQuery in interface CriteriaBuilder

createCriteriaUpdate

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

Create a criteria update statement for the given entity type.

Specified by:

createCriteriaUpdate in interface CriteriaBuilder

createCriteriaDelete

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

Create a criteria delete statement for the given entity type.

Specified by:

createCriteriaDelete in interface CriteriaBuilder

createCriteriaInsertValues

@Nonnull
<T> JpaCriteriaInsertValues<T> createCriteriaInsertValues(@Nonnull
 Class<T> targetEntity)

Create a criteria insert statement which supplies explicit values.

Type Parameters:

T - The target entity type

Parameters:

targetEntity - The target entity type

Returns:

a new insert-values criteria statement

createCriteriaInsertSelect

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

Create a criteria insert statement which obtains inserted values from a select query.

Type Parameters:

T - The target entity type

Parameters:

targetEntity - The target entity type

Returns:

a new insert-select criteria statement

values

@Nonnull
@Incubating(since="6.3")
JpaValues values(@Nonnull
 Expression<?>... expressions)

Create a row of values for an insert-values criteria statement.

Parameters:

expressions - The value expressions in row order

Returns:

the values row

values

@Nonnull
@Incubating(since="6.3")
JpaValues values(@Nonnull
 List<? extends Expression<?>> expressions)

Create a row of values for an insert-values criteria statement.

Parameters:

expressions - The value expressions in row order

Returns:

the values row

createQuery

@Nonnull
<T> JpaCriteriaQuery<T> createQuery(@Nonnull
 String hql,
 @Nonnull
 Class<T> resultClass)

Transform the given HQL select query to an equivalent criteria query.

Parameters:

hql - The HQL select query

resultClass - The result type of the query

Returns:

the equivalent criteria query

Since:

6.3

unionAll

@Nonnull
default <T> JpaCriteriaQuery<T> unionAll(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create a union all set operation over the given criteria queries.

union

@Nonnull
default <T> JpaCriteriaQuery<T> union(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create a union set operation over the given criteria queries.

union

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

Create a union or union all set operation over the given criteria queries.

intersectAll

@Nonnull
default <T> JpaCriteriaQuery<T> intersectAll(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create an intersect all set operation over the given criteria queries.

intersect

@Nonnull
default <T> JpaCriteriaQuery<T> intersect(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create an intersect set operation over the given criteria queries.

intersect

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

Create an intersect or intersect all set operation over the given criteria queries.

exceptAll

@Nonnull
default <T> JpaCriteriaQuery<T> exceptAll(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create an except all set operation over the given criteria queries.

except

@Nonnull
default <T> JpaCriteriaQuery<T> except(@Nonnull
 CriteriaQuery<? extends T> query1,
 @Nonnull
 CriteriaQuery<?>... queries)

Create an except set operation over the given criteria queries.

except

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

Create an except or except all set operation over the given criteria queries.

union

@Nonnull
<T> CriteriaSelect<T> union(@Nonnull
 CriteriaSelect<? extends T> left,
 @Nonnull
 CriteriaSelect<? extends T> right)

Create a union set operation over two criteria selects.

Specified by:

union in interface CriteriaBuilder

union

@Nonnull
<T> JpaCriteriaQuery<T> union(@Nonnull
 CriteriaQuery<? extends T> left,
 @Nonnull
 CriteriaQuery<? extends T> right)

Create a union set operation over two criteria queries.

union

@Nonnull
default <T> JpaSubQuery<T> union(@Nonnull
 Subquery<? extends T> query1,
 @Nonnull
 Subquery<?>... queries)

Create a union set operation over the given subqueries.

union

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

Create a union or union all set operation over the given subqueries.

unionAll

@Nonnull
default <T> JpaSubQuery<T> unionAll(@Nonnull
 JpaSubQuery<? extends T> query1,
 @Nonnull
 JpaSubQuery<? extends T> query2)

Create a union all set operation over two subqueries.

unionAll

@Nonnull
<T> CriteriaSelect<T> unionAll(@Nonnull
 CriteriaSelect<? extends T> left,
 @Nonnull
 CriteriaSelect<? extends T> right)

Create a union all set operation over two criteria selects.

Specified by:

unionAll in interface CriteriaBuilder

unionAll

@Nonnull
<T> JpaCriteriaQuery<T> unionAll(@Nonnull
 CriteriaQuery<? extends T> left,
 @Nonnull
 CriteriaQuery<? extends T> right)

Create a union all set operation over two criteria queries.

intersect

@Nonnull
<T> CriteriaSelect<T> intersect(@Nonnull
 CriteriaSelect<? super T> left,
 @Nonnull
 CriteriaSelect<? super T> right)

Create a intersect set operation over two criteria selects.

Specified by:

intersect in interface CriteriaBuilder

intersectAll

@Nonnull
<T> CriteriaSelect<T> intersectAll(@Nonnull
 CriteriaSelect<? super T> left,
 @Nonnull
 CriteriaSelect<? super T> right)

Create a intersect all set operation over two criteria selects.

Specified by:

intersectAll in interface CriteriaBuilder

intersect

@Nonnull
<T> JpaCriteriaQuery<T> intersect(@Nonnull
 CriteriaQuery<? super T> left,
 @Nonnull
 CriteriaQuery<? super T> right)

Create an intersect set operation over two criteria queries.

intersectAll

@Nonnull
<T> JpaCriteriaQuery<T> intersectAll(@Nonnull
 CriteriaQuery<? super T> left,
 @Nonnull
 CriteriaQuery<? super T> right)

Create an intersect all set operation over two criteria queries.

intersectAll

@Nonnull
default <T> JpaSubQuery<T> intersectAll(@Nonnull
 Subquery<? extends T> query1,
 @Nonnull
 Subquery<?>... queries)

Create an intersect all set operation over the given subqueries.

intersect

@Nonnull
default <T> JpaSubQuery<T> intersect(@Nonnull
 Subquery<? extends T> query1,
 @Nonnull
 Subquery<?>... queries)

Create an intersect set operation over the given subqueries.

intersect

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

Create an intersect or intersect all set operation over the given subqueries.

except

@Nonnull
<T> CriteriaSelect<T> except(@Nonnull
 CriteriaSelect<T> left,
 @Nonnull
 CriteriaSelect<?> right)

Create a except set operation over two criteria selects.

Specified by:

except in interface CriteriaBuilder

exceptAll

@Nonnull
<T> CriteriaSelect<T> exceptAll(@Nonnull
 CriteriaSelect<T> left,
 @Nonnull
 CriteriaSelect<?> right)

Create a except all set operation over two criteria selects.

Specified by:

exceptAll in interface CriteriaBuilder

except

@Nonnull
<T> JpaCriteriaQuery<T> except(@Nonnull
 CriteriaQuery<T> left,
 @Nonnull
 CriteriaQuery<?> right)

Create an except set operation over two criteria queries.

exceptAll

@Nonnull
<T> JpaCriteriaQuery<T> exceptAll(@Nonnull
 CriteriaQuery<T> left,
 @Nonnull
 CriteriaQuery<?> right)

Create an except all set operation over two criteria queries.

exceptAll

@Nonnull
default <T> JpaSubQuery<T> exceptAll(@Nonnull
 Subquery<? extends T> query1,
 @Nonnull
 Subquery<?>... queries)

Create an except all set operation over the given subqueries.

except

@Nonnull
default <T> JpaSubQuery<T> except(@Nonnull
 Subquery<? extends T> query1,
 @Nonnull
 Subquery<?>... queries)

Create an except set operation over the given subqueries.

except

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

Create an except or except all set operation over the given subqueries.

sign

@Nonnull
JpaExpression<Integer> sign(@Nonnull
 Expression<? extends Number> x)

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

Specified by:

sign in interface CriteriaBuilder

Parameters:

x - The expression

Returns:

the sign

ceiling

@Nonnull
<N extends Number> JpaExpression<N> ceiling(@Nonnull
 Expression<N> x)

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

Specified by:

ceiling in interface CriteriaBuilder

Parameters:

x - The expression

Returns:

the ceiling

floor

@Nonnull
<N extends Number> JpaExpression<N> floor(@Nonnull
 Expression<N> x)

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

Specified by:

floor in interface CriteriaBuilder

Parameters:

x - The expression

Returns:

the floor

exp

@Nonnull
JpaExpression<Double> exp(@Nonnull
 Expression<? extends Number> x)

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

Specified by:

exp in interface CriteriaBuilder

Parameters:

x - The expression

Returns:

the exponential

ln

@Nonnull
JpaExpression<Double> ln(@Nonnull
 Expression<? extends Number> x)

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

Specified by:

ln in interface CriteriaBuilder

Parameters:

x - The expression

Returns:

the natural logarithm

power

@Nonnull
JpaExpression<Double> power(@Nonnull
 Expression<? extends Number> x,
 @Nonnull
 Expression<? extends Number> y)

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

Specified by:

power in interface CriteriaBuilder

Parameters:

x - The base

y - The exponent

Returns:

the base raised to the power of the exponent

power

@Nonnull
JpaExpression<Double> power(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

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

Specified by:

power in interface CriteriaBuilder

Parameters:

x - The base

y - The exponent

Returns:

the base raised to the power of the exponent

round

@Nonnull
<T extends Number> JpaExpression<T> round(@Nonnull
 Expression<T> x,
 @Nonnull
 Integer n)

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

Specified by:

round in interface CriteriaBuilder

Parameters:

x - The base

n - The number of decimal places

Returns:

the rounded value

truncate

@Nonnull
<T extends Number> JpaExpression<T> truncate(@Nonnull
 Expression<T> x,
 @Nullable
 Integer n)

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

Parameters:

x - The base

n - The number of decimal places

Returns:

the truncated value

localDate

@Nonnull
JpaExpression<LocalDate> localDate()

Create expression to return current local date.

Specified by:

localDate in interface CriteriaBuilder

Returns:

the expression for the current date

localDateTime

@Nonnull
JpaExpression<LocalDateTime> localDateTime()

Create expression to return current local datetime.

Specified by:

localDateTime in interface CriteriaBuilder

Returns:

the expression for the current timestamp

localTime

@Nonnull
JpaExpression<LocalTime> localTime()

Create expression to return current local time.

Specified by:

localTime in interface CriteriaBuilder

Returns:

the expression for the current time

id

@Nonnull
JpaExpression<?> id(@Nonnull
 Path<?> path)

Create an expression representing the identifier of the given path.

Parameters:

path - The entity path

Returns:

the identifier expression

version

@Nonnull
JpaExpression<?> version(@Nonnull
 Path<?> path)

Create an expression representing the version of the given path.

Parameters:

path - The entity path

Returns:

the version expression

fk

@Nonnull
JpaExpression<?> fk(@Nonnull
 Path<?> path)

Create an expression representing the foreign key of the given association path.

Parameters:

path - The association path

Returns:

the foreign-key expression

treat

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

Downcast the given path to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given root to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

@Nonnull
<X, Y, T extends Y> JpaFrom<X,T> treat(@Nonnull
 From<X,Y> from,
 @Nonnull
 Class<T> type)

Downcast the given from element to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given join to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given collection join to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given set join to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given list join to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

treat

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

Downcast the given map join to the specified subtype.

Specified by:

treat in interface CriteriaBuilder

construct

@Nonnull
<Y> JpaCompoundSelection<Y> construct(@Nonnull
 Class<Y> resultClass,
 @Nonnull
 Selection<?>... selections)

Create a compound selection using the specified result type constructor.

Specified by:

construct in interface CriteriaBuilder

construct

@Nonnull
<Y> JpaCompoundSelection<Y> construct(@Nonnull
 Class<Y> resultClass,
 @Nonnull
 List<? extends Selection<?>> arguments)

Create a compound selection whose arguments are supplied as a list.

Type Parameters:

Y - The result type

Parameters:

resultClass - The compound selection result type

arguments - The selection arguments

Returns:

the compound selection

tuple

@Nonnull
JpaCompoundSelection<Tuple> tuple(@Nonnull
 Selection<?>... selections)

Create a tuple-valued compound selection.

Specified by:

tuple in interface CriteriaBuilder

tuple

@Nonnull
JpaCompoundSelection<Tuple> tuple(@Nonnull
 List<Selection<?>> selections)

Create a tuple-valued compound selection from a list of selections.

Specified by:

tuple in interface CriteriaBuilder

array

@Nonnull
JpaCompoundSelection<Object[]> array(@Nonnull
 Selection<?>... selections)

Create an array-valued compound selection.

Specified by:

array in interface CriteriaBuilder

array

@Nonnull
JpaCompoundSelection<Object[]> array(@Nonnull
 List<Selection<?>> selections)

Create an array-valued compound selection from a list of selections.

Specified by:

array in interface CriteriaBuilder

array

@Nonnull
<Y> JpaCompoundSelection<Y> array(@Nonnull
 Class<Y> resultClass,
 @Nonnull
 Selection<?>... selections)

Create an array-valued compound selection with the given result array type.

array

@Nonnull
<Y> JpaCompoundSelection<Y> array(@Nonnull
 Class<Y> resultClass,
 @Nonnull
 List<? extends Selection<?>> selections)

Create an array-valued compound selection with the given result array type.

avg

@Nonnull
<N extends Number> JpaExpression<Double> avg(@Nonnull
 Expression<N> argument)

Create an aggregate expression returning the average of numeric values.

Specified by:

avg in interface CriteriaBuilder

sum

@Nonnull
<N extends Number> JpaExpression<N> sum(@Nonnull
 Expression<N> argument)

Create an expression returning a numeric sum.

Specified by:

sum in interface CriteriaBuilder

sumAsLong

@Nonnull
JpaExpression<Long> sumAsLong(@Nonnull
 Expression<Integer> argument)

Create an aggregate expression returning the sum as a Long.

Specified by:

sumAsLong in interface CriteriaBuilder

sumAsDouble

@Nonnull
JpaExpression<Double> sumAsDouble(@Nonnull
 Expression<Float> argument)

Create an aggregate expression returning the sum as a Double.

Specified by:

sumAsDouble in interface CriteriaBuilder

max

@Nonnull
<N extends Number> JpaExpression<N> max(@Nonnull
 Expression<N> argument)

Create an aggregate expression returning the maximum numeric value.

Specified by:

max in interface CriteriaBuilder

min

@Nonnull
<N extends Number> JpaExpression<N> min(@Nonnull
 Expression<N> argument)

Create an aggregate expression returning the minimum numeric value.

Specified by:

min in interface CriteriaBuilder

greatest

@Nonnull
<X extends Comparable<? super X>> JpaExpression<X> greatest(@Nonnull
 Expression<X> argument)

Create an aggregate expression returning the greatest comparable value.

Specified by:

greatest in interface CriteriaBuilder

least

@Nonnull
<X extends Comparable<? super X>> JpaExpression<X> least(@Nonnull
 Expression<X> argument)

Create an aggregate expression returning the least comparable value.

Specified by:

least in interface CriteriaBuilder

count

@Nonnull
JpaExpression<Long> count(@Nonnull
 Expression<?> argument)

Create an aggregate expression returning a row count.

Specified by:

count in interface CriteriaBuilder

countDistinct

@Nonnull
JpaExpression<Long> countDistinct(@Nonnull
 Expression<?> x)

Create an aggregate expression returning the count of distinct values.

Specified by:

countDistinct in interface CriteriaBuilder

count

@Nonnull
JpaExpression<Long> count()

Equivalent to HQL count(*).

neg

@Nonnull
<N extends Number> JpaExpression<N> neg(@Nonnull
 Expression<N> x)

Create an expression returning the arithmetic negation of its argument.

Specified by:

neg in interface CriteriaBuilder

abs

@Nonnull
<N extends Number> JpaExpression<N> abs(@Nonnull
 Expression<N> x)

Create an expression returning the absolute value of its argument.

Specified by:

abs in interface CriteriaBuilder

sum

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

Create an expression returning a numeric sum.

Specified by:

sum in interface CriteriaBuilder

sum

@Nonnull
<N extends Number> JpaExpression<N> sum(@Nonnull
 Expression<? extends N> x,
 @Nullable
 N y)

Create an expression returning a numeric sum.

Specified by:

sum in interface CriteriaBuilder

sum

@Nonnull
<N extends Number> JpaExpression<N> sum(@Nullable
 N x,
 @Nonnull
 Expression<? extends N> y)

Create an expression returning a numeric sum.

Specified by:

sum in interface CriteriaBuilder

prod

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

Create an expression returning a numeric product.

Specified by:

prod in interface CriteriaBuilder

prod

@Nonnull
<N extends Number> JpaExpression<N> prod(@Nonnull
 Expression<? extends N> x,
 @Nullable
 N y)

Create an expression returning a numeric product.

Specified by:

prod in interface CriteriaBuilder

prod

@Nonnull
<N extends Number> JpaExpression<N> prod(@Nullable
 N x,
 @Nonnull
 Expression<? extends N> y)

Create an expression returning a numeric product.

Specified by:

prod in interface CriteriaBuilder

diff

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

Create an expression returning a numeric difference.

Specified by:

diff in interface CriteriaBuilder

diff

@Nonnull
<N extends Number> JpaExpression<N> diff(@Nonnull
 Expression<? extends N> x,
 @Nullable
 N y)

Create an expression returning a numeric difference.

Specified by:

diff in interface CriteriaBuilder

diff

@Nonnull
<N extends Number> JpaExpression<N> diff(@Nullable
 N x,
 @Nonnull
 Expression<? extends N> y)

Create an expression returning a numeric difference.

Specified by:

diff in interface CriteriaBuilder

quot

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

Create an expression returning a numeric quotient.

Specified by:

quot in interface CriteriaBuilder

quot

@Nonnull
JpaExpression<Number> quot(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

Create an expression returning a numeric quotient.

Specified by:

quot in interface CriteriaBuilder

quot

@Nonnull
JpaExpression<Number> quot(@Nullable
 Number x,
 @Nonnull
 Expression<? extends Number> y)

Create an expression returning a numeric quotient.

Specified by:

quot in interface CriteriaBuilder

mod

@Nonnull
JpaExpression<Integer> mod(@Nonnull
 Expression<Integer> x,
 @Nonnull
 Expression<Integer> y)

Create an expression returning the remainder of integer division.

Specified by:

mod in interface CriteriaBuilder

mod

@Nonnull
JpaExpression<Integer> mod(@Nonnull
 Expression<Integer> x,
 @Nullable
 Integer y)

Create an expression returning the remainder of integer division.

Specified by:

mod in interface CriteriaBuilder

mod

@Nonnull
JpaExpression<Integer> mod(@Nullable
 Integer x,
 @Nonnull
 Expression<Integer> y)

Create an expression returning the remainder of integer division.

Specified by:

mod in interface CriteriaBuilder

sqrt

@Nonnull
JpaExpression<Double> sqrt(@Nonnull
 Expression<? extends Number> x)

Create an expression returning the square root of its argument.

Specified by:

sqrt in interface CriteriaBuilder

durationSum

@Nonnull
JpaExpression<Duration> durationSum(@Nonnull
 Expression<Duration> x,
 @Nonnull
 Expression<Duration> y)

Add two durations.

Since:

6.3

durationSum

@Nonnull
JpaExpression<Duration> durationSum(@Nonnull
 Expression<Duration> x,
 @Nullable
 Duration y)

Add two durations.

Since:

6.3

durationDiff

@Nonnull
JpaExpression<Duration> durationDiff(@Nonnull
 Expression<Duration> x,
 @Nonnull
 Expression<Duration> y)

Subtract one duration from another.

Since:

6.3

durationDiff

@Nonnull
JpaExpression<Duration> durationDiff(@Nonnull
 Expression<Duration> x,
 @Nullable
 Duration y)

Subtract one duration from another.

Since:

6.3

durationScaled

@Nonnull
JpaExpression<Duration> durationScaled(@Nonnull
 Expression<? extends Number> number,
 @Nonnull
 Expression<Duration> duration)

Scale a duration by a number.

Since:

6.3

durationScaled

@Nonnull
JpaExpression<Duration> durationScaled(@Nullable
 Number number,
 @Nonnull
 Expression<Duration> duration)

Scale a duration by a number.

Since:

6.3

durationScaled

@Nonnull
JpaExpression<Duration> durationScaled(@Nonnull
 Expression<? extends Number> number,
 @Nullable
 Duration duration)

Scale a duration by a number.

Since:

6.3

duration

@Nonnull
@Incubating(since="6.3")
JpaExpression<Duration> duration(long magnitude,
 @Nonnull
 TemporalUnit unit)

A literal Duration, for example, "five days" or "30 minutes".

Since:

6.3

durationByUnit

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> durationByUnit(@Nonnull
 TemporalUnit unit,
 @Nonnull
 Expression<Duration> duration)

Convert a Duration to a numeric magnitude in the given units.

Parameters:

unit - The temporal granularity

duration - The duration in a "unit-free" form

Returns:

the magnitude of the duration measured in the given units

Since:

6.3

durationBetween

@Nonnull
<T extends Temporal> JpaExpression<Duration> durationBetween(@Nonnull
 Expression<T> x,
 @Nonnull
 Expression<T> y)

Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.

Since:

6.3

durationBetween

@Nonnull
<T extends Temporal> JpaExpression<Duration> durationBetween(@Nonnull
 Expression<T> x,
 @Nullable
 T y)

Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.

Since:

6.3

addDuration

@Nonnull
<T extends Temporal> JpaExpression<T> addDuration(@Nonnull
 Expression<T> datetime,
 @Nonnull
 Expression<Duration> duration)

Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

addDuration

@Nonnull
<T extends Temporal> JpaExpression<T> addDuration(@Nonnull
 Expression<T> datetime,
 @Nullable
 Duration duration)

Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

addDuration

@Nonnull
<T extends Temporal> JpaExpression<T> addDuration(@Nullable
 T datetime,
 @Nonnull
 Expression<Duration> duration)

Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

subtractDuration

@Nonnull
<T extends Temporal> JpaExpression<T> subtractDuration(@Nonnull
 Expression<T> datetime,
 @Nonnull
 Expression<Duration> duration)

Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

subtractDuration

@Nonnull
<T extends Temporal> JpaExpression<T> subtractDuration(@Nonnull
 Expression<T> datetime,
 @Nullable
 Duration duration)

Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

subtractDuration

@Nonnull
<T extends Temporal> JpaExpression<T> subtractDuration(@Nullable
 T datetime,
 @Nonnull
 Expression<Duration> duration)

Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.

Since:

6.3

toLong

@Nonnull
JpaExpression<Long> toLong(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to Long.

Specified by:

toLong in interface CriteriaBuilder

toInteger

@Nonnull
JpaExpression<Integer> toInteger(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to Integer.

Specified by:

toInteger in interface CriteriaBuilder

toFloat

@Nonnull
JpaExpression<Float> toFloat(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to Float.

Specified by:

toFloat in interface CriteriaBuilder

toDouble

@Nonnull
JpaExpression<Double> toDouble(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to Double.

Specified by:

toDouble in interface CriteriaBuilder

toBigDecimal

@Nonnull
JpaExpression<BigDecimal> toBigDecimal(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to BigDecimal.

Specified by:

toBigDecimal in interface CriteriaBuilder

toBigInteger

@Nonnull
JpaExpression<BigInteger> toBigInteger(@Nonnull
 Expression<? extends Number> number)

Create an expression converted to BigInteger.

Specified by:

toBigInteger in interface CriteriaBuilder

toString

@Nonnull
JpaExpression<String> toString(@Nonnull
 Expression<Character> character)

Create an expression converted to String.

Specified by:

toString in interface CriteriaBuilder

literal

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

Create a literal expression for the given value.

Specified by:

literal in interface CriteriaBuilder

literals

@Nonnull
<T> List<? extends JpaExpression<T>> literals(@Nonnull
 T... values)

Create literal expressions for each of the given values.

literals

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

Create literal expressions for each value in the given list.

nullLiteral

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

Create a null literal expression of the given type.

Specified by:

nullLiteral in interface CriteriaBuilder

parameter

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

Create a parameter expression.

Specified by:

parameter in interface CriteriaBuilder

parameter

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

Create a parameter expression.

Specified by:

parameter in interface CriteriaBuilder

listParameter

@Nonnull
<T> JpaParameterExpression<List<T>> listParameter(@Nonnull
 Class<T> paramClass)

Create a multivalued parameter accepting multiple arguments packaged together as a List.

Type Parameters:

T - The type of each argument to the parameter

Parameters:

paramClass - The type of each argument to the parameter

Since:

7.0

listParameter

@Nonnull
<T> JpaParameterExpression<List<T>> listParameter(@Nonnull
 Class<T> paramClass,
 @Nullable
 String name)

Create a multivalued parameter accepting multiple arguments packaged together as a List.

Type Parameters:

T - The type of each argument to the parameter

Parameters:

paramClass - The type of each argument to the parameter

name - The parameter name

Since:

7.0

concat

@Nonnull
JpaExpression<String> concat(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> y)

Create a string concatenation expression.

Specified by:

concat in interface CriteriaBuilder

concat

@Nonnull
JpaExpression<String> concat(@Nonnull
 Expression<String> x,
 @Nonnull
 String y)

Create a string concatenation expression.

Specified by:

concat in interface CriteriaBuilder

concat

@Nonnull
JpaExpression<String> concat(@Nonnull
 String x,
 @Nonnull
 Expression<String> y)

Create a string concatenation expression.

Specified by:

concat in interface CriteriaBuilder

concat

@Nonnull
JpaExpression<String> concat(@Nullable
 String x,
 @Nullable
 String y)

Create an expression that concatenates two string literals.

substring

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

Create a substring expression.

Specified by:

substring in interface CriteriaBuilder

substring

@Nonnull
JpaFunction<String> substring(@Nonnull
 Expression<String> x,
 int from)

Create a substring expression.

Specified by:

substring in interface CriteriaBuilder

substring

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

Create a substring expression.

Specified by:

substring in interface CriteriaBuilder

substring

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

Create a substring expression.

Specified by:

substring in interface CriteriaBuilder

trim

@Nonnull
JpaFunction<String> trim(@Nonnull
 Expression<String> x)

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

trim

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

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

trim

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

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

trim

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

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

trim

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

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

trim

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

Create a trim expression.

Specified by:

trim in interface CriteriaBuilder

lower

@Nonnull
JpaFunction<String> lower(@Nonnull
 Expression<String> x)

Create an expression returning a lowercase string.

Specified by:

lower in interface CriteriaBuilder

upper

@Nonnull
JpaFunction<String> upper(@Nonnull
 Expression<String> x)

Create an expression returning an uppercase string.

Specified by:

upper in interface CriteriaBuilder

length

@Nonnull
JpaFunction<Integer> length(@Nonnull
 Expression<String> x)

Create an expression returning the length of a string.

Specified by:

length in interface CriteriaBuilder

locate

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

Create an expression returning the position of a substring.

Specified by:

locate in interface CriteriaBuilder

locate

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

Create an expression returning the position of a substring.

Specified by:

locate in interface CriteriaBuilder

locate

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

Create an expression returning the position of a substring.

Specified by:

locate in interface CriteriaBuilder

locate

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

Create an expression returning the position of a substring.

Specified by:

locate in interface CriteriaBuilder

currentDate

@Nonnull
JpaFunction<Date> currentDate()

Create an expression for the current SQL date.

Specified by:

currentDate in interface CriteriaBuilder

currentTime

@Nonnull
JpaFunction<Time> currentTime()

Create an expression for the current SQL time.

Specified by:

currentTime in interface CriteriaBuilder

currentTimestamp

@Nonnull
JpaFunction<Timestamp> currentTimestamp()

Create an expression for the current SQL timestamp.

Specified by:

currentTimestamp in interface CriteriaBuilder

currentInstant

@Nonnull
JpaFunction<Instant> currentInstant()

Create an expression for the current instant.

function

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

Create an expression invoking a database function.

Specified by:

function in interface CriteriaBuilder

all

@Nonnull
<Y> JpaExpression<Y> all(@Nonnull
 Subquery<Y> subquery)

Create an all quantified expression over a subquery.

Specified by:

all in interface CriteriaBuilder

some

@Nonnull
<Y> JpaExpression<Y> some(@Nonnull
 Subquery<Y> subquery)

Create a some quantified expression over a subquery.

Specified by:

some in interface CriteriaBuilder

any

@Nonnull
<Y> JpaExpression<Y> any(@Nonnull
 Subquery<Y> subquery)

Create an any quantified expression over a subquery.

Specified by:

any in interface CriteriaBuilder

indexes

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

Create an expression representing the indexes of the given list.

value

@Nonnull
<T> JpaExpression<T> value(@Nullable
 T value)

Create an expression for a Java value, using the configured value handling mode.

size

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

Create an expression returning the size of a collection.

Specified by:

size in interface CriteriaBuilder

size

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

Create an expression returning the size of a collection.

Specified by:

size in interface CriteriaBuilder

coalesce

@Nonnull
<T> JpaCoalesce<T> coalesce()

Create a coalesce expression.

Specified by:

coalesce in interface CriteriaBuilder

coalesce

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

Create a coalesce expression.

Specified by:

coalesce in interface CriteriaBuilder

coalesce

@Nonnull
<Y> JpaCoalesce<Y> coalesce(@Nonnull
 Expression<? extends Y> x,
 @Nullable
 Y y)

Create a coalesce expression.

Specified by:

coalesce in interface CriteriaBuilder

nullif

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

Create a nullif expression.

Specified by:

nullif in interface CriteriaBuilder

nullif

@Nonnull
<Y> JpaExpression<Y> nullif(@Nonnull
 Expression<Y> x,
 @Nullable
 Y y)

Create a nullif expression.

Specified by:

nullif in interface CriteriaBuilder

selectCase

@Nonnull
<C,R> JpaSimpleCase<C,R> selectCase(@Nonnull
 Expression<? extends C> expression)

Create a simple case expression.

Specified by:

selectCase in interface CriteriaBuilder

selectCase

@Nonnull
<C,R> JpaSimpleCase<C,R> selectCase(@Nonnull
 Expression<? extends C> expression,
 @Nonnull
 Class<R> resultType)

Create a case expression with the given result type.

Specified by:

selectCase in interface CriteriaBuilder

selectCase

@Nonnull
<R> JpaSearchedCase<R> selectCase()

Create a searched case expression.

Specified by:

selectCase in interface CriteriaBuilder

selectCase

@Nonnull
<R> JpaSearchedCase<R> selectCase(@Nonnull
 Class<R> resultType)

Create a case expression with the given result type.

Specified by:

selectCase in interface CriteriaBuilder

and

@Nonnull
JpaPredicate and(@Nonnull
 Expression<Boolean> x,
 @Nonnull
 Expression<Boolean> y)

Create a conjunction predicate.

Specified by:

and in interface CriteriaBuilder

and

@Nonnull
JpaPredicate and(@Nonnull
 BooleanExpression... restrictions)

Create a conjunction predicate.

Specified by:

and in interface CriteriaBuilder

and

@Nonnull
JpaPredicate and(@Nonnull
 List<? extends Expression<Boolean>> restrictions)

Create a conjunction predicate.

Specified by:

and in interface CriteriaBuilder

and

@Nonnull
@Deprecated
JpaPredicate and(@Nonnull
 Predicate... restrictions)

Deprecated.

Prefer and(BooleanExpression...) instead. This method used to be defined as part of Jakarta Persistence, which removed it as of 4.0.

or

@Nonnull
JpaPredicate or(@Nonnull
 Expression<Boolean> x,
 @Nonnull
 Expression<Boolean> y)

Create a disjunction predicate.

Specified by:

or in interface CriteriaBuilder

or

@Nonnull
JpaPredicate or(@Nonnull
 BooleanExpression... restrictions)

Create a disjunction predicate.

Specified by:

or in interface CriteriaBuilder

or

@Nonnull
JpaPredicate or(@Nonnull
 List<? extends Expression<Boolean>> restrictions)

Create a disjunction predicate.

Specified by:

or in interface CriteriaBuilder

or

@Nonnull
@Deprecated
JpaPredicate or(@Nonnull
 Predicate... restrictions)

Deprecated.

Prefer or(BooleanExpression...) instead. This method used to be defined as part of Jakarta Persistence, which removed it as of 4.0.

not

@Nonnull
JpaPredicate not(@Nonnull
 Expression<Boolean> restriction)

Create a negated predicate.

Specified by:

not in interface CriteriaBuilder

conjunction

@Nonnull
JpaPredicate conjunction()

Create a predicate that is always true.

Specified by:

conjunction in interface CriteriaBuilder

disjunction

@Nonnull
JpaPredicate disjunction()

Create a predicate that is always false.

Specified by:

disjunction in interface CriteriaBuilder

isTrue

@Nonnull
JpaPredicate isTrue(@Nonnull
 Expression<Boolean> x)

Create a predicate testing whether an expression is true.

Specified by:

isTrue in interface CriteriaBuilder

isFalse

@Nonnull
JpaPredicate isFalse(@Nonnull
 Expression<Boolean> x)

Create a predicate testing whether an expression is false.

Specified by:

isFalse in interface CriteriaBuilder

isNull

@Nonnull
JpaPredicate isNull(@Nonnull
 Expression<?> x)

Create a predicate testing whether an expression is null.

Specified by:

isNull in interface CriteriaBuilder

isNotNull

@Nonnull
JpaPredicate isNotNull(@Nonnull
 Expression<?> x)

Create a predicate testing whether an expression is not null.

Specified by:

isNotNull in interface CriteriaBuilder

equal

@Nonnull
JpaPredicate equal(@Nonnull
 Expression<?> x,
 @Nonnull
 Expression<?> y)

Create an equality predicate.

Specified by:

equal in interface CriteriaBuilder

equal

@Nonnull
JpaPredicate equal(@Nonnull
 Expression<?> x,
 @Nullable
 Object y)

Create an equality predicate.

Specified by:

equal in interface CriteriaBuilder

notEqual

@Nonnull
JpaPredicate notEqual(@Nonnull
 Expression<?> x,
 @Nonnull
 Expression<?> y)

Create an inequality predicate.

Specified by:

notEqual in interface CriteriaBuilder

notEqual

@Nonnull
JpaPredicate notEqual(@Nonnull
 Expression<?> x,
 @Nullable
 Object y)

Create an inequality predicate.

Specified by:

notEqual in interface CriteriaBuilder

distinctFrom

@Nonnull
JpaPredicate distinctFrom(@Nonnull
 Expression<?> x,
 @Nonnull
 Expression<?> y)

Create a predicate testing whether two expressions are distinct, treating nulls as comparable values.

distinctFrom

@Nonnull
JpaPredicate distinctFrom(@Nonnull
 Expression<?> x,
 @Nullable
 Object y)

Create a predicate testing whether an expression and a value are distinct, treating nulls as comparable values.

notDistinctFrom

@Nonnull
JpaPredicate notDistinctFrom(@Nonnull
 Expression<?> x,
 @Nonnull
 Expression<?> y)

Create a predicate testing whether two expressions are not distinct, treating nulls as comparable values.

notDistinctFrom

@Nonnull
JpaPredicate notDistinctFrom(@Nonnull
 Expression<?> x,
 @Nullable
 Object y)

Create a predicate testing whether an expression and a value are not distinct, treating nulls as comparable values.

greaterThan

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

Create a greater-than predicate for comparable expressions.

Specified by:

greaterThan in interface CriteriaBuilder

greaterThan

@Nonnull
<Y extends Comparable<? super Y>> JpaPredicate greaterThan(@Nonnull
 Expression<? extends Y> x,
 @Nullable
 Y y)

Create a greater-than predicate for comparable expressions.

Specified by:

greaterThan in interface CriteriaBuilder

greaterThanOrEqualTo

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

Create a greater-than-or-equal predicate for comparable expressions.

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

greaterThanOrEqualTo

@Nonnull
<Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo(@Nonnull
 Expression<? extends Y> x,
 @Nullable
 Y y)

Create a greater-than-or-equal predicate for comparable expressions.

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

lessThan

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

Create a less-than predicate for comparable expressions.

Specified by:

lessThan in interface CriteriaBuilder

lessThan

@Nonnull
<Y extends Comparable<? super Y>> JpaPredicate lessThan(@Nonnull
 Expression<? extends Y> x,
 @Nullable
 Y y)

Create a less-than predicate for comparable expressions.

Specified by:

lessThan in interface CriteriaBuilder

lessThanOrEqualTo

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

Create a less-than-or-equal predicate for comparable expressions.

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

lessThanOrEqualTo

@Nonnull
<Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo(@Nonnull
 Expression<? extends Y> x,
 @Nullable
 Y y)

Create a less-than-or-equal predicate for comparable expressions.

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

between

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

Create a predicate testing whether a value is between two bounds.

Specified by:

between in interface CriteriaBuilder

between

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

Create a predicate testing whether a value is between two bounds.

Specified by:

between in interface CriteriaBuilder

between

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

Create a predicate testing whether a value is between two bounds.

Specified by:

between in interface CriteriaBuilder

gt

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

Create a greater-than predicate for numeric expressions.

Specified by:

gt in interface CriteriaBuilder

gt

@Nonnull
JpaPredicate gt(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

Create a greater-than predicate for numeric expressions.

Specified by:

gt in interface CriteriaBuilder

ge

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

Create a greater-than-or-equal predicate for numeric expressions.

Specified by:

ge in interface CriteriaBuilder

ge

@Nonnull
JpaPredicate ge(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

Create a greater-than-or-equal predicate for numeric expressions.

Specified by:

ge in interface CriteriaBuilder

lt

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

Create a less-than predicate for numeric expressions.

Specified by:

lt in interface CriteriaBuilder

lt

@Nonnull
JpaPredicate lt(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

Create a less-than predicate for numeric expressions.

Specified by:

lt in interface CriteriaBuilder

le

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

Create a less-than-or-equal predicate for numeric expressions.

Specified by:

le in interface CriteriaBuilder

le

@Nonnull
JpaPredicate le(@Nonnull
 Expression<? extends Number> x,
 @Nullable
 Number y)

Create a less-than-or-equal predicate for numeric expressions.

Specified by:

le in interface CriteriaBuilder

isEmpty

@Nonnull
<C extends Collection<?>> JpaPredicate isEmpty(@Nonnull
 Expression<C> collection)

Create a predicate testing whether a collection is empty.

Specified by:

isEmpty in interface CriteriaBuilder

isNotEmpty

@Nonnull
<C extends Collection<?>> JpaPredicate isNotEmpty(@Nonnull
 Expression<C> collection)

Create a predicate testing whether a collection is not empty.

Specified by:

isNotEmpty in interface CriteriaBuilder

isMember

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

Create a predicate testing whether an element is a member of a collection.

Specified by:

isMember in interface CriteriaBuilder

isMember

@Nonnull
<E, C extends Collection<E>> JpaPredicate isMember(@Nullable
 E elem,
 @Nonnull
 Expression<C> collection)

Create a predicate testing whether an element is a member of a collection.

Specified by:

isMember in interface CriteriaBuilder

isNotMember

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

Create a predicate testing whether an element is not a member of a collection.

Specified by:

isNotMember in interface CriteriaBuilder

isNotMember

@Nonnull
<E, C extends Collection<E>> JpaPredicate isNotMember(@Nullable
 E elem,
 @Nonnull
 Expression<C> collection)

Create a predicate testing whether an element is not a member of a collection.

Specified by:

isNotMember in interface CriteriaBuilder

like

@Nonnull
JpaPredicate like(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern)

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

like

@Nonnull
JpaPredicate like(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

like

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

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

like

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

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

like

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

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

like

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

Create a like predicate.

Specified by:

like in interface CriteriaBuilder

ilike

@Nonnull
JpaPredicate ilike(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern)

Create a case-insensitive like predicate.

ilike

@Nonnull
JpaPredicate ilike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern)

Create a case-insensitive like predicate.

ilike

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

Create a case-insensitive like predicate with an escape character expression.

ilike

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

Create a case-insensitive like predicate with an escape character.

ilike

@Nonnull
JpaPredicate ilike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern,
 @Nonnull
 Expression<Character> escapeChar)

Create a case-insensitive like predicate with an escape character expression.

ilike

@Nonnull
JpaPredicate ilike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern,
 char escapeChar)

Create a case-insensitive like predicate with an escape character.

notLike

@Nonnull
JpaPredicate notLike(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern)

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notLike

@Nonnull
JpaPredicate notLike(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notLike

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

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notLike

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

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notLike

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

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notLike

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

Create a negated like predicate.

Specified by:

notLike in interface CriteriaBuilder

notIlike

@Nonnull
JpaPredicate notIlike(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern)

Create a negated case-insensitive like predicate.

notIlike

@Nonnull
JpaPredicate notIlike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern)

Create a negated case-insensitive like predicate.

notIlike

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

Create a negated case-insensitive like predicate with an escape character expression.

notIlike

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

Create a negated case-insensitive like predicate with an escape character.

notIlike

@Nonnull
JpaPredicate notIlike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern,
 @Nonnull
 Expression<Character> escapeChar)

Create a negated case-insensitive like predicate with an escape character expression.

notIlike

@Nonnull
JpaPredicate notIlike(@Nonnull
 Expression<String> x,
 @Nullable
 String pattern,
 char escapeChar)

Create a negated case-insensitive like predicate with an escape character.

likeRegexp

@Nonnull
JpaPredicate likeRegexp(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a predicate testing whether a string expression matches a regular expression.

ilikeRegexp

@Nonnull
JpaPredicate ilikeRegexp(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a case-insensitive predicate testing whether a string expression matches a regular expression.

notLikeRegexp

@Nonnull
JpaPredicate notLikeRegexp(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a negated predicate testing whether a string expression matches a regular expression.

notIlikeRegexp

@Nonnull
JpaPredicate notIlikeRegexp(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern)

Create a negated case-insensitive predicate testing whether a string expression matches a regular expression.

in

@Nonnull
<T> JpaInPredicate<T> in(@Nonnull
 Expression<? extends T> expression)

Create an in predicate builder for the given expression.

Specified by:

in in interface CriteriaBuilder

in

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

Create an in predicate with expression values.

in

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

Create an in predicate with literal values.

in

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

Create an in predicate with values supplied as a collection.

exists

@Nonnull
JpaPredicate exists(@Nonnull
 Subquery<?> subquery)

Create a predicate testing whether a subquery returns results.

Specified by:

exists in interface CriteriaBuilder

isMapEmpty

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

Create a predicate that tests whether a Map is empty.

Parameters:

mapExpression - The map expression to check for emptiness

Returns:

the is-empty predicate

API Note:

Due to type-erasure we cannot name this the same as CriteriaBuilder.isEmpty(Expression).

isMapNotEmpty

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

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

Parameters:

mapExpression - The map expression to check for non-emptiness

Returns:

the is-not-empty predicate

API Note:

Due to type-erasure we cannot name this the same as CriteriaBuilder.isNotEmpty(Expression)

mapSize

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

Create an expression that tests the size of a map.

Parameters:

mapExpression - The map expression for which to calculate the size

Returns:

the size expression

API Note:

Due to type-erasure we cannot name this the same as CriteriaBuilder.size(Expression)

mapSize

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

Create an expression that tests the size of a map.

Parameters:

map - The map for which to calculate the size

Returns:

the size expression

sort

@Nonnull
JpaOrder sort(@Nonnull
 JpaExpression<?> sortExpression)

Create an ordering for the given sort expression.

sort

@Nonnull
JpaOrder sort(@Nonnull
 JpaExpression<?> sortExpression,
 @Nonnull
 SortDirection sortOrder)

Create an ordering for the given sort expression and direction.

sort

@Nonnull
JpaOrder sort(@Nonnull
 JpaExpression<?> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

Create an ordering for the given sort expression, direction, and null precedence.

sort

@Nonnull
JpaOrder sort(@Nonnull
 JpaExpression<?> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence,
 boolean ignoreCase)

Create an ordering for the given sort expression with optional case-insensitive comparison.

asc

@Nonnull
JpaOrder asc(@Nonnull
 Expression<?> x)

Create an ascending ordering for the given expression.

Specified by:

asc in interface CriteriaBuilder

desc

@Nonnull
JpaOrder desc(@Nonnull
 Expression<?> x)

Create a descending ordering for the given expression.

Specified by:

desc in interface CriteriaBuilder

asc

@Nonnull
JpaOrder asc(@Nonnull
 Expression<?> x,
 boolean nullsFirst)

Create an ordering by the ascending value of the expression.

Parameters:

x - The expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

the ascending ordering corresponding to the expression

desc

@Nonnull
JpaOrder desc(@Nonnull
 Expression<?> x,
 boolean nullsFirst)

Create an ordering by the descending value of the expression.

Parameters:

x - The expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

the descending ordering corresponding to the expression

search

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder search(@Nonnull
 JpaCteCriteriaAttribute cteAttribute,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

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

Parameters:

cteAttribute - The CTE attribute used to define the ordering

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

the ordering corresponding to the CTE attribute

search

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder search(@Nonnull
 JpaCteCriteriaAttribute cteAttribute,
 @Nonnull
 SortDirection sortOrder)

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

Parameters:

cteAttribute - The CTE attribute used to define the ordering

sortOrder - The sort order

Returns:

the ordering corresponding to the CTE attribute

search

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder search(@Nonnull
 JpaCteCriteriaAttribute cteAttribute)

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

Parameters:

cteAttribute - The CTE attribute used to define the ordering

Returns:

the ascending ordering corresponding to the CTE attribute

asc

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder asc(@Nonnull
 JpaCteCriteriaAttribute x)

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

Parameters:

x - The CTE attribute used to define the ordering

Returns:

the ascending ordering corresponding to the CTE attribute

desc

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder desc(@Nonnull
 JpaCteCriteriaAttribute x)

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

Parameters:

x - The CTE attribute used to define the ordering

Returns:

the descending ordering corresponding to the CTE attribute

asc

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder asc(@Nonnull
 JpaCteCriteriaAttribute x,
 boolean nullsFirst)

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

Parameters:

x - The CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

the ascending ordering corresponding to the CTE attribute

desc

@Nonnull
@Incubating(since="6.3")
JpaSearchOrder desc(@Nonnull
 JpaCteCriteriaAttribute x,
 boolean nullsFirst)

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

Parameters:

x - The CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

the descending ordering corresponding to the CTE attribute

sql

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> sql(@Nonnull
 String pattern,
 @Nonnull
 Class<T> type,
 @Nonnull
 Expression<?>... arguments)

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

Type Parameters:

T - The type of this expression

Parameters:

pattern - The native SQL pattern

type - The type of this expression

arguments - The optional arguments to the SQL pattern

Returns:

the native SQL expression

format

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> format(@Nonnull
 Expression<? extends TemporalAccessor> datetime,
 @Nonnull
 String pattern)

Format a date, time, or datetime according to a pattern. The pattern must be written in a subset of the pattern language defined by Java’s DateTimeFormatter.

See TemporalFormatSupport.appendFormat(SqlAppender, String) for a full list of pattern elements.

Parameters:

datetime - The datetime expression to format

pattern - The pattern to use for formatting

Returns:

the format expression

year

@Nonnull
@Incubating(since="6.3")
JpaFunction<Integer> year(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

month

@Nonnull
@Incubating(since="6.3")
JpaFunction<Integer> month(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

day

@Nonnull
@Incubating(since="6.3")
JpaFunction<Integer> day(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

hour

@Nonnull
@Incubating(since="6.3")
JpaFunction<Integer> hour(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

minute

@Nonnull
@Incubating(since="6.3")
JpaFunction<Integer> minute(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

second

@Nonnull
@Incubating(since="6.3")
JpaFunction<Float> second(@Nonnull
 Expression<? extends TemporalAccessor> datetime)

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

Parameters:

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

Returns:

the extracted value

truncate

@Nonnull
@Incubating(since="6.3")
<T extends TemporalAccessor> JpaFunction<T> truncate(@Nonnull
 Expression<T> datetime,
 @Nonnull
 TemporalUnit temporalUnit)

Truncates a date, time or datetime expression to the given TemporalUnit. Supported units are: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.

Truncating translates to obtaining a value of the same type in which all temporal units smaller than field have been pruned. For hours, minutes and second this means setting them to 00. For months and days, this means setting them to 01.

Parameters:

datetime - The date, time, or datetime expression to truncate

temporalUnit - The temporal unit for truncation

Returns:

the truncated value

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 int start)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 int start)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 @Nonnull
 Expression<Integer> start)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 @Nonnull
 Expression<Integer> start)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 int start,
 int length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 int start,
 int length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 @Nonnull
 Expression<Integer> start,
 int length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 @Nonnull
 Expression<Integer> start,
 int length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 int start,
 @Nullable
 Expression<Integer> length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 int start,
 @Nullable
 Expression<Integer> length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nullable
 String replacement,
 @Nonnull
 Expression<Integer> start,
 @Nullable
 Expression<Integer> length)

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> overlay(@Nonnull
 Expression<String> string,
 @Nonnull
 Expression<String> replacement,
 @Nonnull
 Expression<Integer> start,
 @Nullable
 Expression<Integer> length)

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

Parameters:

string - The string expression to manipulate

replacement - The replacement string expression

start - The start position

length - The optional number of characters to substitute

Returns:

the overlay expression

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 int length)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 int length)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 int length,
 char padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 int length,
 char padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length,
 char padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length,
 char padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 int length,
 @Nullable
 Expression<Character> padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 int length,
 @Nullable
 Expression<Character> padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length,
 @Nullable
 Expression<Character> padChar)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> pad(@Nullable
 CriteriaBuilder.Trimspec ts,
 @Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length,
 @Nullable
 Expression<Character> padChar)

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

Parameters:

ts - The optional CriteriaBuilder.Trimspec

x - The string expression to pad

length - The length of the result string after padding

padChar - The optional pad character

Returns:

the pad expression

repeat

@Nonnull
JpaFunction<String> repeat(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> times)

Concatenate the given string expression with itself the given number of times.

Parameters:

x - The string expression to concatenate

times - The number of times it should be repeated

Returns:

the repeat expression

repeat

@Nonnull
JpaFunction<String> repeat(@Nonnull
 Expression<String> x,
 int times)

Concatenate the given string expression with itself the given number of times.

Parameters:

x - The string expression to concatenate

times - The number of times it should be repeated

Returns:

the repeat expression

repeat

@Nonnull
JpaFunction<String> repeat(@Nullable
 String x,
 @Nonnull
 Expression<Integer> times)

Concatenate the given string expression with itself the given number of times.

Parameters:

x - The string expression to concatenate

times - The number of times it should be repeated

Returns:

the repeat expression

left

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> left(@Nonnull
 Expression<String> x,
 int length)

Specified by:

left in interface CriteriaBuilder

See Also:

• left(Expression, Expression)

left

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> left(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length)

Extract the length leftmost characters of a string.

Specified by:

left in interface CriteriaBuilder

Parameters:

x - The original string

length - The number of characters

Returns:

the left expression

right

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> right(@Nonnull
 Expression<String> x,
 int length)

Specified by:

right in interface CriteriaBuilder

See Also:

• right(Expression, Expression)

right

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> right(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<Integer> length)

Extract the length rightmost characters of a string.

Specified by:

right in interface CriteriaBuilder

Parameters:

x - The original string

length - The number of characters

Returns:

the left expression

replace

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> replace(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern,
 @Nonnull
 String replacement)

Specified by:

replace in interface CriteriaBuilder

See Also:

• replace(Expression, Expression, Expression)

replace

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> replace(@Nonnull
 Expression<String> x,
 @Nonnull
 String pattern,
 @Nonnull
 Expression<String> replacement)

Specified by:

replace in interface CriteriaBuilder

See Also:

• replace(Expression, Expression, Expression)

replace

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> replace(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern,
 @Nonnull
 String replacement)

Specified by:

replace in interface CriteriaBuilder

See Also:

• replace(Expression, Expression, Expression)

replace

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> replace(@Nonnull
 Expression<String> x,
 @Nonnull
 Expression<String> pattern,
 @Nonnull
 Expression<String> replacement)

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

Specified by:

replace in interface CriteriaBuilder

Parameters:

x - The original string

pattern - The string to be replaced

replacement - The new replacement string

Returns:

the replace expression

collate

@Nonnull
@Incubating(since="6.3")
JpaFunction<String> collate(@Nonnull
 Expression<String> x,
 @Nonnull
 String collation)

Create an expression that applies the named collation to a string expression.

log10

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> log10(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the base-10 logarithm

log

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> log(@Nullable
 Number b,
 @Nonnull
 Expression<? extends Number> x)

See Also:

• log(Expression, Expression)

log

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> log(@Nonnull
 Expression<? extends Number> b,
 @Nonnull
 Expression<? extends Number> x)

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

Parameters:

b - The base

x - The expression

Returns:

the arbitrary-base logarithm

pi

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> pi()

Literal expression corresponding to the value of pi.

Returns:

the pi expression

sin

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> sin(@Nonnull
 Expression<? extends Number> x)

Create an expression that returns the sine of its argument.

Parameters:

x - The expression

Returns:

the sine

cos

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> cos(@Nonnull
 Expression<? extends Number> x)

Create an expression that returns the cosine of its argument.

Parameters:

x - The expression

Returns:

the cosine

tan

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> tan(@Nonnull
 Expression<? extends Number> x)

Create an expression that returns the tangent of its argument.

Parameters:

x - The expression

Returns:

the tangent

asin

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> asin(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the inverse sine

acos

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> acos(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the inverse cosine

atan

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> atan(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the inverse tangent

atan2

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> atan2(@Nullable
 Number y,
 @Nonnull
 Expression<? extends Number> x)

See Also:

• atan2(Expression, Expression)

atan2

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> atan2(@Nonnull
 Expression<? extends Number> y,
 @Nullable
 Number x)

See Also:

• atan2(Expression, Expression)

atan2

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> atan2(@Nonnull
 Expression<? extends Number> y,
 @Nonnull
 Expression<? extends Number> x)

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

Parameters:

y - The y coordinate

x - The x coordinate

Returns:

the 2-argument inverse tangent

sinh

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> sinh(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the hyperbolic sine

cosh

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> cosh(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the hyperbolic cosine

tanh

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> tanh(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the hyperbolic tangent

degrees

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> degrees(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the angle in degrees

radians

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> radians(@Nonnull
 Expression<? extends Number> x)

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

Parameters:

x - The expression

Returns:

the angle in radians

createWindow

@Nonnull
@Incubating(since="6.3")
JpaWindow createWindow()

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

Returns:

the empty window

frameUnboundedPreceding

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameUnboundedPreceding()

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

Returns:

the window frame

frameBetweenPreceding

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameBetweenPreceding(int offset)

See Also:

• frameBetweenPreceding(Expression)

frameBetweenPreceding

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameBetweenPreceding(@Nonnull
 Expression<?> offset)

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

Parameters:

offset - The offset expression

Returns:

the window frame

frameCurrentRow

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameCurrentRow()

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

Returns:

the window frame

frameBetweenFollowing

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameBetweenFollowing(int offset)

See Also:

• frameBetweenFollowing(Expression)

frameBetweenFollowing

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameBetweenFollowing(@Nonnull
 Expression<?> offset)

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

Parameters:

offset - The offset expression

Returns:

the window frame

frameUnboundedFollowing

@Nonnull
@Incubating(since="6.3")
JpaWindowFrame frameUnboundedFollowing()

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

Returns:

the window frame

windowFunction

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> windowFunction(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nonnull
 JpaWindow window,
 @Nonnull
 Expression<?>... args)

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

Type Parameters:

T - The type of this expression

Parameters:

name - The name of the window function

type - The type of this expression

window - The window over which the function will be applied

args - The arguments to the function

Returns:

the window function expression

rowNumber

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rowNumber(@Nonnull
 JpaWindow window)

Create a row_number window function expression.

Parameters:

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

firstValue

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> firstValue(@Nonnull
 Expression<T> argument,
 @Nonnull
 JpaWindow window)

Create a first_value window function expression.

Type Parameters:

T - The type of the expression

Parameters:

argument - The argument expression to pass to first_value

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

lastValue

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> lastValue(@Nonnull
 Expression<T> argument,
 @Nonnull
 JpaWindow window)

Create a last_value window function expression.

Type Parameters:

T - The type of the expression

Parameters:

argument - The argument expression to pass to last_value

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

nthValue

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> nthValue(@Nonnull
 Expression<T> argument,
 int n,
 @Nonnull
 JpaWindow window)

See Also:

• nthValue

nthValue

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> nthValue(@Nonnull
 Expression<T> argument,
 @Nonnull
 Expression<Integer> n,
 @Nonnull
 JpaWindow window)

Create a nth_value window function expression.

Type Parameters:

T - The type of the expression

Parameters:

argument - The argument expression to pass to nth_value

n - The N argument for the function

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

rank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rank(@Nonnull
 JpaWindow window)

Create a rank window function expression.

Parameters:

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

denseRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> denseRank(@Nonnull
 JpaWindow window)

Create a dense_rank window function expression.

Parameters:

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

percentRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> percentRank(@Nonnull
 JpaWindow window)

Create a percent_rank window function expression.

Parameters:

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

cumeDist

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> cumeDist(@Nonnull
 JpaWindow window)

Create a cume_dist window function expression.

Parameters:

window - The window over which the function will be applied

Returns:

the window function expression

See Also:

• windowFunction(String, Class, JpaWindow, Expression...)

functionAggregate

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionAggregate(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<?>... args)

See Also:

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

functionAggregate

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionAggregate(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... args)

See Also:

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

functionAggregate

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionAggregate(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... args)

Create a generic aggregate function expression.

Type Parameters:

T - The type of this expression

Parameters:

name - The name of the ordered set-aggregate function

type - The type of this expression

filter - The optional filter clause

window - The optional window over which to apply the function

args - The optional arguments to the function

Returns:

the aggregate function expression

sum

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Number> sum(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaPredicate filter)

See Also:

• sum(Expression, JpaPredicate, JpaWindow)

sum

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Number> sum(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaWindow window)

See Also:

• sum(Expression, JpaPredicate, JpaWindow)

sum

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Number> sum(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window)

Create a sum aggregate function expression.

Type Parameters:

N - The type of the input expression

Parameters:

argument - The argument to the function

filter - The optional filter clause

window - The optional window over which to apply the function

Returns:

the aggregate function expression

See Also:

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

avg

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Double> avg(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaPredicate filter)

See Also:

• avg(Expression, JpaPredicate, JpaWindow)

avg

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Double> avg(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaWindow window)

See Also:

• avg(Expression, JpaPredicate, JpaWindow)

avg

@Nonnull
@Incubating(since="6.3")
<N extends Number> JpaExpression<Double> avg(@Nonnull
 Expression<N> argument,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window)

Create an avg aggregate function expression.

Type Parameters:

N - The type of the input expression

Parameters:

argument - The argument to the function

filter - The optional filter clause

window - The optional window over which to apply the function

Returns:

the aggregate function expression

See Also:

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

count

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> count(@Nonnull
 Expression<?> argument,
 @Nullable
 JpaPredicate filter)

See Also:

• count(Expression, JpaPredicate, JpaWindow)

count

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> count(@Nonnull
 Expression<?> argument,
 @Nullable
 JpaWindow window)

See Also:

• count(Expression, JpaPredicate, JpaWindow)

count

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> count(@Nonnull
 Expression<?> argument,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window)

Create a count aggregate function expression.

Parameters:

argument - The argument to the function

filter - The optional filter clause

window - The optional window over which to apply the function

Returns:

the aggregate function expression

See Also:

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

functionWithinGroup

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionWithinGroup(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaOrder order,
 @Nonnull
 Expression<?>... args)

See Also:

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

functionWithinGroup

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionWithinGroup(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<?>... args)

See Also:

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

functionWithinGroup

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionWithinGroup(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... args)

See Also:

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

functionWithinGroup

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> functionWithinGroup(@Nonnull
 String name,
 @Nullable
 Class<T> type,
 @Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... args)

Create a generic ordered set-aggregate function expression.

Type Parameters:

T - The type of this expression

Parameters:

name - The name of the ordered set-aggregate function

type - The type of this expression

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

args - The optional arguments to the function

Returns:

the ordered set-aggregate function expression

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 String separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 Expression<String> separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 String separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 Expression<String> separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 String separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 Expression<String> separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 String separator)

See Also:

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

listagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> listagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<String> argument,
 @Nonnull
 Expression<String> separator)

Create a listagg ordered set-aggregate function expression.

Parameters:

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

argument - The values to join

separator - The separator used to join the values

Returns:

the ordered set-aggregate expression

See Also:

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

mode

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> mode(@Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• mode(JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

mode

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> mode(@Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• mode(JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

mode

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> mode(@Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• mode(JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

mode

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> mode(@Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

Create a mode ordered set-aggregate function expression.

Type Parameters:

T - The type of this expression

Parameters:

filter - The optional filter clause

window - The optional window over which to apply the function

sortExpression - The sort expression

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

the ordered set-aggregate expression

See Also:

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

percentileCont

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileCont(@Nonnull
 Expression<? extends Number> argument,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileCont

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileCont(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileCont

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileCont(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileCont(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileCont

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileCont(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

Create a percentile_cont ordered set-aggregate function expression.

Parameters:

argument - The argument to the function

filter - The optional filter clause

window - The optional window over which to apply the function

sortExpression - The sort expression

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

the ordered set-aggregate expression

See Also:

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

percentileDisc

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileDisc(@Nonnull
 Expression<? extends Number> argument,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileDisc

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileDisc(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileDisc

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileDisc(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

See Also:

• percentileDisc(Expression, JpaPredicate, JpaWindow, Expression, SortDirection, Nulls)

percentileDisc

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> percentileDisc(@Nonnull
 Expression<? extends Number> argument,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<T> sortExpression,
 @Nonnull
 SortDirection sortOrder,
 @Nonnull
 Nulls nullPrecedence)

Create a percentile_disc ordered set-aggregate function expression.

Parameters:

argument - The argument to the function

filter - The optional filter clause

window - The optional window over which to apply the function

sortExpression - The sort expression

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

the ordered set-aggregate expression

See Also:

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

rank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rank(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

rank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rank(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

rank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rank(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

rank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Long> rank(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... arguments)

Create a rank ordered set-aggregate function expression.

Parameters:

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

arguments - The arguments to the function

Returns:

the ordered set-aggregate expression

See Also:

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

percentRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> percentRank(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

percentRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> percentRank(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

percentRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> percentRank(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... arguments)

See Also:

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

percentRank

@Nonnull
@Incubating(since="6.3")
JpaExpression<Double> percentRank(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?>... arguments)

Create a percent_rank ordered set-aggregate function expression.

Parameters:

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

arguments - The arguments to the function

Returns:

the ordered set-aggregate expression

See Also:

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

arrayAgg

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAgg(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAgg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAgg(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAgg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<? extends T> argument)

Create a array_agg ordered set-aggregate function expression.

Parameters:

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

argument - The values to aggregate

Returns:

the ordered set-aggregate expression

Since:

6.4

See Also:

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

arrayLiteral

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayLiteral(@Nullable
 T... elements)

Creates an array literal with the array constructor function.

Since:

6.4

arrayLength

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Integer> arrayLength(@Nonnull
 Expression<T[]> arrayExpression)

Determines the length of an array.

Since:

6.4

arrayPosition

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Integer> arrayPosition(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Determines the 1-based position of an element in an array.

Since:

6.4

arrayPosition

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Integer> arrayPosition(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Determines the 1-based position of an element in an array.

Since:

6.4

arrayPositions

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<int[]> arrayPositions(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Determines all 1-based positions of an element in an array.

Since:

6.4

arrayPositions

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<int[]> arrayPositions(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Determines all 1-based positions of an element in an array.

Since:

6.4

arrayPositionsList

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<List<Integer>> arrayPositionsList(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Determines all 1-based positions of an element in an array.

Since:

6.4

arrayPositionsList

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<List<Integer>> arrayPositionsList(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Determines all 1-based positions of an element in an array.

Since:

6.4

arrayConcat

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayConcat(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Concatenates arrays with each other in order.

Since:

6.4

arrayConcat

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayConcat(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nullable
 T[] array2)

Concatenates arrays with each other in order.

Since:

6.4

arrayConcat

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayConcat(@Nullable
 T[] array1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Concatenates arrays with each other in order.

Since:

6.4

arrayAppend

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAppend(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Appends element to array.

Since:

6.4

arrayAppend

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayAppend(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Appends element to array.

Since:

6.4

arrayPrepend

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayPrepend(@Nonnull
 Expression<T> elementExpression,
 @Nonnull
 Expression<T[]> arrayExpression)

Prepends element to array.

Since:

6.4

arrayPrepend

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayPrepend(@Nullable
 T element,
 @Nonnull
 Expression<T[]> arrayExpression)

Prepends element to array.

Since:

6.4

arrayGet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> arrayGet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> indexExpression)

Accesses the element of an array by 1-based index.

Since:

6.4

arrayGet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> arrayGet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer index)

Accesses the element of an array by 1-based index.

Since:

6.4

arraySet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> indexExpression,
 @Nonnull
 Expression<T> elementExpression)

Creates array copy with given element at given 1-based index.

Since:

6.4

arraySet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> indexExpression,
 @Nullable
 T element)

Creates array copy with given element at given 1-based index.

Since:

6.4

arraySet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer index,
 @Nonnull
 Expression<T> elementExpression)

Creates array copy with given element at given 1-based index.

Since:

6.4

arraySet

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySet(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer index,
 @Nullable
 T element)

Creates array copy with given element at given 1-based index.

Since:

6.4

arrayRemove

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayRemove(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Creates array copy with given element removed.

Since:

6.4

arrayRemove

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayRemove(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Creates array copy with given element removed.

Since:

6.4

arrayRemoveIndex

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayRemoveIndex(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> indexExpression)

Creates array copy with the element at the given 1-based index removed.

Since:

6.4

arrayRemoveIndex

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayRemoveIndex(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer index)

Creates array copy with the element at the given 1-based index removed.

Since:

6.4

arraySlice

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySlice(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> lowerIndexExpression,
 @Nonnull
 Expression<Integer> upperIndexExpression)

Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

arraySlice

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySlice(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> lowerIndexExpression,
 @Nullable
 Integer upperIndex)

Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

arraySlice

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySlice(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer lowerIndex,
 @Nonnull
 Expression<Integer> upperIndexExpression)

Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

arraySlice

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySlice(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer lowerIndex,
 @Nullable
 Integer upperIndex)

Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

arrayReplace

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayReplace(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> oldElementExpression,
 @Nonnull
 Expression<T> newElementExpression)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayReplace(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> oldElementExpression,
 @Nullable
 T newElement)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayReplace(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T oldElement,
 @Nonnull
 Expression<T> newElementExpression)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayReplace(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T oldElement,
 @Nullable
 T newElement)

Creates array copy replacing a given element with another.

Since:

6.4

arrayTrim

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayTrim(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates array copy without the last N elements, specified by the second argument.

Since:

6.4

arrayTrim

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayTrim(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 Integer elementCount)

Creates array copy without the last N elements, specified by the second argument.

Since:

6.4

arrayReverse

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayReverse(@Nonnull
 Expression<T[]> arrayExpression)

Reverses the order of elements in an array.

Since:

7.2

arraySort

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySort(@Nonnull
 Expression<T[]> arrayExpression)

Sorts the elements of an array in ascending order.

Since:

7.2

arraySort

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySort(@Nonnull
 Expression<T[]> arrayExpression,
 boolean descending)

Sorts the elements of an array in the specified order.

Since:

7.2

arraySort

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySort(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Boolean> descendingExpression)

Sorts the elements of an array in the specified order.

Since:

7.2

arraySort

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySort(@Nonnull
 Expression<T[]> arrayExpression,
 boolean descending,
 boolean nullsFirst)

Create an expression that sorts the given array with explicit null ordering.

Since:

7.2

arraySort

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arraySort(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<Boolean> descendingExpression,
 @Nonnull
 Expression<Boolean> nullsFirstExpression)

Create an expression that sorts the given array with explicit null ordering.

Since:

7.2

arrayFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayFill(@Nonnull
 Expression<T> elementExpression,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates array with the same element N times, as specified by the arguments.

Since:

6.4

arrayFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayFill(@Nonnull
 Expression<T> elementExpression,
 @Nullable
 Integer elementCount)

Creates array with the same element N times, as specified by the arguments.

Since:

6.4

arrayFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayFill(@Nullable
 T element,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates array with the same element N times, as specified by the arguments.

Since:

6.4

arrayFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T[]> arrayFill(@Nullable
 T element,
 @Nullable
 Integer elementCount)

Creates array with the same element N times, as specified by the arguments.

Since:

6.4

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nonnull
 Expression<String> separatorExpression)

Concatenates the non-null array elements with a separator, as specified by the arguments.

Since:

6.4

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nullable
 String separator)

Concatenates the non-null array elements with a separator, as specified by the arguments.

Since:

6.4

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nonnull
 Expression<String> separatorExpression,
 @Nonnull
 Expression<String> defaultExpression)

Concatenates the array elements with a separator, as specified by the arguments. Null array elements are replaced with the given default element.

Since:

7.1

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nonnull
 Expression<String> separatorExpression,
 @Nullable
 String defaultValue)

Concatenates the array elements with a separator, as specified by the arguments. Null array elements are replaced with the given default element.

Since:

7.1

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nullable
 String separator,
 @Nonnull
 Expression<String> defaultExpression)

Concatenates the array elements with a separator, as specified by the arguments. Null array elements are replaced with the given default element.

Since:

7.1

arrayToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> arrayToString(@Nonnull
 Expression<? extends Object[]> arrayExpression,
 @Nullable
 String separator,
 @Nullable
 String defaultValue)

Concatenates the array elements with a separator, as specified by the arguments. Null array elements are replaced with the given default element.

Since:

7.1

arrayContains

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContains(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Whether an array contains an element.

Since:

6.4

arrayContains

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContains(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Whether an array contains an element.

Since:

6.4

arrayContains

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContains(@Nullable
 T[] array,
 @Nonnull
 Expression<T> elementExpression)

Whether an array contains an element.

Since:

6.4

arrayContainsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContainsNullable(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T> elementExpression)

Whether an array contains a nullable element.

Since:

6.4

arrayContainsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContainsNullable(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T element)

Whether an array contains a nullable element.

Since:

6.4

arrayContainsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayContainsNullable(@Nullable
 T[] array,
 @Nonnull
 Expression<T> elementExpression)

Whether an array contains a nullable element.

Since:

6.4

arrayIncludes

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludes(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludes

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludes(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T[] subArray)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludes

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludes(@Nullable
 T[] array,
 @Nonnull
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludesNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludesNullable(@Nonnull
 Expression<T[]> arrayExpression,
 @Nonnull
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array with nullable elements.

Since:

6.6

arrayIncludesNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludesNullable(@Nonnull
 Expression<T[]> arrayExpression,
 @Nullable
 T[] subArray)

Whether an array is a subset of another array with nullable elements.

Since:

6.6

arrayIncludesNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIncludesNullable(@Nullable
 T[] array,
 @Nonnull
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array with nullable elements.

Since:

6.6

arrayIntersects

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersects(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersects

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersects(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nullable
 T[] array2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersects

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersects(@Nullable
 T[] array1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersectsNullable(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array, supporting null elements.

Since:

6.6

arrayIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersectsNullable(@Nonnull
 Expression<T[]> arrayExpression1,
 @Nullable
 T[] array2)

Whether one array has any elements common with another array, supporting null elements.

Since:

6.6

arrayIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<T> JpaPredicate arrayIntersectsNullable(@Nullable
 T[] array1,
 @Nonnull
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array, supporting null elements.

Since:

6.6

collectionLiteral

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<E>> JpaExpression<C> collectionLiteral(@Nullable
 E... elements)

Creates a basic collection literal with the array constructor function.

Since:

6.4

collectionLength

@Nonnull
@Incubating(since="6.3")
JpaExpression<Integer> collectionLength(@Nonnull
 Expression<? extends Collection<?>> collectionExpression)

Determines the length of a basic collection.

Since:

6.4

collectionPosition

@Nonnull
@Incubating(since="6.3")
<E> JpaExpression<Integer> collectionPosition(@Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression,
 @Nullable
 E element)

Determines the 1-based position of an element in a basic collection.

Since:

6.4

collectionPosition

@Nonnull
@Incubating(since="6.3")
<E> JpaExpression<Integer> collectionPosition(@Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression,
 @Nonnull
 Expression<E> elementExpression)

Determines the 1-based position of an element in a basic collection.

Since:

6.4

collectionPositions

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<int[]> collectionPositions(@Nonnull
 Expression<? extends Collection<? super T>> collectionExpression,
 @Nonnull
 Expression<T> elementExpression)

Determines all 1-based positions of an element in a basic collection.

Since:

6.4

collectionPositions

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<int[]> collectionPositions(@Nonnull
 Expression<? extends Collection<? super T>> collectionExpression,
 @Nullable
 T element)

Determines all 1-based positions of an element in a basic collection.

Since:

6.4

collectionPositionsList

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<List<Integer>> collectionPositionsList(@Nonnull
 Expression<? extends Collection<? super T>> collectionExpression,
 @Nonnull
 Expression<T> elementExpression)

Determines all 1-based positions of an element in a basic collection.

Since:

6.4

collectionPositionsList

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<List<Integer>> collectionPositionsList(@Nonnull
 Expression<? extends Collection<? super T>> collectionExpression,
 @Nullable
 T element)

Determines all 1-based positions of an element in a basic collection.

Since:

6.4

collectionConcat

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionConcat(@Nonnull
 Expression<C> collectionExpression1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Concatenates basic collections with each other in order.

Since:

6.4

collectionConcat

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionConcat(@Nonnull
 Expression<C> collectionExpression1,
 @Nullable
 Collection<? extends E> collection2)

Concatenates basic collections with each other in order.

Since:

6.4

collectionConcat

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionConcat(@Nullable
 C collection1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Concatenates basic collections with each other in order.

Since:

6.4

collectionAppend

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionAppend(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<? extends E> elementExpression)

Appends element to basic collection.

Since:

6.4

collectionAppend

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionAppend(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 E element)

Appends element to basic collection.

Since:

6.4

collectionPrepend

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionPrepend(@Nonnull
 Expression<? extends E> elementExpression,
 @Nonnull
 Expression<C> collectionExpression)

Prepends element to basic collection.

Since:

6.4

collectionPrepend

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionPrepend(@Nullable
 E element,
 @Nonnull
 Expression<C> collectionExpression)

Prepends element to basic collection.

Since:

6.4

collectionGet

@Nonnull
@Incubating(since="6.3")
<E> JpaExpression<E> collectionGet(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nonnull
 Expression<Integer> indexExpression)

Accesses the element of the basic collection by 1-based index.

Since:

6.4

collectionGet

@Nonnull
@Incubating(since="6.3")
<E> JpaExpression<E> collectionGet(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nullable
 Integer index)

Accesses the element of the basic collection by 1-based index.

Since:

6.4

collectionSet

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionSet(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Integer> indexExpression,
 @Nonnull
 Expression<? extends E> elementExpression)

Creates basic collection copy with given element at given 1-based index.

Since:

6.4

collectionSet

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionSet(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Integer> indexExpression,
 @Nullable
 E element)

Creates basic collection copy with given element at given 1-based index.

Since:

6.4

collectionSet

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionSet(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 Integer index,
 @Nonnull
 Expression<? extends E> elementExpression)

Creates basic collection copy with given element at given 1-based index.

Since:

6.4

collectionSet

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionSet(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 Integer index,
 @Nullable
 E element)

Creates basic collection copy with given element at given 1-based index.

Since:

6.4

collectionRemove

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionRemove(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<? extends E> elementExpression)

Creates basic collection copy with given element removed.

Since:

6.4

collectionRemove

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionRemove(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 E element)

Creates basic collection copy with given element removed.

Since:

6.4

collectionRemoveIndex

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionRemoveIndex(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Integer> indexExpression)

Creates basic collection copy with the element at the given 1-based index removed.

Since:

6.4

collectionRemoveIndex

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionRemoveIndex(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 Integer index)

Creates basic collection copy with the element at the given 1-based index removed.

Since:

6.4

collectionSlice

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSlice(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Integer> lowerIndexExpression,
 @Nonnull
 Expression<Integer> upperIndexExpression)

Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSlice(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Integer> lowerIndexExpression,
 @Nullable
 Integer upperIndex)

Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSlice(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 Integer lowerIndex,
 @Nonnull
 Expression<Integer> upperIndexExpression)

Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSlice(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 Integer lowerIndex,
 @Nullable
 Integer upperIndex)

Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.

Since:

6.4

collectionReplace

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionReplace(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<? extends E> oldElementExpression,
 @Nonnull
 Expression<? extends E> newElementExpression)

Creates basic collection copy replacing a given element with another.

Since:

6.4

collectionReplace

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionReplace(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<? extends E> oldElementExpression,
 @Nullable
 E newElement)

Creates basic collection copy replacing a given element with another.

Since:

6.4

collectionReplace

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionReplace(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 E oldElement,
 @Nonnull
 Expression<? extends E> newElementExpression)

Creates basic collection copy replacing a given element with another.

Since:

6.4

collectionReplace

@Nonnull
@Incubating(since="6.3")
<E, C extends Collection<? super E>>
JpaExpression<C> collectionReplace(@Nonnull
 Expression<C> collectionExpression,
 @Nullable
 E oldElement,
 @Nullable
 E newElement)

Creates basic collection copy replacing a given element with another.

Since:

6.4

collectionTrim

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionTrim(@Nonnull
 Expression<C> arrayExpression,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates basic collection copy without the last N elements, specified by the second argument.

Since:

6.4

collectionTrim

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionTrim(@Nonnull
 Expression<C> arrayExpression,
 @Nullable
 Integer elementCount)

Creates basic collection copy without the last N elements, specified by the second argument.

Since:

6.4

collectionReverse

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionReverse(@Nonnull
 Expression<C> collectionExpression)

Create an expression that reverses the order of the elements of a collection.

Since:

7.2

collectionSort

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSort(@Nonnull
 Expression<C> collectionExpression)

Create an expression that sorts the elements of a collection.

Since:

7.2

collectionSort

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSort(@Nonnull
 Expression<C> collectionExpression,
 boolean descending)

Create an expression that sorts the given collection in specified order.

Since:

7.2

collectionSort

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSort(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Boolean> descendingExpression)

Create an expression that sorts the given collection in specified order.

Since:

7.2

collectionSort

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSort(@Nonnull
 Expression<C> collectionExpression,
 boolean descending,
 boolean nullsFirst)

Create an expression that sorts the given collection with explicit null ordering.

Since:

7.2

collectionSort

@Nonnull
@Incubating(since="6.3")
<C extends Collection<?>> JpaExpression<C> collectionSort(@Nonnull
 Expression<C> collectionExpression,
 @Nonnull
 Expression<Boolean> descendingExpression,
 @Nonnull
 Expression<Boolean> nullsFirstExpression)

Create an expression that sorts the given collection with explicit null ordering.

Since:

7.2

collectionFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Collection<T>> collectionFill(@Nonnull
 Expression<T> elementExpression,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates basic collection with the same element N times, as specified by the arguments.

Since:

6.4

collectionFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Collection<T>> collectionFill(@Nonnull
 Expression<T> elementExpression,
 @Nullable
 Integer elementCount)

Creates basic collection with the same element N times, as specified by the arguments.

Since:

6.4

collectionFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Collection<T>> collectionFill(@Nullable
 T element,
 @Nonnull
 Expression<Integer> elementCountExpression)

Creates basic collection with the same element N times, as specified by the arguments.

Since:

6.4

collectionFill

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<Collection<T>> collectionFill(@Nullable
 T element,
 @Nullable
 Integer elementCount)

Creates basic collection with the same element N times, as specified by the arguments.

Since:

6.4

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nonnull
 Expression<String> separatorExpression)

Concatenates the non-null basic collection elements with a separator, as specified by the arguments.

Since:

6.4

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nullable
 String separator)

Concatenates the non-null basic collection elements with a separator, as specified by the arguments.

Since:

6.4

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nonnull
 Expression<String> separatorExpression,
 @Nonnull
 Expression<String> defaultExpression)

Concatenates the collection elements with a separator, as specified by the arguments. Null collection elements are replaced with the given default element.

Since:

7.1

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nonnull
 Expression<String> separatorExpression,
 @Nullable
 String defaultValue)

Concatenates the collection elements with a separator, as specified by the arguments. Null collection elements are replaced with the given default element.

Since:

7.1

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nullable
 String separator,
 @Nonnull
 Expression<String> defaultExpression)

Concatenates the collection elements with a separator, as specified by the arguments. Null collection elements are replaced with the given default element.

Since:

7.1

collectionToString

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> collectionToString(@Nonnull
 Expression<? extends Collection<?>> collectionExpression,
 @Nullable
 String separator,
 @Nullable
 String defaultValue)

Concatenates the collection elements with a separator, as specified by the arguments. Null collection elements are replaced with the given default element.

Since:

7.1

collectionContains

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContains(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nonnull
 Expression<? extends E> elementExpression)

Whether a basic collection contains an element.

Since:

6.4

collectionContains

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContains(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nullable
 E element)

Whether a basic collection contains an element.

Since:

6.4

collectionContains

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContains(@Nonnull
 Collection<E> collection,
 @Nonnull
 Expression<E> elementExpression)

Whether a basic collection contains an element.

Since:

6.4

collectionContainsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContainsNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nonnull
 Expression<? extends E> elementExpression)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionContainsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContainsNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nullable
 E element)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionContainsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionContainsNullable(@Nonnull
 Collection<E> collection,
 @Nonnull
 Expression<E> elementExpression)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionIncludes

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludes(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nonnull
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Whether a basic collection is a subset of another basic collection.

Since:

6.4

collectionIncludes

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludes(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nullable
 Collection<? extends E> subCollection)

Whether a basic collection is a subset of another basic collection.

Since:

6.4

collectionIncludes

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludes(@Nullable
 Collection<E> collection,
 @Nonnull
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Whether a basic collection is a subset of another basic collection.

Since:

6.4

collectionIncludesNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludesNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nonnull
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionIncludesNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludesNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression,
 @Nullable
 Collection<? extends E> subCollection)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionIncludesNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIncludesNullable(@Nullable
 Collection<E> collection,
 @Nonnull
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionIntersects

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersects(@Nonnull
 Expression<? extends Collection<E>> collectionExpression1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Whether one basic collection has any elements common with another basic collection.

Since:

6.6

collectionIntersects

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersects(@Nonnull
 Expression<? extends Collection<E>> collectionExpression1,
 @Nullable
 Collection<? extends E> collection2)

Whether one basic collection has any elements common with another basic collection.

Since:

6.6

collectionIntersects

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersects(@Nullable
 Collection<E> collection1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Whether one basic collection has any elements common with another basic collection.

Since:

6.6

collectionIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersectsNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Whether one basic collection has any elements common with another basic collection, supporting null elements.

Since:

6.6

collectionIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersectsNullable(@Nonnull
 Expression<? extends Collection<E>> collectionExpression1,
 @Nullable
 Collection<? extends E> collection2)

Whether one basic collection has any elements common with another basic collection, supporting null elements.

Since:

6.6

collectionIntersectsNullable

@Nonnull
@Incubating(since="6.3")
<E> JpaPredicate collectionIntersectsNullable(@Nullable
 Collection<E> collection1,
 @Nonnull
 Expression<? extends Collection<? extends E>> collectionExpression2)

Whether one basic collection has any elements common with another basic collection, supporting null elements.

Since:

6.6

jsonValue

@Nonnull
@Incubating(since="6.3")
JpaJsonValueExpression<String> jsonValue(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath)

Since:

7.0

See Also:

• jsonValue(Expression, String, Class)

jsonValue

@Nonnull
@Incubating(since="6.3")
<T> JpaJsonValueExpression<T> jsonValue(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nullable
 Class<T> returningType)

Extracts a value by JSON path from a JSON document.

Since:

7.0

jsonValue

@Nonnull
@Incubating(since="6.3")
JpaJsonValueExpression<String> jsonValue(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath)

Since:

7.0

See Also:

• jsonValue(Expression, Expression, Class)

jsonValue

@Nonnull
@Incubating(since="6.3")
<T> JpaJsonValueExpression<T> jsonValue(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nullable
 Class<T> returningType)

Extracts a value by JSON path from a JSON document.

Since:

7.0

jsonQuery

@Nonnull
@Incubating(since="6.3")
JpaJsonQueryExpression jsonQuery(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath)

Since:

7.0

See Also:

• jsonQuery(Expression, Expression)

jsonQuery

@Nonnull
@Incubating(since="6.3")
JpaJsonQueryExpression jsonQuery(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath)

Queries values by JSON path from a JSON document.

Since:

7.0

jsonExists

@Nonnull
@Incubating(since="6.3")
JpaJsonExistsExpression jsonExists(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath)

Checks if a JSON document contains a node for the given JSON path.

Since:

7.0

jsonExists

@Nonnull
@Incubating(since="6.3")
JpaJsonExistsExpression jsonExists(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath)

Checks if a JSON document contains a node for the given JSON path.

Since:

7.0

jsonObject

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObject(@Nonnull
 Map<?, ? extends Expression<?>> keyValues)

Create a JSON object from the given map of key values.

Since:

7.0

jsonObjectWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectWithNulls(@Nonnull
 Map<?, ? extends Expression<?>> keyValues)

Create a JSON object from the given map of key values, retaining null values in the JSON.

Since:

7.0

jsonArray

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArray(@Nonnull
 Expression<?>... values)

Create a JSON array from the array of values.

Since:

7.0

jsonArrayWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayWithNulls(@Nonnull
 Expression<?>... values)

Create a JSON object from the given array of values, retaining null values in the JSON array.

Since:

7.0

jsonArrayAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAgg(@Nonnull
 Expression<?> value)

Aggregates the given value into a JSON array.

Since:

7.0

jsonArrayAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAgg(@Nonnull
 Expression<?> value,
 @Nonnull
 JpaOrder... orderBy)

Aggregates the given value into a JSON array. Ordering values based on the given order by items.

Since:

7.0

jsonArrayAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAgg(@Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value into a JSON array. Filtering rows that don't match the given filter predicate.

Since:

7.0

jsonArrayAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAgg(@Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter,
 @Nonnull
 JpaOrder... orderBy)

Aggregates the given value into a JSON array. Filtering rows that don't match the given filter predicate. Ordering values based on the given order by items.

Since:

7.0

jsonArrayAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAggWithNulls(@Nonnull
 Expression<?> value)

Aggregates the given value into a JSON array, retaining null values in the JSON array.

Since:

7.0

jsonArrayAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAggWithNulls(@Nonnull
 Expression<?> value,
 @Nonnull
 JpaOrder... orderBy)

Aggregates the given value into a JSON array, retaining null values in the JSON array. Ordering values based on the given order by items.

Since:

7.0

jsonArrayAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAggWithNulls(@Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value into a JSON array, retaining null values in the JSON array. Filtering rows that don't match the given filter predicate.

Since:

7.0

jsonArrayAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonArrayAggWithNulls(@Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter,
 @Nonnull
 JpaOrder... orderBy)

Aggregates the given value into a JSON array, retaining null values in the JSON array. Filtering rows that don't match the given filter predicate. Ordering values based on the given order by items.

Since:

7.0

jsonObjectAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAgg(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value)

Aggregates the given value under the given key into a JSON object.

Since:

7.0

jsonObjectAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithNulls(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value)

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Since:

7.0

jsonObjectAggWithUniqueKeys

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithUniqueKeys(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value)

Aggregates the given value under the given key into a JSON object.

Since:

7.0

jsonObjectAggWithUniqueKeysAndNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithUniqueKeysAndNulls(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value)

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Since:

7.0

jsonObjectAgg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAgg(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value under the given key into a JSON object.

Since:

7.0

jsonObjectAggWithNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithNulls(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Since:

7.0

jsonObjectAggWithUniqueKeys

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithUniqueKeys(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value under the given key into a JSON object.

Since:

7.0

jsonObjectAggWithUniqueKeysAndNulls

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonObjectAggWithUniqueKeysAndNulls(@Nonnull
 Expression<?> key,
 @Nonnull
 Expression<?> value,
 @Nullable
 Predicate filter)

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Since:

7.0

jsonSet

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonSet(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nonnull
 Expression<?> value)

Inserts/Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonSet

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonSet(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nonnull
 Expression<?> value)

Inserts/Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonSet

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonSet(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nullable
 Object value)

Inserts/Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonSet

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonSet(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nullable
 Object value)

Inserts/Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonRemove

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonRemove(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath)

Removes a value by JSON path within a JSON document.

Since:

7.0

jsonRemove

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonRemove(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath)

Removes a value by JSON path within a JSON document.

Since:

7.0

jsonInsert

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonInsert(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nonnull
 Expression<?> value)

Inserts a value by JSON path within a JSON document.

Since:

7.0

jsonInsert

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonInsert(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nonnull
 Expression<?> value)

Inserts a value by JSON path within a JSON document.

Since:

7.0

jsonInsert

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonInsert(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nullable
 Object value)

Inserts a value by JSON path within a JSON document.

Since:

7.0

jsonInsert

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonInsert(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nullable
 Object value)

Inserts a value by JSON path within a JSON document.

Since:

7.0

jsonReplace

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonReplace(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nonnull
 Expression<?> value)

Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonReplace

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonReplace(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nonnull
 Expression<?> value)

Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonReplace

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonReplace(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath,
 @Nullable
 Object value)

Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonReplace

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonReplace(@Nonnull
 Expression<?> jsonDocument,
 @Nonnull
 Expression<String> jsonPath,
 @Nullable
 Object value)

Replaces a value by JSON path within a JSON document.

Since:

7.0

jsonMergepatch

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonMergepatch(@Nonnull
 Expression<?> document,
 @Nonnull
 Expression<?> patch)

Applies the patch JSON document onto the other JSON document and returns that.

Since:

7.0

jsonMergepatch

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonMergepatch(@Nonnull
 Expression<?> document,
 @Nullable
 String patch)

Applies the patch JSON document onto the other JSON document and returns that.

Since:

7.0

jsonMergepatch

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> jsonMergepatch(@Nullable
 String document,
 @Nonnull
 Expression<?> patch)

Applies the patch JSON document onto the other JSON document and returns that.

Since:

7.0

xmlelement

@Nonnull
@Incubating(since="6.3")
JpaXmlElementExpression xmlelement(@Nonnull
 String elementName)

Creates an XML element with the given element name.

Since:

7.0

xmlcomment

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlcomment(@Nullable
 String comment)

Creates an XML comment with the given argument as content.

Since:

7.0

xmlforest

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlforest(@Nonnull
 Expression<?>... elements)

Creates an XML forest from the given XML element expressions.

Since:

7.0

See Also:

• named(Expression, String)

xmlforest

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlforest(@Nonnull
 List<? extends Expression<?>> elements)

Creates an XML forest from the given XML element expressions.

Since:

7.0

See Also:

• named(Expression, String)

xmlconcat

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlconcat(@Nonnull
 Expression<?>... elements)

Concatenates the given XML element expressions.

Since:

7.0

xmlconcat

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlconcat(@Nonnull
 List<? extends Expression<?>> elements)

Concatenates the given XML element expressions.

Since:

7.0

xmlpi

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlpi(@Nonnull
 String elementName)

Creates an XML processing with the given name.

Since:

7.0

xmlpi

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlpi(@Nonnull
 String elementName,
 @Nonnull
 Expression<String> content)

Creates an XML processing with the given name and content.

Since:

7.0

xmlquery

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlquery(@Nullable
 String query,
 @Nonnull
 Expression<?> xmlDocument)

Queries the given XML document with the given XPath or XQuery query.

Since:

7.0

xmlquery

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlquery(@Nonnull
 Expression<String> query,
 @Nonnull
 Expression<?> xmlDocument)

Queries the given XML document with the given XPath or XQuery query.

Since:

7.0

xmlexists

@Nonnull
@Incubating(since="6.3")
JpaExpression<Boolean> xmlexists(@Nullable
 String query,
 @Nonnull
 Expression<?> xmlDocument)

Checks if the given XPath or XQuery query exists in the given XML document.

Since:

7.0

xmlexists

@Nonnull
@Incubating(since="6.3")
JpaExpression<Boolean> xmlexists(@Nonnull
 Expression<String> query,
 @Nonnull
 Expression<?> xmlDocument)

Checks if the given XPath or XQuery query exists in the given XML document.

Since:

7.0

xmlagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlagg(@Nullable
 JpaOrder order,
 @Nonnull
 Expression<?> argument)

See Also:

• xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nonnull
 Expression<?> argument)

See Also:

• xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?> argument)

See Also:

• xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

@Nonnull
@Incubating(since="6.3")
JpaExpression<String> xmlagg(@Nullable
 JpaOrder order,
 @Nullable
 JpaPredicate filter,
 @Nullable
 JpaWindow window,
 @Nonnull
 Expression<?> argument)

Create a xmlagg ordered set-aggregate function expression.

Parameters:

order - The order-by clause used in the within group

filter - The optional filter clause

window - The optional window over which to apply the function

argument - The values to join

Returns:

the ordered set-aggregate expression

See Also:

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

named

@Nonnull
@Incubating(since="6.3")
<T> JpaExpression<T> named(@Nonnull
 Expression<T> expression,
 @Nonnull
 String name)

Creates a named expression. The name is important for the result of the expression, e.g. when building an xmlforest, the name acts as the XML element name.

Since:

7.0

See Also:

• xmlforest(Expression[])
• xmlforest(List)

setReturningFunction

@Nonnull
@Incubating(since="6.3")
<E> JpaSetReturningFunction<E> setReturningFunction(@Nonnull
 String name,
 @Nonnull
 Expression<?>... args)

Create a new set-returning function expression.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

unnestArray

@Nonnull
@Incubating(since="6.3")
<E> JpaSetReturningFunction<E> unnestArray(@Nonnull
 Expression<E[]> array)

Creates an unnest function expression to turn an array into a set of rows.

Since:

7.0

See Also:

• JpaFrom.join(JpaSetReturningFunction)

unnestCollection

@Nonnull
@Incubating(since="6.3")
<E> JpaSetReturningFunction<E> unnestCollection(@Nonnull
 Expression<? extends Collection<E>> collection)

Creates an unnest function expression to turn an array into a set of rows.

Since:

7.0

See Also:

• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nullable
 E stop)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nonnull
 Expression<E> stop)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nullable
 E stop)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nonnull
 Expression<E> stop)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nonnull
 Expression<E> stop,
 @Nonnull
 Expression<E> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nullable
 E stop,
 @Nonnull
 Expression<E> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nonnull
 Expression<E> stop,
 @Nullable
 E step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nonnull
 Expression<E> stop,
 @Nullable
 E step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nullable
 E stop,
 @Nullable
 E step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nullable
 E stop,
 @Nonnull
 Expression<E> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nullable
 E start,
 @Nullable
 E stop,
 @Nullable
 E step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

@Nonnull
@Incubating(since="6.3")
<E extends Number> JpaSetReturningFunction<E> generateSeries(@Nonnull
 Expression<E> start,
 @Nonnull
 Expression<E> stop,
 @Nonnull
 Expression<E> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nullable
 E start,
 @Nonnull
 Expression<E> stop,
 @Nonnull
 Expression<? extends TemporalAmount> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nonnull
 Expression<E> start,
 @Nullable
 E stop,
 @Nonnull
 Expression<? extends TemporalAmount> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nullable
 E start,
 @Nullable
 E stop,
 @Nonnull
 Expression<? extends TemporalAmount> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nonnull
 Expression<E> start,
 @Nonnull
 Expression<E> stop,
 @Nullable
 TemporalAmount step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nonnull
 Expression<E> start,
 @Nullable
 E stop,
 @Nullable
 TemporalAmount step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nullable
 E start,
 @Nonnull
 Expression<E> stop,
 @Nullable
 TemporalAmount step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nullable
 E start,
 @Nullable
 E stop,
 @Nullable
 TemporalAmount step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

@Nonnull
@Incubating(since="6.3")
<E extends Temporal> JpaSetReturningFunction<E> generateTimeSeries(@Nonnull
 Expression<E> start,
 @Nonnull
 Expression<E> stop,
 @Nonnull
 Expression<? extends TemporalAmount> step)

Creates a generate_series function expression to generate a set of values as rows.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

@Nonnull
@Incubating(since="6.3")
JpaJsonTableFunction jsonTable(@Nonnull
 Expression<?> jsonDocument)

Creates a json_table function expression to generate rows from JSON array elements.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

@Nonnull
@Incubating(since="6.3")
JpaJsonTableFunction jsonTable(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 String jsonPath)

Creates a json_table function expression to generate rows from JSON array elements.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

@Nonnull
@Incubating(since="6.3")
JpaJsonTableFunction jsonTable(@Nonnull
 Expression<?> jsonDocument,
 @Nullable
 Expression<String> jsonPath)

Creates a json_table function expression to generate rows from JSON array elements.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

xmlTable

@Nonnull
@Incubating(since="6.3")
JpaXmlTableFunction xmlTable(@Nullable
 String xpath,
 @Nonnull
 Expression<?> xmlDocument)

Creates a xmltable function expression to generate rows from XML elements.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

xmlTable

@Nonnull
@Incubating(since="6.3")
JpaXmlTableFunction xmlTable(@Nonnull
 Expression<String> xpath,
 @Nonnull
 Expression<?> xmlDocument)

Creates a xmltable function expression to generate rows from XML elements.

Since:

7.0

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

concat

@Nonnull
JpaExpression<String> concat(@Nonnull
 List<Expression<String>> expressions)

Create a string concatenation expression from a list of expressions.

Specified by:

concat in interface CriteriaBuilder

extract

@Nonnull
<N, T extends Temporal> JpaExpression<N> extract(@Nonnull
 TemporalField<N,T> field,
 @Nonnull
 Expression<T> temporal)

Create an expression extracting the given temporal field from a temporal expression.

Specified by:

extract in interface CriteriaBuilder