Package org.hibernate.query.criteria

Interface HibernateCriteriaBuilder

All Superinterfaces:

CriteriaBuilder

All Known Subinterfaces:

NodeBuilder

All Known Implementing Classes:

CriteriaDefinition, HibernateCriteriaBuilderDelegate, SqmCriteriaNodeBuilder

@Incubating
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 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

Author:

Steve Ebersole

See Also:

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

Nested Class Summary

Nested classes/interfaces inherited from interface jakarta.persistence.criteria.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 that returns 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 expression over the subquery results.
JpaPredicate	and(Expression<Boolean> x, Expression<Boolean> y)	Create a conjunction of the given boolean expressions.
JpaPredicate	and(Predicate... restrictions)	Create a conjunction of the given restriction predicates.
<Y> JpaExpression<Y>	any(Subquery<Y> subquery)	Create an any expression over the subquery results.
JpaCompoundSelection<Object[]>	array(Selection<?>... selections)	Create an array-valued selection item.
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, Selection<?>... selections)
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
JpaCompoundSelection<Object[]>	array(List<? extends JpaSelection<?>> selections)
<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.
default <T> JpaPredicate	arrayContainsAll(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with arrayIncludes(Expression, Expression)
default <T> JpaPredicate	arrayContainsAll(Expression<T[]> arrayExpression, T[] subArray)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIncludes(Expression, T[])
default <T> JpaPredicate	arrayContainsAll(T[] array, Expression<T[]> subArrayExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIncludes(T[], Expression)
default <T> JpaPredicate	arrayContainsAllNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with arrayIncludesNullable(Expression, Expression)
default <T> JpaPredicate	arrayContainsAllNullable(Expression<T[]> arrayExpression, T[] subArray)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIncludesNullable(Expression, T[])
default <T> JpaPredicate	arrayContainsAllNullable(T[] array, Expression<T[]> subArrayExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIncludesNullable(T[], Expression)
<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.
default <T> JpaPredicate	arrayOverlaps(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with arrayIntersects(Expression, Expression)
default <T> JpaPredicate	arrayOverlaps(Expression<T[]> arrayExpression1, T[] array2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIntersects(Expression, T[])
default <T> JpaPredicate	arrayOverlaps(T[] array1, Expression<T[]> arrayExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIntersects(T[], Expression)
default <T> JpaPredicate	arrayOverlapsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with arrayIntersectsNullable(Expression, Expression)
default <T> JpaPredicate	arrayOverlapsNullable(Expression<T[]> arrayExpression1, T[] array2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIntersectsNullable(Expression, T[])
default <T> JpaPredicate	arrayOverlapsNullable(T[] array1, Expression<T[]> arrayExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with #arrayIntersectsNullable(T[], Expression)
<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[]>	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.
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, String separator)	Concatenates the non-null 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 ordering by the ascending value of the 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 applying the avg operation.
<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 for testing whether the first argument is between the second and third arguments in value.
<Y extends Comparable<? super Y>> JpaPredicate	between(Expression<? extends Y> value, Y lower, Y upper)	Create a predicate for testing whether the first argument is between the second and third arguments in value.
<X, T> JpaExpression<X>	cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
<N extends Number> JpaExpression<N>	ceiling(Expression<N> x)	Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
<T> JpaCoalesce<T>	coalesce()	Create a coalesce expression.
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Expression<? extends Y> y)	Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Y y)	Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
JpaFunction<String>	collate(Expression<String> x, String collation)
<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.
default <E> JpaPredicate	collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludes(Expression, Expression)
default <E> JpaPredicate	collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludes(Expression, Collection)
default <E> JpaPredicate	collectionContainsAll(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludes(Collection, Expression)
default <E> JpaPredicate	collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludesNullable(Expression, Expression)
default <E> JpaPredicate	collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludesNullable(Expression, Collection)
default <E> JpaPredicate	collectionContainsAllNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIncludesNullable(Collection, Expression)
<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.
default <E> JpaPredicate	collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersects(Expression, Expression)
default <E> JpaPredicate	collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersects(Expression, Collection)
default <E> JpaPredicate	collectionOverlaps(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersects(Collection, Expression)
default <E> JpaPredicate	collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersectsNullable(Expression, Expression)
default <E> JpaPredicate	collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersectsNullable(Expression, Collection)
default <E> JpaPredicate	collectionOverlapsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Deprecated, for removal: This API element is subject to removal in a future version. Replaced with collectionIntersectsNullable(Collection, Expression)
<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.
<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.
<T> 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.
<T> JpaExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)	Concatenates the non-null basic 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 an expression for string concatenation.
JpaExpression<String>	concat(Expression<String> x, String y)	Create an expression for string concatenation.
JpaExpression<String>	concat(String x, Expression<String> y)	Create an expression for string concatenation.
JpaExpression<String>	concat(String x, String y)
JpaPredicate	conjunction()	Create a conjunction (with zero conjuncts).
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, Selection<?>... selections)	Create a selection item corresponding to a constructor.
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
JpaExpression<Double>	cos(Expression<? extends Number> x)	Create an expression that returns the cosine of its argument.
JpaExpression<Double>	cosh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic cosine of its argument.
JpaExpression<Long>	count()	Equivalent to HQL count(*).
JpaExpression<Long>	count(Expression<?> argument)	Create an aggregate expression applying the count operation.
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 applying the count distinct operation.
<T> JpaCriteriaDelete<T>	createCriteriaDelete(Class<T> targetEntity)	Create a CriteriaDelete query object to perform a bulk delete operation.
<T> JpaCriteriaInsertSelect<T>	createCriteriaInsertSelect(Class<T> targetEntity)
<T> JpaCriteriaInsertValues<T>	createCriteriaInsertValues(Class<T> targetEntity)
<T> JpaCriteriaUpdate<T>	createCriteriaUpdate(Class<T> targetEntity)	Create a CriteriaUpdate query object to perform a bulk update operation.
JpaCriteriaQuery<Object>	createQuery()	Create a CriteriaQuery object.
<T> JpaCriteriaQuery<T>	createQuery(Class<T> resultClass)	Create a CriteriaQuery object with the specified 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 CriteriaQuery object that returns a tuple of objects as its result.
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 expression to return current date.
JpaFunction<Instant>	currentInstant()
JpaFunction<Time>	currentTime()	Create expression to return current time.
JpaFunction<Timestamp>	currentTimestamp()	Create expression to return current 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 an ordering by the descending value of the 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 that returns the difference between its arguments.
<N extends Number> JpaExpression<N>	diff(Expression<? extends N> x, N y)	Create an expression that returns the difference between its arguments.
<N extends Number> JpaExpression<N>	diff(N x, Expression<? extends N> y)	Create an expression that returns the difference between its arguments.
JpaPredicate	disjunction()	Create a disjunction (with zero disjuncts).
JpaPredicate	distinctFrom(Expression<?> x, Expression<?> y)
JpaPredicate	distinctFrom(Expression<?> x, Object y)
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 a predicate for testing the arguments for equality.
JpaPredicate	equal(Expression<?> x, Object y)	Create a predicate for testing the arguments for equality.
<T> JpaCriteriaQuery<T>	except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	except(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	except(Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	exceptAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	exceptAll(Subquery<? extends T> query1, Subquery<?>... queries)
JpaPredicate	exists(Subquery<?> subquery)	Create a predicate testing the existence of a subquery result.
JpaExpression<Double>	exp(Expression<? extends Number> x)	Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
<T> JpaExpression<T>	firstValue(Expression<T> argument, JpaWindow window)	Create a first_value window function expression.
<P, F> JpaExpression<F>	fk(Path<P> path)
<N extends Number> JpaExpression<N>	floor(Expression<N> x)	Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
JpaFunction<String>	format(Expression<? extends TemporalAccessor> datetime, String pattern)	Format a date, time, or datetime according to a pattern.
JpaWindowFrame	frameBetweenFollowing(int offset)
JpaWindowFrame	frameBetweenFollowing(Expression<?> offset)	Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with 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 for the execution of 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 predicate for testing whether the first argument is greater than or equal to the second.
JpaPredicate	ge(Expression<? extends Number> x, Number y)	Create a predicate for testing whether the first argument is greater than or equal to the second.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)	Create a predicate for testing whether the first argument is greater than the second.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThan(Expression<? extends Y> x, Y y)	Create a predicate for testing whether the first argument is greater than the second.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)	Create a predicate for testing whether the first argument is greater than or equal to the second.
<Y extends Comparable<? super Y>> JpaPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Y y)	Create a predicate for testing whether the first argument is greater than or equal to the second.
<X extends Comparable<? super X>> JpaExpression<X>	greatest(Expression<X> argument)	Create an aggregate expression for finding the greatest of the values (strings, dates, etc).
JpaPredicate	gt(Expression<? extends Number> x, Expression<? extends Number> y)	Create a predicate for testing whether the first argument is greater than the second.
JpaPredicate	gt(Expression<? extends Number> x, Number y)	Create a predicate for testing whether the first argument is greater than the second.
JpaFunction<Integer>	hour(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern)
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern, char escapeChar)
JpaPredicate	ilike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
JpaPredicate	ilike(Expression<String> x, String pattern)
JpaPredicate	ilike(Expression<String> x, String pattern, char escapeChar)
JpaPredicate	ilike(Expression<String> x, String pattern, Expression<Character> escapeChar)
<T> JpaInPredicate<T>	in(Expression<? extends T> expression)	Create predicate to test whether given expression is contained in a list of values.
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, Expression<? extends T>... values)
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, Collection<T> values)
<T> JpaInPredicate<T>	in(Expression<? extends T> expression, T... values)
<K, L extends List<?>> JpaExpression<Set<K>>	indexes(L list)
<T> JpaCriteriaQuery<T>	intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	intersect(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	intersect(Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	intersectAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	intersectAll(Subquery<? extends T> query1, Subquery<?>... queries)
<C extends Collection<?>> JpaPredicate	isEmpty(Expression<C> collection)	Create a predicate that tests whether a collection is empty.
JpaPredicate	isFalse(Expression<Boolean> x)	Create a predicate testing for a false value.
<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 that tests 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 that tests whether an element is a member of a collection.
<C extends Collection<?>> JpaPredicate	isNotEmpty(Expression<C> collection)	Create a predicate that tests whether a collection is not empty.
<E, C extends Collection<E>> JpaPredicate	isNotMember(E elem, Expression<C> collection)	Create a predicate that tests 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 that tests whether an element is not a member of a collection.
JpaPredicate	isNotNull(Expression<?> x)	Create a predicate to test whether the expression is not null.
JpaPredicate	isNull(Expression<?> x)	Create a predicate to test whether the expression is null.
JpaPredicate	isTrue(Expression<Boolean> x)	Create a predicate testing for a true value.
<K, M extends Map<K, ?>> JpaExpression<Set<K>>	keys(M map)	Create an expression that returns the keys of a map.
<T> JpaExpression<T>	lastValue(Expression<T> argument, JpaWindow window)	Create a last_value window function expression.
JpaPredicate	le(Expression<? extends Number> x, Expression<? extends Number> y)	Create a predicate for testing whether the first argument is less than or equal to the second.
JpaPredicate	le(Expression<? extends Number> x, Number y)	Create a predicate for testing whether the first argument is less than or equal to the second.
<X extends Comparable<? super X>> JpaExpression<X>	least(Expression<X> argument)	Create an aggregate expression for finding the least of the values (strings, dates, etc).
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 expression to return length of a string.
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(Expression<? extends Y> x, Expression<? extends Y> y)	Create a predicate for testing whether the first argument is less than the second.
<Y extends Comparable<? super Y>> JpaPredicate	lessThan(Expression<? extends Y> x, Y y)	Create a predicate for testing whether the first argument is less than the second.
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)	Create a predicate for testing whether the first argument is less than or equal to the second.
<Y extends Comparable<? super Y>> JpaPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Y y)	Create a predicate for testing whether the first argument is less than or equal to the second.
JpaPredicate	like(Expression<String> x, Expression<String> pattern)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaPredicate	like(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaPredicate	like(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaPredicate	like(Expression<String> x, String pattern)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaPredicate	like(Expression<String> x, String pattern, char escapeChar)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaPredicate	like(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a predicate for testing whether the expression satisfies the given pattern.
JpaExpression<String>	listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)	Create a listagg ordered set-aggregate function expression.
JpaExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
JpaExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)
<T> JpaExpression<T>	literal(T value)	Create an expression for a literal.
<T> List<? extends JpaExpression<T>>	literals(List<T> values)
<T> List<? extends JpaExpression<T>>	literals(T... values)
JpaExpression<Double>	ln(Expression<? extends Number> x)	Create an expression that returns the natural logarithm of its argument.
JpaExpression<LocalDate>	localDate()	Create expression to return current local date.
JpaExpression<LocalDateTime>	localDateTime()	Create expression to return current local datetime.
JpaExpression<LocalTime>	localTime()	Create expression to return current local time.
JpaFunction<Integer>	locate(Expression<String> x, Expression<String> pattern)	Create expression to locate the position of one string within another, returning position of first character if found.
JpaFunction<Integer>	locate(Expression<String> x, Expression<String> pattern, Expression<Integer> from)	Create expression to locate the position of one string within another, returning position of first character if found.
JpaFunction<Integer>	locate(Expression<String> x, String pattern)	Create expression to locate the position of one string within another, returning position of first character if found.
JpaFunction<Integer>	locate(Expression<String> x, String pattern, int from)	Create expression to locate the position of one string within another, returning position of first character if found.
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 expression for converting a string to lowercase.
JpaPredicate	lt(Expression<? extends Number> x, Expression<? extends Number> y)	Create a predicate for testing whether the first argument is less than the second.
JpaPredicate	lt(Expression<? extends Number> x, Number y)	Create a predicate for testing whether the first argument is less than the second.
<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 applying the numerical max operation.
<N extends Number> JpaExpression<N>	min(Expression<N> argument)	Create an aggregate expression applying the numerical min operation.
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 that returns the modulus (remainder under integer division) of its arguments.
JpaExpression<Integer>	mod(Expression<Integer> x, Integer y)	Create an expression that returns the modulus (remainder under integer division) of its arguments.
JpaExpression<Integer>	mod(Integer x, Expression<Integer> y)	Create an expression that returns the modulus (remainder under integer division) of its arguments.
<T> JpaExpression<T>	mode(Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)	Create a mode ordered set-aggregate function expression.
<T> JpaExpression<T>	mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
JpaFunction<Integer>	month(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
<N extends Number> JpaExpression<N>	neg(Expression<N> x)	Create an expression that returns the arithmetic negation of its argument.
JpaPredicate	not(Expression<Boolean> restriction)	Create a negation of the given restriction.
JpaPredicate	notDistinctFrom(Expression<?> x, Expression<?> y)
JpaPredicate	notDistinctFrom(Expression<?> x, Object y)
JpaPredicate	notEqual(Expression<?> x, Expression<?> y)	Create a predicate for testing the arguments for inequality.
JpaPredicate	notEqual(Expression<?> x, Object y)	Create a predicate for testing the arguments for inequality.
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern)
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
JpaPredicate	notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
JpaPredicate	notIlike(Expression<String> x, String pattern)
JpaPredicate	notIlike(Expression<String> x, String pattern, char escapeChar)
JpaPredicate	notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern)	Create a predicate for testing whether the expression does not satisfy the given pattern.
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern, char escapeChar)	Create a predicate for testing whether the expression does not satisfy the given pattern.
JpaPredicate	notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)	Create a predicate for testing whether the expression does not satisfy the given pattern.
JpaPredicate	notLike(Expression<String> x, String pattern)	Create a predicate for testing whether the expression does not satisfy the given pattern.
JpaPredicate	notLike(Expression<String> x, String pattern, char escapeChar)	Create a predicate for testing whether the expression does not satisfy the given pattern.
JpaPredicate	notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)	Create a predicate for testing whether the expression does not satisfy the given pattern.
<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 an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
<Y> JpaExpression<Y>	nullif(Expression<Y> x, Y y)	Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
<T> JpaExpression<T>	nullLiteral(Class<T> resultClass)	Create an expression for a null literal with the given type.
JpaPredicate	or(Expression<Boolean> x, Expression<Boolean> y)	Create a disjunction of the given boolean expressions.
JpaPredicate	or(Predicate... restrictions)	Create a disjunction of the given restriction predicates.
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 with the given name.
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)	Create a percentile_cont ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)	Create a percentile_disc ordered set-aggregate function expression.
<T> JpaExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
JpaExpression<Double>	percentRank(JpaOrder order, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)	Create a percent_rank ordered set-aggregate function expression.
JpaExpression<Double>	percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Double>	percentRank(JpaWindow window)	Create a percent_rank window function expression.
JpaExpression<Double>	pi()	Literal expression corresponding to the value of pi.
JpaExpression<Double>	power(Expression<? extends Number> x, Expression<? extends Number> y)	Create an expression that returns the first argument raised to the power of its second argument.
JpaExpression<Double>	power(Expression<? extends Number> x, Number y)	Create an expression that returns the first argument raised to the power of its second argument.
<N extends Number> JpaExpression<N>	prod(Expression<? extends N> x, Expression<? extends N> y)	Create an expression that returns the product of its arguments.
<N extends Number> JpaExpression<N>	prod(Expression<? extends N> x, N y)	Create an expression that returns the product of its arguments.
<N extends Number> JpaExpression<N>	prod(N x, Expression<? extends N> y)	Create an expression that returns the product of its arguments.
JpaExpression<Number>	quot(Expression<? extends Number> x, Expression<? extends Number> y)	Create an expression that returns the quotient of its arguments.
JpaExpression<Number>	quot(Expression<? extends Number> x, Number y)	Create an expression that returns the quotient of its arguments.
JpaExpression<Number>	quot(Number x, Expression<? extends Number> y)	Create an expression that returns the quotient of its arguments.
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, NullPrecedence nullPrecedence)	Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
JpaFunction<Float>	second(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.
<R> JpaSearchedCase<R>	selectCase()	Create a general case expression.
<C, R> JpaSimpleCase<C,R>	selectCase(Expression<? extends C> expression)	Create a simple case 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 that tests the size of a collection.
<C extends Collection<?>> JpaExpression<Integer>	size(Expression<C> collection)	Create an expression that tests the size of a collection.
<Y> JpaExpression<Y>	some(Subquery<Y> subquery)	Create a some expression over the subquery results.
JpaOrder	sort(JpaExpression<?> sortExpression)
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
JpaOrder	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence, boolean ignoreCase)
<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 that returns the square root of its argument.
JpaFunction<String>	substring(Expression<String> x, int from)	Create an expression for substring extraction.
JpaFunction<String>	substring(Expression<String> x, int from, int len)	Create an expression for substring extraction.
JpaFunction<String>	substring(Expression<String> x, Expression<Integer> from)	Create an expression for substring extraction.
JpaFunction<String>	substring(Expression<String> x, Expression<Integer> from, Expression<Integer> len)	Create an expression for substring extraction.
<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 that returns the sum of its arguments.
<N extends Number> JpaExpression<N>	sum(Expression<? extends N> x, N y)	Create an expression that returns the sum of its arguments.
<N extends Number> JpaExpression<N>	sum(Expression<N> argument)	Create an aggregate expression applying the sum operation.
<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 that returns the sum of its arguments.
JpaExpression<Double>	sumAsDouble(Expression<Float> argument)	Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.
JpaExpression<Long>	sumAsLong(Expression<Integer> argument)	Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.
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)	Typecast.
JpaExpression<BigInteger>	toBigInteger(Expression<? extends Number> number)	Typecast.
JpaExpression<Double>	toDouble(Expression<? extends Number> number)	Typecast.
JpaExpression<Float>	toFloat(Expression<? extends Number> number)	Typecast.
JpaExpression<Integer>	toInteger(Expression<? extends Number> number)	Typecast.
JpaExpression<Long>	toLong(Expression<? extends Number> number)	Typecast.
JpaExpression<String>	toString(Expression<Character> character)	Typecast.
<X, T, E extends T> JpaCollectionJoin<X,E>	treat(CollectionJoin<X,T> join, Class<E> type)	Downcast CollectionJoin object to the specified type.
<X, T, V extends T> JpaJoin<X,V>	treat(Join<X,T> join, Class<V> type)	Downcast Join object to the specified type.
<X, T, E extends T> JpaListJoin<X,E>	treat(ListJoin<X,T> join, Class<E> type)	Downcast ListJoin object to the specified type.
<X, K, T, V extends T> JpaMapJoin<X,K,V>	treat(MapJoin<X,K,T> join, Class<V> type)	Downcast MapJoin object to the specified type.
<X, T extends X> JpaPath<T>	treat(Path<X> path, Class<T> type)	Downcast Path object to the specified type.
<X, T extends X> JpaRoot<T>	treat(Root<X> root, Class<T> type)	Downcast Root object to the specified type.
<X, T, E extends T> JpaSetJoin<X,E>	treat(SetJoin<X,T> join, Class<E> type)	Downcast SetJoin object to the specified type.
JpaFunction<String>	trim(char t, Expression<String> x)	Create expression to trim character from both ends of a string.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, char t, Expression<String> x)	Create expression to trim character from a string.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<Character> t, Expression<String> x)	Create expression to trim character from a string.
JpaFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<String> x)	Create expression to trim blanks from a string.
JpaFunction<String>	trim(Expression<Character> t, Expression<String> x)	Create expression to trim character from both ends of a string.
JpaFunction<String>	trim(Expression<String> x)	Create expression to trim blanks from both ends of a string.
<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 selection item.
JpaCompoundSelection<Tuple>	tuple(List<? extends JpaSelection<?>> selections)
<T> JpaCriteriaQuery<T>	union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	union(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	union(Subquery<? extends T> query1, Subquery<?>... queries)
default <T> JpaCriteriaQuery<T>	unionAll(CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
default <T> JpaSubQuery<T>	unionAll(Subquery<? extends T> query1, Subquery<?>... queries)
<T extends HibernateCriteriaBuilder> T	unwrap(Class<T> clazz)
JpaFunction<String>	upper(Expression<String> x)	Create expression for converting a string to uppercase.
<T> JpaExpression<T>	value(T value)
JpaValues	values(Expression<?>... expressions)
JpaValues	values(List<? extends Expression<?>> expressions)
<V, M extends Map<?, V>> Expression<Collection<V>>	values(M map)	Create an expression that returns the values of a map.
<T> JpaExpression<T>	windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)	Create a generic window function expression that will be applied over the specified window.
JpaPredicate	wrap(Expression<Boolean> expression)
JpaPredicate	wrap(Expression<Boolean>... expressions)
JpaFunction<Integer>	year(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.

Method Details

cast

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

wrap

JpaPredicate wrap(Expression<Boolean> expression)

wrap

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

unwrap

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

createQuery

JpaCriteriaQuery<Object> createQuery()

Description copied from interface: CriteriaBuilder

Create a CriteriaQuery object.

Specified by:

createQuery in interface CriteriaBuilder

Returns:

criteria query object

createQuery

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

Description copied from interface: CriteriaBuilder

Create a CriteriaQuery object with the specified result type.

Specified by:

createQuery in interface CriteriaBuilder

Parameters:

resultClass - type of the query result

Returns:

criteria query object

createTupleQuery

JpaCriteriaQuery<Tuple> createTupleQuery()

Description copied from interface: CriteriaBuilder

Create a CriteriaQuery object that returns a tuple of objects as its result.

Specified by:

createTupleQuery in interface CriteriaBuilder

Returns:

criteria query object

createCriteriaUpdate

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

Description copied from interface: CriteriaBuilder

Create a CriteriaUpdate query object to perform a bulk update operation.

Specified by:

createCriteriaUpdate in interface CriteriaBuilder

Parameters:

targetEntity - target type for update operation

Returns:

the query object

createCriteriaDelete

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

Description copied from interface: CriteriaBuilder

Create a CriteriaDelete query object to perform a bulk delete operation.

Specified by:

createCriteriaDelete in interface CriteriaBuilder

Parameters:

targetEntity - target type for delete operation

Returns:

the query object

createCriteriaInsertValues

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

createCriteriaInsertSelect

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

values

@Incubating
JpaValues values(Expression<?>... expressions)

values

@Incubating
JpaValues values(List<? extends Expression<?>> expressions)

createQuery

<T> JpaCriteriaQuery<T> createQuery(String hql,
 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

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

union

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

union

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

intersectAll

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

intersect

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

intersect

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

exceptAll

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

except

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

except

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

unionAll

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

union

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

union

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

intersectAll

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

intersect

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

intersect

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

exceptAll

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

except

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

except

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

sign

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.

Specified by:

sign in interface CriteriaBuilder

Parameters:

x - expression

Returns:

sign

ceiling

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

Specified by:

ceiling in interface CriteriaBuilder

Parameters:

x - expression

Returns:

ceiling

floor

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

Specified by:

floor in interface CriteriaBuilder

Parameters:

x - expression

Returns:

floor

exp

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.

Specified by:

exp in interface CriteriaBuilder

Parameters:

x - expression

Returns:

exponential

ln

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

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

Specified by:

ln in interface CriteriaBuilder

Parameters:

x - expression

Returns:

natural logarithm

power

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.

Specified by:

power in interface CriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

power

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.

Specified by:

power in interface CriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

round

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

Specified by:

round in interface CriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the rounded value

truncate

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

Parameters:

x - base

n - number of decimal places

Returns:

the truncated value

localDate

JpaExpression<LocalDate> localDate()

Create expression to return current local date.

Specified by:

localDate in interface CriteriaBuilder

Returns:

expression for current date

localDateTime

JpaExpression<LocalDateTime> localDateTime()

Create expression to return current local datetime.

Specified by:

localDateTime in interface CriteriaBuilder

Returns:

expression for current timestamp

localTime

JpaExpression<LocalTime> localTime()

Create expression to return current local time.

Specified by:

localTime in interface CriteriaBuilder

Returns:

expression for current time

fk

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

treat

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

Description copied from interface: CriteriaBuilder

Downcast Path object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

path - path

type - type to be downcast to

Returns:

Path object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast Root object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

root - root

type - type to be downcast to

Returns:

Root object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast Join object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

join - Join object

type - type to be downcast to

Returns:

Join object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast CollectionJoin object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

join - CollectionJoin object

type - type to be downcast to

Returns:

CollectionJoin object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast SetJoin object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

join - SetJoin object

type - type to be downcast to

Returns:

SetJoin object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast ListJoin object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

join - ListJoin object

type - type to be downcast to

Returns:

ListJoin object of the specified type

treat

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

Description copied from interface: CriteriaBuilder

Downcast MapJoin object to the specified type.

Specified by:

treat in interface CriteriaBuilder

Parameters:

join - MapJoin object

type - type to be downcast to

Returns:

MapJoin object of the specified type

construct

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

Description copied from interface: CriteriaBuilder

Create a selection item corresponding to a constructor. This method is used to specify a constructor that will be applied to the results of the query execution. If the constructor is for an entity class, the resulting entities will be in the new state after the query is executed.

Specified by:

construct in interface CriteriaBuilder

Parameters:

resultClass - class whose instance is to be constructed

selections - arguments to the constructor

Returns:

compound selection item

construct

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

tuple

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

Description copied from interface: CriteriaBuilder

Create a tuple-valued selection item.

Specified by:

tuple in interface CriteriaBuilder

Parameters:

selections - selection items

Returns:

tuple-valued compound selection

tuple

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

array

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

Description copied from interface: CriteriaBuilder

Create an array-valued selection item.

Specified by:

array in interface CriteriaBuilder

Parameters:

selections - selection items

Returns:

array-valued compound selection

array

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

array

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

array

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

avg

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the avg operation.

Specified by:

avg in interface CriteriaBuilder

Parameters:

argument - expression representing input value to avg operation

Returns:

avg expression

sum

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the sum operation.

Specified by:

sum in interface CriteriaBuilder

Parameters:

argument - expression representing input value to sum operation

Returns:

sum expression

sumAsLong

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.

Specified by:

sumAsLong in interface CriteriaBuilder

Parameters:

argument - expression representing input value to sum operation

Returns:

sum expression

sumAsDouble

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.

Specified by:

sumAsDouble in interface CriteriaBuilder

Parameters:

argument - expression representing input value to sum operation

Returns:

sum expression

max

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the numerical max operation.

Specified by:

max in interface CriteriaBuilder

Parameters:

argument - expression representing input value to max operation

Returns:

max expression

min

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the numerical min operation.

Specified by:

min in interface CriteriaBuilder

Parameters:

argument - expression representing input value to min operation

Returns:

min expression

greatest

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression for finding the greatest of the values (strings, dates, etc).

Specified by:

greatest in interface CriteriaBuilder

Parameters:

argument - expression representing input value to greatest operation

Returns:

greatest expression

least

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression for finding the least of the values (strings, dates, etc).

Specified by:

least in interface CriteriaBuilder

Parameters:

argument - expression representing input value to least operation

Returns:

least expression

count

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the count operation.

Specified by:

count in interface CriteriaBuilder

Parameters:

argument - expression representing input value to count operation

Returns:

count expression

countDistinct

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

Description copied from interface: CriteriaBuilder

Create an aggregate expression applying the count distinct operation.

Specified by:

countDistinct in interface CriteriaBuilder

Parameters:

x - expression representing input value to count distinct operation

Returns:

count distinct expression

count

JpaExpression<Long> count()

Equivalent to HQL count(*).

neg

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the arithmetic negation of its argument.

Specified by:

neg in interface CriteriaBuilder

Parameters:

x - expression

Returns:

arithmetic negation

abs

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the absolute value of its argument.

Specified by:

abs in interface CriteriaBuilder

Parameters:

x - expression

Returns:

absolute value

sum

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the sum of its arguments.

Specified by:

sum in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

sum

sum

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the sum of its arguments.

Specified by:

sum in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

sum

sum

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the sum of its arguments.

Specified by:

sum in interface CriteriaBuilder

Parameters:

x - value

y - expression

Returns:

sum

prod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the product of its arguments.

Specified by:

prod in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

product

prod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the product of its arguments.

Specified by:

prod in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

product

prod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the product of its arguments.

Specified by:

prod in interface CriteriaBuilder

Parameters:

x - value

y - expression

Returns:

product

diff

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the difference between its arguments.

Specified by:

diff in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

difference

diff

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the difference between its arguments.

Specified by:

diff in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

difference

diff

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the difference between its arguments.

Specified by:

diff in interface CriteriaBuilder

Parameters:

x - value

y - expression

Returns:

difference

quot

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the quotient of its arguments.

Specified by:

quot in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

quotient

quot

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the quotient of its arguments.

Specified by:

quot in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

quotient

quot

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the quotient of its arguments.

Specified by:

quot in interface CriteriaBuilder

Parameters:

x - value

y - expression

Returns:

quotient

mod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the modulus (remainder under integer division) of its arguments.

Specified by:

mod in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

modulus

mod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the modulus (remainder under integer division) of its arguments.

Specified by:

mod in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

modulus

mod

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the modulus (remainder under integer division) of its arguments.

Specified by:

mod in interface CriteriaBuilder

Parameters:

x - value

y - expression

Returns:

modulus

sqrt

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the square root of its argument.

Specified by:

sqrt in interface CriteriaBuilder

Parameters:

x - expression

Returns:

square root

durationSum

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

Add two durations.

Since:

6.3

durationSum

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

Add two durations.

Since:

6.3

durationDiff

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

Subtract one duration from another.

Since:

6.3

durationDiff

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

Subtract one duration from another.

Since:

6.3

durationScaled

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

Scale a duration by a number.

Since:

6.3

durationScaled

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

Scale a duration by a number.

Since:

6.3

durationScaled

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

Scale a duration by a number.

Since:

6.3

duration

@Incubating
JpaExpression<Duration> duration(long magnitude,
 TemporalUnit unit)

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

Since:

6.3

durationByUnit

@Incubating
JpaExpression<Long> durationByUnit(TemporalUnit unit,
 Expression<Duration> duration)

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

Parameters:

unit - a choice of 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

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

Since:

6.3

durationBetween

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

Since:

6.3

addDuration

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

Since:

6.3

addDuration

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

Since:

6.3

addDuration

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

Since:

6.3

subtractDuration

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

Since:

6.3

subtractDuration

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

Since:

6.3

subtractDuration

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

Since:

6.3

toLong

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toLong in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<Long>

toInteger

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toInteger in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<Integer>

toFloat

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toFloat in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<Float>

toDouble

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toDouble in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<Double>

toBigDecimal

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toBigDecimal in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<BigDecimal>

toBigInteger

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toBigInteger in interface CriteriaBuilder

Parameters:

number - numeric expression

Returns:

Expression<BigInteger>

toString

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

Description copied from interface: CriteriaBuilder

Typecast. Returns same expression object.

Specified by:

toString in interface CriteriaBuilder

Parameters:

character - expression

Returns:

Expression<String>

literal

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

Description copied from interface: CriteriaBuilder

Create an expression for a literal.

Specified by:

literal in interface CriteriaBuilder

Parameters:

value - value represented by the expression

Returns:

expression literal

literals

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

literals

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

nullLiteral

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

Description copied from interface: CriteriaBuilder

Create an expression for a null literal with the given type.

Specified by:

nullLiteral in interface CriteriaBuilder

Parameters:

resultClass - type of the null literal

Returns:

null expression literal

parameter

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

Description copied from interface: CriteriaBuilder

Create a parameter expression.

Specified by:

parameter in interface CriteriaBuilder

Parameters:

paramClass - parameter class

Returns:

parameter expression

parameter

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

Description copied from interface: CriteriaBuilder

Create a parameter expression with the given name.

Specified by:

parameter in interface CriteriaBuilder

Parameters:

paramClass - parameter class

name - name that can be used to refer to the parameter

Returns:

parameter expression

concat

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

Description copied from interface: CriteriaBuilder

Create an expression for string concatenation.

Specified by:

concat in interface CriteriaBuilder

Parameters:

x - string expression

y - string expression

Returns:

expression corresponding to concatenation

concat

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

Description copied from interface: CriteriaBuilder

Create an expression for string concatenation.

Specified by:

concat in interface CriteriaBuilder

Parameters:

x - string expression

y - string

Returns:

expression corresponding to concatenation

concat

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

Description copied from interface: CriteriaBuilder

Create an expression for string concatenation.

Specified by:

concat in interface CriteriaBuilder

Parameters:

x - string

y - string expression

Returns:

expression corresponding to concatenation

concat

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

substring

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

Description copied from interface: CriteriaBuilder

Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string. First position is 1.

Specified by:

substring in interface CriteriaBuilder

Parameters:

x - string expression

from - start position expression

Returns:

expression corresponding to substring extraction

substring

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

Description copied from interface: CriteriaBuilder

Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string. First position is 1.

Specified by:

substring in interface CriteriaBuilder

Parameters:

x - string expression

from - start position

Returns:

expression corresponding to substring extraction

substring

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

Description copied from interface: CriteriaBuilder

Create an expression for substring extraction. Extracts a substring of given length starting at the specified position. First position is 1.

Specified by:

substring in interface CriteriaBuilder

Parameters:

x - string expression

from - start position expression

len - length expression

Returns:

expression corresponding to substring extraction

substring

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

Description copied from interface: CriteriaBuilder

Create an expression for substring extraction. Extracts a substring of given length starting at the specified position. First position is 1.

Specified by:

substring in interface CriteriaBuilder

Parameters:

x - string expression

from - start position

len - length

Returns:

expression corresponding to substring extraction

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim blanks from both ends of a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

x - expression for string to trim

Returns:

trim expression

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim blanks from a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

ts - trim specification

x - expression for string to trim

Returns:

trim expression

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim character from both ends of a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

t - expression for character to be trimmed

x - expression for string to trim

Returns:

trim expression

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim character from a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

ts - trim specification

t - expression for character to be trimmed

x - expression for string to trim

Returns:

trim expression

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim character from both ends of a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

t - character to be trimmed

x - expression for string to trim

Returns:

trim expression

trim

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

Description copied from interface: CriteriaBuilder

Create expression to trim character from a string.

Specified by:

trim in interface CriteriaBuilder

Parameters:

ts - trim specification

t - character to be trimmed

x - expression for string to trim

Returns:

trim expression

lower

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

Description copied from interface: CriteriaBuilder

Create expression for converting a string to lowercase.

Specified by:

lower in interface CriteriaBuilder

Parameters:

x - string expression

Returns:

expression to convert to lowercase

upper

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

Description copied from interface: CriteriaBuilder

Create expression for converting a string to uppercase.

Specified by:

upper in interface CriteriaBuilder

Parameters:

x - string expression

Returns:

expression to convert to uppercase

length

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

Description copied from interface: CriteriaBuilder

Create expression to return length of a string.

Specified by:

length in interface CriteriaBuilder

Parameters:

x - string expression

Returns:

length expression

locate

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

Description copied from interface: CriteriaBuilder

Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.

Warning: the order of the parameters of this method is reversed compared to the corresponding function in JPQL.

Specified by:

locate in interface CriteriaBuilder

Parameters:

x - expression for string to be searched

pattern - expression for string to be located

Returns:

expression corresponding to position

locate

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

Description copied from interface: CriteriaBuilder

Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.

Warning: the order of the parameters of this method is reversed compared to the corresponding function in JPQL.

Specified by:

locate in interface CriteriaBuilder

Parameters:

x - expression for string to be searched

pattern - string to be located

Returns:

expression corresponding to position

locate

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

Description copied from interface: CriteriaBuilder

Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.

Warning: the order of the first two parameters of this method is reversed compared to the corresponding function in JPQL.

Specified by:

locate in interface CriteriaBuilder

Parameters:

x - expression for string to be searched

pattern - expression for string to be located

from - expression for position at which to start search

Returns:

expression corresponding to position

locate

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

Description copied from interface: CriteriaBuilder

Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.

Warning: the order of the first two parameters of this method is reversed compared to the corresponding function in JPQL.

Specified by:

locate in interface CriteriaBuilder

Parameters:

x - expression for string to be searched

pattern - string to be located

from - position at which to start search

Returns:

expression corresponding to position

currentDate

JpaFunction<Date> currentDate()

Description copied from interface: CriteriaBuilder

Create expression to return current date.

Specified by:

currentDate in interface CriteriaBuilder

Returns:

expression for current date

currentTime

JpaFunction<Time> currentTime()

Description copied from interface: CriteriaBuilder

Create expression to return current time.

Specified by:

currentTime in interface CriteriaBuilder

Returns:

expression for current time

currentTimestamp

JpaFunction<Timestamp> currentTimestamp()

Description copied from interface: CriteriaBuilder

Create expression to return current timestamp.

Specified by:

currentTimestamp in interface CriteriaBuilder

Returns:

expression for current timestamp

currentInstant

JpaFunction<Instant> currentInstant()

function

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

Description copied from interface: CriteriaBuilder

Create an expression for the execution of a database function.

Specified by:

function in interface CriteriaBuilder

Parameters:

name - function name

type - expected result type

args - function arguments

Returns:

expression

all

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

Description copied from interface: CriteriaBuilder

Create an all expression over the subquery results.

Specified by:

all in interface CriteriaBuilder

Parameters:

subquery - subquery

Returns:

all expression

some

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

Description copied from interface: CriteriaBuilder

Create a some expression over the subquery results. This expression is equivalent to an any expression.

Specified by:

some in interface CriteriaBuilder

Parameters:

subquery - subquery

Returns:

some expression

any

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

Description copied from interface: CriteriaBuilder

Create an any expression over the subquery results. This expression is equivalent to a some expression.

Specified by:

any in interface CriteriaBuilder

Parameters:

subquery - subquery

Returns:

any expression

keys

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

Description copied from interface: CriteriaBuilder

Create an expression that returns the keys of a map.

Specified by:

keys in interface CriteriaBuilder

Parameters:

map - map

Returns:

set expression

indexes

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

value

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

values

<V,
M extends Map<?,
V>> Expression<Collection<V>> values(M map)

Description copied from interface: CriteriaBuilder

Create an expression that returns the values of a map.

Specified by:

values in interface CriteriaBuilder

Parameters:

map - map

Returns:

collection expression

size

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

Description copied from interface: CriteriaBuilder

Create an expression that tests the size of a collection.

Specified by:

size in interface CriteriaBuilder

Parameters:

collection - expression

Returns:

size expression

size

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

Description copied from interface: CriteriaBuilder

Create an expression that tests the size of a collection.

Specified by:

size in interface CriteriaBuilder

Parameters:

collection - collection

Returns:

size expression

coalesce

<T> JpaCoalesce<T> coalesce()

Description copied from interface: CriteriaBuilder

Create a coalesce expression.

Specified by:

coalesce in interface CriteriaBuilder

Returns:

coalesce expression

coalesce

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

Description copied from interface: CriteriaBuilder

Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.

Specified by:

coalesce in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

coalesce expression

coalesce

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

Description copied from interface: CriteriaBuilder

Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.

Specified by:

coalesce in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

coalesce expression

nullif

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

Description copied from interface: CriteriaBuilder

Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

nullif expression

nullif

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

Description copied from interface: CriteriaBuilder

Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.

Specified by:

nullif in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

nullif expression

selectCase

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

Description copied from interface: CriteriaBuilder

Create a simple case expression.

Specified by:

selectCase in interface CriteriaBuilder

Parameters:

expression - to be tested against the case conditions

Returns:

simple case expression

selectCase

<R> JpaSearchedCase<R> selectCase()

Description copied from interface: CriteriaBuilder

Create a general case expression.

Specified by:

selectCase in interface CriteriaBuilder

Returns:

general case expression

and

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

Description copied from interface: CriteriaBuilder

Create a conjunction of the given boolean expressions.

Specified by:

and in interface CriteriaBuilder

Parameters:

x - boolean expression

y - boolean expression

Returns:

and predicate

and

JpaPredicate and(Predicate... restrictions)

Description copied from interface: CriteriaBuilder

Create a conjunction of the given restriction predicates. A conjunction of zero predicates is true.

Specified by:

and in interface CriteriaBuilder

Parameters:

restrictions - zero or more restriction predicates

Returns:

and predicate

or

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

Description copied from interface: CriteriaBuilder

Create a disjunction of the given boolean expressions.

Specified by:

or in interface CriteriaBuilder

Parameters:

x - boolean expression

y - boolean expression

Returns:

or predicate

or

JpaPredicate or(Predicate... restrictions)

Description copied from interface: CriteriaBuilder

Create a disjunction of the given restriction predicates. A disjunction of zero predicates is false.

Specified by:

or in interface CriteriaBuilder

Parameters:

restrictions - zero or more restriction predicates

Returns:

or predicate

not

JpaPredicate not(Expression<Boolean> restriction)

Description copied from interface: CriteriaBuilder

Create a negation of the given restriction.

Specified by:

not in interface CriteriaBuilder

Parameters:

restriction - restriction expression

Returns:

not predicate

conjunction

JpaPredicate conjunction()

Description copied from interface: CriteriaBuilder

Create a conjunction (with zero conjuncts). A conjunction with zero conjuncts is true.

Specified by:

conjunction in interface CriteriaBuilder

Returns:

and predicate

disjunction

JpaPredicate disjunction()

Description copied from interface: CriteriaBuilder

Create a disjunction (with zero disjuncts). A disjunction with zero disjuncts is false.

Specified by:

disjunction in interface CriteriaBuilder

Returns:

or predicate

isTrue

JpaPredicate isTrue(Expression<Boolean> x)

Description copied from interface: CriteriaBuilder

Create a predicate testing for a true value.

Specified by:

isTrue in interface CriteriaBuilder

Parameters:

x - expression to be tested

Returns:

predicate

isFalse

JpaPredicate isFalse(Expression<Boolean> x)

Description copied from interface: CriteriaBuilder

Create a predicate testing for a false value.

Specified by:

isFalse in interface CriteriaBuilder

Parameters:

x - expression to be tested

Returns:

predicate

isNull

JpaPredicate isNull(Expression<?> x)

Description copied from interface: CriteriaBuilder

Create a predicate to test whether the expression is null.

Specified by:

isNull in interface CriteriaBuilder

Parameters:

x - expression

Returns:

is-null predicate

isNotNull

JpaPredicate isNotNull(Expression<?> x)

Description copied from interface: CriteriaBuilder

Create a predicate to test whether the expression is not null.

Specified by:

isNotNull in interface CriteriaBuilder

Parameters:

x - expression

Returns:

is-not-null predicate

equal

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing the arguments for equality.

Specified by:

equal in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

equality predicate

equal

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing the arguments for equality.

Specified by:

equal in interface CriteriaBuilder

Parameters:

x - expression

y - object

Returns:

equality predicate

notEqual

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing the arguments for inequality.

Specified by:

notEqual in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

inequality predicate

notEqual

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing the arguments for inequality.

Specified by:

notEqual in interface CriteriaBuilder

Parameters:

x - expression

y - object

Returns:

inequality predicate

distinctFrom

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

distinctFrom

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

notDistinctFrom

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

notDistinctFrom

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

greaterThan

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than the second.

Specified by:

greaterThan in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

greater-than predicate

greaterThan

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than the second.

Specified by:

greaterThan in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

greater-than predicate

greaterThanOrEqualTo

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than or equal to the second.

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

greater-than-or-equal predicate

greaterThanOrEqualTo

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than or equal to the second.

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

greater-than-or-equal predicate

lessThan

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than the second.

Specified by:

lessThan in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

less-than predicate

lessThan

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than the second.

Specified by:

lessThan in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

less-than predicate

lessThanOrEqualTo

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than or equal to the second.

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

less-than-or-equal predicate

lessThanOrEqualTo

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than or equal to the second.

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

less-than-or-equal predicate

between

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is between the second and third arguments in value.

Specified by:

between in interface CriteriaBuilder

Parameters:

value - expression

lower - expression

upper - expression

Returns:

between predicate

between

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is between the second and third arguments in value.

Specified by:

between in interface CriteriaBuilder

Parameters:

value - expression

lower - value

upper - value

Returns:

between predicate

gt

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than the second.

Specified by:

gt in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

greater-than predicate

gt

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than the second.

Specified by:

gt in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

greater-than predicate

ge

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than or equal to the second.

Specified by:

ge in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

greater-than-or-equal predicate

ge

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is greater than or equal to the second.

Specified by:

ge in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

greater-than-or-equal predicate

lt

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than the second.

Specified by:

lt in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

less-than predicate

lt

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than the second.

Specified by:

lt in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

less-than predicate

le

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than or equal to the second.

Specified by:

le in interface CriteriaBuilder

Parameters:

x - expression

y - expression

Returns:

less-than-or-equal predicate

le

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the first argument is less than or equal to the second.

Specified by:

le in interface CriteriaBuilder

Parameters:

x - expression

y - value

Returns:

less-than-or-equal predicate

isEmpty

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

Description copied from interface: CriteriaBuilder

Create a predicate that tests whether a collection is empty.

Specified by:

isEmpty in interface CriteriaBuilder

Parameters:

collection - expression

Returns:

is-empty predicate

isNotEmpty

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

Description copied from interface: CriteriaBuilder

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

Specified by:

isNotEmpty in interface CriteriaBuilder

Parameters:

collection - expression

Returns:

is-not-empty predicate

isMember

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

Description copied from interface: CriteriaBuilder

Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false.

Specified by:

isMember in interface CriteriaBuilder

Parameters:

elem - element expression

collection - expression

Returns:

is-member predicate

isMember

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

Description copied from interface: CriteriaBuilder

Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false.

Specified by:

isMember in interface CriteriaBuilder

Parameters:

elem - element

collection - expression

Returns:

is-member predicate

isNotMember

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

Description copied from interface: CriteriaBuilder

Create a predicate that tests whether an element is not a member of a collection. If the collection is empty, the predicate will be true.

Specified by:

isNotMember in interface CriteriaBuilder

Parameters:

elem - element expression

collection - expression

Returns:

is-not-member predicate

isNotMember

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

Description copied from interface: CriteriaBuilder

Create a predicate that tests whether an element is not a member of a collection. If the collection is empty, the predicate will be true.

Specified by:

isNotMember in interface CriteriaBuilder

Parameters:

elem - element

collection - expression

Returns:

is-not-member predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

Returns:

like predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

Returns:

like predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

escapeChar - escape character expression

Returns:

like predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

escapeChar - escape character

Returns:

like predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

escapeChar - escape character expression

Returns:

like predicate

like

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression satisfies the given pattern.

Specified by:

like in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

escapeChar - escape character

Returns:

like predicate

ilike

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

ilike

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

ilike

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

ilike

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

ilike

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

ilike

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

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

Returns:

not-like predicate

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

Returns:

not-like predicate

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

escapeChar - escape character expression

Returns:

not-like predicate

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string expression

escapeChar - escape character

Returns:

not-like predicate

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

escapeChar - escape character expression

Returns:

not-like predicate

notLike

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

Description copied from interface: CriteriaBuilder

Create a predicate for testing whether the expression does not satisfy the given pattern.

Specified by:

notLike in interface CriteriaBuilder

Parameters:

x - string expression

pattern - string

escapeChar - escape character

Returns:

not-like predicate

notIlike

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

notIlike

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

notIlike

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

notIlike

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

notIlike

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

notIlike

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

in

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

Description copied from interface: CriteriaBuilder

Create predicate to test whether given expression is contained in a list of values.

Specified by:

in in interface CriteriaBuilder

Parameters:

expression - to be tested against list of values

Returns:

in predicate

in

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

in

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

in

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

exists

JpaPredicate exists(Subquery<?> subquery)

Description copied from interface: CriteriaBuilder

Create a predicate testing the existence of a subquery result.

Specified by:

exists in interface CriteriaBuilder

Parameters:

subquery - subquery whose result is to be tested

Returns:

exists predicate

isMapEmpty

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

Create a predicate that tests whether a Map is empty.

Parameters:

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

Returns:

is-empty predicate

isMapNotEmpty

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

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

Parameters:

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

Returns:

is-not-empty predicate

mapSize

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

Create an expression that tests the size of a map.

Parameters:

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

Returns:

size expression

mapSize

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

Create an expression that tests the size of a map.

Parameters:

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

Returns:

size expression

sort

JpaOrder sort(JpaExpression<?> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence,
 boolean ignoreCase)

sort

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

sort

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

sort

JpaOrder sort(JpaExpression<?> sortExpression)

asc

JpaOrder asc(Expression<?> x)

Description copied from interface: CriteriaBuilder

Create an ordering by the ascending value of the expression.

Specified by:

asc in interface CriteriaBuilder

Parameters:

x - expression used to define the ordering

Returns:

ascending ordering corresponding to the expression

desc

JpaOrder desc(Expression<?> x)

Description copied from interface: CriteriaBuilder

Create an ordering by the descending value of the expression.

Specified by:

desc in interface CriteriaBuilder

Parameters:

x - expression used to define the ordering

Returns:

descending ordering corresponding to the expression

asc

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

Create an ordering by the ascending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc

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

Create an ordering by the descending value of the expression.

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

search

@Incubating
JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

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

Parameters:

cteAttribute - CTE attribute used to define the ordering

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

ordering corresponding to the CTE attribute

search

@Incubating
JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute,
 SortDirection sortOrder)

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

Parameters:

cteAttribute - CTE attribute used to define the ordering

sortOrder - The sort order

Returns:

ordering corresponding to the CTE attribute

search

@Incubating
JpaSearchOrder search(JpaCteCriteriaAttribute cteAttribute)

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

Parameters:

cteAttribute - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

asc

@Incubating
JpaSearchOrder asc(JpaCteCriteriaAttribute x)

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

Parameters:

x - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

desc

@Incubating
JpaSearchOrder desc(JpaCteCriteriaAttribute x)

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

Parameters:

x - CTE attribute used to define the ordering

Returns:

descending ordering corresponding to the CTE attribute

asc

@Incubating
JpaSearchOrder asc(JpaCteCriteriaAttribute x,
 boolean nullsFirst)

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

Parameters:

x - CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the CTE attribute

desc

@Incubating
JpaSearchOrder desc(JpaCteCriteriaAttribute x,
 boolean nullsFirst)

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

Parameters:

x - CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the CTE attribute

sql

@Incubating
<T> JpaExpression<T> sql(String pattern,
 Class<T> type,
 Expression<?>... arguments)

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

Type Parameters:

T - type of this expression

Parameters:

pattern - native SQL pattern

type - type of this expression

arguments - optional arguments to the SQL pattern

Returns:

native SQL expression

format

@Incubating
JpaFunction<String> format(Expression<? extends TemporalAccessor> datetime,
 String pattern)

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

See Dialect.appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender, java.lang.String) for a full list of pattern elements.

Parameters:

datetime - the datetime expression to format

pattern - the pattern to use for formatting

Returns:

format expression

year

@Incubating
JpaFunction<Integer> year(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

@Incubating
JpaFunction<Integer> month(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

@Incubating
JpaFunction<Integer> day(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

@Incubating
JpaFunction<Integer> hour(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

@Incubating
JpaFunction<Integer> minute(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

@Incubating
JpaFunction<Float> second(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

@Incubating
<T extends TemporalAccessor> JpaFunction<T> truncate(Expression<T> datetime,
 TemporalUnit temporalUnit)

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

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

Parameters:

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

temporalUnit - the temporal unit for truncation

Returns:

the truncated value

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

See Also:

• overlay(Expression, Expression, Expression, Expression)

overlay

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

Parameters:

string - string expression to be manipulated

replacement - string expression to replace in original

start - start position

length - optional, number of characters to substitute

Returns:

overlay expression

pad

@Incubating
JpaFunction<String> pad(Expression<String> x,
 int length)

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

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

See Also:

• pad(Trimspec, Expression, Expression, Expression)

pad

@Incubating
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. Optionally pass a CriteriaBuilder.Trimspec to pad the string expression with LEADING or TRAILING (default) characters.

Parameters:

ts - optional CriteriaBuilder.Trimspec

x - string expression to pad

length - length of the result string after padding

padChar - optional pad character

Returns:

pad expression

repeat

JpaFunction<String> repeat(Expression<String> x,
 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:

repeat expression

repeat

JpaFunction<String> repeat(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:

repeat expression

repeat

JpaFunction<String> repeat(String x,
 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:

repeat expression

left

@Incubating
JpaFunction<String> left(Expression<String> x,
 int length)

See Also:

• left(Expression, Expression)

left

@Incubating
JpaFunction<String> left(Expression<String> x,
 Expression<Integer> length)

Extract the length leftmost characters of a string.

Parameters:

x - original string

length - number of characters

Returns:

left expression

right

@Incubating
JpaFunction<String> right(Expression<String> x,
 int length)

See Also:

• right(Expression, Expression)

right

@Incubating
JpaFunction<String> right(Expression<String> x,
 Expression<Integer> length)

Extract the length rightmost characters of a string.

Parameters:

x - original string

length - number of characters

Returns:

left expression

replace

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

See Also:

• replace(Expression, Expression, Expression)

replace

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

See Also:

• replace(Expression, Expression, Expression)

replace

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

See Also:

• replace(Expression, Expression, Expression)

replace

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

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

Parameters:

x - original string

pattern - the string to be replaced

replacement - the new replacement string

Returns:

replace expression

collate

@Incubating
JpaFunction<String> collate(Expression<String> x,
 String collation)

log10

@Incubating
JpaExpression<Double> log10(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

base-10 logarithm

log

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

See Also:

• log(Expression, Expression)

log

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

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

Parameters:

b - base

x - expression

Returns:

arbitrary-base logarithm

pi

@Incubating
JpaExpression<Double> pi()

Literal expression corresponding to the value of pi.

Returns:

pi expression

sin

@Incubating
JpaExpression<Double> sin(Expression<? extends Number> x)

Create an expression that returns the sine of its argument.

Parameters:

x - expression

Returns:

sine

cos

@Incubating
JpaExpression<Double> cos(Expression<? extends Number> x)

Create an expression that returns the cosine of its argument.

Parameters:

x - expression

Returns:

cosine

tan

@Incubating
JpaExpression<Double> tan(Expression<? extends Number> x)

Create an expression that returns the tangent of its argument.

Parameters:

x - expression

Returns:

tangent

asin

@Incubating
JpaExpression<Double> asin(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

inverse sine

acos

@Incubating
JpaExpression<Double> acos(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

inverse cosine

atan

@Incubating
JpaExpression<Double> atan(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

inverse tangent

atan2

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

See Also:

• atan2(Expression, Expression)

atan2

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

See Also:

• atan2(Expression, Expression)

atan2

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

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

Parameters:

y - y coordinate

x - x coordinate

Returns:

2-argument inverse tangent

sinh

@Incubating
JpaExpression<Double> sinh(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

hyperbolic sine

cosh

@Incubating
JpaExpression<Double> cosh(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

hyperbolic cosine

tanh

@Incubating
JpaExpression<Double> tanh(Expression<? extends Number> x)

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

Parameters:

x - expression

Returns:

hyperbolic tangent

degrees

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

Parameters:

x - expression

Returns:

degrees

radians

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

Parameters:

x - expression

Returns:

radians

createWindow

@Incubating
JpaWindow createWindow()

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

Returns:

the empty window

frameUnboundedPreceding

@Incubating
JpaWindowFrame frameUnboundedPreceding()

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

Returns:

the window frame

frameBetweenPreceding

@Incubating
JpaWindowFrame frameBetweenPreceding(int offset)

See Also:

• frameBetweenPreceding(Expression)

frameBetweenPreceding

@Incubating
JpaWindowFrame frameBetweenPreceding(Expression<?> offset)

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

Parameters:

offset - the offset expression

Returns:

the window frame

frameCurrentRow

@Incubating
JpaWindowFrame frameCurrentRow()

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

Returns:

the window frame

frameBetweenFollowing

@Incubating
JpaWindowFrame frameBetweenFollowing(int offset)

See Also:

• frameBetweenFollowing(Expression)

frameBetweenFollowing

@Incubating
JpaWindowFrame frameBetweenFollowing(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

@Incubating
JpaWindowFrame frameUnboundedFollowing()

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

Returns:

the window frame

windowFunction

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

Type Parameters:

T - type of this expression

Parameters:

name - name of the window function

type - type of this expression

window - window over which the function will be applied

args - arguments to the function

Returns:

window function expression

rowNumber

@Incubating
JpaExpression<Long> rowNumber(JpaWindow window)

Create a row_number window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

firstValue

@Incubating
<T> JpaExpression<T> firstValue(Expression<T> argument,
 JpaWindow window)

Create a first_value window function expression.

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to first_value

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

lastValue

@Incubating
<T> JpaExpression<T> lastValue(Expression<T> argument,
 JpaWindow window)

Create a last_value window function expression.

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to last_value

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

nthValue

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

See Also:

• nthValue

nthValue

@Incubating
<T> JpaExpression<T> nthValue(Expression<T> argument,
 Expression<Integer> n,
 JpaWindow window)

Create a nth_value window function expression.

Type Parameters:

T - type of the expression

Parameters:

argument - argument expression to pass to nth_value

n - the N argument for the function

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

rank

@Incubating
JpaExpression<Long> rank(JpaWindow window)

Create a rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

denseRank

@Incubating
JpaExpression<Long> denseRank(JpaWindow window)

Create a dense_rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

percentRank

@Incubating
JpaExpression<Double> percentRank(JpaWindow window)

Create a percent_rank window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

cumeDist

@Incubating
JpaExpression<Double> cumeDist(JpaWindow window)

Create a cume_dist window function expression.

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

functionAggregate

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

See Also:

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

functionAggregate

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

See Also:

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

functionAggregate

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

Create a generic aggregate function expression.

Type Parameters:

T - type of this expression

Parameters:

name - name of the ordered set-aggregate function

type - type of this expression

filter - optional filter clause

window - optional window over which to apply the function

args - optional arguments to the function

Returns:

aggregate function expression

sum

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

See Also:

• sum(Expression, JpaPredicate, JpaWindow)

sum

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

See Also:

• sum(Expression, JpaPredicate, JpaWindow)

sum

@Incubating
<N extends Number> JpaExpression<Number> sum(Expression<N> argument,
 JpaPredicate filter,
 JpaWindow window)

Create a sum aggregate function expression.

Type Parameters:

N - type of the input expression

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

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

avg

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

See Also:

• avg(Expression, JpaPredicate, JpaWindow)

avg

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

See Also:

• avg(Expression, JpaPredicate, JpaWindow)

avg

@Incubating
<N extends Number> JpaExpression<Double> avg(Expression<N> argument,
 JpaPredicate filter,
 JpaWindow window)

Create an avg aggregate function expression.

Type Parameters:

N - type of the input expression

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

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

count

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

See Also:

• count(Expression, JpaPredicate, JpaWindow)

count

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

See Also:

• count(Expression, JpaPredicate, JpaWindow)

count

@Incubating
JpaExpression<Long> count(Expression<?> argument,
 JpaPredicate filter,
 JpaWindow window)

Create a count aggregate function expression.

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

Returns:

aggregate function expression

See Also:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

See Also:

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

functionWithinGroup

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

Type Parameters:

T - type of this expression

Parameters:

name - name of the ordered set-aggregate function

type - type of this expression

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

args - optional arguments to the function

Returns:

ordered set-aggregate function expression

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

See Also:

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

listagg

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

Create a listagg ordered set-aggregate function expression.

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

argument - values to join

separator - the separator used to join the values

Returns:

ordered set-aggregate expression

See Also:

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

mode

@Incubating
<T> JpaExpression<T> mode(Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

mode

@Incubating
<T> JpaExpression<T> mode(JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

mode

@Incubating
<T> JpaExpression<T> mode(JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

mode

@Incubating
<T> JpaExpression<T> mode(JpaPredicate filter,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Create a mode ordered set-aggregate function expression.

Type Parameters:

T - type of this expression

Parameters:

filter - optional filter clause

window - optional window over which to apply the function

sortExpression - the sort expression

sortOrder - the sort order

nullPrecedence - the null precedence

Returns:

ordered set-aggregate expression

See Also:

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

percentileCont

@Incubating
<T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileCont

@Incubating
<T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
 JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileCont

@Incubating
<T> JpaExpression<T> percentileCont(Expression<? extends Number> argument,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileCont

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

Create a percentile_cont ordered set-aggregate function expression.

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

sortExpression - the sort expression

sortOrder - the sort order

nullPrecedence - the null precedence

Returns:

ordered set-aggregate expression

See Also:

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

percentileDisc

@Incubating
<T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileDisc

@Incubating
<T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
 JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileDisc

@Incubating
<T> JpaExpression<T> percentileDisc(Expression<? extends Number> argument,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

See Also:

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

percentileDisc

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

Create a percentile_disc ordered set-aggregate function expression.

Parameters:

argument - argument to the function

filter - optional filter clause

window - optional window over which to apply the function

sortExpression - the sort expression

sortOrder - the sort order

nullPrecedence - the null precedence

Returns:

ordered set-aggregate expression

See Also:

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

rank

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

See Also:

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

rank

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

See Also:

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

rank

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

See Also:

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

rank

@Incubating
JpaExpression<Long> rank(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... arguments)

Create a rank ordered set-aggregate function expression.

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

arguments - arguments to the function

Returns:

ordered set-aggregate expression

See Also:

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

percentRank

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

See Also:

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

percentRank

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

See Also:

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

percentRank

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

See Also:

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

percentRank

@Incubating
JpaExpression<Double> percentRank(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... arguments)

Create a percent_rank ordered set-aggregate function expression.

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

arguments - arguments to the function

Returns:

ordered set-aggregate expression

See Also:

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

arrayAgg

@Incubating
<T> JpaExpression<T[]> arrayAgg(JpaOrder order,
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Incubating
<T> JpaExpression<T[]> arrayAgg(JpaOrder order,
 JpaPredicate filter,
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Incubating
<T> JpaExpression<T[]> arrayAgg(JpaOrder order,
 JpaWindow window,
 Expression<? extends T> argument)

Since:

6.4

See Also:

• arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

@Incubating
<T> JpaExpression<T[]> arrayAgg(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<? extends T> argument)

Create a array_agg ordered set-aggregate function expression.

Parameters:

order - order by clause used in within group

filter - optional filter clause

window - optional window over which to apply the function

argument - values to aggregate

Returns:

ordered set-aggregate expression

Since:

6.4

See Also:

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

arrayLiteral

@Incubating
<T> JpaExpression<T[]> arrayLiteral(T... elements)

Creates an array literal with the array constructor function.

Since:

6.4

arrayLength

@Incubating
<T> JpaExpression<Integer> arrayLength(Expression<T[]> arrayExpression)

Determines the length of an array.

Since:

6.4

arrayPosition

@Incubating
<T> JpaExpression<Integer> arrayPosition(Expression<T[]> arrayExpression,
 T element)

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

Since:

6.4

arrayPosition

@Incubating
<T> JpaExpression<Integer> arrayPosition(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

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

Since:

6.4

arrayPositions

@Incubating
<T> JpaExpression<int[]> arrayPositions(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

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

Since:

6.4

arrayPositions

@Incubating
<T> JpaExpression<int[]> arrayPositions(Expression<T[]> arrayExpression,
 T element)

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

Since:

6.4

arrayPositionsList

@Incubating
<T> JpaExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

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

Since:

6.4

arrayPositionsList

@Incubating
<T> JpaExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression,
 T element)

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

Since:

6.4

arrayConcat

@Incubating
<T> JpaExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Concatenates arrays with each other in order.

Since:

6.4

arrayConcat

@Incubating
<T> JpaExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1,
 T[] array2)

Concatenates arrays with each other in order.

Since:

6.4

arrayConcat

@Incubating
<T> JpaExpression<T[]> arrayConcat(T[] array1,
 Expression<T[]> arrayExpression2)

Concatenates arrays with each other in order.

Since:

6.4

arrayAppend

@Incubating
<T> JpaExpression<T[]> arrayAppend(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Appends element to array.

Since:

6.4

arrayAppend

@Incubating
<T> JpaExpression<T[]> arrayAppend(Expression<T[]> arrayExpression,
 T element)

Appends element to array.

Since:

6.4

arrayPrepend

@Incubating
<T> JpaExpression<T[]> arrayPrepend(Expression<T> elementExpression,
 Expression<T[]> arrayExpression)

Prepends element to array.

Since:

6.4

arrayPrepend

@Incubating
<T> JpaExpression<T[]> arrayPrepend(T element,
 Expression<T[]> arrayExpression)

Prepends element to array.

Since:

6.4

arrayGet

@Incubating
<T> JpaExpression<T> arrayGet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression)

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

Since:

6.4

arrayGet

@Incubating
<T> JpaExpression<T> arrayGet(Expression<T[]> arrayExpression,
 Integer index)

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

Since:

6.4

arraySet

@Incubating
<T> JpaExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression,
 Expression<T> elementExpression)

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

Since:

6.4

arraySet

@Incubating
<T> JpaExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression,
 T element)

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

Since:

6.4

arraySet

@Incubating
<T> JpaExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Integer index,
 Expression<T> elementExpression)

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

Since:

6.4

arraySet

@Incubating
<T> JpaExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Integer index,
 T element)

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

Since:

6.4

arrayRemove

@Incubating
<T> JpaExpression<T[]> arrayRemove(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Creates array copy with given element removed.

Since:

6.4

arrayRemove

@Incubating
<T> JpaExpression<T[]> arrayRemove(Expression<T[]> arrayExpression,
 T element)

Creates array copy with given element removed.

Since:

6.4

arrayRemoveIndex

@Incubating
<T> JpaExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression)

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

Since:

6.4

arrayRemoveIndex

@Incubating
<T> JpaExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression,
 Integer index)

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

Since:

6.4

arraySlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

arraySlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

arraySlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

arraySlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

arrayReplace

@Incubating
<T> JpaExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 Expression<T> oldElementExpression,
 Expression<T> newElementExpression)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Incubating
<T> JpaExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 Expression<T> oldElementExpression,
 T newElement)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Incubating
<T> JpaExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 T oldElement,
 Expression<T> newElementExpression)

Creates array copy replacing a given element with another.

Since:

6.4

arrayReplace

@Incubating
<T> JpaExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 T oldElement,
 T newElement)

Creates array copy replacing a given element with another.

Since:

6.4

arrayTrim

@Incubating
<T> JpaExpression<T[]> arrayTrim(Expression<T[]> arrayExpression,
 Expression<Integer> elementCountExpression)

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

Since:

6.4

arrayTrim

@Incubating
<T> JpaExpression<T[]> arrayTrim(Expression<T[]> arrayExpression,
 Integer elementCount)

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

Since:

6.4

arrayFill

@Incubating
<T> JpaExpression<T[]> arrayFill(Expression<T> elementExpression,
 Expression<Integer> elementCountExpression)

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

Since:

6.4

arrayFill

@Incubating
<T> JpaExpression<T[]> arrayFill(Expression<T> elementExpression,
 Integer elementCount)

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

Since:

6.4

arrayFill

@Incubating
<T> JpaExpression<T[]> arrayFill(T element,
 Expression<Integer> elementCountExpression)

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

Since:

6.4

arrayFill

@Incubating
<T> JpaExpression<T[]> arrayFill(T element,
 Integer elementCount)

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

Since:

6.4

arrayToString

@Incubating
JpaExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression,
 Expression<String> separatorExpression)

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

Since:

6.4

arrayToString

@Incubating
JpaExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression,
 String separator)

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

Since:

6.4

arrayContains

@Incubating
<T> JpaPredicate arrayContains(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Whether an array contains an element.

Since:

6.4

arrayContains

@Incubating
<T> JpaPredicate arrayContains(Expression<T[]> arrayExpression,
 T element)

Whether an array contains an element.

Since:

6.4

arrayContains

@Incubating
<T> JpaPredicate arrayContains(T[] array,
 Expression<T> elementExpression)

Whether an array contains an element.

Since:

6.4

arrayContainsNullable

@Incubating
<T> JpaPredicate arrayContainsNullable(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Whether an array contains a nullable element.

Since:

6.4

arrayContainsNullable

@Incubating
<T> JpaPredicate arrayContainsNullable(Expression<T[]> arrayExpression,
 T element)

Whether an array contains a nullable element.

Since:

6.4

arrayContainsNullable

@Incubating
<T> JpaPredicate arrayContainsNullable(T[] array,
 Expression<T> elementExpression)

Whether an array contains a nullable element.

Since:

6.4

arrayContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAll(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with arrayIncludes(Expression, Expression)

Whether an array is a subset of another array.

Since:

6.4

arrayContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAll(Expression<T[]> arrayExpression,
 T[] subArray)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIncludes(Expression, T[])

Whether an array is a subset of another array.

Since:

6.4

arrayContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAll(T[] array,
 Expression<T[]> subArrayExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIncludes(T[], Expression)

Whether an array is a subset of another array.

Since:

6.4

arrayContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAllNullable(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with arrayIncludesNullable(Expression, Expression)

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

Since:

6.4

arrayContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAllNullable(Expression<T[]> arrayExpression,
 T[] subArray)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIncludesNullable(Expression, T[])

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

Since:

6.4

arrayContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayContainsAllNullable(T[] array,
 Expression<T[]> subArrayExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIncludesNullable(T[], Expression)

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

Since:

6.4

arrayIncludes

@Incubating
<T> JpaPredicate arrayIncludes(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludes

@Incubating
<T> JpaPredicate arrayIncludes(Expression<T[]> arrayExpression,
 T[] subArray)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludes

@Incubating
<T> JpaPredicate arrayIncludes(T[] array,
 Expression<T[]> subArrayExpression)

Whether an array is a subset of another array.

Since:

6.6

arrayIncludesNullable

@Incubating
<T> JpaPredicate arrayIncludesNullable(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

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

Since:

6.6

arrayIncludesNullable

@Incubating
<T> JpaPredicate arrayIncludesNullable(Expression<T[]> arrayExpression,
 T[] subArray)

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

Since:

6.6

arrayIncludesNullable

@Incubating
<T> JpaPredicate arrayIncludesNullable(T[] array,
 Expression<T[]> subArrayExpression)

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

Since:

6.6

arrayOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlaps(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with arrayIntersects(Expression, Expression)

Whether one array has any elements common with another array.

Since:

6.4

arrayOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlaps(Expression<T[]> arrayExpression1,
 T[] array2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIntersects(Expression, T[])

Whether one array has any elements common with another array.

Since:

6.4

arrayOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlaps(T[] array1,
 Expression<T[]> arrayExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIntersects(T[], Expression)

Whether one array has any elements common with another array.

Since:

6.4

arrayOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlapsNullable(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with arrayIntersectsNullable(Expression, Expression)

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

Since:

6.4

arrayOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlapsNullable(Expression<T[]> arrayExpression1,
 T[] array2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIntersectsNullable(Expression, T[])

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

Since:

6.4

arrayOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <T> JpaPredicate arrayOverlapsNullable(T[] array1,
 Expression<T[]> arrayExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with #arrayIntersectsNullable(T[], Expression)

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

Since:

6.4

arrayIntersects

@Incubating
<T> JpaPredicate arrayIntersects(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersects

@Incubating
<T> JpaPredicate arrayIntersects(Expression<T[]> arrayExpression1,
 T[] array2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersects

@Incubating
<T> JpaPredicate arrayIntersects(T[] array1,
 Expression<T[]> arrayExpression2)

Whether one array has any elements common with another array.

Since:

6.6

arrayIntersectsNullable

@Incubating
<T> JpaPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

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

Since:

6.6

arrayIntersectsNullable

@Incubating
<T> JpaPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1,
 T[] array2)

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

Since:

6.6

arrayIntersectsNullable

@Incubating
<T> JpaPredicate arrayIntersectsNullable(T[] array1,
 Expression<T[]> arrayExpression2)

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

Since:

6.6

collectionLiteral

@Incubating
<E,
C extends Collection<E>> JpaExpression<C> collectionLiteral(E... elements)

Creates a basic collection literal with the array constructor function.

Since:

6.4

collectionLength

@Incubating
JpaExpression<Integer> collectionLength(Expression<? extends Collection<?>> collectionExpression)

Determines the length of a basic collection.

Since:

6.4

collectionPosition

@Incubating
<E> JpaExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression,
 E element)

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

Since:

6.4

collectionPosition

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

Since:

6.4

collectionPositions

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

Since:

6.4

collectionPositions

@Incubating
<T> JpaExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression,
 T element)

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

Since:

6.4

collectionPositionsList

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

Since:

6.4

collectionPositionsList

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

Since:

6.4

collectionConcat

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

Since:

6.4

collectionConcat

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionConcat(Expression<C> collectionExpression1,
 Collection<? extends E> collection2)

Concatenates basic collections with each other in order.

Since:

6.4

collectionConcat

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

Since:

6.4

collectionAppend

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionAppend(Expression<C> collectionExpression,
 Expression<? extends E> elementExpression)

Appends element to basic collection.

Since:

6.4

collectionAppend

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionAppend(Expression<C> collectionExpression,
 E element)

Appends element to basic collection.

Since:

6.4

collectionPrepend

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionPrepend(Expression<? extends E> elementExpression,
 Expression<C> collectionExpression)

Prepends element to basic collection.

Since:

6.4

collectionPrepend

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionPrepend(E element,
 Expression<C> collectionExpression)

Prepends element to basic collection.

Since:

6.4

collectionGet

@Incubating
<E> JpaExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression,
 Expression<Integer> indexExpression)

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

Since:

6.4

collectionGet

@Incubating
<E> JpaExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression,
 Integer index)

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

Since:

6.4

collectionSet

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

Since:

6.4

collectionSet

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

Since:

6.4

collectionSet

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

Since:

6.4

collectionSet

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

Since:

6.4

collectionRemove

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionRemove(Expression<C> collectionExpression,
 Expression<? extends E> elementExpression)

Creates basic collection copy with given element removed.

Since:

6.4

collectionRemove

@Incubating
<E,
C extends Collection<? super E>>
JpaExpression<C> collectionRemove(Expression<C> collectionExpression,
 E element)

Creates basic collection copy with given element removed.

Since:

6.4

collectionRemoveIndex

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

Since:

6.4

collectionRemoveIndex

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

Since:

6.4

collectionSlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

collectionSlice

@Incubating
<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. Both indexes are inclusive.

Since:

6.4

collectionReplace

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

Since:

6.4

collectionReplace

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

Since:

6.4

collectionReplace

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

Since:

6.4

collectionReplace

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

Since:

6.4

collectionTrim

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

Since:

6.4

collectionTrim

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

Since:

6.4

collectionFill

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

Since:

6.4

collectionFill

@Incubating
<T> JpaExpression<Collection<T>> collectionFill(Expression<T> elementExpression,
 Integer elementCount)

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

Since:

6.4

collectionFill

@Incubating
<T> JpaExpression<Collection<T>> collectionFill(T element,
 Expression<Integer> elementCountExpression)

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

Since:

6.4

collectionFill

@Incubating
<T> JpaExpression<Collection<T>> collectionFill(T element,
 Integer elementCount)

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

Since:

6.4

collectionToString

@Incubating
<T> 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.

Since:

6.4

collectionToString

@Incubating
<T> JpaExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression,
 String separator)

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

Since:

6.4

collectionContains

@Incubating
<E> JpaPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends E> elementExpression)

Whether a basic collection contains an element.

Since:

6.4

collectionContains

@Incubating
<E> JpaPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression,
 E element)

Whether a basic collection contains an element.

Since:

6.4

collectionContains

@Incubating
<E> JpaPredicate collectionContains(Collection<E> collection,
 Expression<E> elementExpression)

Whether a basic collection contains an element.

Since:

6.4

collectionContainsNullable

@Incubating
<E> JpaPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends E> elementExpression)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionContainsNullable

@Incubating
<E> JpaPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression,
 E element)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionContainsNullable

@Incubating
<E> JpaPredicate collectionContainsNullable(Collection<E> collection,
 Expression<E> elementExpression)

Whether a basic collection contains a nullable element.

Since:

6.4

collectionContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAll(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludes(Expression, Expression)

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

Since:

6.4

collectionContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAll(Expression<? extends Collection<E>> collectionExpression,
 Collection<? extends E> subCollection)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludes(Expression, Collection)

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

Since:

6.4

collectionContainsAll

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAll(Collection<E> collection,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludes(Collection, Expression)

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

Since:

6.4

collectionContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludesNullable(Expression, Expression)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression,
 Collection<? extends E> subCollection)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludesNullable(Expression, Collection)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionContainsAllNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionContainsAllNullable(Collection<E> collection,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIncludesNullable(Collection, Expression)

Whether a basic collection is a subset of another basic collection with nullable elements.

Since:

6.4

collectionIncludes

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

Since:

6.4

collectionIncludes

@Incubating
<E> JpaPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression,
 Collection<? extends E> subCollection)

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

Since:

6.4

collectionIncludes

@Incubating
<E> JpaPredicate collectionIncludes(Collection<E> collection,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

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

Since:

6.4

collectionIncludesNullable

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

Since:

6.4

collectionIncludesNullable

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

Since:

6.4

collectionIncludesNullable

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

Since:

6.4

collectionOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersects(Expression, Expression)

Whether one basic collection has any elements common with another basic collection.

Since:

6.4

collectionOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1,
 Collection<? extends E> collection2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersects(Expression, Collection)

Whether one basic collection has any elements common with another basic collection.

Since:

6.4

collectionOverlaps

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlaps(Collection<E> collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersects(Collection, Expression)

Whether one basic collection has any elements common with another basic collection.

Since:

6.4

collectionOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersectsNullable(Expression, Expression)

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

Since:

6.4

collectionOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1,
 Collection<? extends E> collection2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersectsNullable(Expression, Collection)

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

Since:

6.4

collectionOverlapsNullable

@Incubating
@Deprecated(forRemoval=true)
default <E> JpaPredicate collectionOverlapsNullable(Collection<E> collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Deprecated, for removal: This API element is subject to removal in a future version.

Replaced with collectionIntersectsNullable(Collection, Expression)

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

Since:

6.4

collectionIntersects

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

Since:

6.6

collectionIntersects

@Incubating
<E> JpaPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1,
 Collection<? extends E> collection2)

Whether one basic collection has any elements common with another basic collection.

Since:

6.6

collectionIntersects

@Incubating
<E> JpaPredicate collectionIntersects(Collection<E> collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Whether one basic collection has any elements common with another basic collection.

Since:

6.6

collectionIntersectsNullable

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

Since:

6.6

collectionIntersectsNullable

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

Since:

6.6

collectionIntersectsNullable

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

Since:

6.6