Package org.hibernate.query.sqm.internal

Class SqmCriteriaNodeBuilder

java.lang.Object

org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder

All Implemented Interfaces:

CriteriaBuilder, Serializable, BindingContext, HibernateCriteriaBuilder, NodeBuilder

public class SqmCriteriaNodeBuilder
extends Object
implements NodeBuilder, Serializable

Acts as a JPA CriteriaBuilder by using SQM nodes as the JPA Criteria nodes

See Also:

• Serialized Form

Nested Class Summary

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

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

Constructor Summary

Constructors

Constructor	Description
SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, QueryEngineOptions options, BindingContext bindingContext)

Method Summary

Modifier and Type	Method	Description
<N extends Number> SqmExpression<N>	abs(Expression<N> x)
SqmFunction<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> SqmModifiedSubQueryExpression<Y>	all(Subquery<Y> subquery)
SqmPredicate	and(Expression<Boolean> x, Expression<Boolean> y)
SqmPredicate	and(Predicate... restrictions)
SqmPredicate	and(List<Predicate> restrictions)
<Y> SqmModifiedSubQueryExpression<Y>	any(Subquery<Y> subquery)
JpaCompoundSelection<Object[]>	array(Selection<?>[] selections)
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, Selection<?>[] selections)
<Y> JpaCompoundSelection<Y>	array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
JpaCompoundSelection<Object[]>	array(List<Selection<?>> selections)
<T> SqmExpression<T[]>	arrayAgg(JpaOrder order, Expression<? extends T> argument)
<T> SqmExpression<T[]>	arrayAgg(JpaOrder order, JpaPredicate filter, Expression<? extends T> argument)
<T> SqmExpression<T[]>	arrayAgg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument)	Create a array_agg ordered set-aggregate function expression.
<T> SqmExpression<T[]>	arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)
<T> SqmExpression<T[]>	arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Appends element to array.
<T> SqmExpression<T[]>	arrayAppend(Expression<T[]> arrayExpression, T element)	Appends element to array.
<T> SqmExpression<T[]>	arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Concatenates arrays with each other in order.
<T> SqmExpression<T[]>	arrayConcat(Expression<T[]> arrayExpression1, T[] array2)	Concatenates arrays with each other in order.
<T> SqmExpression<T[]>	arrayConcat(T[] array1, Expression<T[]> arrayExpression2)	Concatenates arrays with each other in order.
<T> SqmPredicate	arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Whether an array contains an element.
<T> SqmPredicate	arrayContains(Expression<T[]> arrayExpression, T element)	Whether an array contains an element.
<T> SqmPredicate	arrayContains(T[] array, Expression<T> elementExpression)	Whether an array contains an element.
<T> SqmPredicate	arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Whether an array contains a nullable element.
<T> SqmPredicate	arrayContainsNullable(Expression<T[]> arrayExpression, T element)	Whether an array contains a nullable element.
<T> SqmPredicate	arrayContainsNullable(T[] array, Expression<T> elementExpression)	Whether an array contains a nullable element.
<T> SqmExpression<T[]>	arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)	Creates array with the same element N times, as specified by the arguments.
<T> SqmExpression<T[]>	arrayFill(Expression<T> elementExpression, Integer elementCount)	Creates array with the same element N times, as specified by the arguments.
<T> SqmExpression<T[]>	arrayFill(T element, Expression<Integer> elementCountExpression)	Creates array with the same element N times, as specified by the arguments.
<T> SqmExpression<T[]>	arrayFill(T element, Integer elementCount)	Creates array with the same element N times, as specified by the arguments.
<T> SqmExpression<T>	arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)	Accesses the element of an array by 1-based index.
<T> SqmExpression<T>	arrayGet(Expression<T[]> arrayExpression, Integer index)	Accesses the element of an array by 1-based index.
<T> SqmPredicate	arrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array.
<T> SqmPredicate	arrayIncludes(Expression<T[]> arrayExpression, T[] subArray)	Whether an array is a subset of another array.
<T> SqmPredicate	arrayIncludes(T[] array, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array.
<T> SqmPredicate	arrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array with nullable elements.
<T> SqmPredicate	arrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)	Whether an array is a subset of another array with nullable elements.
<T> SqmPredicate	arrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)	Whether an array is a subset of another array with nullable elements.
<T> SqmPredicate	arrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array.
<T> SqmPredicate	arrayIntersects(Expression<T[]> arrayExpression1, T[] array2)	Whether one array has any elements common with another array.
<T> SqmPredicate	arrayIntersects(T[] array1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array.
<T> SqmPredicate	arrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array, supporting null elements.
<T> SqmPredicate	arrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)	Whether one array has any elements common with another array, supporting null elements.
<T> SqmPredicate	arrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)	Whether one array has any elements common with another array, supporting null elements.
<T> SqmExpression<Integer>	arrayLength(Expression<T[]> arrayExpression)	Determines the length of an array.
<T> SqmExpression<T[]>	arrayLiteral(T... elements)	Creates an array literal with the array constructor function.
<T> SqmExpression<Integer>	arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines the 1-based position of an element in an array.
<T> SqmExpression<Integer>	arrayPosition(Expression<T[]> arrayExpression, T element)	Determines the 1-based position of an element in an array.
<T> SqmExpression<int[]>	arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in an array.
<T> SqmExpression<int[]>	arrayPositions(Expression<T[]> arrayExpression, T element)	Determines all 1-based positions of an element in an array.
<T> SqmExpression<List<Integer>>	arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in an array.
<T> SqmExpression<List<Integer>>	arrayPositionsList(Expression<T[]> arrayExpression, T element)	Determines all 1-based positions of an element in an array.
<T> SqmExpression<T[]>	arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)	Prepends element to array.
<T> SqmExpression<T[]>	arrayPrepend(T element, Expression<T[]> arrayExpression)	Prepends element to array.
<T> SqmExpression<T[]>	arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)	Creates array copy with given element removed.
<T> SqmExpression<T[]>	arrayRemove(Expression<T[]> arrayExpression, T element)	Creates array copy with given element removed.
<T> SqmExpression<T[]>	arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)	Creates array copy with the element at the given 1-based index removed.
<T> SqmExpression<T[]>	arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)	Creates array copy with the element at the given 1-based index removed.
<T> SqmExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)	Creates array copy replacing a given element with another.
<T> SqmExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)	Creates array copy replacing a given element with another.
<T> SqmExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)	Creates array copy replacing a given element with another.
<T> SqmExpression<T[]>	arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)	Creates array copy replacing a given element with another.
<T> SqmExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)	Creates array copy with given element at given 1-based index.
<T> SqmExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)	Creates array copy with given element at given 1-based index.
<T> SqmExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)	Creates array copy with given element at given 1-based index.
<T> SqmExpression<T[]>	arraySet(Expression<T[]> arrayExpression, Integer index, T element)	Creates array copy with given element at given 1-based index.
<T> SqmExpression<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> SqmExpression<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> SqmExpression<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> SqmExpression<T[]>	arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)	Creates a sub-array of the based on 1-based lower and upper index.
SqmExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)	Concatenates the non-null array elements with a separator, as specified by the arguments.
SqmExpression<String>	arrayToString(Expression<? extends Object[]> arrayExpression, String separator)	Concatenates the non-null array elements with a separator, as specified by the arguments.
<T> SqmExpression<T[]>	arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)	Creates array copy without the last N elements, specified by the second argument.
<T> SqmExpression<T[]>	arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)	Creates array copy without the last N elements, specified by the second argument.
SqmSortSpecification	asc(Expression<?> x)
JpaOrder	asc(Expression<?> x, boolean nullsFirst)	Create an ordering by the ascending value of the expression.
Order	asc(Expression<?> expression, Nulls nullPrecedence)
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.
SqmFunction<Double>	asin(Expression<? extends Number> x)	Create an expression that returns the inverse sine of its argument.
SqmFunction<Double>	atan(Expression<? extends Number> x)	Create an expression that returns the inverse tangent of its argument.
SqmFunction<Double>	atan2(Expression<? extends Number> y, Expression<? extends Number> x)	Create an expression that returns the inverse tangent of y over x.
SqmFunction<Double>	atan2(Expression<? extends Number> y, Number x)
SqmFunction<Double>	atan2(Number y, Expression<? extends Number> x)
<N extends Number> SqmExpression<Double>	avg(Expression<N> argument)
<N extends Number> SqmExpression<Double>	avg(Expression<N> argument, JpaPredicate filter)
<N extends Number> SqmExpression<Double>	avg(Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create an avg aggregate function expression.
<N extends Number> SqmExpression<Double>	avg(Expression<N> argument, JpaWindow window)
<Y extends Comparable<? super Y>> SqmPredicate	between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)
<Y extends Comparable<? super Y>> SqmPredicate	between(Expression<? extends Y> value, Y lower, Y upper)
<X, T> SqmExpression<X>	cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
<X, T> SqmExpression<X>	cast(JpaExpression<T> expression, JpaCastTarget<X> castTarget)
<X> SqmCastTarget<X>	castTarget(Class<X> castTargetJavaType)
<X> SqmCastTarget<X>	castTarget(Class<X> castTargetJavaType, int precision, int scale)
<X> SqmCastTarget<X>	castTarget(Class<X> castTargetJavaType, long length)
<N extends Number> JpaExpression<N>	ceiling(Expression<N> x)	Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
<T> SqmCoalesce<T>	coalesce()
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Expression<? extends Y> y)
<Y> JpaCoalesce<Y>	coalesce(Expression<? extends Y> x, Y y)
SqmFunction<String>	collate(Expression<String> x, String collation)
<E, C extends Collection<? super E>> SqmExpression<C>	collectionAppend(Expression<C> collectionExpression, E element)	Appends element to basic collection.
<E, C extends Collection<? super E>> SqmExpression<C>	collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)	Appends element to basic collection.
<E, C extends Collection<? super E>> SqmExpression<C>	collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Concatenates basic collections with each other in order.
<E, C extends Collection<? super E>> SqmExpression<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>> SqmExpression<C>	collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)	Concatenates basic collections with each other in order.
<E> SqmPredicate	collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)	Whether a basic collection contains an element.
<E> SqmPredicate	collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)	Whether a basic collection contains an element.
<E> SqmPredicate	collectionContains(Collection<E> collection, Expression<E> elementExpression)	Whether a basic collection contains an element.
<E> SqmPredicate	collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)	Whether a basic collection contains a nullable element.
<E> SqmPredicate	collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)	Whether a basic collection contains a nullable element.
<E> SqmPredicate	collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)	Whether a basic collection contains a nullable element.
<T> SqmExpression<Collection<T>>	collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)	Creates basic collection with the same element N times, as specified by the arguments.
<T> SqmExpression<Collection<T>>	collectionFill(Expression<T> elementExpression, Integer elementCount)	Creates basic collection with the same element N times, as specified by the arguments.
<T> SqmExpression<Collection<T>>	collectionFill(T element, Expression<Integer> elementCountExpression)	Creates basic collection with the same element N times, as specified by the arguments.
<T> SqmExpression<Collection<T>>	collectionFill(T element, Integer elementCount)	Creates basic collection with the same element N times, as specified by the arguments.
<E> SqmExpression<E>	collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)	Accesses the element of the basic collection by 1-based index.
<E> SqmExpression<E>	collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)	Accesses the element of the basic collection by 1-based index.
<E> SqmPredicate	collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection.
<E> SqmPredicate	collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)	Whether a basic collection is a subset of another basic collection.
<E> SqmPredicate	collectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)	Whether a basic collection is a subset of another basic collection.
<E> SqmPredicate	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> SqmPredicate	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> SqmPredicate	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> SqmPredicate	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> SqmPredicate	collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)	Whether one basic collection has any elements common with another basic collection.
<E> SqmPredicate	collectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)	Whether one basic collection has any elements common with another basic collection.
<E> SqmPredicate	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> SqmPredicate	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> SqmPredicate	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.
SqmExpression<Integer>	collectionLength(Expression<? extends Collection<?>> collectionExpression)	Determines the length of a basic collection.
<E, C extends Collection<E>> SqmExpression<C>	collectionLiteral(E... elements)	Creates a basic collection literal with the array constructor function.
<E> SqmExpression<Integer>	collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)	Determines the 1-based position of an element in a basic collection.
<E> SqmExpression<Integer>	collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)	Determines the 1-based position of an element in a basic collection.
<T> SqmExpression<int[]>	collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)	Determines all 1-based positions of an element in a basic collection.
<T> SqmExpression<int[]>	collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)	Determines all 1-based positions of an element in a basic collection.
<T> SqmExpression<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> SqmExpression<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>> SqmExpression<C>	collectionPrepend(E element, Expression<C> collectionExpression)	Prepends element to basic collection.
<E, C extends Collection<? super E>> SqmExpression<C>	collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)	Prepends element to basic collection.
<E, C extends Collection<? super E>> SqmExpression<C>	collectionRemove(Expression<C> collectionExpression, E element)	Creates basic collection copy with given element removed.
<E, C extends Collection<? super E>> SqmExpression<C>	collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)	Creates basic collection copy with given element removed.
<C extends Collection<?>> SqmExpression<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<?>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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>> SqmExpression<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<?>> SqmExpression<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<?>> SqmExpression<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<?>> SqmExpression<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<?>> SqmExpression<C>	collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)	Creates a sub-collection of the based on 1-based lower and upper index.
SqmExpression<String>	collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)	Concatenates the non-null basic collection elements with a separator, as specified by the arguments.
SqmExpression<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<?>> SqmExpression<C>	collectionTrim(Expression<C> collectionExpression, Expression<Integer> indexExpression)	Creates basic collection copy without the last N elements, specified by the second argument.
<C extends Collection<?>> SqmExpression<C>	collectionTrim(Expression<C> collectionExpression, Integer index)	Creates basic collection copy without the last N elements, specified by the second argument.
SqmExpression<String>	concat(Expression<String> x, Expression<String> y)
SqmExpression<String>	concat(Expression<String> x, String y)
SqmExpression<String>	concat(String x, Expression<String> y)
SqmExpression<String>	concat(String x, String y)
SqmExpression<String>	concat(List<Expression<String>> expressions)
SqmPredicate	conjunction()
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, Selection<?>[] arguments)
<Y> JpaCompoundSelection<Y>	construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
SqmFunction<Double>	cos(Expression<? extends Number> x)	Create an expression that returns the cosine of its argument.
SqmFunction<Double>	cosh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic cosine of its argument.
SqmExpression<Long>	count()	Equivalent to HQL count(*).
SqmExpression<Long>	count(Expression<?> argument)
SqmExpression<Long>	count(Expression<?> argument, JpaPredicate filter)
SqmExpression<Long>	count(Expression<?> argument, JpaPredicate filter, JpaWindow window)	Create a count aggregate function expression.
SqmExpression<Long>	count(Expression<?> argument, JpaWindow window)
SqmExpression<Long>	countDistinct(Expression<?> argument)
<T> SqmDeleteStatement<T>	createCriteriaDelete(Class<T> targetEntity)
<T> SqmInsertSelectStatement<T>	createCriteriaInsertSelect(Class<T> targetEntity)
<T> SqmInsertValuesStatement<T>	createCriteriaInsertValues(Class<T> targetEntity)
<T> SqmUpdateStatement<T>	createCriteriaUpdate(Class<T> targetEntity)
SqmSelectStatement<Object>	createQuery()
<T> SqmSelectStatement<T>	createQuery(Class<T> resultClass)
<T> SqmSelectStatement<T>	createQuery(String hql, Class<T> resultClass)	Transform the given HQL select query to an equivalent criteria query.
SqmSelectStatement<Tuple>	createTupleQuery()
SqmWindow	createWindow()	Create an empty JpaWindow to use with window and aggregate functions.
SqmExpression<Double>	cumeDist(JpaWindow window)	Create a cume_dist window function expression.
SqmFunction<Date>	currentDate()
SqmFunction<Instant>	currentInstant()
SqmFunction<Time>	currentTime()
SqmFunction<Timestamp>	currentTimestamp()
SqmFunction<Integer>	day(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.DAY of a date, time, or datetime expression.
SqmFunction<Double>	degrees(Expression<? extends Number> x)	Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
SqmExpression<Long>	denseRank(JpaWindow window)	Create a dense_rank window function expression.
SqmSortSpecification	desc(Expression<?> x)
JpaOrder	desc(Expression<?> x, boolean nullsFirst)	Create an ordering by the descending value of the expression.
Order	desc(Expression<?> expression, Nulls nullPrecedence)
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> SqmExpression<N>	diff(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number> SqmExpression<N>	diff(Expression<? extends N> x, N y)
<N extends Number> SqmExpression<N>	diff(N x, Expression<? extends N> y)
SqmPredicate	disjunction()
SqmPredicate	distinctFrom(Expression<?> x, Expression<?> y)
SqmPredicate	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.
SqmPredicate	equal(Expression<?> x, Expression<?> y)
SqmPredicate	equal(Expression<?> x, Object y)
<T> JpaCriteriaQuery<T>	except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
<T> JpaCriteriaQuery<T>	except(CriteriaQuery<T> left, CriteriaQuery<?> right)
<T> CriteriaSelect<T>	except(CriteriaSelect<T> left, CriteriaSelect<?> right)
<T> JpaCriteriaQuery<T>	exceptAll(CriteriaQuery<T> left, CriteriaQuery<?> right)
<T> CriteriaSelect<T>	exceptAll(CriteriaSelect<T> left, CriteriaSelect<?> right)
SqmPredicate	exists(Subquery<?> subQuery)
JpaExpression<Double>	exp(Expression<? extends Number> x)	Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
<N, T extends Temporal> SqmExpression<N>	extract(TemporalField<N,T> field, Expression<T> temporal)
<T> SqmExpression<T>	firstValue(Expression<T> argument, JpaWindow window)	Create a first_value window function expression.
<P, F> SqmExpression<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.
SqmFunction<String>	format(Expression<? extends TemporalAccessor> datetime, String pattern)	Format a date, time, or datetime according to a pattern.
SqmWindowFrame	frameBetweenFollowing(int offset)
SqmWindowFrame	frameBetweenFollowing(Expression<?> offset)	Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.
SqmWindowFrame	frameBetweenPreceding(int offset)
SqmWindowFrame	frameBetweenPreceding(Expression<?> offset)	Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.
SqmWindowFrame	frameCurrentRow()	Create a window frame of type FrameKind.CURRENT_ROW to use with JpaWindows.
SqmWindowFrame	frameUnboundedFollowing()	Create a window frame of type FrameKind.UNBOUNDED_FOLLOWING to use with JpaWindows.
SqmWindowFrame	frameUnboundedPreceding()	Create a window frame of type FrameKind.UNBOUNDED_PRECEDING to use with JpaWindows.
<T> SqmFunction<T>	function(String name, Class<T> type, Expression<?>[] args)
<T> SqmExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)
<T> SqmExpression<T>	functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args)	Create a generic aggregate function expression.
<T> SqmExpression<T>	functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)
<T> SqmExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)
<T> SqmExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)
<T> SqmExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args)	Create a generic ordered set-aggregate function expression.
<T> SqmExpression<T>	functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)
SqmPredicate	ge(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate	ge(Expression<? extends Number> x, Number y)
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, E stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, E stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, E stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, Expression<E> stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, Expression<E> stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(E start, Expression<E> stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, E stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, E stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, E stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop, E step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Number> SqmSetReturningFunction<E>	generateSeries(Expression<E> start, Expression<E> stop, Expression<E> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(E start, E stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(E start, E stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(E start, Expression<E> stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(E start, Expression<E> stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(Expression<E> start, E stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(Expression<E> start, E stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(Expression<E> start, Expression<E> stop, Expression<? extends TemporalAmount> step)	Creates a generate_series function expression to generate a set of values as rows.
<E extends Temporal> SqmSetReturningFunction<E>	generateTimeSeries(Expression<E> start, Expression<E> stop, TemporalAmount step)	Creates a generate_series function expression to generate a set of values as rows.
FunctionReturnTypeResolver	getAvgReturnTypeResolver()
BasicType<Boolean>	getBooleanType()
BasicType<Character>	getCharacterType()
JpaMetamodel	getDomainModel()
ImmutableEntityUpdateQueryHandlingMode	getImmutableEntityUpdateQueryHandlingMode()
BasicType<Integer>	getIntegerType()
JpaCompliance	getJpaCompliance()
JpaMetamodel	getJpaMetamodel()
BasicType<Long>	getLongType()
MappingMetamodelImplementor	getMappingMetamodel()
QueryEngine	getQueryEngine()
BasicType<String>	getStringType()
FunctionReturnTypeResolver	getSumReturnTypeResolver()
TypeConfiguration	getTypeConfiguration()
<Y extends Comparable<? super Y>> SqmPredicate	greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)
<Y extends Comparable<? super Y>> SqmPredicate	greaterThan(Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>> SqmPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
<Y extends Comparable<? super Y>> SqmPredicate	greaterThanOrEqualTo(Expression<? extends Y> x, Y y)
<X extends Comparable<? super X>> SqmExpression<X>	greatest(Expression<X> argument)
SqmPredicate	gt(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate	gt(Expression<? extends Number> x, Number y)
SqmFunction<Integer>	hour(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
SqmPredicate	ilike(Expression<String> searchString, Expression<String> pattern)
SqmPredicate	ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)
SqmPredicate	ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate	ilike(Expression<String> searchString, String pattern)
SqmPredicate	ilike(Expression<String> searchString, String pattern, char escapeChar)
SqmPredicate	ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
<T> SqmInPredicate<T>	in(Expression<? extends T> expression)
<T> SqmInPredicate<T>	in(Expression<? extends T> expression, Expression<? extends T>... values)
<T> SqmInPredicate<T>	in(Expression<? extends T> expression, Collection<T> values)
<T> SqmInPredicate<T>	in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)
<T> SqmInPredicate<T>	in(Expression<? extends T> expression, T... values)
<K, L extends List<?>> SqmExpression<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)
<T> JpaCriteriaQuery<T>	intersect(CriteriaQuery<? super T> left, CriteriaQuery<? super T> right)
<T> CriteriaSelect<T>	intersect(CriteriaSelect<? super T> left, CriteriaSelect<? super T> right)
<T> JpaCriteriaQuery<T>	intersectAll(CriteriaQuery<? super T> left, CriteriaQuery<? super T> right)
<T> CriteriaSelect<T>	intersectAll(CriteriaSelect<? super T> left, CriteriaSelect<? super T> right)
<C extends Collection<?>> SqmPredicate	isEmpty(Expression<C> collection)
SqmPredicate	isFalse(Expression<Boolean> x)
boolean	isJpaQueryComplianceEnabled()
<M extends Map<?, ?>> SqmPredicate	isMapEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is empty.
<M extends Map<?, ?>> SqmPredicate	isMapNotEmpty(JpaExpression<M> mapExpression)	Create a predicate that tests whether a Map is not empty.
<E, C extends Collection<E>> SqmPredicate	isMember(E elem, Expression<C> collection)
<E, C extends Collection<E>> SqmPredicate	isMember(Expression<E> elem, Expression<C> collection)
<C extends Collection<?>> SqmPredicate	isNotEmpty(Expression<C> collection)
<E, C extends Collection<E>> SqmPredicate	isNotMember(E elem, Expression<C> collection)
<E, C extends Collection<E>> SqmPredicate	isNotMember(Expression<E> elem, Expression<C> collection)
SqmPredicate	isNotNull(Expression<?> x)
SqmPredicate	isNull(Expression<?> x)
SqmPredicate	isTrue(Expression<Boolean> x)
SqmExpression<String>	jsonArray(Expression<?>... values)	Create a JSON array from the array of values.
SqmExpression<String>	jsonArrayAgg(Expression<?> value)	Aggregates the given value into a JSON array.
SqmExpression<String>	jsonArrayAgg(Expression<?> value, Predicate filter)	Aggregates the given value into a JSON array.
SqmExpression<String>	jsonArrayAgg(Expression<?> value, Predicate filter, JpaOrder... orderBy)	Aggregates the given value into a JSON array.
SqmExpression<String>	jsonArrayAgg(Expression<?> value, JpaOrder... orderBy)	Aggregates the given value into a JSON array.
SqmExpression<String>	jsonArrayAggWithNulls(Expression<?> value)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
SqmExpression<String>	jsonArrayAggWithNulls(Expression<?> value, Predicate filter)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
SqmExpression<String>	jsonArrayAggWithNulls(Expression<?> value, Predicate filter, JpaOrder... orderBy)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
SqmExpression<String>	jsonArrayAggWithNulls(Expression<?> value, JpaOrder... orderBy)	Aggregates the given value into a JSON array, retaining null values in the JSON array.
SqmExpression<String>	jsonArrayWithNulls(Expression<?>... values)	Create a JSON object from the given array of values, retaining null values in the JSON array.
SqmJsonExistsExpression	jsonExists(Expression<?> jsonDocument, Expression<String> jsonPath)	Checks if a JSON document contains a node for the given JSON path.
SqmJsonExistsExpression	jsonExists(Expression<?> jsonDocument, String jsonPath)	Checks if a JSON document contains a node for the given JSON path.
SqmExpression<String>	jsonInsert(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Inserts a value by JSON path within a JSON document.
SqmExpression<String>	jsonInsert(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Inserts a value by JSON path within a JSON document.
SqmExpression<String>	jsonInsert(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Inserts a value by JSON path within a JSON document.
SqmExpression<String>	jsonInsert(Expression<?> jsonDocument, String jsonPath, Object value)	Inserts a value by JSON path within a JSON document.
SqmExpression<String>	jsonMergepatch(Expression<?> document, Expression<?> patch)	Applies the patch JSON document onto the other JSON document and returns that.
SqmExpression<String>	jsonMergepatch(Expression<?> document, String patch)	Applies the patch JSON document onto the other JSON document and returns that.
SqmExpression<String>	jsonMergepatch(String document, Expression<?> patch)	Applies the patch JSON document onto the other JSON document and returns that.
SqmExpression<String>	jsonObject(Map<?,? extends Expression<?>> keyValues)	Create a JSON object from the given map of key values.
SqmExpression<String>	jsonObjectAgg(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object.
SqmExpression<String>	jsonObjectAgg(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object.
SqmExpression<String>	jsonObjectAggWithNulls(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
SqmExpression<String>	jsonObjectAggWithNulls(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
SqmExpression<String>	jsonObjectAggWithUniqueKeys(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object.
SqmExpression<String>	jsonObjectAggWithUniqueKeys(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object.
SqmExpression<String>	jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key, Expression<?> value)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
SqmExpression<String>	jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key, Expression<?> value, Predicate filter)	Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.
SqmExpression<String>	jsonObjectWithNulls(Map<?,? extends Expression<?>> keyValues)	Create a JSON object from the given map of key values, retaining null values in the JSON.
SqmJsonQueryExpression	jsonQuery(Expression<?> jsonDocument, Expression<String> jsonPath)	Queries values by JSON path from a JSON document.
SqmJsonQueryExpression	jsonQuery(Expression<?> jsonDocument, String jsonPath)
SqmExpression<String>	jsonRemove(Expression<?> jsonDocument, Expression<String> jsonPath)	Removes a value by JSON path within a JSON document.
SqmExpression<String>	jsonRemove(Expression<?> jsonDocument, String jsonPath)	Removes a value by JSON path within a JSON document.
SqmExpression<String>	jsonReplace(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonReplace(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonReplace(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonReplace(Expression<?> jsonDocument, String jsonPath, Object value)	Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonSet(Expression<?> jsonDocument, Expression<String> jsonPath, Expression<?> value)	Inserts/Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonSet(Expression<?> jsonDocument, Expression<String> jsonPath, Object value)	Inserts/Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonSet(Expression<?> jsonDocument, String jsonPath, Expression<?> value)	Inserts/Replaces a value by JSON path within a JSON document.
SqmExpression<String>	jsonSet(Expression<?> jsonDocument, String jsonPath, Object value)	Inserts/Replaces a value by JSON path within a JSON document.
SqmJsonTableFunction<?>	jsonTable(Expression<?> jsonDocument)	Creates a json_table function expression to generate rows from JSON array elements.
SqmJsonTableFunction<?>	jsonTable(Expression<?> jsonDocument, @Nullable Expression<String> jsonPath)	Creates a json_table function expression to generate rows from JSON array elements.
SqmJsonTableFunction<?>	jsonTable(Expression<?> jsonDocument, String jsonPath)	Creates a json_table function expression to generate rows from JSON array elements.
SqmJsonValueExpression<String>	jsonValue(Expression<?> jsonDocument, Expression<String> jsonPath)
<T> SqmJsonValueExpression<T>	jsonValue(Expression<?> jsonDocument, Expression<String> jsonPath, Class<T> returningType)	Extracts a value by JSON path from a JSON document.
SqmJsonValueExpression<String>	jsonValue(Expression<?> jsonDocument, String jsonPath)
<T> SqmJsonValueExpression<T>	jsonValue(Expression<?> jsonDocument, String jsonPath, Class<T> returningType)	Extracts a value by JSON path from a JSON document.
<K, M extends Map<K, ?>> SqmExpression<Set<K>>	keys(M map)
<T> SqmExpression<T>	lastValue(Expression<T> argument, JpaWindow window)	Create a last_value window function expression.
SqmPredicate	le(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate	le(Expression<? extends Number> x, Number y)
<X extends Comparable<? super X>> SqmExpression<X>	least(Expression<X> argument)
SqmFunction<String>	left(Expression<String> x, int length)
SqmFunction<String>	left(Expression<String> x, Expression<Integer> length)	Extract the length leftmost characters of a string.
SqmFunction<Integer>	length(Expression<String> argument)
<Y extends Comparable<? super Y>> SqmPredicate	lessThan(Expression<? extends Y> x, Expression<? extends Y> y)
<Y extends Comparable<? super Y>> SqmPredicate	lessThan(Expression<? extends Y> x, Y y)
<Y extends Comparable<? super Y>> SqmPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
<Y extends Comparable<? super Y>> SqmPredicate	lessThanOrEqualTo(Expression<? extends Y> x, Y y)
SqmPredicate	like(Expression<String> searchString, Expression<String> pattern)
SqmPredicate	like(Expression<String> searchString, Expression<String> pattern, char escapeChar)
SqmPredicate	like(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate	like(Expression<String> searchString, String pattern)
SqmPredicate	like(Expression<String> searchString, String pattern, char escapeChar)
SqmPredicate	like(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
SqmExpression<String>	listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
SqmExpression<String>	listagg(JpaOrder order, Expression<String> argument, String separator)
SqmExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)
SqmExpression<String>	listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)
SqmExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)	Create a listagg ordered set-aggregate function expression.
SqmExpression<String>	listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
SqmExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
SqmExpression<String>	listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)
<T> JpaParameterExpression<List<T>>	listParameter(Class<T> paramClass)	Create a multivalued parameter accepting multiple arguments packaged together as a List.
<T> JpaParameterExpression<List<T>>	listParameter(Class<T> paramClass, String name)	Create a multivalued parameter accepting multiple arguments packaged together as a List.
<T> SqmLiteral<T>	literal(T value)
<T> SqmLiteral<T>	literal(T value, SqmExpression<? extends T> typeInferenceSource)
<T> List<? extends SqmExpression<T>>	literals(List<T> values)
<T> List<? extends SqmExpression<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.
SqmFunction<Integer>	locate(Expression<String> source, Expression<String> pattern)
SqmFunction<Integer>	locate(Expression<String> source, Expression<String> pattern, Expression<Integer> startPosition)
SqmFunction<Integer>	locate(Expression<String> source, String pattern)
SqmFunction<Integer>	locate(Expression<String> source, String pattern, int startPosition)
SqmFunction<Double>	log(Expression<? extends Number> b, Expression<? extends Number> x)	Create an expression that returns the logarithm of x to the base b.
SqmFunction<Double>	log(Number b, Expression<? extends Number> x)
SqmFunction<Double>	log10(Expression<? extends Number> x)	Create an expression that returns the base-10 logarithm of its argument.
SqmFunction<String>	lower(Expression<String> x)
SqmPredicate	lt(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate	lt(Expression<? extends Number> x, Number y)
<M extends Map<?, ?>> SqmExpression<Integer>	mapSize(M map)	Create an expression that tests the size of a map.
<M extends Map<?, ?>> SqmExpression<Integer>	mapSize(JpaExpression<M> mapExpression)	Create an expression that tests the size of a map.
<N extends Number> SqmExpression<N>	max(Expression<N> argument)
<N extends Number> SqmExpression<N>	min(Expression<N> argument)
SqmFunction<Integer>	minute(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.
SqmExpression<Integer>	mod(Expression<Integer> x, Expression<Integer> y)
SqmExpression<Integer>	mod(Expression<Integer> x, Integer y)
SqmExpression<Integer>	mod(Integer x, Expression<Integer> y)
<T> SqmExpression<T>	mode(Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>	mode(JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>	mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)	Create a mode ordered set-aggregate function expression.
<T> SqmExpression<T>	mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
SqmFunction<Integer>	month(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
<T> SqmExpression<T>	named(Expression<T> expression, String name)	Creates a named expression.
<N extends Number> SqmExpression<N>	neg(Expression<N> x)
SqmPredicate	not(Expression<Boolean> restriction)
SqmPredicate	notDistinctFrom(Expression<?> x, Expression<?> y)
SqmPredicate	notDistinctFrom(Expression<?> x, Object y)
SqmPredicate	notEqual(Expression<?> x, Expression<?> y)
SqmPredicate	notEqual(Expression<?> x, Object y)
SqmPredicate	notIlike(Expression<String> x, Expression<String> pattern)
SqmPredicate	notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
SqmPredicate	notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate	notIlike(Expression<String> x, String pattern)
SqmPredicate	notIlike(Expression<String> x, String pattern, char escapeChar)
SqmPredicate	notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
SqmPredicate	notLike(Expression<String> x, Expression<String> pattern)
SqmPredicate	notLike(Expression<String> x, Expression<String> pattern, char escapeChar)
SqmPredicate	notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate	notLike(Expression<String> x, String pattern)
SqmPredicate	notLike(Expression<String> x, String pattern, char escapeChar)
SqmPredicate	notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)
<T> SqmExpression<T>	nthValue(Expression<T> argument, int n, JpaWindow window)
<T> SqmExpression<T>	nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)	Create a nth_value window function expression.
<Y> SqmExpression<Y>	nullif(Expression<Y> x, Expression<?> y)
<Y> SqmExpression<Y>	nullif(Expression<Y> x, Y y)
<T> SqmExpression<T>	nullLiteral(Class<T> resultClass)
SqmPredicate	or(Expression<Boolean> x, Expression<Boolean> y)
SqmPredicate	or(Predicate... restrictions)
SqmPredicate	or(List<Predicate> restrictions)
SqmFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start)
SqmFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start, int length)
SqmFunction<String>	overlay(Expression<String> string, Expression<String> replacement, int start, Expression<Integer> length)
SqmFunction<String>	overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)
SqmFunction<String>	overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, int length)
SqmFunction<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.
SqmFunction<String>	overlay(Expression<String> string, String replacement, int start)
SqmFunction<String>	overlay(Expression<String> string, String replacement, int start, int length)
SqmFunction<String>	overlay(Expression<String> string, String replacement, int start, Expression<Integer> length)
SqmFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start)
SqmFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start, int length)
SqmFunction<String>	overlay(Expression<String> string, String replacement, Expression<Integer> start, Expression<Integer> length)
SqmFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)
SqmFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, char padChar)
SqmFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length, Expression<Character> padChar)
SqmFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length)
SqmFunction<String>	pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length, char padChar)
SqmFunction<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.
SqmFunction<String>	pad(Expression<String> x, int length)
SqmFunction<String>	pad(Expression<String> x, int length, char padChar)
SqmFunction<String>	pad(Expression<String> x, int length, Expression<Character> padChar)
SqmFunction<String>	pad(Expression<String> x, Expression<Integer> length)
SqmFunction<String>	pad(Expression<String> x, Expression<Integer> length, char padChar)
SqmFunction<String>	pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)
<T> JpaCriteriaParameter<T>	parameter(Class<T> paramClass)
<T> JpaCriteriaParameter<T>	parameter(Class<T> paramClass, String name)
<T> SqmExpression<T>	percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>	percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<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> SqmExpression<T>	percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>	percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<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> SqmExpression<T>	percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
SqmExpression<Double>	percentRank(JpaOrder order, Expression<?>... arguments)
SqmExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
SqmExpression<Double>	percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)	Create a percent_rank ordered set-aggregate function expression.
SqmExpression<Double>	percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<Double>	percentRank(JpaWindow window)	Create a percent_rank window function expression.
SqmFunction<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> SqmExpression<N>	prod(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number> SqmExpression<N>	prod(Expression<? extends N> x, N y)
<N extends Number> SqmExpression<N>	prod(N x, Expression<? extends N> y)
SqmExpression<Number>	quot(Expression<? extends Number> x, Expression<? extends Number> y)
SqmExpression<Number>	quot(Expression<? extends Number> x, Number y)
SqmExpression<Number>	quot(Number x, Expression<? extends Number> y)
SqmFunction<Double>	radians(Expression<? extends Number> x)	Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
SqmExpression<Long>	rank(JpaOrder order, Expression<?>... arguments)
SqmExpression<Long>	rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
SqmExpression<Long>	rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)	Create a rank ordered set-aggregate function expression.
SqmExpression<Long>	rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<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.
SqmFunction<String>	replace(Expression<String> x, Expression<String> pattern, Expression<String> replacement)	Replace all occurrences of pattern within the original string with replacement.
SqmFunction<String>	replace(Expression<String> x, Expression<String> pattern, String replacement)
SqmFunction<String>	replace(Expression<String> x, String pattern, Expression<String> replacement)
SqmFunction<String>	replace(Expression<String> x, String pattern, String replacement)
SqmFunction<String>	right(Expression<String> x, int length)
SqmFunction<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.
SqmExpression<Long>	rowNumber(JpaWindow window)	Create a row_number window function expression.
JpaSearchOrder	search(JpaCteCriteriaAttribute sortExpression)	Create a search ordering based on the ascending value of the CTE attribute.
JpaSearchOrder	search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder)	Create a search ordering based on the sort order of the value of the CTE attribute.
JpaSearchOrder	search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)	Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
SqmFunction<Float>	second(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.
<R> SqmCaseSearched<R>	selectCase()
<C, R> SqmCaseSimple<C,R>	selectCase(Expression<? extends C> expression)
<E> SqmSetReturningFunction<E>	setReturningFunction(String name, Expression<?>... args)	Create a new set-returning function expression.
JpaExpression<Integer>	sign(Expression<? extends Number> x)	Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
SqmFunction<Double>	sin(Expression<? extends Number> x)	Create an expression that returns the sine of its argument.
SqmFunction<Double>	sinh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic sine of its argument.
<C extends Collection<?>> SqmExpression<Integer>	size(C collection)
<C extends Collection<?>> SqmExpression<Integer>	size(Expression<C> collection)
<Y> SqmModifiedSubQueryExpression<Y>	some(Subquery<Y> subquery)
SqmSortSpecification	sort(JpaExpression<?> sortExpression)
SqmSortSpecification	sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
SqmSortSpecification	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, Nulls nullPrecedence)
SqmSortSpecification	sort(JpaExpression<?> sortExpression, SortDirection sortOrder, Nulls nullPrecedence, boolean ignoreCase)
<T> SqmFunction<T>	sql(String pattern, Class<T> type, Expression<?>... arguments)	Embed native pattern that will be unquoted and embedded in the generated SQL.
SqmExpression<Double>	sqrt(Expression<? extends Number> x)
SqmFunction<String>	substring(Expression<String> source, int from)
SqmFunction<String>	substring(Expression<String> source, int from, int len)
SqmFunction<String>	substring(Expression<String> source, Expression<Integer> from)
SqmFunction<String>	substring(Expression<String> source, Expression<Integer> from, Expression<Integer> len)
<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> SqmExpression<N>	sum(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number> SqmExpression<N>	sum(Expression<? extends N> x, N y)
<N extends Number> SqmExpression<N>	sum(Expression<N> argument)
<N extends Number> SqmExpression<Number>	sum(Expression<N> argument, JpaPredicate filter)
<N extends Number> SqmExpression<Number>	sum(Expression<N> argument, JpaPredicate filter, JpaWindow window)	Create a sum aggregate function expression.
<N extends Number> SqmExpression<Number>	sum(Expression<N> argument, JpaWindow window)
<N extends Number> SqmExpression<N>	sum(N x, Expression<? extends N> y)
SqmExpression<Double>	sumAsDouble(Expression<Float> argument)
SqmExpression<Long>	sumAsLong(Expression<Integer> argument)
SqmFunction<Double>	tan(Expression<? extends Number> x)	Create an expression that returns the tangent of its argument.
SqmFunction<Double>	tanh(Expression<? extends Number> x)	Create an expression that returns the hyperbolic tangent of its argument.
SqmExpression<BigDecimal>	toBigDecimal(Expression<? extends Number> number)
SqmExpression<BigInteger>	toBigInteger(Expression<? extends Number> number)
SqmExpression<Double>	toDouble(Expression<? extends Number> number)
SqmExpression<Float>	toFloat(Expression<? extends Number> number)
SqmExpression<Integer>	toInteger(Expression<? extends Number> number)
SqmExpression<Long>	toLong(Expression<? extends Number> number)
SqmExpression<String>	toString(Expression<Character> character)
<X, T, E extends T> SqmBagJoin<X,E>	treat(CollectionJoin<X,T> join, Class<E> type)
<X, T, V extends T> SqmSingularJoin<X,V>	treat(Join<X,T> join, Class<V> type)
<X, T, E extends T> SqmListJoin<X,E>	treat(ListJoin<X,T> join, Class<E> type)
<X, K, T, V extends T> SqmMapJoin<X,K,V>	treat(MapJoin<X,K,T> join, Class<V> type)
<X, T extends X> SqmPath<T>	treat(Path<X> path, Class<T> type)
<X, T extends X> SqmRoot<T>	treat(Root<X> root, Class<T> type)
<X, T, E extends T> SqmSetJoin<X,E>	treat(SetJoin<X,T> join, Class<E> type)
SqmFunction<String>	trim(char trimChar, Expression<String> source)
SqmFunction<String>	trim(CriteriaBuilder.Trimspec ts, char trimChar, Expression<String> source)
SqmFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<Character> trimChar, Expression<String> source)
SqmFunction<String>	trim(CriteriaBuilder.Trimspec ts, Expression<String> source)
SqmFunction<String>	trim(Expression<Character> trimChar, Expression<String> source)
SqmFunction<String>	trim(Expression<String> source)
<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> SqmFunction<T>	truncate(Expression<T> datetime, TemporalUnit temporalUnit)	Truncates a date, time or datetime expression to the given TemporalUnit.
JpaCompoundSelection<Tuple>	tuple(Selection<?>[] selections)
<R> SqmTuple<R>	tuple(Class<R> tupleType, List<? extends SqmExpression<?>> expressions)
<R> SqmTuple<R>	tuple(Class<R> tupleType, SqmExpression<?>... expressions)
JpaCompoundSelection<Tuple>	tuple(List<Selection<?>> selections)
<R> SqmTuple<R>	tuple(SqmExpressible<R> tupleType, List<? extends SqmExpression<?>> sqmExpressions)
<R> SqmTuple<R>	tuple(SqmExpressible<R> tupleType, SqmExpression<?>... expressions)
<T> JpaCriteriaQuery<T>	union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>	union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
<T> JpaCriteriaQuery<T>	union(CriteriaQuery<? extends T> left, CriteriaQuery<? extends T> right)
<T> JpaCriteriaSelect<T>	union(CriteriaSelect<? extends T> left, CriteriaSelect<? extends T> right)
<T> JpaCriteriaQuery<T>	unionAll(CriteriaQuery<? extends T> left, CriteriaQuery<? extends T> right)
<T> CriteriaSelect<T>	unionAll(CriteriaSelect<? extends T> left, CriteriaSelect<? extends T> right)
<E> SqmSetReturningFunction<E>	unnestArray(Expression<E[]> array)	Creates an unnest function expression to turn an array into a set of rows.
<E> SqmSetReturningFunction<E>	unnestCollection(Expression<? extends Collection<E>> collection)	Creates an unnest function expression to turn an array into a set of rows.
<T extends HibernateCriteriaBuilder> T	unwrap(Class<T> clazz)
SqmFunction<String>	upper(Expression<String> x)
<T> SqmExpression<T>	value(T value)
<T> SqmExpression<T>	value(T value, SqmExpression<? extends T> typeInferenceSource)	Creates an expression for the value with the given "type inference" information
SqmValues	values(Expression<?>... expressions)
SqmValues	values(List<? extends Expression<?>> expressions)
<V, M extends Map<?, V>> Expression<Collection<V>>	values(M map)
<T> SqmExpression<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.
SqmPredicate	wrap(Expression<Boolean> expression)
final SqmPredicate	wrap(Expression<Boolean>... expressions)
SqmExpression<String>	xmlagg(JpaOrder order, Expression<?> argument)
SqmExpression<String>	xmlagg(JpaOrder order, JpaPredicate filter, Expression<?> argument)
SqmExpression<String>	xmlagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument)	Create a xmlagg ordered set-aggregate function expression.
SqmExpression<String>	xmlagg(JpaOrder order, JpaWindow window, Expression<?> argument)
SqmExpression<String>	xmlcomment(String comment)	Creates an XML comment with the given argument as content.
SqmExpression<String>	xmlconcat(Expression<?>... elements)	Concatenates the given XML element expressions.
SqmExpression<String>	xmlconcat(List<? extends Expression<?>> elements)	Concatenates the given XML element expressions.
SqmXmlElementExpression	xmlelement(String elementName)	Creates an XML element with the given element name.
SqmExpression<Boolean>	xmlexists(Expression<String> query, Expression<?> xmlDocument)	Checks if the given XPath or XQuery query exists in the given XML document.
SqmExpression<Boolean>	xmlexists(String query, Expression<?> xmlDocument)	Checks if the given XPath or XQuery query exists in the given XML document.
SqmExpression<String>	xmlforest(Expression<?>... elements)	Creates an XML forest from the given XML element expressions.
SqmExpression<String>	xmlforest(List<? extends Expression<?>> elements)	Creates an XML forest from the given XML element expressions.
SqmExpression<String>	xmlpi(String elementName)	Creates an XML processing with the given name.
SqmExpression<String>	xmlpi(String elementName, Expression<String> content)	Creates an XML processing with the given name and content.
SqmExpression<String>	xmlquery(Expression<String> query, Expression<?> xmlDocument)	Queries the given XML document with the given XPath or XQuery query.
SqmExpression<String>	xmlquery(String query, Expression<?> xmlDocument)	Queries the given XML document with the given XPath or XQuery query.
SqmXmlTableFunction<?>	xmlTable(Expression<String> xpath, Expression<?> xmlDocument)	Creates a xmltable function expression to generate rows from XML elements.
SqmXmlTableFunction<?>	xmlTable(String xpath, Expression<?> xmlDocument)	Creates a xmltable function expression to generate rows from XML elements.
SqmFunction<Integer>	year(Expression<? extends TemporalAccessor> datetime)	Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.hibernate.query.criteria.HibernateCriteriaBuilder

except, except, exceptAll, exceptAll, intersect, intersect, intersectAll, intersectAll, union, union, unionAll, unionAll

Methods inherited from interface org.hibernate.query.sqm.NodeBuilder

arrayContainsAll, arrayContainsAll, arrayContainsAll, arrayContainsAllNullable, arrayContainsAllNullable, arrayContainsAllNullable, arrayOverlaps, arrayOverlaps, arrayOverlaps, arrayOverlapsNullable, arrayOverlapsNullable, arrayOverlapsNullable, collectionContainsAll, collectionContainsAll, collectionContainsAll, collectionContainsAllNullable, collectionContainsAllNullable, collectionContainsAllNullable, collectionOverlaps, collectionOverlaps, collectionOverlaps, collectionOverlapsNullable, collectionOverlapsNullable, collectionOverlapsNullable, sort, sort

Constructor Details

SqmCriteriaNodeBuilder

public SqmCriteriaNodeBuilder(String uuid,
 String name,
 QueryEngine queryEngine,
 QueryEngineOptions options,
 BindingContext bindingContext)

Method Details

getDomainModel

public JpaMetamodel getDomainModel()

Specified by:

getDomainModel in interface NodeBuilder

getTypeConfiguration

public TypeConfiguration getTypeConfiguration()

Specified by:

getTypeConfiguration in interface BindingContext

Specified by:

getTypeConfiguration in interface NodeBuilder

isJpaQueryComplianceEnabled

public boolean isJpaQueryComplianceEnabled()

Specified by:

isJpaQueryComplianceEnabled in interface NodeBuilder

getJpaCompliance

public JpaCompliance getJpaCompliance()

Specified by:

getJpaCompliance in interface NodeBuilder

getImmutableEntityUpdateQueryHandlingMode

public ImmutableEntityUpdateQueryHandlingMode getImmutableEntityUpdateQueryHandlingMode()

Specified by:

getImmutableEntityUpdateQueryHandlingMode in interface NodeBuilder

getBooleanType

public BasicType<Boolean> getBooleanType()

Specified by:

getBooleanType in interface NodeBuilder

getIntegerType

public BasicType<Integer> getIntegerType()

Specified by:

getIntegerType in interface NodeBuilder

getLongType

public BasicType<Long> getLongType()

Specified by:

getLongType in interface NodeBuilder

getCharacterType

public BasicType<Character> getCharacterType()

Specified by:

getCharacterType in interface NodeBuilder

getStringType

public BasicType<String> getStringType()

getSumReturnTypeResolver

public FunctionReturnTypeResolver getSumReturnTypeResolver()

getAvgReturnTypeResolver

public FunctionReturnTypeResolver getAvgReturnTypeResolver()

getQueryEngine

public QueryEngine getQueryEngine()

Specified by:

getQueryEngine in interface NodeBuilder

getJpaMetamodel

public JpaMetamodel getJpaMetamodel()

Specified by:

getJpaMetamodel in interface BindingContext

createQuery

public SqmSelectStatement<Object> createQuery()

Specified by:

createQuery in interface CriteriaBuilder

Specified by:

createQuery in interface HibernateCriteriaBuilder

Specified by:

createQuery in interface NodeBuilder

createQuery

public <T> SqmSelectStatement<T> createQuery(Class<T> resultClass)

Specified by:

createQuery in interface CriteriaBuilder

Specified by:

createQuery in interface HibernateCriteriaBuilder

Specified by:

createQuery in interface NodeBuilder

createQuery

public <T> SqmSelectStatement<T> createQuery(String hql,
 Class<T> resultClass)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

createQuery in interface HibernateCriteriaBuilder

Specified by:

createQuery in interface NodeBuilder

Parameters:

hql - The HQL select query

resultClass - The result type of the query

Returns:

The equivalent criteria query

createTupleQuery

public SqmSelectStatement<Tuple> createTupleQuery()

Specified by:

createTupleQuery in interface CriteriaBuilder

Specified by:

createTupleQuery in interface HibernateCriteriaBuilder

Specified by:

createTupleQuery in interface NodeBuilder

createCriteriaUpdate

public <T> SqmUpdateStatement<T> createCriteriaUpdate(Class<T> targetEntity)

Specified by:

createCriteriaUpdate in interface CriteriaBuilder

Specified by:

createCriteriaUpdate in interface HibernateCriteriaBuilder

Specified by:

createCriteriaUpdate in interface NodeBuilder

createCriteriaDelete

public <T> SqmDeleteStatement<T> createCriteriaDelete(Class<T> targetEntity)

Specified by:

createCriteriaDelete in interface CriteriaBuilder

Specified by:

createCriteriaDelete in interface HibernateCriteriaBuilder

Specified by:

createCriteriaDelete in interface NodeBuilder

createCriteriaInsertValues

public <T> SqmInsertValuesStatement<T> createCriteriaInsertValues(Class<T> targetEntity)

Specified by:

createCriteriaInsertValues in interface HibernateCriteriaBuilder

Specified by:

createCriteriaInsertValues in interface NodeBuilder

createCriteriaInsertSelect

public <T> SqmInsertSelectStatement<T> createCriteriaInsertSelect(Class<T> targetEntity)

Specified by:

createCriteriaInsertSelect in interface HibernateCriteriaBuilder

Specified by:

createCriteriaInsertSelect in interface NodeBuilder

values

public SqmValues values(Expression<?>... expressions)

Specified by:

values in interface HibernateCriteriaBuilder

Specified by:

values in interface NodeBuilder

values

public SqmValues values(List<? extends Expression<?>> expressions)

Specified by:

values in interface HibernateCriteriaBuilder

Specified by:

values in interface NodeBuilder

union

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

Specified by:

union in interface HibernateCriteriaBuilder

intersect

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

Specified by:

intersect in interface HibernateCriteriaBuilder

except

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

Specified by:

except in interface HibernateCriteriaBuilder

union

public <T> JpaCriteriaSelect<T> union(CriteriaSelect<? extends T> left,
 CriteriaSelect<? extends T> right)

Specified by:

union in interface CriteriaBuilder

Specified by:

union in interface HibernateCriteriaBuilder

union

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

Specified by:

union in interface HibernateCriteriaBuilder

unionAll

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

Specified by:

unionAll in interface CriteriaBuilder

Specified by:

unionAll in interface HibernateCriteriaBuilder

intersect

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

Specified by:

intersect in interface HibernateCriteriaBuilder

except

public <T> CriteriaSelect<T> except(CriteriaSelect<T> left,
 CriteriaSelect<?> right)

Specified by:

except in interface CriteriaBuilder

Specified by:

except in interface HibernateCriteriaBuilder

exceptAll

public <T> CriteriaSelect<T> exceptAll(CriteriaSelect<T> left,
 CriteriaSelect<?> right)

Specified by:

exceptAll in interface CriteriaBuilder

Specified by:

exceptAll in interface HibernateCriteriaBuilder

except

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

Specified by:

except in interface HibernateCriteriaBuilder

cast

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

Specified by:

cast in interface HibernateCriteriaBuilder

Specified by:

cast in interface NodeBuilder

cast

public <X,
T> SqmExpression<X> cast(JpaExpression<T> expression,
 JpaCastTarget<X> castTarget)

Specified by:

cast in interface HibernateCriteriaBuilder

Specified by:

cast in interface NodeBuilder

castTarget

public <X> SqmCastTarget<X> castTarget(Class<X> castTargetJavaType)

Specified by:

castTarget in interface HibernateCriteriaBuilder

Specified by:

castTarget in interface NodeBuilder

castTarget

public <X> SqmCastTarget<X> castTarget(Class<X> castTargetJavaType,
 long length)

Specified by:

castTarget in interface HibernateCriteriaBuilder

Specified by:

castTarget in interface NodeBuilder

castTarget

public <X> SqmCastTarget<X> castTarget(Class<X> castTargetJavaType,
 int precision,
 int scale)

Specified by:

castTarget in interface HibernateCriteriaBuilder

Specified by:

castTarget in interface NodeBuilder

wrap

public SqmPredicate wrap(Expression<Boolean> expression)

Specified by:

wrap in interface HibernateCriteriaBuilder

Specified by:

wrap in interface NodeBuilder

wrap

@SafeVarargs
public final SqmPredicate wrap(Expression<Boolean>... expressions)

Specified by:

wrap in interface HibernateCriteriaBuilder

Specified by:

wrap in interface NodeBuilder

unwrap

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

Specified by:

unwrap in interface HibernateCriteriaBuilder

fk

public <P,
F> SqmExpression<F> fk(Path<P> path)

Specified by:

fk in interface HibernateCriteriaBuilder

Specified by:

fk in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

union

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

Specified by:

union in interface HibernateCriteriaBuilder

unionAll

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

Specified by:

unionAll in interface HibernateCriteriaBuilder

intersect

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

Specified by:

intersect in interface CriteriaBuilder

Specified by:

intersect in interface HibernateCriteriaBuilder

intersectAll

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

Specified by:

intersectAll in interface CriteriaBuilder

Specified by:

intersectAll in interface HibernateCriteriaBuilder

intersect

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

Specified by:

intersect in interface HibernateCriteriaBuilder

intersectAll

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

Specified by:

intersectAll in interface HibernateCriteriaBuilder

except

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

Specified by:

except in interface HibernateCriteriaBuilder

exceptAll

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

Specified by:

exceptAll in interface HibernateCriteriaBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

treat

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

Specified by:

treat in interface CriteriaBuilder

Specified by:

treat in interface HibernateCriteriaBuilder

Specified by:

treat in interface NodeBuilder

sort

public SqmSortSpecification sort(JpaExpression<?> sortExpression,
 SortDirection sortOrder,
 Nulls nullPrecedence)

Specified by:

sort in interface HibernateCriteriaBuilder

Specified by:

sort in interface NodeBuilder

sort

public SqmSortSpecification sort(JpaExpression<?> sortExpression,
 SortDirection sortOrder,
 Nulls nullPrecedence,
 boolean ignoreCase)

Specified by:

sort in interface HibernateCriteriaBuilder

Specified by:

sort in interface NodeBuilder

sort

public SqmSortSpecification sort(JpaExpression<?> sortExpression,
 SortDirection sortOrder)

Specified by:

sort in interface HibernateCriteriaBuilder

Specified by:

sort in interface NodeBuilder

sort

public SqmSortSpecification sort(JpaExpression<?> sortExpression)

Specified by:

sort in interface HibernateCriteriaBuilder

Specified by:

sort in interface NodeBuilder

asc

public SqmSortSpecification asc(Expression<?> x)

Specified by:

asc in interface CriteriaBuilder

Specified by:

asc in interface HibernateCriteriaBuilder

Specified by:

asc in interface NodeBuilder

desc

public SqmSortSpecification desc(Expression<?> x)

Specified by:

desc in interface CriteriaBuilder

Specified by:

desc in interface HibernateCriteriaBuilder

Specified by:

desc in interface NodeBuilder

asc

public Order asc(Expression<?> expression,
 Nulls nullPrecedence)

Specified by:

asc in interface CriteriaBuilder

desc

public Order desc(Expression<?> expression,
 Nulls nullPrecedence)

Specified by:

desc in interface CriteriaBuilder

asc

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

Description copied from interface: HibernateCriteriaBuilder

Create an ordering by the ascending value of the expression.

Specified by:

asc in interface HibernateCriteriaBuilder

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

ascending ordering corresponding to the expression

desc

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

Description copied from interface: HibernateCriteriaBuilder

Create an ordering by the descending value of the expression.

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - expression used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the expression

search

public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

sortExpression - CTE attribute used to define the ordering

sortOrder - The sort order

nullPrecedence - The null precedence

Returns:

ordering corresponding to the CTE attribute

search

public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression,
 SortDirection sortOrder)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

sortExpression - CTE attribute used to define the ordering

sortOrder - The sort order

Returns:

ordering corresponding to the CTE attribute

search

public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

search in interface HibernateCriteriaBuilder

Parameters:

sortExpression - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

asc

public JpaSearchOrder asc(JpaCteCriteriaAttribute x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

asc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

Returns:

ascending ordering corresponding to the CTE attribute

desc

public JpaSearchOrder desc(JpaCteCriteriaAttribute x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

Returns:

descending ordering corresponding to the CTE attribute

asc

public JpaSearchOrder asc(JpaCteCriteriaAttribute x,
 boolean nullsFirst)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

asc in interface HibernateCriteriaBuilder

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

public JpaSearchOrder desc(JpaCteCriteriaAttribute x,
 boolean nullsFirst)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

desc in interface HibernateCriteriaBuilder

Parameters:

x - CTE attribute used to define the ordering

nullsFirst - Whether null should be sorted first

Returns:

descending ordering corresponding to the CTE attribute

tuple

public JpaCompoundSelection<Tuple> tuple(Selection<?>[] selections)

Specified by:

tuple in interface CriteriaBuilder

Specified by:

tuple in interface HibernateCriteriaBuilder

Specified by:

tuple in interface NodeBuilder

tuple

public JpaCompoundSelection<Tuple> tuple(List<Selection<?>> selections)

Specified by:

tuple in interface CriteriaBuilder

Specified by:

tuple in interface HibernateCriteriaBuilder

Specified by:

tuple in interface NodeBuilder

tuple

public <R> SqmTuple<R> tuple(Class<R> tupleType,
 SqmExpression<?>... expressions)

Specified by:

tuple in interface NodeBuilder

tuple

public <R> SqmTuple<R> tuple(Class<R> tupleType,
 List<? extends SqmExpression<?>> expressions)

Specified by:

tuple in interface NodeBuilder

tuple

public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType,
 SqmExpression<?>... expressions)

Specified by:

tuple in interface NodeBuilder

tuple

public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType,
 List<? extends SqmExpression<?>> sqmExpressions)

Specified by:

tuple in interface NodeBuilder

array

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

Specified by:

array in interface CriteriaBuilder

Specified by:

array in interface HibernateCriteriaBuilder

Specified by:

array in interface NodeBuilder

array

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

Specified by:

array in interface CriteriaBuilder

Specified by:

array in interface HibernateCriteriaBuilder

Specified by:

array in interface NodeBuilder

array

public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass,
 Selection<?>[] selections)

Specified by:

array in interface HibernateCriteriaBuilder

array

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

Specified by:

array in interface HibernateCriteriaBuilder

construct

public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass,
 Selection<?>[] arguments)

Specified by:

construct in interface CriteriaBuilder

Specified by:

construct in interface HibernateCriteriaBuilder

Specified by:

construct in interface NodeBuilder

construct

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

Specified by:

construct in interface HibernateCriteriaBuilder

Specified by:

construct in interface NodeBuilder

avg

public <N extends Number> SqmExpression<Double> avg(Expression<N> argument)

Specified by:

avg in interface CriteriaBuilder

Specified by:

avg in interface HibernateCriteriaBuilder

Specified by:

avg in interface NodeBuilder

sum

public <N extends Number> SqmExpression<N> sum(Expression<N> argument)

Specified by:

sum in interface CriteriaBuilder

Specified by:

sum in interface HibernateCriteriaBuilder

Specified by:

sum in interface NodeBuilder

sumAsLong

public SqmExpression<Long> sumAsLong(Expression<Integer> argument)

Specified by:

sumAsLong in interface CriteriaBuilder

Specified by:

sumAsLong in interface HibernateCriteriaBuilder

Specified by:

sumAsLong in interface NodeBuilder

sumAsDouble

public SqmExpression<Double> sumAsDouble(Expression<Float> argument)

Specified by:

sumAsDouble in interface CriteriaBuilder

Specified by:

sumAsDouble in interface HibernateCriteriaBuilder

Specified by:

sumAsDouble in interface NodeBuilder

max

public <N extends Number> SqmExpression<N> max(Expression<N> argument)

Specified by:

max in interface CriteriaBuilder

Specified by:

max in interface HibernateCriteriaBuilder

Specified by:

max in interface NodeBuilder

min

public <N extends Number> SqmExpression<N> min(Expression<N> argument)

Specified by:

min in interface CriteriaBuilder

Specified by:

min in interface HibernateCriteriaBuilder

Specified by:

min in interface NodeBuilder

greatest

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

Specified by:

greatest in interface CriteriaBuilder

Specified by:

greatest in interface HibernateCriteriaBuilder

Specified by:

greatest in interface NodeBuilder

least

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

Specified by:

least in interface CriteriaBuilder

Specified by:

least in interface HibernateCriteriaBuilder

Specified by:

least in interface NodeBuilder

count

public SqmExpression<Long> count(Expression<?> argument)

Specified by:

count in interface CriteriaBuilder

Specified by:

count in interface HibernateCriteriaBuilder

Specified by:

count in interface NodeBuilder

countDistinct

public SqmExpression<Long> countDistinct(Expression<?> argument)

Specified by:

countDistinct in interface CriteriaBuilder

Specified by:

countDistinct in interface HibernateCriteriaBuilder

Specified by:

countDistinct in interface NodeBuilder

count

public SqmExpression<Long> count()

Description copied from interface: HibernateCriteriaBuilder

Equivalent to HQL count(*).

Specified by:

count in interface HibernateCriteriaBuilder

Specified by:

count in interface NodeBuilder

sign

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

sign in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

sign

ceiling

public <N extends Number> JpaExpression<N> ceiling(Expression<N> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

ceiling in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

ceiling

floor

public <N extends Number> JpaExpression<N> floor(Expression<N> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

floor in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

floor

exp

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

exp in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

exponential

ln

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

ln in interface CriteriaBuilder

Specified by:

ln in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

natural logarithm

power

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

power in interface CriteriaBuilder

Specified by:

power in interface HibernateCriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

power

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

power in interface CriteriaBuilder

Specified by:

power in interface HibernateCriteriaBuilder

Parameters:

x - base

y - exponent

Returns:

the base raised to the power of the exponent

round

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

round in interface HibernateCriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the rounded value

truncate

public <T extends Number> JpaExpression<T> truncate(Expression<T> x,
 Integer n)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

truncate in interface HibernateCriteriaBuilder

Parameters:

x - base

n - number of decimal places

Returns:

the truncated value

neg

public <N extends Number> SqmExpression<N> neg(Expression<N> x)

Specified by:

neg in interface CriteriaBuilder

Specified by:

neg in interface HibernateCriteriaBuilder

Specified by:

neg in interface NodeBuilder

abs

public <N extends Number> SqmExpression<N> abs(Expression<N> x)

Specified by:

abs in interface CriteriaBuilder

Specified by:

abs in interface HibernateCriteriaBuilder

Specified by:

abs in interface NodeBuilder

duration

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

duration in interface HibernateCriteriaBuilder

durationByUnit

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

durationByUnit in interface HibernateCriteriaBuilder

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

durationSum

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

Description copied from interface: HibernateCriteriaBuilder

Add two durations.

Specified by:

durationSum in interface HibernateCriteriaBuilder

durationSum

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

Description copied from interface: HibernateCriteriaBuilder

Add two durations.

Specified by:

durationSum in interface HibernateCriteriaBuilder

durationDiff

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

Description copied from interface: HibernateCriteriaBuilder

Subtract one duration from another.

Specified by:

durationDiff in interface HibernateCriteriaBuilder

durationDiff

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

Description copied from interface: HibernateCriteriaBuilder

Subtract one duration from another.

Specified by:

durationDiff in interface HibernateCriteriaBuilder

durationScaled

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

Description copied from interface: HibernateCriteriaBuilder

Scale a duration by a number.

Specified by:

durationScaled in interface HibernateCriteriaBuilder

durationScaled

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

Description copied from interface: HibernateCriteriaBuilder

Scale a duration by a number.

Specified by:

durationScaled in interface HibernateCriteriaBuilder

durationScaled

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

Description copied from interface: HibernateCriteriaBuilder

Scale a duration by a number.

Specified by:

durationScaled in interface HibernateCriteriaBuilder

durationBetween

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

durationBetween in interface HibernateCriteriaBuilder

durationBetween

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

durationBetween in interface HibernateCriteriaBuilder

addDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

addDuration in interface HibernateCriteriaBuilder

addDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

addDuration in interface HibernateCriteriaBuilder

addDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

addDuration in interface HibernateCriteriaBuilder

subtractDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

subtractDuration in interface HibernateCriteriaBuilder

subtractDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

subtractDuration in interface HibernateCriteriaBuilder

subtractDuration

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

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

subtractDuration in interface HibernateCriteriaBuilder

sum

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

Specified by:

sum in interface CriteriaBuilder

Specified by:

sum in interface HibernateCriteriaBuilder

Specified by:

sum in interface NodeBuilder

sum

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

Specified by:

sum in interface CriteriaBuilder

Specified by:

sum in interface HibernateCriteriaBuilder

Specified by:

sum in interface NodeBuilder

sum

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

Specified by:

sum in interface CriteriaBuilder

Specified by:

sum in interface HibernateCriteriaBuilder

Specified by:

sum in interface NodeBuilder

prod

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

Specified by:

prod in interface CriteriaBuilder

Specified by:

prod in interface HibernateCriteriaBuilder

Specified by:

prod in interface NodeBuilder

prod

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

Specified by:

prod in interface CriteriaBuilder

Specified by:

prod in interface HibernateCriteriaBuilder

Specified by:

prod in interface NodeBuilder

prod

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

Specified by:

prod in interface CriteriaBuilder

Specified by:

prod in interface HibernateCriteriaBuilder

Specified by:

prod in interface NodeBuilder

diff

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

Specified by:

diff in interface CriteriaBuilder

Specified by:

diff in interface HibernateCriteriaBuilder

Specified by:

diff in interface NodeBuilder

diff

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

Specified by:

diff in interface CriteriaBuilder

Specified by:

diff in interface HibernateCriteriaBuilder

Specified by:

diff in interface NodeBuilder

diff

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

Specified by:

diff in interface CriteriaBuilder

Specified by:

diff in interface HibernateCriteriaBuilder

Specified by:

diff in interface NodeBuilder

quot

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

Specified by:

quot in interface CriteriaBuilder

Specified by:

quot in interface HibernateCriteriaBuilder

Specified by:

quot in interface NodeBuilder

quot

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

Specified by:

quot in interface CriteriaBuilder

Specified by:

quot in interface HibernateCriteriaBuilder

Specified by:

quot in interface NodeBuilder

quot

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

Specified by:

quot in interface CriteriaBuilder

Specified by:

quot in interface HibernateCriteriaBuilder

Specified by:

quot in interface NodeBuilder

mod

public SqmExpression<Integer> mod(Expression<Integer> x,
 Expression<Integer> y)

Specified by:

mod in interface CriteriaBuilder

Specified by:

mod in interface HibernateCriteriaBuilder

Specified by:

mod in interface NodeBuilder

mod

public SqmExpression<Integer> mod(Expression<Integer> x,
 Integer y)

Specified by:

mod in interface CriteriaBuilder

Specified by:

mod in interface HibernateCriteriaBuilder

Specified by:

mod in interface NodeBuilder

mod

public SqmExpression<Integer> mod(Integer x,
 Expression<Integer> y)

Specified by:

mod in interface CriteriaBuilder

Specified by:

mod in interface HibernateCriteriaBuilder

Specified by:

mod in interface NodeBuilder

sqrt

public SqmExpression<Double> sqrt(Expression<? extends Number> x)

Specified by:

sqrt in interface CriteriaBuilder

Specified by:

sqrt in interface HibernateCriteriaBuilder

Specified by:

sqrt in interface NodeBuilder

toLong

public SqmExpression<Long> toLong(Expression<? extends Number> number)

Specified by:

toLong in interface CriteriaBuilder

Specified by:

toLong in interface HibernateCriteriaBuilder

Specified by:

toLong in interface NodeBuilder

toInteger

public SqmExpression<Integer> toInteger(Expression<? extends Number> number)

Specified by:

toInteger in interface CriteriaBuilder

Specified by:

toInteger in interface HibernateCriteriaBuilder

Specified by:

toInteger in interface NodeBuilder

toFloat

public SqmExpression<Float> toFloat(Expression<? extends Number> number)

Specified by:

toFloat in interface CriteriaBuilder

Specified by:

toFloat in interface HibernateCriteriaBuilder

Specified by:

toFloat in interface NodeBuilder

toDouble

public SqmExpression<Double> toDouble(Expression<? extends Number> number)

Specified by:

toDouble in interface CriteriaBuilder

Specified by:

toDouble in interface HibernateCriteriaBuilder

Specified by:

toDouble in interface NodeBuilder

toBigDecimal

public SqmExpression<BigDecimal> toBigDecimal(Expression<? extends Number> number)

Specified by:

toBigDecimal in interface CriteriaBuilder

Specified by:

toBigDecimal in interface HibernateCriteriaBuilder

Specified by:

toBigDecimal in interface NodeBuilder

toBigInteger

public SqmExpression<BigInteger> toBigInteger(Expression<? extends Number> number)

Specified by:

toBigInteger in interface CriteriaBuilder

Specified by:

toBigInteger in interface HibernateCriteriaBuilder

Specified by:

toBigInteger in interface NodeBuilder

toString

public SqmExpression<String> toString(Expression<Character> character)

Specified by:

toString in interface CriteriaBuilder

Specified by:

toString in interface HibernateCriteriaBuilder

Specified by:

toString in interface NodeBuilder

literal

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

literal

public <T> SqmLiteral<T> literal(T value)

Specified by:

literal in interface CriteriaBuilder

Specified by:

literal in interface HibernateCriteriaBuilder

Specified by:

literal in interface NodeBuilder

getMappingMetamodel

public MappingMetamodelImplementor getMappingMetamodel()

Specified by:

getMappingMetamodel in interface BindingContext

literals

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

Specified by:

literals in interface HibernateCriteriaBuilder

Specified by:

literals in interface NodeBuilder

literals

public <T> List<? extends SqmExpression<T>> literals(List<T> values)

Specified by:

literals in interface HibernateCriteriaBuilder

Specified by:

literals in interface NodeBuilder

nullLiteral

public <T> SqmExpression<T> nullLiteral(Class<T> resultClass)

Specified by:

nullLiteral in interface CriteriaBuilder

Specified by:

nullLiteral in interface HibernateCriteriaBuilder

Specified by:

nullLiteral in interface NodeBuilder

parameter

public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass)

Specified by:

parameter in interface CriteriaBuilder

Specified by:

parameter in interface HibernateCriteriaBuilder

Specified by:

parameter in interface NodeBuilder

See Also:

• JpaParameterExpression

parameter

public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass,
 String name)

Specified by:

parameter in interface CriteriaBuilder

Specified by:

parameter in interface HibernateCriteriaBuilder

Specified by:

parameter in interface NodeBuilder

listParameter

public <T> JpaParameterExpression<List<T>> listParameter(Class<T> paramClass)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

listParameter in interface HibernateCriteriaBuilder

Type Parameters:

T - the type of each argument to the parameter

Parameters:

paramClass - the type of each argument to the parameter

listParameter

public <T> JpaParameterExpression<List<T>> listParameter(Class<T> paramClass,
 String name)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

listParameter in interface HibernateCriteriaBuilder

Type Parameters:

T - the type of each argument to the parameter

Parameters:

paramClass - the type of each argument to the parameter

name - the parameter name

concat

public SqmExpression<String> concat(List<Expression<String>> expressions)

Specified by:

concat in interface CriteriaBuilder

Specified by:

concat in interface HibernateCriteriaBuilder

concat

public SqmExpression<String> concat(Expression<String> x,
 Expression<String> y)

Specified by:

concat in interface CriteriaBuilder

Specified by:

concat in interface HibernateCriteriaBuilder

Specified by:

concat in interface NodeBuilder

concat

public SqmExpression<String> concat(Expression<String> x,
 String y)

Specified by:

concat in interface CriteriaBuilder

Specified by:

concat in interface HibernateCriteriaBuilder

Specified by:

concat in interface NodeBuilder

concat

public SqmExpression<String> concat(String x,
 Expression<String> y)

Specified by:

concat in interface CriteriaBuilder

Specified by:

concat in interface HibernateCriteriaBuilder

Specified by:

concat in interface NodeBuilder

concat

public SqmExpression<String> concat(String x,
 String y)

Specified by:

concat in interface HibernateCriteriaBuilder

Specified by:

concat in interface NodeBuilder

substring

public SqmFunction<String> substring(Expression<String> source,
 Expression<Integer> from)

Specified by:

substring in interface CriteriaBuilder

Specified by:

substring in interface HibernateCriteriaBuilder

Specified by:

substring in interface NodeBuilder

substring

public SqmFunction<String> substring(Expression<String> source,
 int from)

Specified by:

substring in interface CriteriaBuilder

Specified by:

substring in interface HibernateCriteriaBuilder

Specified by:

substring in interface NodeBuilder

substring

public SqmFunction<String> substring(Expression<String> source,
 Expression<Integer> from,
 Expression<Integer> len)

Specified by:

substring in interface CriteriaBuilder

Specified by:

substring in interface HibernateCriteriaBuilder

Specified by:

substring in interface NodeBuilder

substring

public SqmFunction<String> substring(Expression<String> source,
 int from,
 int len)

Specified by:

substring in interface CriteriaBuilder

Specified by:

substring in interface HibernateCriteriaBuilder

Specified by:

substring in interface NodeBuilder

trim

public SqmFunction<String> trim(Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

trim

public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
 Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

trim

public SqmFunction<String> trim(Expression<Character> trimChar,
 Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

trim

public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
 Expression<Character> trimChar,
 Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

trim

public SqmFunction<String> trim(char trimChar,
 Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

trim

public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts,
 char trimChar,
 Expression<String> source)

Specified by:

trim in interface CriteriaBuilder

Specified by:

trim in interface HibernateCriteriaBuilder

Specified by:

trim in interface NodeBuilder

lower

public SqmFunction<String> lower(Expression<String> x)

Specified by:

lower in interface CriteriaBuilder

Specified by:

lower in interface HibernateCriteriaBuilder

Specified by:

lower in interface NodeBuilder

upper

public SqmFunction<String> upper(Expression<String> x)

Specified by:

upper in interface CriteriaBuilder

Specified by:

upper in interface HibernateCriteriaBuilder

Specified by:

upper in interface NodeBuilder

length

public SqmFunction<Integer> length(Expression<String> argument)

Specified by:

length in interface CriteriaBuilder

Specified by:

length in interface HibernateCriteriaBuilder

Specified by:

length in interface NodeBuilder

locate

public SqmFunction<Integer> locate(Expression<String> source,
 Expression<String> pattern)

Specified by:

locate in interface CriteriaBuilder

Specified by:

locate in interface HibernateCriteriaBuilder

Specified by:

locate in interface NodeBuilder

locate

public SqmFunction<Integer> locate(Expression<String> source,
 String pattern)

Specified by:

locate in interface CriteriaBuilder

Specified by:

locate in interface HibernateCriteriaBuilder

Specified by:

locate in interface NodeBuilder

locate

public SqmFunction<Integer> locate(Expression<String> source,
 Expression<String> pattern,
 Expression<Integer> startPosition)

Specified by:

locate in interface CriteriaBuilder

Specified by:

locate in interface HibernateCriteriaBuilder

Specified by:

locate in interface NodeBuilder

locate

public SqmFunction<Integer> locate(Expression<String> source,
 String pattern,
 int startPosition)

Specified by:

locate in interface CriteriaBuilder

Specified by:

locate in interface HibernateCriteriaBuilder

Specified by:

locate in interface NodeBuilder

currentDate

public SqmFunction<Date> currentDate()

Specified by:

currentDate in interface CriteriaBuilder

Specified by:

currentDate in interface HibernateCriteriaBuilder

Specified by:

currentDate in interface NodeBuilder

currentTimestamp

public SqmFunction<Timestamp> currentTimestamp()

Specified by:

currentTimestamp in interface CriteriaBuilder

Specified by:

currentTimestamp in interface HibernateCriteriaBuilder

Specified by:

currentTimestamp in interface NodeBuilder

currentTime

public SqmFunction<Time> currentTime()

Specified by:

currentTime in interface CriteriaBuilder

Specified by:

currentTime in interface HibernateCriteriaBuilder

Specified by:

currentTime in interface NodeBuilder

currentInstant

public SqmFunction<Instant> currentInstant()

Specified by:

currentInstant in interface HibernateCriteriaBuilder

Specified by:

currentInstant in interface NodeBuilder

localDate

public JpaExpression<LocalDate> localDate()

Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local date.

Specified by:

localDate in interface CriteriaBuilder

Specified by:

localDate in interface HibernateCriteriaBuilder

Returns:

expression for current date

localDateTime

public JpaExpression<LocalDateTime> localDateTime()

Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local datetime.

Specified by:

localDateTime in interface CriteriaBuilder

Specified by:

localDateTime in interface HibernateCriteriaBuilder

Returns:

expression for current timestamp

localTime

public JpaExpression<LocalTime> localTime()

Description copied from interface: HibernateCriteriaBuilder

Create expression to return current local time.

Specified by:

localTime in interface CriteriaBuilder

Specified by:

localTime in interface HibernateCriteriaBuilder

Returns:

expression for current time

function

public <T> SqmFunction<T> function(String name,
 Class<T> type,
 Expression<?>[] args)

Specified by:

function in interface CriteriaBuilder

Specified by:

function in interface HibernateCriteriaBuilder

Specified by:

function in interface NodeBuilder

all

public <Y> SqmModifiedSubQueryExpression<Y> all(Subquery<Y> subquery)

Specified by:

all in interface CriteriaBuilder

Specified by:

all in interface HibernateCriteriaBuilder

Specified by:

all in interface NodeBuilder

some

public <Y> SqmModifiedSubQueryExpression<Y> some(Subquery<Y> subquery)

Specified by:

some in interface CriteriaBuilder

Specified by:

some in interface HibernateCriteriaBuilder

Specified by:

some in interface NodeBuilder

any

public <Y> SqmModifiedSubQueryExpression<Y> any(Subquery<Y> subquery)

Specified by:

any in interface CriteriaBuilder

Specified by:

any in interface HibernateCriteriaBuilder

Specified by:

any in interface NodeBuilder

keys

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

Specified by:

keys in interface CriteriaBuilder

Specified by:

keys in interface HibernateCriteriaBuilder

Specified by:

keys in interface NodeBuilder

indexes

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

Specified by:

indexes in interface HibernateCriteriaBuilder

Specified by:

indexes in interface NodeBuilder

value

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

Creates an expression for the value with the given "type inference" information

value

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

Specified by:

value in interface HibernateCriteriaBuilder

values

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

Specified by:

values in interface CriteriaBuilder

Specified by:

values in interface HibernateCriteriaBuilder

Specified by:

values in interface NodeBuilder

size

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

Specified by:

size in interface CriteriaBuilder

Specified by:

size in interface HibernateCriteriaBuilder

Specified by:

size in interface NodeBuilder

size

public <C extends Collection<?>>
SqmExpression<Integer> size(C collection)

Specified by:

size in interface CriteriaBuilder

Specified by:

size in interface HibernateCriteriaBuilder

Specified by:

size in interface NodeBuilder

coalesce

public <T> SqmCoalesce<T> coalesce()

Specified by:

coalesce in interface CriteriaBuilder

Specified by:

coalesce in interface HibernateCriteriaBuilder

Specified by:

coalesce in interface NodeBuilder

coalesce

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

Specified by:

coalesce in interface CriteriaBuilder

Specified by:

coalesce in interface HibernateCriteriaBuilder

Specified by:

coalesce in interface NodeBuilder

coalesce

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

Specified by:

coalesce in interface CriteriaBuilder

Specified by:

coalesce in interface HibernateCriteriaBuilder

Specified by:

coalesce in interface NodeBuilder

nullif

public <Y> SqmExpression<Y> nullif(Expression<Y> x,
 Expression<?> y)

Specified by:

nullif in interface CriteriaBuilder

Specified by:

nullif in interface HibernateCriteriaBuilder

Specified by:

nullif in interface NodeBuilder

nullif

public <Y> SqmExpression<Y> nullif(Expression<Y> x,
 Y y)

Specified by:

nullif in interface CriteriaBuilder

Specified by:

nullif in interface HibernateCriteriaBuilder

Specified by:

nullif in interface NodeBuilder

selectCase

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

Specified by:

selectCase in interface CriteriaBuilder

Specified by:

selectCase in interface HibernateCriteriaBuilder

Specified by:

selectCase in interface NodeBuilder

selectCase

public <R> SqmCaseSearched<R> selectCase()

Specified by:

selectCase in interface CriteriaBuilder

Specified by:

selectCase in interface HibernateCriteriaBuilder

Specified by:

selectCase in interface NodeBuilder

mapSize

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

Description copied from interface: HibernateCriteriaBuilder

Create an expression that tests the size of a map.

Specified by:

mapSize in interface HibernateCriteriaBuilder

Specified by:

mapSize in interface NodeBuilder

Parameters:

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

Returns:

size expression

mapSize

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

Description copied from interface: HibernateCriteriaBuilder

Create an expression that tests the size of a map.

Specified by:

mapSize in interface HibernateCriteriaBuilder

Specified by:

mapSize in interface NodeBuilder

Parameters:

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

Returns:

size expression

and

public SqmPredicate and(Expression<Boolean> x,
 Expression<Boolean> y)

Specified by:

and in interface CriteriaBuilder

Specified by:

and in interface HibernateCriteriaBuilder

Specified by:

and in interface NodeBuilder

and

public SqmPredicate and(Predicate... restrictions)

Specified by:

and in interface CriteriaBuilder

Specified by:

and in interface HibernateCriteriaBuilder

Specified by:

and in interface NodeBuilder

and

public SqmPredicate and(List<Predicate> restrictions)

Specified by:

and in interface CriteriaBuilder

Specified by:

and in interface HibernateCriteriaBuilder

or

public SqmPredicate or(Expression<Boolean> x,
 Expression<Boolean> y)

Specified by:

or in interface CriteriaBuilder

Specified by:

or in interface HibernateCriteriaBuilder

Specified by:

or in interface NodeBuilder

or

public SqmPredicate or(Predicate... restrictions)

Specified by:

or in interface CriteriaBuilder

Specified by:

or in interface HibernateCriteriaBuilder

Specified by:

or in interface NodeBuilder

or

public SqmPredicate or(List<Predicate> restrictions)

Specified by:

or in interface CriteriaBuilder

Specified by:

or in interface HibernateCriteriaBuilder

not

public SqmPredicate not(Expression<Boolean> restriction)

Specified by:

not in interface CriteriaBuilder

Specified by:

not in interface HibernateCriteriaBuilder

Specified by:

not in interface NodeBuilder

conjunction

public SqmPredicate conjunction()

Specified by:

conjunction in interface CriteriaBuilder

Specified by:

conjunction in interface HibernateCriteriaBuilder

Specified by:

conjunction in interface NodeBuilder

disjunction

public SqmPredicate disjunction()

Specified by:

disjunction in interface CriteriaBuilder

Specified by:

disjunction in interface HibernateCriteriaBuilder

Specified by:

disjunction in interface NodeBuilder

isTrue

public SqmPredicate isTrue(Expression<Boolean> x)

Specified by:

isTrue in interface CriteriaBuilder

Specified by:

isTrue in interface HibernateCriteriaBuilder

Specified by:

isTrue in interface NodeBuilder

isFalse

public SqmPredicate isFalse(Expression<Boolean> x)

Specified by:

isFalse in interface CriteriaBuilder

Specified by:

isFalse in interface HibernateCriteriaBuilder

Specified by:

isFalse in interface NodeBuilder

isNull

public SqmPredicate isNull(Expression<?> x)

Specified by:

isNull in interface CriteriaBuilder

Specified by:

isNull in interface HibernateCriteriaBuilder

Specified by:

isNull in interface NodeBuilder

isNotNull

public SqmPredicate isNotNull(Expression<?> x)

Specified by:

isNotNull in interface CriteriaBuilder

Specified by:

isNotNull in interface HibernateCriteriaBuilder

Specified by:

isNotNull in interface NodeBuilder

between

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

Specified by:

between in interface CriteriaBuilder

Specified by:

between in interface HibernateCriteriaBuilder

Specified by:

between in interface NodeBuilder

between

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

Specified by:

between in interface CriteriaBuilder

Specified by:

between in interface HibernateCriteriaBuilder

Specified by:

between in interface NodeBuilder

equal

public SqmPredicate equal(Expression<?> x,
 Expression<?> y)

Specified by:

equal in interface CriteriaBuilder

Specified by:

equal in interface HibernateCriteriaBuilder

Specified by:

equal in interface NodeBuilder

equal

public SqmPredicate equal(Expression<?> x,
 Object y)

Specified by:

equal in interface CriteriaBuilder

Specified by:

equal in interface HibernateCriteriaBuilder

Specified by:

equal in interface NodeBuilder

notEqual

public SqmPredicate notEqual(Expression<?> x,
 Expression<?> y)

Specified by:

notEqual in interface CriteriaBuilder

Specified by:

notEqual in interface HibernateCriteriaBuilder

Specified by:

notEqual in interface NodeBuilder

notEqual

public SqmPredicate notEqual(Expression<?> x,
 Object y)

Specified by:

notEqual in interface CriteriaBuilder

Specified by:

notEqual in interface HibernateCriteriaBuilder

Specified by:

notEqual in interface NodeBuilder

distinctFrom

public SqmPredicate distinctFrom(Expression<?> x,
 Expression<?> y)

Specified by:

distinctFrom in interface HibernateCriteriaBuilder

Specified by:

distinctFrom in interface NodeBuilder

distinctFrom

public SqmPredicate distinctFrom(Expression<?> x,
 Object y)

Specified by:

distinctFrom in interface HibernateCriteriaBuilder

Specified by:

distinctFrom in interface NodeBuilder

notDistinctFrom

public SqmPredicate notDistinctFrom(Expression<?> x,
 Expression<?> y)

Specified by:

notDistinctFrom in interface HibernateCriteriaBuilder

Specified by:

notDistinctFrom in interface NodeBuilder

notDistinctFrom

public SqmPredicate notDistinctFrom(Expression<?> x,
 Object y)

Specified by:

notDistinctFrom in interface HibernateCriteriaBuilder

Specified by:

notDistinctFrom in interface NodeBuilder

greaterThan

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

Specified by:

greaterThan in interface CriteriaBuilder

Specified by:

greaterThan in interface HibernateCriteriaBuilder

Specified by:

greaterThan in interface NodeBuilder

greaterThan

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

Specified by:

greaterThan in interface CriteriaBuilder

Specified by:

greaterThan in interface HibernateCriteriaBuilder

Specified by:

greaterThan in interface NodeBuilder

greaterThanOrEqualTo

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

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

Specified by:

greaterThanOrEqualTo in interface HibernateCriteriaBuilder

Specified by:

greaterThanOrEqualTo in interface NodeBuilder

greaterThanOrEqualTo

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

Specified by:

greaterThanOrEqualTo in interface CriteriaBuilder

Specified by:

greaterThanOrEqualTo in interface HibernateCriteriaBuilder

Specified by:

greaterThanOrEqualTo in interface NodeBuilder

lessThan

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

Specified by:

lessThan in interface CriteriaBuilder

Specified by:

lessThan in interface HibernateCriteriaBuilder

Specified by:

lessThan in interface NodeBuilder

lessThan

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

Specified by:

lessThan in interface CriteriaBuilder

Specified by:

lessThan in interface HibernateCriteriaBuilder

Specified by:

lessThan in interface NodeBuilder

lessThanOrEqualTo

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

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

Specified by:

lessThanOrEqualTo in interface HibernateCriteriaBuilder

Specified by:

lessThanOrEqualTo in interface NodeBuilder

lessThanOrEqualTo

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

Specified by:

lessThanOrEqualTo in interface CriteriaBuilder

Specified by:

lessThanOrEqualTo in interface HibernateCriteriaBuilder

Specified by:

lessThanOrEqualTo in interface NodeBuilder

gt

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

Specified by:

gt in interface CriteriaBuilder

Specified by:

gt in interface HibernateCriteriaBuilder

Specified by:

gt in interface NodeBuilder

gt

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

Specified by:

gt in interface CriteriaBuilder

Specified by:

gt in interface HibernateCriteriaBuilder

Specified by:

gt in interface NodeBuilder

ge

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

Specified by:

ge in interface CriteriaBuilder

Specified by:

ge in interface HibernateCriteriaBuilder

Specified by:

ge in interface NodeBuilder

ge

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

Specified by:

ge in interface CriteriaBuilder

Specified by:

ge in interface HibernateCriteriaBuilder

Specified by:

ge in interface NodeBuilder

lt

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

Specified by:

lt in interface CriteriaBuilder

Specified by:

lt in interface HibernateCriteriaBuilder

Specified by:

lt in interface NodeBuilder

lt

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

Specified by:

lt in interface CriteriaBuilder

Specified by:

lt in interface HibernateCriteriaBuilder

Specified by:

lt in interface NodeBuilder

le

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

Specified by:

le in interface CriteriaBuilder

Specified by:

le in interface HibernateCriteriaBuilder

Specified by:

le in interface NodeBuilder

le

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

Specified by:

le in interface CriteriaBuilder

Specified by:

le in interface HibernateCriteriaBuilder

Specified by:

le in interface NodeBuilder

isEmpty

public <C extends Collection<?>> SqmPredicate isEmpty(Expression<C> collection)

Specified by:

isEmpty in interface CriteriaBuilder

Specified by:

isEmpty in interface HibernateCriteriaBuilder

Specified by:

isEmpty in interface NodeBuilder

isNotEmpty

public <C extends Collection<?>> SqmPredicate isNotEmpty(Expression<C> collection)

Specified by:

isNotEmpty in interface CriteriaBuilder

Specified by:

isNotEmpty in interface HibernateCriteriaBuilder

Specified by:

isNotEmpty in interface NodeBuilder

isMember

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

Specified by:

isMember in interface CriteriaBuilder

Specified by:

isMember in interface HibernateCriteriaBuilder

Specified by:

isMember in interface NodeBuilder

isMember

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

Specified by:

isMember in interface CriteriaBuilder

Specified by:

isMember in interface HibernateCriteriaBuilder

Specified by:

isMember in interface NodeBuilder

isNotMember

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

Specified by:

isNotMember in interface CriteriaBuilder

Specified by:

isNotMember in interface HibernateCriteriaBuilder

Specified by:

isNotMember in interface NodeBuilder

isNotMember

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

Specified by:

isNotMember in interface CriteriaBuilder

Specified by:

isNotMember in interface HibernateCriteriaBuilder

Specified by:

isNotMember in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 Expression<String> pattern)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 String pattern)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 Expression<String> pattern,
 Expression<Character> escapeChar)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 Expression<String> pattern,
 char escapeChar)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 String pattern,
 Expression<Character> escapeChar)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

like

public SqmPredicate like(Expression<String> searchString,
 String pattern,
 char escapeChar)

Specified by:

like in interface CriteriaBuilder

Specified by:

like in interface HibernateCriteriaBuilder

Specified by:

like in interface NodeBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 Expression<String> pattern)

Specified by:

ilike in interface HibernateCriteriaBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 String pattern)

Specified by:

ilike in interface HibernateCriteriaBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 Expression<String> pattern,
 Expression<Character> escapeChar)

Specified by:

ilike in interface HibernateCriteriaBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 Expression<String> pattern,
 char escapeChar)

Specified by:

ilike in interface HibernateCriteriaBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 String pattern,
 Expression<Character> escapeChar)

Specified by:

ilike in interface HibernateCriteriaBuilder

ilike

public SqmPredicate ilike(Expression<String> searchString,
 String pattern,
 char escapeChar)

Specified by:

ilike in interface HibernateCriteriaBuilder

notLike

public SqmPredicate notLike(Expression<String> x,
 Expression<String> pattern)

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notLike

public SqmPredicate notLike(Expression<String> x,
 String pattern)

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notLike

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

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notLike

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

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notLike

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

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notLike

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

Specified by:

notLike in interface CriteriaBuilder

Specified by:

notLike in interface HibernateCriteriaBuilder

Specified by:

notLike in interface NodeBuilder

notIlike

public SqmPredicate notIlike(Expression<String> x,
 Expression<String> pattern)

Specified by:

notIlike in interface HibernateCriteriaBuilder

notIlike

public SqmPredicate notIlike(Expression<String> x,
 String pattern)

Specified by:

notIlike in interface HibernateCriteriaBuilder

notIlike

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

Specified by:

notIlike in interface HibernateCriteriaBuilder

notIlike

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

Specified by:

notIlike in interface HibernateCriteriaBuilder

notIlike

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

Specified by:

notIlike in interface HibernateCriteriaBuilder

notIlike

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

Specified by:

notIlike in interface HibernateCriteriaBuilder

in

public <T> SqmInPredicate<T> in(Expression<? extends T> expression)

Specified by:

in in interface CriteriaBuilder

Specified by:

in in interface HibernateCriteriaBuilder

Specified by:

in in interface NodeBuilder

in

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

Specified by:

in in interface HibernateCriteriaBuilder

Specified by:

in in interface NodeBuilder

in

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

Specified by:

in in interface HibernateCriteriaBuilder

Specified by:

in in interface NodeBuilder

in

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

Specified by:

in in interface HibernateCriteriaBuilder

Specified by:

in in interface NodeBuilder

in

public <T> SqmInPredicate<T> in(Expression<? extends T> expression,
 SqmSubQuery<T> subQuery)

Specified by:

in in interface NodeBuilder

exists

public SqmPredicate exists(Subquery<?> subQuery)

Specified by:

exists in interface CriteriaBuilder

Specified by:

exists in interface HibernateCriteriaBuilder

Specified by:

exists in interface NodeBuilder

isMapEmpty

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

Description copied from interface: HibernateCriteriaBuilder

Create a predicate that tests whether a Map is empty.

Specified by:

isMapEmpty in interface HibernateCriteriaBuilder

Specified by:

isMapEmpty in interface NodeBuilder

Parameters:

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

Returns:

is-empty predicate

isMapNotEmpty

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

isMapNotEmpty in interface HibernateCriteriaBuilder

Specified by:

isMapNotEmpty in interface NodeBuilder

Parameters:

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

Returns:

is-not-empty predicate

sql

public <T> SqmFunction<T> sql(String pattern,
 Class<T> type,
 Expression<?>... arguments)

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

sql in interface HibernateCriteriaBuilder

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

public SqmFunction<String> format(Expression<? extends TemporalAccessor> datetime,
 String pattern)

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

format in interface HibernateCriteriaBuilder

Parameters:

datetime - the datetime expression to format

pattern - the pattern to use for formatting

Returns:

format expression

extract

public <N,
T extends Temporal> SqmExpression<N> extract(TemporalField<N,T> field,
 Expression<T> temporal)

Specified by:

extract in interface CriteriaBuilder

Specified by:

extract in interface HibernateCriteriaBuilder

year

public SqmFunction<Integer> year(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

year in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

month

public SqmFunction<Integer> month(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

month in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

day

public SqmFunction<Integer> day(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

day in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

hour

public SqmFunction<Integer> hour(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

hour in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

minute

public SqmFunction<Integer> minute(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

minute in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

second

public SqmFunction<Float> second(Expression<? extends TemporalAccessor> datetime)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

second in interface HibernateCriteriaBuilder

Parameters:

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

Returns:

the extracted value

truncate

public <T extends TemporalAccessor> SqmFunction<T> truncate(Expression<T> datetime,
 TemporalUnit temporalUnit)

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

truncate in interface HibernateCriteriaBuilder

Parameters:

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

temporalUnit - the temporal unit for truncation

Returns:

the truncated value

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 int start)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 int start)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 Expression<Integer> start)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 Expression<Integer> start)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 int start,
 int length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 int start,
 int length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 Expression<Integer> start,
 int length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 Expression<Integer> start,
 int length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 int start,
 Expression<Integer> length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 int start,
 Expression<Integer> length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 String replacement,
 Expression<Integer> start,
 Expression<Integer> length)

Specified by:

overlay in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)

overlay

public SqmFunction<String> overlay(Expression<String> string,
 Expression<String> replacement,
 Expression<Integer> start,
 Expression<Integer> length)

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

overlay in interface HibernateCriteriaBuilder

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

public SqmFunction<String> pad(Expression<String> x,
 int length)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 int length)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(Expression<String> x,
 Expression<Integer> length)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 Expression<Integer> length)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(Expression<String> x,
 int length,
 char padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 int length,
 char padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(Expression<String> x,
 int length,
 Expression<Character> padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 int length,
 Expression<Character> padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(Expression<String> x,
 Expression<Integer> length,
 char padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 Expression<Integer> length,
 char padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(Expression<String> x,
 Expression<Integer> length,
 Expression<Character> padChar)

Specified by:

pad in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)

pad

public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts,
 Expression<String> x,
 Expression<Integer> length,
 Expression<Character> padChar)

Description copied from interface: HibernateCriteriaBuilder

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.

Specified by:

pad in interface HibernateCriteriaBuilder

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

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

repeat in interface HibernateCriteriaBuilder

Parameters:

x - the string expression to concatenate

times - the number of times it should be repeated

Returns:

repeat expression

repeat

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

repeat in interface HibernateCriteriaBuilder

Parameters:

x - the string expression to concatenate

times - the number of times it should be repeated

Returns:

repeat expression

repeat

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

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

repeat in interface HibernateCriteriaBuilder

Parameters:

x - the string expression to concatenate

times - the number of times it should be repeated

Returns:

repeat expression

left

public SqmFunction<String> left(Expression<String> x,
 int length)

Specified by:

left in interface CriteriaBuilder

Specified by:

left in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.left(Expression, Expression)

left

public SqmFunction<String> left(Expression<String> x,
 Expression<Integer> length)

Description copied from interface: HibernateCriteriaBuilder

Extract the length leftmost characters of a string.

Specified by:

left in interface CriteriaBuilder

Specified by:

left in interface HibernateCriteriaBuilder

Parameters:

x - original string

length - number of characters

Returns:

left expression

right

public SqmFunction<String> right(Expression<String> x,
 int length)

Specified by:

right in interface CriteriaBuilder

Specified by:

right in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.right(Expression, Expression)

right

public SqmFunction<String> right(Expression<String> x,
 Expression<Integer> length)

Description copied from interface: HibernateCriteriaBuilder

Extract the length rightmost characters of a string.

Specified by:

right in interface CriteriaBuilder

Specified by:

right in interface HibernateCriteriaBuilder

Parameters:

x - original string

length - number of characters

Returns:

left expression

replace

public SqmFunction<String> replace(Expression<String> x,
 String pattern,
 String replacement)

Specified by:

replace in interface CriteriaBuilder

Specified by:

replace in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace

public SqmFunction<String> replace(Expression<String> x,
 String pattern,
 Expression<String> replacement)

Specified by:

replace in interface CriteriaBuilder

Specified by:

replace in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace

public SqmFunction<String> replace(Expression<String> x,
 Expression<String> pattern,
 String replacement)

Specified by:

replace in interface CriteriaBuilder

Specified by:

replace in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.replace(Expression, Expression, Expression)

replace

public SqmFunction<String> replace(Expression<String> x,
 Expression<String> pattern,
 Expression<String> replacement)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

replace in interface CriteriaBuilder

Specified by:

replace in interface HibernateCriteriaBuilder

Parameters:

x - original string

pattern - the string to be replaced

replacement - the new replacement string

Returns:

replace expression

collate

public SqmFunction<String> collate(Expression<String> x,
 String collation)

Specified by:

collate in interface HibernateCriteriaBuilder

log10

public SqmFunction<Double> log10(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

log10 in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

base-10 logarithm

log

public SqmFunction<Double> log(Number b,
 Expression<? extends Number> x)

Specified by:

log in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.log(Expression, Expression)

log

public SqmFunction<Double> log(Expression<? extends Number> b,
 Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

log in interface HibernateCriteriaBuilder

Parameters:

b - base

x - expression

Returns:

arbitrary-base logarithm

pi

public SqmFunction<Double> pi()

Description copied from interface: HibernateCriteriaBuilder

Literal expression corresponding to the value of pi.

Specified by:

pi in interface HibernateCriteriaBuilder

Returns:

pi expression

sin

public SqmFunction<Double> sin(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the sine of its argument.

Specified by:

sin in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

sine

cos

public SqmFunction<Double> cos(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the cosine of its argument.

Specified by:

cos in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

cosine

tan

public SqmFunction<Double> tan(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

Create an expression that returns the tangent of its argument.

Specified by:

tan in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

tangent

asin

public SqmFunction<Double> asin(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

asin in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse sine

acos

public SqmFunction<Double> acos(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

acos in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse cosine

atan

public SqmFunction<Double> atan(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

atan in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

inverse tangent

atan2

public SqmFunction<Double> atan2(Number y,
 Expression<? extends Number> x)

Specified by:

atan2 in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.atan2(Expression, Expression)

atan2

public SqmFunction<Double> atan2(Expression<? extends Number> y,
 Number x)

Specified by:

atan2 in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.atan2(Expression, Expression)

atan2

public SqmFunction<Double> atan2(Expression<? extends Number> y,
 Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

atan2 in interface HibernateCriteriaBuilder

Parameters:

y - y coordinate

x - x coordinate

Returns:

2-argument inverse tangent

sinh

public SqmFunction<Double> sinh(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

sinh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic sine

cosh

public SqmFunction<Double> cosh(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

cosh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic cosine

tanh

public SqmFunction<Double> tanh(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

tanh in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

hyperbolic tangent

degrees

public SqmFunction<Double> degrees(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

degrees in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

degrees

radians

public SqmFunction<Double> radians(Expression<? extends Number> x)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

radians in interface HibernateCriteriaBuilder

Parameters:

x - expression

Returns:

radians

createWindow

public SqmWindow createWindow()

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

createWindow in interface HibernateCriteriaBuilder

Returns:

the empty window

frameUnboundedPreceding

public SqmWindowFrame frameUnboundedPreceding()

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

frameUnboundedPreceding in interface HibernateCriteriaBuilder

Returns:

the window frame

frameBetweenPreceding

public SqmWindowFrame frameBetweenPreceding(int offset)

Specified by:

frameBetweenPreceding in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.frameBetweenPreceding(Expression)

frameBetweenPreceding

public SqmWindowFrame frameBetweenPreceding(Expression<?> offset)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

frameBetweenPreceding in interface HibernateCriteriaBuilder

Parameters:

offset - the offset expression

Returns:

the window frame

frameCurrentRow

public SqmWindowFrame frameCurrentRow()

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

frameCurrentRow in interface HibernateCriteriaBuilder

Returns:

the window frame

frameBetweenFollowing

public SqmWindowFrame frameBetweenFollowing(int offset)

Specified by:

frameBetweenFollowing in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.frameBetweenFollowing(Expression)

frameBetweenFollowing

public SqmWindowFrame frameBetweenFollowing(Expression<?> offset)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

frameBetweenFollowing in interface HibernateCriteriaBuilder

Parameters:

offset - the offset expression

Returns:

the window frame

frameUnboundedFollowing

public SqmWindowFrame frameUnboundedFollowing()

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

frameUnboundedFollowing in interface HibernateCriteriaBuilder

Returns:

the window frame

windowFunction

public <T> SqmExpression<T> windowFunction(String name,
 Class<T> type,
 JpaWindow window,
 Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

windowFunction in interface HibernateCriteriaBuilder

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

public SqmExpression<Long> rowNumber(JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a row_number window function expression.

Specified by:

rowNumber in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

firstValue

public <T> SqmExpression<T> firstValue(Expression<T> argument,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a first_value window function expression.

Specified by:

firstValue in interface HibernateCriteriaBuilder

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:

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

lastValue

public <T> SqmExpression<T> lastValue(Expression<T> argument,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a last_value window function expression.

Specified by:

lastValue in interface HibernateCriteriaBuilder

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:

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

nthValue

public <T> SqmExpression<T> nthValue(Expression<T> argument,
 int n,
 JpaWindow window)

Specified by:

nthValue in interface HibernateCriteriaBuilder

See Also:

• nthValue

nthValue

public <T> SqmExpression<T> nthValue(Expression<T> argument,
 Expression<Integer> n,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a nth_value window function expression.

Specified by:

nthValue in interface HibernateCriteriaBuilder

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:

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

rank

public SqmExpression<Long> rank(JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a rank window function expression.

Specified by:

rank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

denseRank

public SqmExpression<Long> denseRank(JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a dense_rank window function expression.

Specified by:

denseRank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

percentRank

public SqmExpression<Double> percentRank(JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a percent_rank window function expression.

Specified by:

percentRank in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

cumeDist

public SqmExpression<Double> cumeDist(JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a cume_dist window function expression.

Specified by:

cumeDist in interface HibernateCriteriaBuilder

Parameters:

window - window over which the function will be applied

Returns:

window function expression

See Also:

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

functionAggregate

public <T> SqmExpression<T> functionAggregate(String name,
 Class<T> type,
 JpaPredicate filter,
 Expression<?>... args)

Specified by:

functionAggregate in interface HibernateCriteriaBuilder

See Also:

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

functionAggregate

public <T> SqmExpression<T> functionAggregate(String name,
 Class<T> type,
 JpaWindow window,
 Expression<?>... args)

Specified by:

functionAggregate in interface HibernateCriteriaBuilder

See Also:

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

functionAggregate

public <T> SqmExpression<T> functionAggregate(String name,
 Class<T> type,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

Create a generic aggregate function expression.

Specified by:

functionAggregate in interface HibernateCriteriaBuilder

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

public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
 JpaPredicate filter)

Specified by:

sum in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)

sum

public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
 JpaWindow window)

Specified by:

sum in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)

sum

public <N extends Number> SqmExpression<Number> sum(Expression<N> argument,
 JpaPredicate filter,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a sum aggregate function expression.

Specified by:

sum in interface HibernateCriteriaBuilder

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:

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

avg

public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
 JpaPredicate filter)

Specified by:

avg in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)

avg

public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
 JpaWindow window)

Specified by:

avg in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)

avg

public <N extends Number> SqmExpression<Double> avg(Expression<N> argument,
 JpaPredicate filter,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create an avg aggregate function expression.

Specified by:

avg in interface HibernateCriteriaBuilder

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:

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

count

public SqmExpression<Long> count(Expression<?> argument,
 JpaPredicate filter)

Specified by:

count in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)

count

public SqmExpression<Long> count(Expression<?> argument,
 JpaWindow window)

Specified by:

count in interface HibernateCriteriaBuilder

See Also:

• HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)

count

public SqmExpression<Long> count(Expression<?> argument,
 JpaPredicate filter,
 JpaWindow window)

Description copied from interface: HibernateCriteriaBuilder

Create a count aggregate function expression.

Specified by:

count in interface HibernateCriteriaBuilder

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:

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

functionWithinGroup

public <T> SqmExpression<T> functionWithinGroup(String name,
 Class<T> type,
 JpaOrder order,
 Expression<?>... args)

Specified by:

functionWithinGroup in interface HibernateCriteriaBuilder

See Also:

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

functionWithinGroup

public <T> SqmExpression<T> functionWithinGroup(String name,
 Class<T> type,
 JpaOrder order,
 JpaPredicate filter,
 Expression<?>... args)

Specified by:

functionWithinGroup in interface HibernateCriteriaBuilder

See Also:

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

functionWithinGroup

public <T> SqmExpression<T> functionWithinGroup(String name,
 Class<T> type,
 JpaOrder order,
 JpaWindow window,
 Expression<?>... args)

Specified by:

functionWithinGroup in interface HibernateCriteriaBuilder

See Also:

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

functionWithinGroup

public <T> SqmExpression<T> functionWithinGroup(String name,
 Class<T> type,
 JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

Create a generic ordered set-aggregate function expression.

Specified by:

functionWithinGroup in interface HibernateCriteriaBuilder

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

public SqmExpression<String> listagg(JpaOrder order,
 Expression<String> argument,
 String separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 Expression<String> argument,
 Expression<String> separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaPredicate filter,
 Expression<String> argument,
 String separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaPredicate filter,
 Expression<String> argument,
 Expression<String> separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaWindow window,
 Expression<String> argument,
 String separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaWindow window,
 Expression<String> argument,
 Expression<String> separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<String> argument,
 String separator)

Specified by:

listagg in interface HibernateCriteriaBuilder

See Also:

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

listagg

public SqmExpression<String> listagg(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<String> argument,
 Expression<String> separator)

Description copied from interface: HibernateCriteriaBuilder

Create a listagg ordered set-aggregate function expression.

Specified by:

listagg in interface HibernateCriteriaBuilder

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:

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

mode

public <T> SqmExpression<T> mode(Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

mode in interface HibernateCriteriaBuilder

See Also:

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

mode

public <T> SqmExpression<T> mode(JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

mode in interface HibernateCriteriaBuilder

See Also:

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

mode

public <T> SqmExpression<T> mode(JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

mode in interface HibernateCriteriaBuilder

See Also:

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

mode

public <T> SqmExpression<T> mode(JpaPredicate filter,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Description copied from interface: HibernateCriteriaBuilder

Create a mode ordered set-aggregate function expression.

Specified by:

mode in interface HibernateCriteriaBuilder

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:

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

percentileCont

public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileCont in interface HibernateCriteriaBuilder

See Also:

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

percentileCont

public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
 JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileCont in interface HibernateCriteriaBuilder

See Also:

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

percentileCont

public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileCont in interface HibernateCriteriaBuilder

See Also:

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

percentileCont

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

Description copied from interface: HibernateCriteriaBuilder

Create a percentile_cont ordered set-aggregate function expression.

Specified by:

percentileCont in interface HibernateCriteriaBuilder

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:

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

percentileDisc

public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileDisc in interface HibernateCriteriaBuilder

See Also:

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

percentileDisc

public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
 JpaPredicate filter,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileDisc in interface HibernateCriteriaBuilder

See Also:

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

percentileDisc

public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument,
 JpaWindow window,
 Expression<T> sortExpression,
 SortDirection sortOrder,
 NullPrecedence nullPrecedence)

Specified by:

percentileDisc in interface HibernateCriteriaBuilder

See Also:

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

percentileDisc

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

Description copied from interface: HibernateCriteriaBuilder

Create a percentile_disc ordered set-aggregate function expression.

Specified by:

percentileDisc in interface HibernateCriteriaBuilder

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:

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

rank

public SqmExpression<Long> rank(JpaOrder order,
 Expression<?>... arguments)

Specified by:

rank in interface HibernateCriteriaBuilder

See Also:

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

rank

public SqmExpression<Long> rank(JpaOrder order,
 JpaPredicate filter,
 Expression<?>... arguments)

Specified by:

rank in interface HibernateCriteriaBuilder

See Also:

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

rank

public SqmExpression<Long> rank(JpaOrder order,
 JpaWindow window,
 Expression<?>... arguments)

Specified by:

rank in interface HibernateCriteriaBuilder

See Also:

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

rank

public SqmExpression<Long> rank(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... arguments)

Description copied from interface: HibernateCriteriaBuilder

Create a rank ordered set-aggregate function expression.

Specified by:

rank in interface HibernateCriteriaBuilder

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:

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

percentRank

public SqmExpression<Double> percentRank(JpaOrder order,
 Expression<?>... arguments)

Specified by:

percentRank in interface HibernateCriteriaBuilder

See Also:

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

percentRank

public SqmExpression<Double> percentRank(JpaOrder order,
 JpaPredicate filter,
 Expression<?>... arguments)

Specified by:

percentRank in interface HibernateCriteriaBuilder

See Also:

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

percentRank

public SqmExpression<Double> percentRank(JpaOrder order,
 JpaWindow window,
 Expression<?>... arguments)

Specified by:

percentRank in interface HibernateCriteriaBuilder

See Also:

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

percentRank

public SqmExpression<Double> percentRank(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?>... arguments)

Description copied from interface: HibernateCriteriaBuilder

Create a percent_rank ordered set-aggregate function expression.

Specified by:

percentRank in interface HibernateCriteriaBuilder

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:

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

arrayAgg

public <T> SqmExpression<T[]> arrayAgg(JpaOrder order,
 Expression<? extends T> argument)

Specified by:

arrayAgg in interface HibernateCriteriaBuilder

Specified by:

arrayAgg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

public <T> SqmExpression<T[]> arrayAgg(JpaOrder order,
 JpaPredicate filter,
 Expression<? extends T> argument)

Specified by:

arrayAgg in interface HibernateCriteriaBuilder

Specified by:

arrayAgg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

public <T> SqmExpression<T[]> arrayAgg(JpaOrder order,
 JpaWindow window,
 Expression<? extends T> argument)

Specified by:

arrayAgg in interface HibernateCriteriaBuilder

Specified by:

arrayAgg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)

arrayAgg

public <T> SqmExpression<T[]> arrayAgg(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<? extends T> argument)

Description copied from interface: HibernateCriteriaBuilder

Create a array_agg ordered set-aggregate function expression.

Specified by:

arrayAgg in interface HibernateCriteriaBuilder

Specified by:

arrayAgg in interface NodeBuilder

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

See Also:

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

arrayLiteral

public <T> SqmExpression<T[]> arrayLiteral(T... elements)

Description copied from interface: HibernateCriteriaBuilder

Creates an array literal with the array constructor function.

Specified by:

arrayLiteral in interface HibernateCriteriaBuilder

Specified by:

arrayLiteral in interface NodeBuilder

arrayPosition

public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPosition in interface HibernateCriteriaBuilder

Specified by:

arrayPosition in interface NodeBuilder

arrayPosition

public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPosition in interface HibernateCriteriaBuilder

Specified by:

arrayPosition in interface NodeBuilder

arrayPositions

public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPositions in interface HibernateCriteriaBuilder

Specified by:

arrayPositions in interface NodeBuilder

arrayPositions

public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPositions in interface HibernateCriteriaBuilder

Specified by:

arrayPositions in interface NodeBuilder

arrayPositionsList

public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPositionsList in interface HibernateCriteriaBuilder

Specified by:

arrayPositionsList in interface NodeBuilder

arrayPositionsList

public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayPositionsList in interface HibernateCriteriaBuilder

Specified by:

arrayPositionsList in interface NodeBuilder

arrayLength

public <T> SqmExpression<Integer> arrayLength(Expression<T[]> arrayExpression)

Description copied from interface: HibernateCriteriaBuilder

Determines the length of an array.

Specified by:

arrayLength in interface HibernateCriteriaBuilder

Specified by:

arrayLength in interface NodeBuilder

arrayConcat

public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates arrays with each other in order.

Specified by:

arrayConcat in interface HibernateCriteriaBuilder

Specified by:

arrayConcat in interface NodeBuilder

arrayConcat

public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1,
 T[] array2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates arrays with each other in order.

Specified by:

arrayConcat in interface HibernateCriteriaBuilder

Specified by:

arrayConcat in interface NodeBuilder

arrayConcat

public <T> SqmExpression<T[]> arrayConcat(T[] array1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates arrays with each other in order.

Specified by:

arrayConcat in interface HibernateCriteriaBuilder

Specified by:

arrayConcat in interface NodeBuilder

arrayAppend

public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Appends element to array.

Specified by:

arrayAppend in interface HibernateCriteriaBuilder

Specified by:

arrayAppend in interface NodeBuilder

arrayAppend

public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

Appends element to array.

Specified by:

arrayAppend in interface HibernateCriteriaBuilder

Specified by:

arrayAppend in interface NodeBuilder

arrayPrepend

public <T> SqmExpression<T[]> arrayPrepend(Expression<T> elementExpression,
 Expression<T[]> arrayExpression)

Description copied from interface: HibernateCriteriaBuilder

Prepends element to array.

Specified by:

arrayPrepend in interface HibernateCriteriaBuilder

Specified by:

arrayPrepend in interface NodeBuilder

arrayPrepend

public <T> SqmExpression<T[]> arrayPrepend(T element,
 Expression<T[]> arrayExpression)

Description copied from interface: HibernateCriteriaBuilder

Prepends element to array.

Specified by:

arrayPrepend in interface HibernateCriteriaBuilder

Specified by:

arrayPrepend in interface NodeBuilder

arrayContains

public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains an element.

Specified by:

arrayContains in interface HibernateCriteriaBuilder

Specified by:

arrayContains in interface NodeBuilder

arrayContains

public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains an element.

Specified by:

arrayContains in interface HibernateCriteriaBuilder

Specified by:

arrayContains in interface NodeBuilder

arrayContains

public <T> SqmPredicate arrayContains(T[] array,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains an element.

Specified by:

arrayContains in interface HibernateCriteriaBuilder

Specified by:

arrayContains in interface NodeBuilder

arrayContainsNullable

public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains a nullable element.

Specified by:

arrayContainsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayContainsNullable in interface NodeBuilder

arrayContainsNullable

public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains a nullable element.

Specified by:

arrayContainsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayContainsNullable in interface NodeBuilder

arrayContainsNullable

public <T> SqmPredicate arrayContainsNullable(T[] array,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array contains a nullable element.

Specified by:

arrayContainsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayContainsNullable in interface NodeBuilder

arrayIncludes

public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array is a subset of another array.

Specified by:

arrayIncludes in interface HibernateCriteriaBuilder

Specified by:

arrayIncludes in interface NodeBuilder

arrayIncludes

public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression,
 T[] subArray)

Description copied from interface: HibernateCriteriaBuilder

Whether an array is a subset of another array.

Specified by:

arrayIncludes in interface HibernateCriteriaBuilder

Specified by:

arrayIncludes in interface NodeBuilder

arrayIncludes

public <T> SqmPredicate arrayIncludes(T[] array,
 Expression<T[]> subArrayExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether an array is a subset of another array.

Specified by:

arrayIncludes in interface HibernateCriteriaBuilder

Specified by:

arrayIncludes in interface NodeBuilder

arrayIncludesNullable

public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression,
 Expression<T[]> subArrayExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIncludesNullable in interface NodeBuilder

arrayIncludesNullable

public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression,
 T[] subArray)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIncludesNullable in interface NodeBuilder

arrayIncludesNullable

public <T> SqmPredicate arrayIncludesNullable(T[] array,
 Expression<T[]> subArrayExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIncludesNullable in interface NodeBuilder

arrayIntersects

public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

Whether one array has any elements common with another array.

Specified by:

arrayIntersects in interface HibernateCriteriaBuilder

Specified by:

arrayIntersects in interface NodeBuilder

arrayIntersects

public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1,
 T[] array2)

Description copied from interface: HibernateCriteriaBuilder

Whether one array has any elements common with another array.

Specified by:

arrayIntersects in interface HibernateCriteriaBuilder

Specified by:

arrayIntersects in interface NodeBuilder

arrayIntersects

public <T> SqmPredicate arrayIntersects(T[] array1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

Whether one array has any elements common with another array.

Specified by:

arrayIntersects in interface HibernateCriteriaBuilder

Specified by:

arrayIntersects in interface NodeBuilder

arrayIntersectsNullable

public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIntersectsNullable in interface NodeBuilder

arrayIntersectsNullable

public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1,
 T[] array2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIntersectsNullable in interface NodeBuilder

arrayIntersectsNullable

public <T> SqmPredicate arrayIntersectsNullable(T[] array1,
 Expression<T[]> arrayExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

arrayIntersectsNullable in interface NodeBuilder

arrayGet

public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayGet in interface HibernateCriteriaBuilder

Specified by:

arrayGet in interface NodeBuilder

arrayGet

public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression,
 Integer index)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayGet in interface HibernateCriteriaBuilder

Specified by:

arrayGet in interface NodeBuilder

arraySet

public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySet in interface HibernateCriteriaBuilder

Specified by:

arraySet in interface NodeBuilder

arraySet

public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySet in interface HibernateCriteriaBuilder

Specified by:

arraySet in interface NodeBuilder

arraySet

public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Integer index,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySet in interface HibernateCriteriaBuilder

Specified by:

arraySet in interface NodeBuilder

arraySet

public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression,
 Integer index,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySet in interface HibernateCriteriaBuilder

Specified by:

arraySet in interface NodeBuilder

arrayRemove

public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy with given element removed.

Specified by:

arrayRemove in interface HibernateCriteriaBuilder

Specified by:

arrayRemove in interface NodeBuilder

arrayRemove

public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy with given element removed.

Specified by:

arrayRemove in interface HibernateCriteriaBuilder

Specified by:

arrayRemove in interface NodeBuilder

arrayRemoveIndex

public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression,
 Expression<Integer> indexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayRemoveIndex in interface HibernateCriteriaBuilder

Specified by:

arrayRemoveIndex in interface NodeBuilder

arrayRemoveIndex

public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression,
 Integer index)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayRemoveIndex in interface HibernateCriteriaBuilder

Specified by:

arrayRemoveIndex in interface NodeBuilder

arraySlice

public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression,
 Expression<Integer> lowerIndexExpression,
 Expression<Integer> upperIndexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySlice in interface HibernateCriteriaBuilder

Specified by:

arraySlice in interface NodeBuilder

arraySlice

public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression,
 Expression<Integer> lowerIndexExpression,
 Integer upperIndex)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySlice in interface HibernateCriteriaBuilder

Specified by:

arraySlice in interface NodeBuilder

arraySlice

public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression,
 Integer lowerIndex,
 Expression<Integer> upperIndexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySlice in interface HibernateCriteriaBuilder

Specified by:

arraySlice in interface NodeBuilder

arraySlice

public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression,
 Integer lowerIndex,
 Integer upperIndex)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arraySlice in interface HibernateCriteriaBuilder

Specified by:

arraySlice in interface NodeBuilder

arrayReplace

public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 Expression<T> oldElementExpression,
 Expression<T> newElementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy replacing a given element with another.

Specified by:

arrayReplace in interface HibernateCriteriaBuilder

Specified by:

arrayReplace in interface NodeBuilder

arrayReplace

public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 Expression<T> oldElementExpression,
 T newElement)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy replacing a given element with another.

Specified by:

arrayReplace in interface HibernateCriteriaBuilder

Specified by:

arrayReplace in interface NodeBuilder

arrayReplace

public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 T oldElement,
 Expression<T> newElementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy replacing a given element with another.

Specified by:

arrayReplace in interface HibernateCriteriaBuilder

Specified by:

arrayReplace in interface NodeBuilder

arrayReplace

public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression,
 T oldElement,
 T newElement)

Description copied from interface: HibernateCriteriaBuilder

Creates array copy replacing a given element with another.

Specified by:

arrayReplace in interface HibernateCriteriaBuilder

Specified by:

arrayReplace in interface NodeBuilder

arrayTrim

public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression,
 Expression<Integer> elementCountExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayTrim in interface HibernateCriteriaBuilder

Specified by:

arrayTrim in interface NodeBuilder

arrayTrim

public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression,
 Integer elementCount)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayTrim in interface HibernateCriteriaBuilder

Specified by:

arrayTrim in interface NodeBuilder

arrayFill

public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression,
 Expression<Integer> elementCountExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayFill in interface HibernateCriteriaBuilder

Specified by:

arrayFill in interface NodeBuilder

arrayFill

public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression,
 Integer elementCount)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayFill in interface HibernateCriteriaBuilder

Specified by:

arrayFill in interface NodeBuilder

arrayFill

public <T> SqmExpression<T[]> arrayFill(T element,
 Expression<Integer> elementCountExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayFill in interface HibernateCriteriaBuilder

Specified by:

arrayFill in interface NodeBuilder

arrayFill

public <T> SqmExpression<T[]> arrayFill(T element,
 Integer elementCount)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayFill in interface HibernateCriteriaBuilder

Specified by:

arrayFill in interface NodeBuilder

arrayToString

public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression,
 Expression<String> separatorExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayToString in interface HibernateCriteriaBuilder

Specified by:

arrayToString in interface NodeBuilder

arrayToString

public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression,
 String separator)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

arrayToString in interface HibernateCriteriaBuilder

Specified by:

arrayToString in interface NodeBuilder

collectionLiteral

public <E,
C extends Collection<E>> SqmExpression<C> collectionLiteral(E... elements)

Description copied from interface: HibernateCriteriaBuilder

Creates a basic collection literal with the array constructor function.

Specified by:

collectionLiteral in interface HibernateCriteriaBuilder

Specified by:

collectionLiteral in interface NodeBuilder

collectionPosition

public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPosition in interface HibernateCriteriaBuilder

Specified by:

collectionPosition in interface NodeBuilder

collectionPosition

public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression,
 Expression<E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPosition in interface HibernateCriteriaBuilder

Specified by:

collectionPosition in interface NodeBuilder

collectionPositions

public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPositions in interface HibernateCriteriaBuilder

Specified by:

collectionPositions in interface NodeBuilder

collectionPositions

public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPositions in interface HibernateCriteriaBuilder

Specified by:

collectionPositions in interface NodeBuilder

collectionPositionsList

public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression,
 Expression<T> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPositionsList in interface HibernateCriteriaBuilder

Specified by:

collectionPositionsList in interface NodeBuilder

collectionPositionsList

public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression,
 T element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionPositionsList in interface HibernateCriteriaBuilder

Specified by:

collectionPositionsList in interface NodeBuilder

collectionLength

public SqmExpression<Integer> collectionLength(Expression<? extends Collection<?>> collectionExpression)

Description copied from interface: HibernateCriteriaBuilder

Determines the length of a basic collection.

Specified by:

collectionLength in interface HibernateCriteriaBuilder

Specified by:

collectionLength in interface NodeBuilder

collectionConcat

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionConcat(Expression<C> collectionExpression1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates basic collections with each other in order.

Specified by:

collectionConcat in interface HibernateCriteriaBuilder

Specified by:

collectionConcat in interface NodeBuilder

collectionConcat

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionConcat(Expression<C> collectionExpression1,
 Collection<? extends E> collection2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates basic collections with each other in order.

Specified by:

collectionConcat in interface HibernateCriteriaBuilder

Specified by:

collectionConcat in interface NodeBuilder

collectionConcat

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionConcat(C collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

Concatenates basic collections with each other in order.

Specified by:

collectionConcat in interface HibernateCriteriaBuilder

Specified by:

collectionConcat in interface NodeBuilder

collectionAppend

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionAppend(Expression<C> collectionExpression,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Appends element to basic collection.

Specified by:

collectionAppend in interface HibernateCriteriaBuilder

Specified by:

collectionAppend in interface NodeBuilder

collectionAppend

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionAppend(Expression<C> collectionExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

Appends element to basic collection.

Specified by:

collectionAppend in interface HibernateCriteriaBuilder

Specified by:

collectionAppend in interface NodeBuilder

collectionPrepend

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionPrepend(Expression<? extends E> elementExpression,
 Expression<C> collectionExpression)

Description copied from interface: HibernateCriteriaBuilder

Prepends element to basic collection.

Specified by:

collectionPrepend in interface HibernateCriteriaBuilder

Specified by:

collectionPrepend in interface NodeBuilder

collectionPrepend

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionPrepend(E element,
 Expression<C> collectionExpression)

Description copied from interface: HibernateCriteriaBuilder

Prepends element to basic collection.

Specified by:

collectionPrepend in interface HibernateCriteriaBuilder

Specified by:

collectionPrepend in interface NodeBuilder

collectionContains

public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains an element.

Specified by:

collectionContains in interface HibernateCriteriaBuilder

Specified by:

collectionContains in interface NodeBuilder

collectionContains

public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains an element.

Specified by:

collectionContains in interface HibernateCriteriaBuilder

Specified by:

collectionContains in interface NodeBuilder

collectionContains

public <E> SqmPredicate collectionContains(Collection<E> collection,
 Expression<E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains an element.

Specified by:

collectionContains in interface HibernateCriteriaBuilder

Specified by:

collectionContains in interface NodeBuilder

collectionContainsNullable

public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains a nullable element.

Specified by:

collectionContainsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionContainsNullable in interface NodeBuilder

collectionContainsNullable

public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains a nullable element.

Specified by:

collectionContainsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionContainsNullable in interface NodeBuilder

collectionContainsNullable

public <E> SqmPredicate collectionContainsNullable(Collection<E> collection,
 Expression<E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Whether a basic collection contains a nullable element.

Specified by:

collectionContainsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionContainsNullable in interface NodeBuilder

collectionIncludes

public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludes in interface HibernateCriteriaBuilder

Specified by:

collectionIncludes in interface NodeBuilder

collectionIncludes

public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression,
 Collection<? extends E> subCollection)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludes in interface HibernateCriteriaBuilder

Specified by:

collectionIncludes in interface NodeBuilder

collectionIncludes

public <E> SqmPredicate collectionIncludes(Collection<E> collection,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludes in interface HibernateCriteriaBuilder

Specified by:

collectionIncludes in interface NodeBuilder

collectionIncludesNullable

public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIncludesNullable in interface NodeBuilder

collectionIncludesNullable

public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression,
 Collection<? extends E> subCollection)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIncludesNullable in interface NodeBuilder

collectionIncludesNullable

public <E> SqmPredicate collectionIncludesNullable(Collection<E> collection,
 Expression<? extends Collection<? extends E>> subCollectionExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIncludesNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIncludesNullable in interface NodeBuilder

collectionIntersects

public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersects in interface HibernateCriteriaBuilder

Specified by:

collectionIntersects in interface NodeBuilder

collectionIntersects

public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1,
 Collection<? extends E> collection2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersects in interface HibernateCriteriaBuilder

Specified by:

collectionIntersects in interface NodeBuilder

collectionIntersects

public <E> SqmPredicate collectionIntersects(Collection<E> collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersects in interface HibernateCriteriaBuilder

Specified by:

collectionIntersects in interface NodeBuilder

collectionIntersectsNullable

public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIntersectsNullable in interface NodeBuilder

collectionIntersectsNullable

public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1,
 Collection<? extends E> collection2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIntersectsNullable in interface NodeBuilder

collectionIntersectsNullable

public <E> SqmPredicate collectionIntersectsNullable(Collection<E> collection1,
 Expression<? extends Collection<? extends E>> collectionExpression2)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionIntersectsNullable in interface HibernateCriteriaBuilder

Specified by:

collectionIntersectsNullable in interface NodeBuilder

collectionGet

public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression,
 Expression<Integer> indexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionGet in interface HibernateCriteriaBuilder

Specified by:

collectionGet in interface NodeBuilder

collectionGet

public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression,
 Integer index)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionGet in interface HibernateCriteriaBuilder

Specified by:

collectionGet in interface NodeBuilder

collectionSet

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionSet(Expression<C> collectionExpression,
 Expression<Integer> indexExpression,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSet in interface HibernateCriteriaBuilder

Specified by:

collectionSet in interface NodeBuilder

collectionSet

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionSet(Expression<C> collectionExpression,
 Expression<Integer> indexExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSet in interface HibernateCriteriaBuilder

Specified by:

collectionSet in interface NodeBuilder

collectionSet

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionSet(Expression<C> collectionExpression,
 Integer index,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSet in interface HibernateCriteriaBuilder

Specified by:

collectionSet in interface NodeBuilder

collectionSet

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionSet(Expression<C> collectionExpression,
 Integer index,
 E element)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSet in interface HibernateCriteriaBuilder

Specified by:

collectionSet in interface NodeBuilder

collectionRemove

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionRemove(Expression<C> collectionExpression,
 Expression<? extends E> elementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy with given element removed.

Specified by:

collectionRemove in interface HibernateCriteriaBuilder

Specified by:

collectionRemove in interface NodeBuilder

collectionRemove

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionRemove(Expression<C> collectionExpression,
 E element)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy with given element removed.

Specified by:

collectionRemove in interface HibernateCriteriaBuilder

Specified by:

collectionRemove in interface NodeBuilder

collectionRemoveIndex

public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression,
 Expression<Integer> indexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionRemoveIndex in interface HibernateCriteriaBuilder

Specified by:

collectionRemoveIndex in interface NodeBuilder

collectionRemoveIndex

public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression,
 Integer index)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionRemoveIndex in interface HibernateCriteriaBuilder

Specified by:

collectionRemoveIndex in interface NodeBuilder

collectionSlice

public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression,
 Expression<Integer> lowerIndexExpression,
 Expression<Integer> upperIndexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSlice in interface HibernateCriteriaBuilder

Specified by:

collectionSlice in interface NodeBuilder

collectionSlice

public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression,
 Expression<Integer> lowerIndexExpression,
 Integer upperIndex)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSlice in interface HibernateCriteriaBuilder

Specified by:

collectionSlice in interface NodeBuilder

collectionSlice

public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression,
 Integer lowerIndex,
 Expression<Integer> upperIndexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSlice in interface HibernateCriteriaBuilder

Specified by:

collectionSlice in interface NodeBuilder

collectionSlice

public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression,
 Integer lowerIndex,
 Integer upperIndex)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionSlice in interface HibernateCriteriaBuilder

Specified by:

collectionSlice in interface NodeBuilder

collectionReplace

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionReplace(Expression<C> collectionExpression,
 Expression<? extends E> oldElementExpression,
 Expression<? extends E> newElementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy replacing a given element with another.

Specified by:

collectionReplace in interface HibernateCriteriaBuilder

Specified by:

collectionReplace in interface NodeBuilder

collectionReplace

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionReplace(Expression<C> collectionExpression,
 Expression<? extends E> oldElementExpression,
 E newElement)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy replacing a given element with another.

Specified by:

collectionReplace in interface HibernateCriteriaBuilder

Specified by:

collectionReplace in interface NodeBuilder

collectionReplace

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionReplace(Expression<C> collectionExpression,
 E oldElement,
 Expression<? extends E> newElementExpression)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy replacing a given element with another.

Specified by:

collectionReplace in interface HibernateCriteriaBuilder

Specified by:

collectionReplace in interface NodeBuilder

collectionReplace

public <E,
C extends Collection<? super E>>
SqmExpression<C> collectionReplace(Expression<C> collectionExpression,
 E oldElement,
 E newElement)

Description copied from interface: HibernateCriteriaBuilder

Creates basic collection copy replacing a given element with another.

Specified by:

collectionReplace in interface HibernateCriteriaBuilder

Specified by:

collectionReplace in interface NodeBuilder

collectionTrim

public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression,
 Expression<Integer> indexExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionTrim in interface HibernateCriteriaBuilder

Specified by:

collectionTrim in interface NodeBuilder

collectionTrim

public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression,
 Integer index)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionTrim in interface HibernateCriteriaBuilder

Specified by:

collectionTrim in interface NodeBuilder

collectionFill

public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression,
 Expression<Integer> elementCountExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionFill in interface HibernateCriteriaBuilder

Specified by:

collectionFill in interface NodeBuilder

collectionFill

public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression,
 Integer elementCount)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionFill in interface HibernateCriteriaBuilder

Specified by:

collectionFill in interface NodeBuilder

collectionFill

public <T> SqmExpression<Collection<T>> collectionFill(T element,
 Expression<Integer> elementCountExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionFill in interface HibernateCriteriaBuilder

Specified by:

collectionFill in interface NodeBuilder

collectionFill

public <T> SqmExpression<Collection<T>> collectionFill(T element,
 Integer elementCount)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionFill in interface HibernateCriteriaBuilder

Specified by:

collectionFill in interface NodeBuilder

collectionToString

public SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression,
 Expression<String> separatorExpression)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionToString in interface HibernateCriteriaBuilder

Specified by:

collectionToString in interface NodeBuilder

collectionToString

public SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression,
 String separator)

Description copied from interface: HibernateCriteriaBuilder

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

Specified by:

collectionToString in interface HibernateCriteriaBuilder

Specified by:

collectionToString in interface NodeBuilder

jsonValue

public SqmJsonValueExpression<String> jsonValue(Expression<?> jsonDocument,
 String jsonPath)

Specified by:

jsonValue in interface HibernateCriteriaBuilder

Specified by:

jsonValue in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.jsonValue(Expression, String, Class)

jsonValue

public <T> SqmJsonValueExpression<T> jsonValue(Expression<?> jsonDocument,
 String jsonPath,
 Class<T> returningType)

Description copied from interface: HibernateCriteriaBuilder

Extracts a value by JSON path from a JSON document.

Specified by:

jsonValue in interface HibernateCriteriaBuilder

Specified by:

jsonValue in interface NodeBuilder

jsonValue

public SqmJsonValueExpression<String> jsonValue(Expression<?> jsonDocument,
 Expression<String> jsonPath)

Specified by:

jsonValue in interface HibernateCriteriaBuilder

Specified by:

jsonValue in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.jsonValue(Expression, Expression, Class)

jsonValue

public <T> SqmJsonValueExpression<T> jsonValue(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Class<T> returningType)

Description copied from interface: HibernateCriteriaBuilder

Extracts a value by JSON path from a JSON document.

Specified by:

jsonValue in interface HibernateCriteriaBuilder

Specified by:

jsonValue in interface NodeBuilder

jsonQuery

public SqmJsonQueryExpression jsonQuery(Expression<?> jsonDocument,
 String jsonPath)

Specified by:

jsonQuery in interface HibernateCriteriaBuilder

Specified by:

jsonQuery in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.jsonQuery(Expression, Expression)

jsonQuery

public SqmJsonQueryExpression jsonQuery(Expression<?> jsonDocument,
 Expression<String> jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Queries values by JSON path from a JSON document.

Specified by:

jsonQuery in interface HibernateCriteriaBuilder

Specified by:

jsonQuery in interface NodeBuilder

jsonExists

public SqmJsonExistsExpression jsonExists(Expression<?> jsonDocument,
 String jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Checks if a JSON document contains a node for the given JSON path.

Specified by:

jsonExists in interface HibernateCriteriaBuilder

Specified by:

jsonExists in interface NodeBuilder

jsonExists

public SqmJsonExistsExpression jsonExists(Expression<?> jsonDocument,
 Expression<String> jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Checks if a JSON document contains a node for the given JSON path.

Specified by:

jsonExists in interface HibernateCriteriaBuilder

Specified by:

jsonExists in interface NodeBuilder

jsonArrayWithNulls

public SqmExpression<String> jsonArrayWithNulls(Expression<?>... values)

Description copied from interface: HibernateCriteriaBuilder

Create a JSON object from the given array of values, retaining null values in the JSON array.

Specified by:

jsonArrayWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonArrayWithNulls in interface NodeBuilder

jsonArray

public SqmExpression<String> jsonArray(Expression<?>... values)

Description copied from interface: HibernateCriteriaBuilder

Create a JSON array from the array of values.

Specified by:

jsonArray in interface HibernateCriteriaBuilder

Specified by:

jsonArray in interface NodeBuilder

jsonArrayAgg

public SqmExpression<String> jsonArrayAgg(Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array.

Specified by:

jsonArrayAgg in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAgg in interface NodeBuilder

jsonArrayAgg

public SqmExpression<String> jsonArrayAgg(Expression<?> value,
 Predicate filter,
 JpaOrder... orderBy)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array. Filtering rows that don't match the given filter predicate. Ordering values based on the given order by items.

Specified by:

jsonArrayAgg in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAgg in interface NodeBuilder

jsonArrayAgg

public SqmExpression<String> jsonArrayAgg(Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array. Filtering rows that don't match the given filter predicate.

Specified by:

jsonArrayAgg in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAgg in interface NodeBuilder

jsonArrayAgg

public SqmExpression<String> jsonArrayAgg(Expression<?> value,
 JpaOrder... orderBy)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array. Ordering values based on the given order by items.

Specified by:

jsonArrayAgg in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAgg in interface NodeBuilder

jsonArrayAggWithNulls

public SqmExpression<String> jsonArrayAggWithNulls(Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array, retaining null values in the JSON array.

Specified by:

jsonArrayAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAggWithNulls in interface NodeBuilder

jsonArrayAggWithNulls

public SqmExpression<String> jsonArrayAggWithNulls(Expression<?> value,
 Predicate filter,
 JpaOrder... orderBy)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array, retaining null values in the JSON array. Filtering rows that don't match the given filter predicate. Ordering values based on the given order by items.

Specified by:

jsonArrayAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAggWithNulls in interface NodeBuilder

jsonArrayAggWithNulls

public SqmExpression<String> jsonArrayAggWithNulls(Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array, retaining null values in the JSON array. Filtering rows that don't match the given filter predicate.

Specified by:

jsonArrayAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAggWithNulls in interface NodeBuilder

jsonArrayAggWithNulls

public SqmExpression<String> jsonArrayAggWithNulls(Expression<?> value,
 JpaOrder... orderBy)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value into a JSON array, retaining null values in the JSON array. Ordering values based on the given order by items.

Specified by:

jsonArrayAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonArrayAggWithNulls in interface NodeBuilder

jsonObjectAggWithUniqueKeysAndNulls

public SqmExpression<String> jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Specified by:

jsonObjectAggWithUniqueKeysAndNulls in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithUniqueKeysAndNulls in interface NodeBuilder

jsonObjectAggWithUniqueKeys

public SqmExpression<String> jsonObjectAggWithUniqueKeys(Expression<?> key,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object.

Specified by:

jsonObjectAggWithUniqueKeys in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithUniqueKeys in interface NodeBuilder

jsonObjectAggWithNulls

public SqmExpression<String> jsonObjectAggWithNulls(Expression<?> key,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Specified by:

jsonObjectAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithNulls in interface NodeBuilder

jsonObjectAgg

public SqmExpression<String> jsonObjectAgg(Expression<?> key,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object.

Specified by:

jsonObjectAgg in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAgg in interface NodeBuilder

jsonObjectAggWithUniqueKeysAndNulls

public SqmExpression<String> jsonObjectAggWithUniqueKeysAndNulls(Expression<?> key,
 Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Specified by:

jsonObjectAggWithUniqueKeysAndNulls in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithUniqueKeysAndNulls in interface NodeBuilder

jsonObjectAggWithUniqueKeys

public SqmExpression<String> jsonObjectAggWithUniqueKeys(Expression<?> key,
 Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object.

Specified by:

jsonObjectAggWithUniqueKeys in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithUniqueKeys in interface NodeBuilder

jsonObjectAggWithNulls

public SqmExpression<String> jsonObjectAggWithNulls(Expression<?> key,
 Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object, retaining null values in the JSON object.

Specified by:

jsonObjectAggWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAggWithNulls in interface NodeBuilder

jsonObjectAgg

public SqmExpression<String> jsonObjectAgg(Expression<?> key,
 Expression<?> value,
 Predicate filter)

Description copied from interface: HibernateCriteriaBuilder

Aggregates the given value under the given key into a JSON object.

Specified by:

jsonObjectAgg in interface HibernateCriteriaBuilder

Specified by:

jsonObjectAgg in interface NodeBuilder

jsonObjectWithNulls

public SqmExpression<String> jsonObjectWithNulls(Map<?,? extends Expression<?>> keyValues)

Description copied from interface: HibernateCriteriaBuilder

Create a JSON object from the given map of key values, retaining null values in the JSON.

Specified by:

jsonObjectWithNulls in interface HibernateCriteriaBuilder

Specified by:

jsonObjectWithNulls in interface NodeBuilder

jsonObject

public SqmExpression<String> jsonObject(Map<?,? extends Expression<?>> keyValues)

Description copied from interface: HibernateCriteriaBuilder

Create a JSON object from the given map of key values.

Specified by:

jsonObject in interface HibernateCriteriaBuilder

Specified by:

jsonObject in interface NodeBuilder

jsonSet

public SqmExpression<String> jsonSet(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Inserts/Replaces a value by JSON path within a JSON document.

Specified by:

jsonSet in interface HibernateCriteriaBuilder

Specified by:

jsonSet in interface NodeBuilder

jsonSet

public SqmExpression<String> jsonSet(Expression<?> jsonDocument,
 String jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Inserts/Replaces a value by JSON path within a JSON document.

Specified by:

jsonSet in interface HibernateCriteriaBuilder

Specified by:

jsonSet in interface NodeBuilder

jsonSet

public SqmExpression<String> jsonSet(Expression<?> jsonDocument,
 String jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Inserts/Replaces a value by JSON path within a JSON document.

Specified by:

jsonSet in interface HibernateCriteriaBuilder

Specified by:

jsonSet in interface NodeBuilder

jsonSet

public SqmExpression<String> jsonSet(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Inserts/Replaces a value by JSON path within a JSON document.

Specified by:

jsonSet in interface HibernateCriteriaBuilder

Specified by:

jsonSet in interface NodeBuilder

jsonRemove

public SqmExpression<String> jsonRemove(Expression<?> jsonDocument,
 String jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Removes a value by JSON path within a JSON document.

Specified by:

jsonRemove in interface HibernateCriteriaBuilder

Specified by:

jsonRemove in interface NodeBuilder

jsonRemove

public SqmExpression<String> jsonRemove(Expression<?> jsonDocument,
 Expression<String> jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Removes a value by JSON path within a JSON document.

Specified by:

jsonRemove in interface HibernateCriteriaBuilder

Specified by:

jsonRemove in interface NodeBuilder

jsonInsert

public SqmExpression<String> jsonInsert(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Inserts a value by JSON path within a JSON document.

Specified by:

jsonInsert in interface HibernateCriteriaBuilder

Specified by:

jsonInsert in interface NodeBuilder

jsonInsert

public SqmExpression<String> jsonInsert(Expression<?> jsonDocument,
 String jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Inserts a value by JSON path within a JSON document.

Specified by:

jsonInsert in interface HibernateCriteriaBuilder

Specified by:

jsonInsert in interface NodeBuilder

jsonInsert

public SqmExpression<String> jsonInsert(Expression<?> jsonDocument,
 String jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Inserts a value by JSON path within a JSON document.

Specified by:

jsonInsert in interface HibernateCriteriaBuilder

Specified by:

jsonInsert in interface NodeBuilder

jsonInsert

public SqmExpression<String> jsonInsert(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Inserts a value by JSON path within a JSON document.

Specified by:

jsonInsert in interface HibernateCriteriaBuilder

Specified by:

jsonInsert in interface NodeBuilder

jsonReplace

public SqmExpression<String> jsonReplace(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Replaces a value by JSON path within a JSON document.

Specified by:

jsonReplace in interface HibernateCriteriaBuilder

Specified by:

jsonReplace in interface NodeBuilder

jsonReplace

public SqmExpression<String> jsonReplace(Expression<?> jsonDocument,
 String jsonPath,
 Object value)

Description copied from interface: HibernateCriteriaBuilder

Replaces a value by JSON path within a JSON document.

Specified by:

jsonReplace in interface HibernateCriteriaBuilder

Specified by:

jsonReplace in interface NodeBuilder

jsonReplace

public SqmExpression<String> jsonReplace(Expression<?> jsonDocument,
 String jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Replaces a value by JSON path within a JSON document.

Specified by:

jsonReplace in interface HibernateCriteriaBuilder

Specified by:

jsonReplace in interface NodeBuilder

jsonReplace

public SqmExpression<String> jsonReplace(Expression<?> jsonDocument,
 Expression<String> jsonPath,
 Expression<?> value)

Description copied from interface: HibernateCriteriaBuilder

Replaces a value by JSON path within a JSON document.

Specified by:

jsonReplace in interface HibernateCriteriaBuilder

Specified by:

jsonReplace in interface NodeBuilder

jsonMergepatch

public SqmExpression<String> jsonMergepatch(String document,
 Expression<?> patch)

Description copied from interface: HibernateCriteriaBuilder

Applies the patch JSON document onto the other JSON document and returns that.

Specified by:

jsonMergepatch in interface HibernateCriteriaBuilder

Specified by:

jsonMergepatch in interface NodeBuilder

jsonMergepatch

public SqmExpression<String> jsonMergepatch(Expression<?> document,
 String patch)

Description copied from interface: HibernateCriteriaBuilder

Applies the patch JSON document onto the other JSON document and returns that.

Specified by:

jsonMergepatch in interface HibernateCriteriaBuilder

Specified by:

jsonMergepatch in interface NodeBuilder

jsonMergepatch

public SqmExpression<String> jsonMergepatch(Expression<?> document,
 Expression<?> patch)

Description copied from interface: HibernateCriteriaBuilder

Applies the patch JSON document onto the other JSON document and returns that.

Specified by:

jsonMergepatch in interface HibernateCriteriaBuilder

Specified by:

jsonMergepatch in interface NodeBuilder

xmlelement

public SqmXmlElementExpression xmlelement(String elementName)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML element with the given element name.

Specified by:

xmlelement in interface HibernateCriteriaBuilder

Specified by:

xmlelement in interface NodeBuilder

xmlcomment

public SqmExpression<String> xmlcomment(String comment)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML comment with the given argument as content.

Specified by:

xmlcomment in interface HibernateCriteriaBuilder

Specified by:

xmlcomment in interface NodeBuilder

named

public <T> SqmExpression<T> named(Expression<T> expression,
 String name)

Description copied from interface: HibernateCriteriaBuilder

Creates a named expression. The name is important for the result of the expression, e.g. when building an xmlforest, the name acts as the XML element name.

Specified by:

named in interface HibernateCriteriaBuilder

Specified by:

named in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.xmlforest(Expression[])
• HibernateCriteriaBuilder.xmlforest(List)

xmlforest

public SqmExpression<String> xmlforest(Expression<?>... elements)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML forest from the given XML element expressions.

Specified by:

xmlforest in interface HibernateCriteriaBuilder

Specified by:

xmlforest in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.named(Expression, String)

xmlforest

public SqmExpression<String> xmlforest(List<? extends Expression<?>> elements)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML forest from the given XML element expressions.

Specified by:

xmlforest in interface HibernateCriteriaBuilder

Specified by:

xmlforest in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.named(Expression, String)

xmlconcat

public SqmExpression<String> xmlconcat(Expression<?>... elements)

Description copied from interface: HibernateCriteriaBuilder

Concatenates the given XML element expressions.

Specified by:

xmlconcat in interface HibernateCriteriaBuilder

Specified by:

xmlconcat in interface NodeBuilder

xmlconcat

public SqmExpression<String> xmlconcat(List<? extends Expression<?>> elements)

Description copied from interface: HibernateCriteriaBuilder

Concatenates the given XML element expressions.

Specified by:

xmlconcat in interface HibernateCriteriaBuilder

Specified by:

xmlconcat in interface NodeBuilder

xmlpi

public SqmExpression<String> xmlpi(String elementName)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML processing with the given name.

Specified by:

xmlpi in interface HibernateCriteriaBuilder

Specified by:

xmlpi in interface NodeBuilder

xmlpi

public SqmExpression<String> xmlpi(String elementName,
 Expression<String> content)

Description copied from interface: HibernateCriteriaBuilder

Creates an XML processing with the given name and content.

Specified by:

xmlpi in interface HibernateCriteriaBuilder

Specified by:

xmlpi in interface NodeBuilder

xmlquery

public SqmExpression<String> xmlquery(String query,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Queries the given XML document with the given XPath or XQuery query.

Specified by:

xmlquery in interface HibernateCriteriaBuilder

Specified by:

xmlquery in interface NodeBuilder

xmlquery

public SqmExpression<String> xmlquery(Expression<String> query,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Queries the given XML document with the given XPath or XQuery query.

Specified by:

xmlquery in interface HibernateCriteriaBuilder

Specified by:

xmlquery in interface NodeBuilder

xmlexists

public SqmExpression<Boolean> xmlexists(String query,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Checks if the given XPath or XQuery query exists in the given XML document.

Specified by:

xmlexists in interface HibernateCriteriaBuilder

Specified by:

xmlexists in interface NodeBuilder

xmlexists

public SqmExpression<Boolean> xmlexists(Expression<String> query,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Checks if the given XPath or XQuery query exists in the given XML document.

Specified by:

xmlexists in interface HibernateCriteriaBuilder

Specified by:

xmlexists in interface NodeBuilder

xmlagg

public SqmExpression<String> xmlagg(JpaOrder order,
 Expression<?> argument)

Specified by:

xmlagg in interface HibernateCriteriaBuilder

Specified by:

xmlagg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

public SqmExpression<String> xmlagg(JpaOrder order,
 JpaPredicate filter,
 Expression<?> argument)

Specified by:

xmlagg in interface HibernateCriteriaBuilder

Specified by:

xmlagg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

public SqmExpression<String> xmlagg(JpaOrder order,
 JpaWindow window,
 Expression<?> argument)

Specified by:

xmlagg in interface HibernateCriteriaBuilder

Specified by:

xmlagg in interface NodeBuilder

See Also:

• HibernateCriteriaBuilder.xmlagg(JpaOrder, JpaPredicate, JpaWindow, Expression)

xmlagg

public SqmExpression<String> xmlagg(JpaOrder order,
 JpaPredicate filter,
 JpaWindow window,
 Expression<?> argument)

Description copied from interface: HibernateCriteriaBuilder

Create a xmlagg ordered set-aggregate function expression.

Specified by:

xmlagg in interface HibernateCriteriaBuilder

Specified by:

xmlagg in interface NodeBuilder

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

Returns:

ordered set-aggregate expression

See Also:

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

setReturningFunction

public <E> SqmSetReturningFunction<E> setReturningFunction(String name,
 Expression<?>... args)

Description copied from interface: HibernateCriteriaBuilder

Create a new set-returning function expression.

Specified by:

setReturningFunction in interface HibernateCriteriaBuilder

Specified by:

setReturningFunction in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

unnestArray

public <E> SqmSetReturningFunction<E> unnestArray(Expression<E[]> array)

Description copied from interface: HibernateCriteriaBuilder

Creates an unnest function expression to turn an array into a set of rows.

Specified by:

unnestArray in interface HibernateCriteriaBuilder

Specified by:

unnestArray in interface NodeBuilder

See Also:

• JpaFrom.join(JpaSetReturningFunction)

unnestCollection

public <E> SqmSetReturningFunction<E> unnestCollection(Expression<? extends Collection<E>> collection)

Description copied from interface: HibernateCriteriaBuilder

Creates an unnest function expression to turn an array into a set of rows.

Specified by:

unnestCollection in interface HibernateCriteriaBuilder

Specified by:

unnestCollection in interface NodeBuilder

See Also:

• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(Expression<E> start,
 Expression<E> stop,
 Expression<? extends TemporalAmount> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(E start,
 E stop,
 TemporalAmount step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(E start,
 Expression<E> stop,
 TemporalAmount step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(Expression<E> start,
 E stop,
 TemporalAmount step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(Expression<E> start,
 Expression<E> stop,
 TemporalAmount step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(E start,
 E stop,
 Expression<? extends TemporalAmount> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(Expression<E> start,
 E stop,
 Expression<? extends TemporalAmount> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateTimeSeries

public <E extends Temporal>
SqmSetReturningFunction<E> generateTimeSeries(E start,
 Expression<E> stop,
 Expression<? extends TemporalAmount> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateTimeSeries in interface HibernateCriteriaBuilder

Specified by:

generateTimeSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 Expression<E> stop,
 Expression<E> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 E stop,
 E step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 E stop,
 Expression<E> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 E stop,
 E step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 Expression<E> stop,
 E step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 Expression<E> stop,
 E step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 E stop,
 Expression<E> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 Expression<E> stop,
 Expression<E> step)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 Expression<E> stop)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(Expression<E> start,
 E stop)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 Expression<E> stop)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

generateSeries

public <E extends Number>
SqmSetReturningFunction<E> generateSeries(E start,
 E stop)

Description copied from interface: HibernateCriteriaBuilder

Creates a generate_series function expression to generate a set of values as rows.

Specified by:

generateSeries in interface HibernateCriteriaBuilder

Specified by:

generateSeries in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

public SqmJsonTableFunction<?> jsonTable(Expression<?> jsonDocument)

Description copied from interface: HibernateCriteriaBuilder

Creates a json_table function expression to generate rows from JSON array elements.

Specified by:

jsonTable in interface HibernateCriteriaBuilder

Specified by:

jsonTable in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

public SqmJsonTableFunction<?> jsonTable(Expression<?> jsonDocument,
 String jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Creates a json_table function expression to generate rows from JSON array elements.

Specified by:

jsonTable in interface HibernateCriteriaBuilder

Specified by:

jsonTable in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

jsonTable

public SqmJsonTableFunction<?> jsonTable(Expression<?> jsonDocument,
 @Nullable Expression<String> jsonPath)

Description copied from interface: HibernateCriteriaBuilder

Creates a json_table function expression to generate rows from JSON array elements.

Specified by:

jsonTable in interface HibernateCriteriaBuilder

Specified by:

jsonTable in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

xmlTable

public SqmXmlTableFunction<?> xmlTable(String xpath,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Creates a xmltable function expression to generate rows from XML elements.

Specified by:

xmlTable in interface HibernateCriteriaBuilder

Specified by:

xmlTable in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)

xmlTable

public SqmXmlTableFunction<?> xmlTable(Expression<String> xpath,
 Expression<?> xmlDocument)

Description copied from interface: HibernateCriteriaBuilder

Creates a xmltable function expression to generate rows from XML elements.

Specified by:

xmlTable in interface HibernateCriteriaBuilder

Specified by:

xmlTable in interface NodeBuilder

See Also:

• JpaSelectCriteria.from(JpaSetReturningFunction)
• JpaFrom.join(JpaSetReturningFunction)