Package org.hibernate.query.sqm.internal
Class SqmCriteriaNodeBuilder
- java.lang.Object
-
- org.hibernate.query.sqm.internal.SqmCriteriaNodeBuilder
-
- All Implemented Interfaces:
CriteriaBuilder,Serializable,HibernateCriteriaBuilder,NodeBuilder,SqmCreationContext
public class SqmCriteriaNodeBuilder extends Object implements NodeBuilder, SqmCreationContext, Serializable
Acts as a JPACriteriaBuilderby 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, boolean jpaComplianceEnabled, ValueHandlingMode criteriaValueHandlingMode, Supplier<SessionFactoryImplementor> sessionFactory)
-
Method Summary
All Methods Instance Methods Concrete Methods 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)SqmPredicateand(Expression<Boolean> x, Expression<Boolean> y)SqmPredicateand(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<? extends JpaSelection<?>> 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 aarray_aggordered 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> SqmPredicatearrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)Whether an array contains an element.<T> SqmPredicatearrayContains(Expression<T[]> arrayExpression, T element)Whether an array contains an element.<T> SqmPredicatearrayContains(T[] array, Expression<T> elementExpression)Whether an array contains an element.<T> SqmPredicatearrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)Whether an array contains a nullable element.<T> SqmPredicatearrayContainsNullable(Expression<T[]> arrayExpression, T element)Whether an array contains a nullable element.<T> SqmPredicatearrayContainsNullable(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> SqmPredicatearrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)Whether an array is a subset of another array.<T> SqmPredicatearrayIncludes(Expression<T[]> arrayExpression, T[] subArray)Whether an array is a subset of another array.<T> SqmPredicatearrayIncludes(T[] array, Expression<T[]> subArrayExpression)Whether an array is a subset of another array.<T> SqmPredicatearrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)Whether an array is a subset of another array with nullable elements.<T> SqmPredicatearrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)Whether an array is a subset of another array with nullable elements.<T> SqmPredicatearrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)Whether an array is a subset of another array with nullable elements.<T> SqmPredicatearrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)Whether one array has any elements common with another array.<T> SqmPredicatearrayIntersects(Expression<T[]> arrayExpression1, T[] array2)Whether one array has any elements common with another array.<T> SqmPredicatearrayIntersects(T[] array1, Expression<T[]> arrayExpression2)Whether one array has any elements common with another array.<T> SqmPredicatearrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)Whether one array has any elements common with another array, supportingnullelements.<T> SqmPredicatearrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)Whether one array has any elements common with another array, supportingnullelements.<T> SqmPredicatearrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)Whether one array has any elements common with another array, supportingnullelements.<T> SqmExpression<Integer>arrayLength(Expression<T[]> arrayExpression)Determines the length of an array.<T> SqmExpression<T[]>arrayLiteral(T... elements)Creates an array literal with thearrayconstructor 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.SqmSortSpecificationasc(Expression<?> x)JpaOrderasc(Expression<?> x, boolean nullsFirst)Create an ordering by the ascending value of the expression.JpaSearchOrderasc(JpaCteCriteriaAttribute x)Create a search ordering by the ascending value of the CTE attribute.JpaSearchOrderasc(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 ofyoverx.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 anavgaggregate function expression.<N extends Number>
SqmExpression<Double>avg(Expression<N> argument, JpaWindow window)<Y extends Comparable<? super Y>>
SqmPredicatebetween(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)<Y extends Comparable<? super Y>>
SqmPredicatebetween(Expression<? extends Y> value, Y lower, Y upper)<X,T>
SqmExpression<X>cast(JpaExpression<T> expression, Class<X> castTargetJavaType)<N extends Number>
JpaExpression<N>ceiling(Expression<N> x)Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.<T> 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> SqmPredicatecollectionContains(Expression<? extends Collection<E>> collectionExpression, E element)Whether a basic collection contains an element.<E> SqmPredicatecollectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)Whether a basic collection contains an element.<E> SqmPredicatecollectionContains(Collection<E> collection, Expression<E> elementExpression)Whether a basic collection contains an element.<E> SqmPredicatecollectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)Whether a basic collection contains a nullable element.<E> SqmPredicatecollectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)Whether a basic collection contains a nullable element.<E> SqmPredicatecollectionContainsNullable(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> SqmPredicatecollectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)Whether a basic collection is a subset of another basic collection.<E> SqmPredicatecollectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)Whether a basic collection is a subset of another basic collection.<E> SqmPredicatecollectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)Whether a basic collection is a subset of another basic collection.<E> SqmPredicatecollectionIncludesNullable(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> SqmPredicatecollectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)Whether a basic collection is a subset of another basic collection with nullable elements.<E> SqmPredicatecollectionIncludesNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)Whether a basic collection is a subset of another basic collection with nullable elements.<E> SqmPredicatecollectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)Whether one basic collection has any elements common with another basic collection.<E> SqmPredicatecollectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)Whether one basic collection has any elements common with another basic collection.<E> SqmPredicatecollectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)Whether one basic collection has any elements common with another basic collection.<E> SqmPredicatecollectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)Whether one basic collection has any elements common with another basic collection, supportingnullelements.<E> SqmPredicatecollectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)Whether one basic collection has any elements common with another basic collection, supportingnullelements.<E> SqmPredicatecollectionIntersectsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)Whether one basic collection has any elements common with another basic collection, supportingnullelements.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 thearrayconstructor 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.<T> 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.<T> 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)SqmPredicateconjunction()<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 HQLcount(*).SqmExpression<Long>count(Expression<?> argument)SqmExpression<Long>count(Expression<?> argument, JpaPredicate filter)SqmExpression<Long>count(Expression<?> argument, JpaPredicate filter, JpaWindow window)Create acountaggregate 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 HQLselectquery to an equivalent criteria query.SqmSelectStatement<Tuple>createTupleQuery()SqmWindowcreateWindow()Create an emptyJpaWindowto use with window and aggregate functions.SqmExpression<Double>cumeDist(JpaWindow window)Create acume_distwindow function expression.SqmFunction<Date>currentDate()SqmFunction<Instant>currentInstant()SqmFunction<Time>currentTime()SqmFunction<Timestamp>currentTimestamp()SqmFunction<Integer>day(Expression<? extends TemporalAccessor> datetime)Extracts theTemporalUnit.DAYof 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 adense_rankwindow function expression.SqmSortSpecificationdesc(Expression<?> x)JpaOrderdesc(Expression<?> x, boolean nullsFirst)Create an ordering by the descending value of the expression.JpaSearchOrderdesc(JpaCteCriteriaAttribute x)Create a search ordering by the descending value of the CTE attribute.JpaSearchOrderdesc(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)SqmPredicatedisjunction()SqmPredicatedistinctFrom(Expression<?> x, Expression<?> y)SqmPredicatedistinctFrom(Expression<?> x, Object y)JpaExpression<Duration>duration(long magnitude, TemporalUnit unit)A literalDuration, 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 aDurationto 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.SqmPredicateequal(Expression<?> x, Expression<?> y)SqmPredicateequal(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)SqmPredicateexists(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.<T> SqmExpression<T>firstValue(Expression<T> argument, JpaWindow window)Create afirst_valuewindow 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.SqmWindowFrameframeBetweenFollowing(int offset)SqmWindowFrameframeBetweenFollowing(Expression<?> offset)Create a window frame of typeFrameKind.OFFSET_FOLLOWINGto use withJpaWindows.SqmWindowFrameframeBetweenPreceding(int offset)SqmWindowFrameframeBetweenPreceding(Expression<?> offset)Create window frame of typeFrameKind.OFFSET_PRECEDINGto use withJpaWindows.SqmWindowFrameframeCurrentRow()Create a window frame of typeFrameKind.CURRENT_ROWto use withJpaWindows.SqmWindowFrameframeUnboundedFollowing()Create a window frame of typeFrameKind.UNBOUNDED_FOLLOWINGto use withJpaWindows.SqmWindowFrameframeUnboundedPreceding()Create a window frame of typeFrameKind.UNBOUNDED_PRECEDINGto use withJpaWindows.<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)SqmPredicatege(Expression<? extends Number> x, Expression<? extends Number> y)SqmPredicatege(Expression<? extends Number> x, Number y)FunctionReturnTypeResolvergetAvgReturnTypeResolver()BasicType<Boolean>getBooleanType()BasicType<Character>getCharacterType()JpaMetamodelgetDomainModel()BasicType<Integer>getIntegerType()JpaMetamodelImplementorgetJpaMetamodel()Access to the domain model metadataBasicType<Long>getLongType()QueryEnginegetQueryEngine()SessionFactoryImplementorgetSessionFactory()FunctionReturnTypeResolvergetSumReturnTypeResolver()TypeConfigurationgetTypeConfiguration()<Y extends Comparable<? super Y>>
SqmPredicategreaterThan(Expression<? extends Y> x, Expression<? extends Y> y)<Y extends Comparable<? super Y>>
SqmPredicategreaterThan(Expression<? extends Y> x, Y y)<Y extends Comparable<? super Y>>
SqmPredicategreaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)<Y extends Comparable<? super Y>>
SqmPredicategreaterThanOrEqualTo(Expression<? extends Y> x, Y y)<X extends Comparable<? super X>>
SqmExpression<X>greatest(Expression<X> argument)SqmPredicategt(Expression<? extends Number> x, Expression<? extends Number> y)SqmPredicategt(Expression<? extends Number> x, Number y)SqmFunction<Integer>hour(Expression<? extends TemporalAccessor> datetime)Extracts theTemporalUnit.HOURof a date, time, or datetime expression.SqmPredicateilike(Expression<String> searchString, Expression<String> pattern)SqmPredicateilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)SqmPredicateilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)SqmPredicateilike(Expression<String> searchString, String pattern)SqmPredicateilike(Expression<String> searchString, String pattern, char escapeChar)SqmPredicateilike(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)<C extends Collection<?>>
SqmPredicateisEmpty(Expression<C> collection)SqmPredicateisFalse(Expression<Boolean> x)booleanisJpaQueryComplianceEnabled()<M extends Map<?,?>>
SqmPredicateisMapEmpty(JpaExpression<M> mapExpression)Create a predicate that tests whether a Map is empty.<M extends Map<?,?>>
SqmPredicateisMapNotEmpty(JpaExpression<M> mapExpression)Create a predicate that tests whether a Map is not empty.<E,C extends Collection<E>>
SqmPredicateisMember(E elem, Expression<C> collection)<E,C extends Collection<E>>
SqmPredicateisMember(Expression<E> elem, Expression<C> collection)<C extends Collection<?>>
SqmPredicateisNotEmpty(Expression<C> collection)<E,C extends Collection<E>>
SqmPredicateisNotMember(E elem, Expression<C> collection)<E,C extends Collection<E>>
SqmPredicateisNotMember(Expression<E> elem, Expression<C> collection)SqmPredicateisNotNull(Expression<?> x)SqmPredicateisNull(Expression<?> x)SqmPredicateisTrue(Expression<Boolean> x)<K,M extends Map<K,?>>
SqmExpression<Set<K>>keys(M map)<T> SqmExpression<T>lastValue(Expression<T> argument, JpaWindow window)Create alast_valuewindow function expression.SqmPredicatele(Expression<? extends Number> x, Expression<? extends Number> y)SqmPredicatele(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 thelengthleftmost characters of a string.SqmFunction<Integer>length(Expression<String> argument)<Y extends Comparable<? super Y>>
SqmPredicatelessThan(Expression<? extends Y> x, Expression<? extends Y> y)<Y extends Comparable<? super Y>>
SqmPredicatelessThan(Expression<? extends Y> x, Y y)<Y extends Comparable<? super Y>>
SqmPredicatelessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)<Y extends Comparable<? super Y>>
SqmPredicatelessThanOrEqualTo(Expression<? extends Y> x, Y y)SqmPredicatelike(Expression<String> searchString, Expression<String> pattern)SqmPredicatelike(Expression<String> searchString, Expression<String> pattern, char escapeChar)SqmPredicatelike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)SqmPredicatelike(Expression<String> searchString, String pattern)SqmPredicatelike(Expression<String> searchString, String pattern, char escapeChar)SqmPredicatelike(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 alistaggordered 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> 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 ofxto the baseb.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)SqmPredicatelt(Expression<? extends Number> x, Expression<? extends Number> y)SqmPredicatelt(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 theTemporalUnit.MINUTEof 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 amodeordered 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 theTemporalUnit.MONTHof a date, time, or datetime expression.<N extends Number>
SqmExpression<N>neg(Expression<N> x)SqmPredicatenot(Expression<Boolean> restriction)SqmPredicatenotDistinctFrom(Expression<?> x, Expression<?> y)SqmPredicatenotDistinctFrom(Expression<?> x, Object y)SqmPredicatenotEqual(Expression<?> x, Expression<?> y)SqmPredicatenotEqual(Expression<?> x, Object y)SqmPredicatenotIlike(Expression<String> x, Expression<String> pattern)SqmPredicatenotIlike(Expression<String> x, Expression<String> pattern, char escapeChar)SqmPredicatenotIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)SqmPredicatenotIlike(Expression<String> x, String pattern)SqmPredicatenotIlike(Expression<String> x, String pattern, char escapeChar)SqmPredicatenotIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)SqmPredicatenotLike(Expression<String> x, Expression<String> pattern)SqmPredicatenotLike(Expression<String> x, Expression<String> pattern, char escapeChar)SqmPredicatenotLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)SqmPredicatenotLike(Expression<String> x, String pattern)SqmPredicatenotLike(Expression<String> x, String pattern, char escapeChar)SqmPredicatenotLike(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 anth_valuewindow 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)SqmPredicateor(Expression<Boolean> x, Expression<Boolean> y)SqmPredicateor(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 thestringexpression with thereplacementexpression, starting from indexstartand substituting a number of characters corresponding to the length of thereplacementexpression or thelengthparameter 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 thepadCharcharacter 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 apercentile_contordered 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 apercentile_discordered 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 apercent_rankordered set-aggregate function expression.SqmExpression<Double>percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)SqmExpression<Double>percentRank(JpaWindow window)Create apercent_rankwindow 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 arankordered set-aggregate function expression.SqmExpression<Long>rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)SqmExpression<Long>rank(JpaWindow window)Create arankwindow 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 ofpatternwithin the original string withreplacement.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 thelengthrightmost 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 arow_numberwindow function expression.JpaSearchOrdersearch(JpaCteCriteriaAttribute sortExpression)Create a search ordering based on the ascending value of the CTE attribute.JpaSearchOrdersearch(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder)Create a search ordering based on the sort order of the value of the CTE attribute.JpaSearchOrdersearch(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 theTemporalUnit.SECONDof a date, time, or datetime expression.<R> SqmCaseSearched<R>selectCase()<C,R>
SqmCaseSimple<C,R>selectCase(Expression<? extends C> expression)JpaExpression<Integer>sign(Expression<? extends Number> x)Create an expression that returns the sign of its argument, that is,1if its argument is positive,-1if its argument is negative, or0if 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)SqmSortSpecificationsort(JpaExpression<?> sortExpression)SqmSortSpecificationsort(JpaExpression<?> sortExpression, SortDirection sortOrder)SqmSortSpecificationsort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)SqmSortSpecificationsort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence, boolean ignoreCase)<T> SqmFunction<T>sql(String pattern, Class<T> type, Expression<?>... arguments)Embed nativepatternthat 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 asumaggregate 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 givenTemporalUnit.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<? extends JpaSelection<?>> 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 extends HibernateCriteriaBuilder>
Tunwrap(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" informationSqmValuesvalues(Expression<?>... expressions)SqmValuesvalues(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 specifiedwindow.SqmPredicatewrap(Expression<Boolean> expression)SqmPredicatewrap(Expression<Boolean>... expressions)SqmFunction<Integer>year(Expression<? extends TemporalAccessor> datetime)Extracts theTemporalUnit.YEARof 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
-
Methods inherited from interface org.hibernate.query.sqm.spi.SqmCreationContext
getNodeBuilder, getServiceRegistry
-
-
-
-
Constructor Detail
-
SqmCriteriaNodeBuilder
public SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, boolean jpaComplianceEnabled, ValueHandlingMode criteriaValueHandlingMode, Supplier<SessionFactoryImplementor> sessionFactory)
-
-
Method Detail
-
getDomainModel
public JpaMetamodel getDomainModel()
- Specified by:
getDomainModelin interfaceNodeBuilder
-
getTypeConfiguration
public TypeConfiguration getTypeConfiguration()
- Specified by:
getTypeConfigurationin interfaceNodeBuilder- Specified by:
getTypeConfigurationin interfaceSqmCreationContext
-
isJpaQueryComplianceEnabled
public boolean isJpaQueryComplianceEnabled()
- Specified by:
isJpaQueryComplianceEnabledin interfaceNodeBuilder
-
getSessionFactory
public SessionFactoryImplementor getSessionFactory()
- Specified by:
getSessionFactoryin interfaceNodeBuilder
-
getBooleanType
public BasicType<Boolean> getBooleanType()
- Specified by:
getBooleanTypein interfaceNodeBuilder
-
getIntegerType
public BasicType<Integer> getIntegerType()
- Specified by:
getIntegerTypein interfaceNodeBuilder
-
getLongType
public BasicType<Long> getLongType()
- Specified by:
getLongTypein interfaceNodeBuilder
-
getCharacterType
public BasicType<Character> getCharacterType()
- Specified by:
getCharacterTypein interfaceNodeBuilder
-
getSumReturnTypeResolver
public FunctionReturnTypeResolver getSumReturnTypeResolver()
-
getAvgReturnTypeResolver
public FunctionReturnTypeResolver getAvgReturnTypeResolver()
-
getQueryEngine
public QueryEngine getQueryEngine()
- Specified by:
getQueryEnginein interfaceNodeBuilder- Specified by:
getQueryEnginein interfaceSqmCreationContext
-
getJpaMetamodel
public JpaMetamodelImplementor getJpaMetamodel()
Description copied from interface:SqmCreationContextAccess to the domain model metadata- Specified by:
getJpaMetamodelin interfaceSqmCreationContext
-
createQuery
public SqmSelectStatement<Object> createQuery()
- Specified by:
createQueryin interfaceCriteriaBuilder- Specified by:
createQueryin interfaceHibernateCriteriaBuilder- Specified by:
createQueryin interfaceNodeBuilder
-
createQuery
public <T> SqmSelectStatement<T> createQuery(Class<T> resultClass)
- Specified by:
createQueryin interfaceCriteriaBuilder- Specified by:
createQueryin interfaceHibernateCriteriaBuilder- Specified by:
createQueryin interfaceNodeBuilder
-
createQuery
public <T> SqmSelectStatement<T> createQuery(String hql, Class<T> resultClass)
Description copied from interface:HibernateCriteriaBuilderTransform the given HQLselectquery to an equivalent criteria query.- Specified by:
createQueryin interfaceHibernateCriteriaBuilder- Specified by:
createQueryin interfaceNodeBuilder- Parameters:
hql- The HQLselectqueryresultClass- The result type of the query- Returns:
- The equivalent criteria query
-
createTupleQuery
public SqmSelectStatement<Tuple> createTupleQuery()
- Specified by:
createTupleQueryin interfaceCriteriaBuilder- Specified by:
createTupleQueryin interfaceHibernateCriteriaBuilder- Specified by:
createTupleQueryin interfaceNodeBuilder
-
createCriteriaUpdate
public <T> SqmUpdateStatement<T> createCriteriaUpdate(Class<T> targetEntity)
- Specified by:
createCriteriaUpdatein interfaceCriteriaBuilder- Specified by:
createCriteriaUpdatein interfaceHibernateCriteriaBuilder- Specified by:
createCriteriaUpdatein interfaceNodeBuilder
-
createCriteriaDelete
public <T> SqmDeleteStatement<T> createCriteriaDelete(Class<T> targetEntity)
- Specified by:
createCriteriaDeletein interfaceCriteriaBuilder- Specified by:
createCriteriaDeletein interfaceHibernateCriteriaBuilder- Specified by:
createCriteriaDeletein interfaceNodeBuilder
-
createCriteriaInsertValues
public <T> SqmInsertValuesStatement<T> createCriteriaInsertValues(Class<T> targetEntity)
- Specified by:
createCriteriaInsertValuesin interfaceHibernateCriteriaBuilder- Specified by:
createCriteriaInsertValuesin interfaceNodeBuilder
-
createCriteriaInsertSelect
public <T> SqmInsertSelectStatement<T> createCriteriaInsertSelect(Class<T> targetEntity)
- Specified by:
createCriteriaInsertSelectin interfaceHibernateCriteriaBuilder- Specified by:
createCriteriaInsertSelectin interfaceNodeBuilder
-
values
public SqmValues values(Expression<?>... expressions)
- Specified by:
valuesin interfaceHibernateCriteriaBuilder- Specified by:
valuesin interfaceNodeBuilder
-
values
public SqmValues values(List<? extends Expression<?>> expressions)
- Specified by:
valuesin interfaceHibernateCriteriaBuilder- Specified by:
valuesin interfaceNodeBuilder
-
union
public <T> JpaCriteriaQuery<T> union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
unionin interfaceHibernateCriteriaBuilder
-
intersect
public <T> JpaCriteriaQuery<T> intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
intersectin interfaceHibernateCriteriaBuilder
-
except
public <T> JpaCriteriaQuery<T> except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
exceptin interfaceHibernateCriteriaBuilder
-
union
public <T> JpaSubQuery<T> union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
unionin interfaceHibernateCriteriaBuilder
-
intersect
public <T> JpaSubQuery<T> intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
intersectin interfaceHibernateCriteriaBuilder
-
except
public <T> JpaSubQuery<T> except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
exceptin interfaceHibernateCriteriaBuilder
-
cast
public <X,T> SqmExpression<X> cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
- Specified by:
castin interfaceHibernateCriteriaBuilder- Specified by:
castin interfaceNodeBuilder
-
wrap
public SqmPredicate wrap(Expression<Boolean> expression)
- Specified by:
wrapin interfaceHibernateCriteriaBuilder- Specified by:
wrapin interfaceNodeBuilder
-
wrap
@SafeVarargs public final SqmPredicate wrap(Expression<Boolean>... expressions)
- Specified by:
wrapin interfaceHibernateCriteriaBuilder- Specified by:
wrapin interfaceNodeBuilder
-
unwrap
public <T extends HibernateCriteriaBuilder> T unwrap(Class<T> clazz)
- Specified by:
unwrapin interfaceHibernateCriteriaBuilder
-
fk
public <P,F> SqmExpression<F> fk(Path<P> path)
- Specified by:
fkin interfaceHibernateCriteriaBuilder- Specified by:
fkin interfaceNodeBuilder
-
treat
public <X,T extends X> SqmPath<T> treat(Path<X> path, Class<T> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,T extends X> SqmRoot<T> treat(Root<X> root, Class<T> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,T,V extends T> SqmSingularJoin<X,V> treat(Join<X,T> join, Class<V> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmBagJoin<X,E> treat(CollectionJoin<X,T> join, Class<E> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmSetJoin<X,E> treat(SetJoin<X,T> join, Class<E> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmListJoin<X,E> treat(ListJoin<X,T> join, Class<E> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
treat
public <X,K,T,V extends T> SqmMapJoin<X,K,V> treat(MapJoin<X,K,T> join, Class<V> type)
- Specified by:
treatin interfaceCriteriaBuilder- Specified by:
treatin interfaceHibernateCriteriaBuilder- Specified by:
treatin interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
- Specified by:
sortin interfaceHibernateCriteriaBuilder- Specified by:
sortin interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence, boolean ignoreCase)
- Specified by:
sortin interfaceHibernateCriteriaBuilder- Specified by:
sortin interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
- Specified by:
sortin interfaceHibernateCriteriaBuilder- Specified by:
sortin interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression)
- Specified by:
sortin interfaceHibernateCriteriaBuilder- Specified by:
sortin interfaceNodeBuilder
-
asc
public SqmSortSpecification asc(Expression<?> x)
- Specified by:
ascin interfaceCriteriaBuilder- Specified by:
ascin interfaceHibernateCriteriaBuilder- Specified by:
ascin interfaceNodeBuilder
-
desc
public SqmSortSpecification desc(Expression<?> x)
- Specified by:
descin interfaceCriteriaBuilder- Specified by:
descin interfaceHibernateCriteriaBuilder- Specified by:
descin interfaceNodeBuilder
-
asc
public JpaOrder asc(Expression<?> x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilderCreate an ordering by the ascending value of the expression.- Specified by:
ascin interfaceHibernateCriteriaBuilder- Parameters:
x- expression used to define the orderingnullsFirst- Whethernullshould be sorted first- Returns:
- ascending ordering corresponding to the expression
-
desc
public JpaOrder desc(Expression<?> x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilderCreate an ordering by the descending value of the expression.- Specified by:
descin interfaceHibernateCriteriaBuilder- Parameters:
x- expression used to define the orderingnullsFirst- Whethernullshould be sorted first- Returns:
- descending ordering corresponding to the expression
-
search
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Description copied from interface:HibernateCriteriaBuilderCreate a search ordering based on the sort order and null precedence of the value of the CTE attribute.- Specified by:
searchin interfaceHibernateCriteriaBuilder- Parameters:
sortExpression- CTE attribute used to define the orderingsortOrder- The sort ordernullPrecedence- The null precedence- Returns:
- ordering corresponding to the CTE attribute
-
search
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder)
Description copied from interface:HibernateCriteriaBuilderCreate a search ordering based on the sort order of the value of the CTE attribute.- Specified by:
searchin interfaceHibernateCriteriaBuilder- Parameters:
sortExpression- CTE attribute used to define the orderingsortOrder- The sort order- Returns:
- ordering corresponding to the CTE attribute
-
search
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression)
Description copied from interface:HibernateCriteriaBuilderCreate a search ordering based on the ascending value of the CTE attribute.- Specified by:
searchin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate a search ordering by the ascending value of the CTE attribute.- Specified by:
ascin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate a search ordering by the descending value of the CTE attribute.- Specified by:
descin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate a search ordering by the ascending value of the CTE attribute.- Specified by:
ascin interfaceHibernateCriteriaBuilder- Parameters:
x- CTE attribute used to define the orderingnullsFirst- Whethernullshould be sorted first- Returns:
- ascending ordering corresponding to the CTE attribute
-
desc
public JpaSearchOrder desc(JpaCteCriteriaAttribute x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilderCreate a search ordering by the descending value of the CTE attribute.- Specified by:
descin interfaceHibernateCriteriaBuilder- Parameters:
x- CTE attribute used to define the orderingnullsFirst- Whethernullshould be sorted first- Returns:
- descending ordering corresponding to the CTE attribute
-
tuple
public JpaCompoundSelection<Tuple> tuple(Selection<?>[] selections)
- Specified by:
tuplein interfaceCriteriaBuilder- Specified by:
tuplein interfaceHibernateCriteriaBuilder- Specified by:
tuplein interfaceNodeBuilder
-
tuple
public JpaCompoundSelection<Tuple> tuple(List<? extends JpaSelection<?>> selections)
- Specified by:
tuplein interfaceHibernateCriteriaBuilder- Specified by:
tuplein interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(Class<R> tupleType, SqmExpression<?>... expressions)
- Specified by:
tuplein interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(Class<R> tupleType, List<? extends SqmExpression<?>> expressions)
- Specified by:
tuplein interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType, SqmExpression<?>... expressions)
- Specified by:
tuplein interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType, List<? extends SqmExpression<?>> sqmExpressions)
- Specified by:
tuplein interfaceNodeBuilder
-
array
public JpaCompoundSelection<Object[]> array(Selection<?>[] selections)
- Specified by:
arrayin interfaceCriteriaBuilder- Specified by:
arrayin interfaceHibernateCriteriaBuilder- Specified by:
arrayin interfaceNodeBuilder
-
array
public JpaCompoundSelection<Object[]> array(List<? extends JpaSelection<?>> selections)
- Specified by:
arrayin interfaceHibernateCriteriaBuilder- Specified by:
arrayin interfaceNodeBuilder
-
array
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass, Selection<?>[] selections)
- Specified by:
arrayin interfaceHibernateCriteriaBuilder
-
array
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
- Specified by:
arrayin interfaceHibernateCriteriaBuilder
-
construct
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass, Selection<?>[] arguments)
- Specified by:
constructin interfaceCriteriaBuilder- Specified by:
constructin interfaceHibernateCriteriaBuilder- Specified by:
constructin interfaceNodeBuilder
-
construct
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
- Specified by:
constructin interfaceHibernateCriteriaBuilder- Specified by:
constructin interfaceNodeBuilder
-
avg
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument)
- Specified by:
avgin interfaceCriteriaBuilder- Specified by:
avgin interfaceHibernateCriteriaBuilder- Specified by:
avgin interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<N> argument)
- Specified by:
sumin interfaceCriteriaBuilder- Specified by:
sumin interfaceHibernateCriteriaBuilder- Specified by:
sumin interfaceNodeBuilder
-
sumAsLong
public SqmExpression<Long> sumAsLong(Expression<Integer> argument)
- Specified by:
sumAsLongin interfaceCriteriaBuilder- Specified by:
sumAsLongin interfaceHibernateCriteriaBuilder- Specified by:
sumAsLongin interfaceNodeBuilder
-
sumAsDouble
public SqmExpression<Double> sumAsDouble(Expression<Float> argument)
- Specified by:
sumAsDoublein interfaceCriteriaBuilder- Specified by:
sumAsDoublein interfaceHibernateCriteriaBuilder- Specified by:
sumAsDoublein interfaceNodeBuilder
-
max
public <N extends Number> SqmExpression<N> max(Expression<N> argument)
- Specified by:
maxin interfaceCriteriaBuilder- Specified by:
maxin interfaceHibernateCriteriaBuilder- Specified by:
maxin interfaceNodeBuilder
-
min
public <N extends Number> SqmExpression<N> min(Expression<N> argument)
- Specified by:
minin interfaceCriteriaBuilder- Specified by:
minin interfaceHibernateCriteriaBuilder- Specified by:
minin interfaceNodeBuilder
-
greatest
public <X extends Comparable<? super X>> SqmExpression<X> greatest(Expression<X> argument)
- Specified by:
greatestin interfaceCriteriaBuilder- Specified by:
greatestin interfaceHibernateCriteriaBuilder- Specified by:
greatestin interfaceNodeBuilder
-
least
public <X extends Comparable<? super X>> SqmExpression<X> least(Expression<X> argument)
- Specified by:
leastin interfaceCriteriaBuilder- Specified by:
leastin interfaceHibernateCriteriaBuilder- Specified by:
leastin interfaceNodeBuilder
-
count
public SqmExpression<Long> count(Expression<?> argument)
- Specified by:
countin interfaceCriteriaBuilder- Specified by:
countin interfaceHibernateCriteriaBuilder- Specified by:
countin interfaceNodeBuilder
-
countDistinct
public SqmExpression<Long> countDistinct(Expression<?> argument)
- Specified by:
countDistinctin interfaceCriteriaBuilder- Specified by:
countDistinctin interfaceHibernateCriteriaBuilder- Specified by:
countDistinctin interfaceNodeBuilder
-
count
public SqmExpression<Long> count()
Description copied from interface:HibernateCriteriaBuilderEquivalent to HQLcount(*).- Specified by:
countin interfaceHibernateCriteriaBuilder- Specified by:
countin interfaceNodeBuilder
-
sign
public JpaExpression<Integer> sign(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the sign of its argument, that is,1if its argument is positive,-1if its argument is negative, or0if its argument is exactly zero.- Specified by:
signin interfaceCriteriaBuilder- Specified by:
signin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- sign
-
ceiling
public <N extends Number> JpaExpression<N> ceiling(Expression<N> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.- Specified by:
ceilingin interfaceCriteriaBuilder- Specified by:
ceilingin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- ceiling
-
floor
public <N extends Number> JpaExpression<N> floor(Expression<N> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.- Specified by:
floorin interfaceCriteriaBuilder- Specified by:
floorin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- floor
-
exp
public JpaExpression<Double> exp(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.- Specified by:
expin interfaceCriteriaBuilder- Specified by:
expin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- exponential
-
ln
public JpaExpression<Double> ln(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the natural logarithm of its argument.- Specified by:
lnin interfaceCriteriaBuilder- Specified by:
lnin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- natural logarithm
-
power
public JpaExpression<Double> power(Expression<? extends Number> x, Expression<? extends Number> y)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the first argument raised to the power of its second argument.- Specified by:
powerin interfaceCriteriaBuilder- Specified by:
powerin interfaceHibernateCriteriaBuilder- Parameters:
x- basey- 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:HibernateCriteriaBuilderCreate an expression that returns the first argument raised to the power of its second argument.- Specified by:
powerin interfaceCriteriaBuilder- Specified by:
powerin interfaceHibernateCriteriaBuilder- Parameters:
x- basey- 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:HibernateCriteriaBuilderCreate an expression that returns the first argument rounded to the number of decimal places given by the second argument.- Specified by:
roundin interfaceCriteriaBuilder- Specified by:
roundin interfaceHibernateCriteriaBuilder- Parameters:
x- basen- 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:HibernateCriteriaBuilderCreate an expression that returns the first argument truncated to the number of decimal places given by the second argument.- Specified by:
truncatein interfaceHibernateCriteriaBuilder- Parameters:
x- basen- number of decimal places- Returns:
- the truncated value
-
neg
public <N extends Number> SqmExpression<N> neg(Expression<N> x)
- Specified by:
negin interfaceCriteriaBuilder- Specified by:
negin interfaceHibernateCriteriaBuilder- Specified by:
negin interfaceNodeBuilder
-
abs
public <N extends Number> SqmExpression<N> abs(Expression<N> x)
- Specified by:
absin interfaceCriteriaBuilder- Specified by:
absin interfaceHibernateCriteriaBuilder- Specified by:
absin interfaceNodeBuilder
-
duration
public JpaExpression<Duration> duration(long magnitude, TemporalUnit unit)
Description copied from interface:HibernateCriteriaBuilderA literalDuration, for example, "five days" or "30 minutes".- Specified by:
durationin interfaceHibernateCriteriaBuilder
-
durationByUnit
public JpaExpression<Long> durationByUnit(TemporalUnit unit, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderConvert aDurationto a numeric magnitude in the given units.- Specified by:
durationByUnitin interfaceHibernateCriteriaBuilder- Parameters:
unit- a choice of temporal granularityduration- 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:HibernateCriteriaBuilderAdd two durations.- Specified by:
durationSumin interfaceHibernateCriteriaBuilder
-
durationSum
public JpaExpression<Duration> durationSum(Expression<Duration> x, Duration y)
Description copied from interface:HibernateCriteriaBuilderAdd two durations.- Specified by:
durationSumin interfaceHibernateCriteriaBuilder
-
durationDiff
public JpaExpression<Duration> durationDiff(Expression<Duration> x, Expression<Duration> y)
Description copied from interface:HibernateCriteriaBuilderSubtract one duration from another.- Specified by:
durationDiffin interfaceHibernateCriteriaBuilder
-
durationDiff
public JpaExpression<Duration> durationDiff(Expression<Duration> x, Duration y)
Description copied from interface:HibernateCriteriaBuilderSubtract one duration from another.- Specified by:
durationDiffin interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Expression<? extends Number> number, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderScale a duration by a number.- Specified by:
durationScaledin interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Number number, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderScale a duration by a number.- Specified by:
durationScaledin interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Expression<? extends Number> number, Duration duration)
Description copied from interface:HibernateCriteriaBuilderScale a duration by a number.- Specified by:
durationScaledin interfaceHibernateCriteriaBuilder
-
durationBetween
public <T extends Temporal> JpaExpression<Duration> durationBetween(Expression<T> x, Expression<T> y)
Description copied from interface:HibernateCriteriaBuilderSubtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.- Specified by:
durationBetweenin interfaceHibernateCriteriaBuilder
-
durationBetween
public <T extends Temporal> JpaExpression<Duration> durationBetween(Expression<T> x, T y)
Description copied from interface:HibernateCriteriaBuilderSubtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.- Specified by:
durationBetweenin interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(Expression<T> datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderAdd 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:
addDurationin interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(Expression<T> datetime, Duration duration)
Description copied from interface:HibernateCriteriaBuilderAdd 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:
addDurationin interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(T datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderAdd 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:
addDurationin interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(Expression<T> datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderSubtract 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:
subtractDurationin interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(Expression<T> datetime, Duration duration)
Description copied from interface:HibernateCriteriaBuilderSubtract 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:
subtractDurationin interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(T datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilderSubtract 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:
subtractDurationin interfaceHibernateCriteriaBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
sumin interfaceCriteriaBuilder- Specified by:
sumin interfaceHibernateCriteriaBuilder- Specified by:
sumin interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x, N y)
- Specified by:
sumin interfaceCriteriaBuilder- Specified by:
sumin interfaceHibernateCriteriaBuilder- Specified by:
sumin interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(N x, Expression<? extends N> y)
- Specified by:
sumin interfaceCriteriaBuilder- Specified by:
sumin interfaceHibernateCriteriaBuilder- Specified by:
sumin interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
prodin interfaceCriteriaBuilder- Specified by:
prodin interfaceHibernateCriteriaBuilder- Specified by:
prodin interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x, N y)
- Specified by:
prodin interfaceCriteriaBuilder- Specified by:
prodin interfaceHibernateCriteriaBuilder- Specified by:
prodin interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(N x, Expression<? extends N> y)
- Specified by:
prodin interfaceCriteriaBuilder- Specified by:
prodin interfaceHibernateCriteriaBuilder- Specified by:
prodin interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
diffin interfaceCriteriaBuilder- Specified by:
diffin interfaceHibernateCriteriaBuilder- Specified by:
diffin interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x, N y)
- Specified by:
diffin interfaceCriteriaBuilder- Specified by:
diffin interfaceHibernateCriteriaBuilder- Specified by:
diffin interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(N x, Expression<? extends N> y)
- Specified by:
diffin interfaceCriteriaBuilder- Specified by:
diffin interfaceHibernateCriteriaBuilder- Specified by:
diffin interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
quotin interfaceCriteriaBuilder- Specified by:
quotin interfaceHibernateCriteriaBuilder- Specified by:
quotin interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Expression<? extends Number> x, Number y)
- Specified by:
quotin interfaceCriteriaBuilder- Specified by:
quotin interfaceHibernateCriteriaBuilder- Specified by:
quotin interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Number x, Expression<? extends Number> y)
- Specified by:
quotin interfaceCriteriaBuilder- Specified by:
quotin interfaceHibernateCriteriaBuilder- Specified by:
quotin interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Expression<Integer> x, Expression<Integer> y)
- Specified by:
modin interfaceCriteriaBuilder- Specified by:
modin interfaceHibernateCriteriaBuilder- Specified by:
modin interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Expression<Integer> x, Integer y)
- Specified by:
modin interfaceCriteriaBuilder- Specified by:
modin interfaceHibernateCriteriaBuilder- Specified by:
modin interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Integer x, Expression<Integer> y)
- Specified by:
modin interfaceCriteriaBuilder- Specified by:
modin interfaceHibernateCriteriaBuilder- Specified by:
modin interfaceNodeBuilder
-
sqrt
public SqmExpression<Double> sqrt(Expression<? extends Number> x)
- Specified by:
sqrtin interfaceCriteriaBuilder- Specified by:
sqrtin interfaceHibernateCriteriaBuilder- Specified by:
sqrtin interfaceNodeBuilder
-
toLong
public SqmExpression<Long> toLong(Expression<? extends Number> number)
- Specified by:
toLongin interfaceCriteriaBuilder- Specified by:
toLongin interfaceHibernateCriteriaBuilder- Specified by:
toLongin interfaceNodeBuilder
-
toInteger
public SqmExpression<Integer> toInteger(Expression<? extends Number> number)
- Specified by:
toIntegerin interfaceCriteriaBuilder- Specified by:
toIntegerin interfaceHibernateCriteriaBuilder- Specified by:
toIntegerin interfaceNodeBuilder
-
toFloat
public SqmExpression<Float> toFloat(Expression<? extends Number> number)
- Specified by:
toFloatin interfaceCriteriaBuilder- Specified by:
toFloatin interfaceHibernateCriteriaBuilder- Specified by:
toFloatin interfaceNodeBuilder
-
toDouble
public SqmExpression<Double> toDouble(Expression<? extends Number> number)
- Specified by:
toDoublein interfaceCriteriaBuilder- Specified by:
toDoublein interfaceHibernateCriteriaBuilder- Specified by:
toDoublein interfaceNodeBuilder
-
toBigDecimal
public SqmExpression<BigDecimal> toBigDecimal(Expression<? extends Number> number)
- Specified by:
toBigDecimalin interfaceCriteriaBuilder- Specified by:
toBigDecimalin interfaceHibernateCriteriaBuilder- Specified by:
toBigDecimalin interfaceNodeBuilder
-
toBigInteger
public SqmExpression<BigInteger> toBigInteger(Expression<? extends Number> number)
- Specified by:
toBigIntegerin interfaceCriteriaBuilder- Specified by:
toBigIntegerin interfaceHibernateCriteriaBuilder- Specified by:
toBigIntegerin interfaceNodeBuilder
-
toString
public SqmExpression<String> toString(Expression<Character> character)
- Specified by:
toStringin interfaceCriteriaBuilder- Specified by:
toStringin interfaceHibernateCriteriaBuilder- Specified by:
toStringin interfaceNodeBuilder
-
literal
public <T> SqmLiteral<T> literal(T value, SqmExpression<? extends T> typeInferenceSource)
-
literal
public <T> SqmLiteral<T> literal(T value)
- Specified by:
literalin interfaceCriteriaBuilder- Specified by:
literalin interfaceHibernateCriteriaBuilder- Specified by:
literalin interfaceNodeBuilder
-
literals
public <T> List<? extends SqmExpression<T>> literals(T[] values)
- Specified by:
literalsin interfaceHibernateCriteriaBuilder- Specified by:
literalsin interfaceNodeBuilder
-
literals
public <T> List<? extends SqmExpression<T>> literals(List<T> values)
- Specified by:
literalsin interfaceHibernateCriteriaBuilder- Specified by:
literalsin interfaceNodeBuilder
-
nullLiteral
public <T> SqmExpression<T> nullLiteral(Class<T> resultClass)
- Specified by:
nullLiteralin interfaceCriteriaBuilder- Specified by:
nullLiteralin interfaceHibernateCriteriaBuilder- Specified by:
nullLiteralin interfaceNodeBuilder
-
parameter
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass)
- Specified by:
parameterin interfaceCriteriaBuilder- Specified by:
parameterin interfaceHibernateCriteriaBuilder- Specified by:
parameterin interfaceNodeBuilder- See Also:
JpaParameterExpression
-
parameter
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass, String name)
- Specified by:
parameterin interfaceCriteriaBuilder- Specified by:
parameterin interfaceHibernateCriteriaBuilder- Specified by:
parameterin interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(Expression<String> x, Expression<String> y)
- Specified by:
concatin interfaceCriteriaBuilder- Specified by:
concatin interfaceHibernateCriteriaBuilder- Specified by:
concatin interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(Expression<String> x, String y)
- Specified by:
concatin interfaceCriteriaBuilder- Specified by:
concatin interfaceHibernateCriteriaBuilder- Specified by:
concatin interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(String x, Expression<String> y)
- Specified by:
concatin interfaceCriteriaBuilder- Specified by:
concatin interfaceHibernateCriteriaBuilder- Specified by:
concatin interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(String x, String y)
- Specified by:
concatin interfaceHibernateCriteriaBuilder- Specified by:
concatin interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, Expression<Integer> from)
- Specified by:
substringin interfaceCriteriaBuilder- Specified by:
substringin interfaceHibernateCriteriaBuilder- Specified by:
substringin interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, int from)
- Specified by:
substringin interfaceCriteriaBuilder- Specified by:
substringin interfaceHibernateCriteriaBuilder- Specified by:
substringin interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, Expression<Integer> from, Expression<Integer> len)
- Specified by:
substringin interfaceCriteriaBuilder- Specified by:
substringin interfaceHibernateCriteriaBuilder- Specified by:
substringin interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, int from, int len)
- Specified by:
substringin interfaceCriteriaBuilder- Specified by:
substringin interfaceHibernateCriteriaBuilder- Specified by:
substringin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(Expression<Character> trimChar, Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, Expression<Character> trimChar, Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(char trimChar, Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, char trimChar, Expression<String> source)
- Specified by:
trimin interfaceCriteriaBuilder- Specified by:
trimin interfaceHibernateCriteriaBuilder- Specified by:
trimin interfaceNodeBuilder
-
lower
public SqmFunction<String> lower(Expression<String> x)
- Specified by:
lowerin interfaceCriteriaBuilder- Specified by:
lowerin interfaceHibernateCriteriaBuilder- Specified by:
lowerin interfaceNodeBuilder
-
upper
public SqmFunction<String> upper(Expression<String> x)
- Specified by:
upperin interfaceCriteriaBuilder- Specified by:
upperin interfaceHibernateCriteriaBuilder- Specified by:
upperin interfaceNodeBuilder
-
length
public SqmFunction<Integer> length(Expression<String> argument)
- Specified by:
lengthin interfaceCriteriaBuilder- Specified by:
lengthin interfaceHibernateCriteriaBuilder- Specified by:
lengthin interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, Expression<String> pattern)
- Specified by:
locatein interfaceCriteriaBuilder- Specified by:
locatein interfaceHibernateCriteriaBuilder- Specified by:
locatein interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, String pattern)
- Specified by:
locatein interfaceCriteriaBuilder- Specified by:
locatein interfaceHibernateCriteriaBuilder- Specified by:
locatein interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, Expression<String> pattern, Expression<Integer> startPosition)
- Specified by:
locatein interfaceCriteriaBuilder- Specified by:
locatein interfaceHibernateCriteriaBuilder- Specified by:
locatein interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, String pattern, int startPosition)
- Specified by:
locatein interfaceCriteriaBuilder- Specified by:
locatein interfaceHibernateCriteriaBuilder- Specified by:
locatein interfaceNodeBuilder
-
currentDate
public SqmFunction<Date> currentDate()
- Specified by:
currentDatein interfaceCriteriaBuilder- Specified by:
currentDatein interfaceHibernateCriteriaBuilder- Specified by:
currentDatein interfaceNodeBuilder
-
currentTimestamp
public SqmFunction<Timestamp> currentTimestamp()
- Specified by:
currentTimestampin interfaceCriteriaBuilder- Specified by:
currentTimestampin interfaceHibernateCriteriaBuilder- Specified by:
currentTimestampin interfaceNodeBuilder
-
currentTime
public SqmFunction<Time> currentTime()
- Specified by:
currentTimein interfaceCriteriaBuilder- Specified by:
currentTimein interfaceHibernateCriteriaBuilder- Specified by:
currentTimein interfaceNodeBuilder
-
currentInstant
public SqmFunction<Instant> currentInstant()
- Specified by:
currentInstantin interfaceHibernateCriteriaBuilder- Specified by:
currentInstantin interfaceNodeBuilder
-
localDate
public JpaExpression<LocalDate> localDate()
Description copied from interface:HibernateCriteriaBuilderCreate expression to return current local date.- Specified by:
localDatein interfaceCriteriaBuilder- Specified by:
localDatein interfaceHibernateCriteriaBuilder- Returns:
- expression for current date
-
localDateTime
public JpaExpression<LocalDateTime> localDateTime()
Description copied from interface:HibernateCriteriaBuilderCreate expression to return current local datetime.- Specified by:
localDateTimein interfaceCriteriaBuilder- Specified by:
localDateTimein interfaceHibernateCriteriaBuilder- Returns:
- expression for current timestamp
-
localTime
public JpaExpression<LocalTime> localTime()
Description copied from interface:HibernateCriteriaBuilderCreate expression to return current local time.- Specified by:
localTimein interfaceCriteriaBuilder- Specified by:
localTimein interfaceHibernateCriteriaBuilder- Returns:
- expression for current time
-
function
public <T> SqmFunction<T> function(String name, Class<T> type, Expression<?>[] args)
- Specified by:
functionin interfaceCriteriaBuilder- Specified by:
functionin interfaceHibernateCriteriaBuilder- Specified by:
functionin interfaceNodeBuilder
-
all
public <Y> SqmModifiedSubQueryExpression<Y> all(Subquery<Y> subquery)
- Specified by:
allin interfaceCriteriaBuilder- Specified by:
allin interfaceHibernateCriteriaBuilder- Specified by:
allin interfaceNodeBuilder
-
some
public <Y> SqmModifiedSubQueryExpression<Y> some(Subquery<Y> subquery)
- Specified by:
somein interfaceCriteriaBuilder- Specified by:
somein interfaceHibernateCriteriaBuilder- Specified by:
somein interfaceNodeBuilder
-
any
public <Y> SqmModifiedSubQueryExpression<Y> any(Subquery<Y> subquery)
- Specified by:
anyin interfaceCriteriaBuilder- Specified by:
anyin interfaceHibernateCriteriaBuilder- Specified by:
anyin interfaceNodeBuilder
-
keys
public <K,M extends Map<K,?>> SqmExpression<Set<K>> keys(M map)
- Specified by:
keysin interfaceCriteriaBuilder- Specified by:
keysin interfaceHibernateCriteriaBuilder- Specified by:
keysin interfaceNodeBuilder
-
indexes
public <K,L extends List<?>> SqmExpression<Set<K>> indexes(L list)
- Specified by:
indexesin interfaceHibernateCriteriaBuilder- Specified by:
indexesin interfaceNodeBuilder
-
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:
valuein interfaceHibernateCriteriaBuilder
-
values
public <V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
- Specified by:
valuesin interfaceCriteriaBuilder- Specified by:
valuesin interfaceHibernateCriteriaBuilder- Specified by:
valuesin interfaceNodeBuilder
-
size
public <C extends Collection<?>> SqmExpression<Integer> size(Expression<C> collection)
- Specified by:
sizein interfaceCriteriaBuilder- Specified by:
sizein interfaceHibernateCriteriaBuilder- Specified by:
sizein interfaceNodeBuilder
-
size
public <C extends Collection<?>> SqmExpression<Integer> size(C collection)
- Specified by:
sizein interfaceCriteriaBuilder- Specified by:
sizein interfaceHibernateCriteriaBuilder- Specified by:
sizein interfaceNodeBuilder
-
coalesce
public <T> SqmCoalesce<T> coalesce()
- Specified by:
coalescein interfaceCriteriaBuilder- Specified by:
coalescein interfaceHibernateCriteriaBuilder- Specified by:
coalescein interfaceNodeBuilder
-
coalesce
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
coalescein interfaceCriteriaBuilder- Specified by:
coalescein interfaceHibernateCriteriaBuilder- Specified by:
coalescein interfaceNodeBuilder
-
coalesce
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x, Y y)
- Specified by:
coalescein interfaceCriteriaBuilder- Specified by:
coalescein interfaceHibernateCriteriaBuilder- Specified by:
coalescein interfaceNodeBuilder
-
nullif
public <Y> SqmExpression<Y> nullif(Expression<Y> x, Expression<?> y)
- Specified by:
nullifin interfaceCriteriaBuilder- Specified by:
nullifin interfaceHibernateCriteriaBuilder- Specified by:
nullifin interfaceNodeBuilder
-
nullif
public <Y> SqmExpression<Y> nullif(Expression<Y> x, Y y)
- Specified by:
nullifin interfaceCriteriaBuilder- Specified by:
nullifin interfaceHibernateCriteriaBuilder- Specified by:
nullifin interfaceNodeBuilder
-
selectCase
public <C,R> SqmCaseSimple<C,R> selectCase(Expression<? extends C> expression)
- Specified by:
selectCasein interfaceCriteriaBuilder- Specified by:
selectCasein interfaceHibernateCriteriaBuilder- Specified by:
selectCasein interfaceNodeBuilder
-
selectCase
public <R> SqmCaseSearched<R> selectCase()
- Specified by:
selectCasein interfaceCriteriaBuilder- Specified by:
selectCasein interfaceHibernateCriteriaBuilder- Specified by:
selectCasein interfaceNodeBuilder
-
mapSize
public <M extends Map<?,?>> SqmExpression<Integer> mapSize(JpaExpression<M> mapExpression)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that tests the size of a map.- Specified by:
mapSizein interfaceHibernateCriteriaBuilder- Specified by:
mapSizein interfaceNodeBuilder- 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:HibernateCriteriaBuilderCreate an expression that tests the size of a map.- Specified by:
mapSizein interfaceHibernateCriteriaBuilder- Specified by:
mapSizein interfaceNodeBuilder- 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:
andin interfaceCriteriaBuilder- Specified by:
andin interfaceHibernateCriteriaBuilder- Specified by:
andin interfaceNodeBuilder
-
and
public SqmPredicate and(Predicate... restrictions)
- Specified by:
andin interfaceCriteriaBuilder- Specified by:
andin interfaceHibernateCriteriaBuilder- Specified by:
andin interfaceNodeBuilder
-
or
public SqmPredicate or(Expression<Boolean> x, Expression<Boolean> y)
- Specified by:
orin interfaceCriteriaBuilder- Specified by:
orin interfaceHibernateCriteriaBuilder- Specified by:
orin interfaceNodeBuilder
-
or
public SqmPredicate or(Predicate... restrictions)
- Specified by:
orin interfaceCriteriaBuilder- Specified by:
orin interfaceHibernateCriteriaBuilder- Specified by:
orin interfaceNodeBuilder
-
not
public SqmPredicate not(Expression<Boolean> restriction)
- Specified by:
notin interfaceCriteriaBuilder- Specified by:
notin interfaceHibernateCriteriaBuilder- Specified by:
notin interfaceNodeBuilder
-
conjunction
public SqmPredicate conjunction()
- Specified by:
conjunctionin interfaceCriteriaBuilder- Specified by:
conjunctionin interfaceHibernateCriteriaBuilder- Specified by:
conjunctionin interfaceNodeBuilder
-
disjunction
public SqmPredicate disjunction()
- Specified by:
disjunctionin interfaceCriteriaBuilder- Specified by:
disjunctionin interfaceHibernateCriteriaBuilder- Specified by:
disjunctionin interfaceNodeBuilder
-
isTrue
public SqmPredicate isTrue(Expression<Boolean> x)
- Specified by:
isTruein interfaceCriteriaBuilder- Specified by:
isTruein interfaceHibernateCriteriaBuilder- Specified by:
isTruein interfaceNodeBuilder
-
isFalse
public SqmPredicate isFalse(Expression<Boolean> x)
- Specified by:
isFalsein interfaceCriteriaBuilder- Specified by:
isFalsein interfaceHibernateCriteriaBuilder- Specified by:
isFalsein interfaceNodeBuilder
-
isNull
public SqmPredicate isNull(Expression<?> x)
- Specified by:
isNullin interfaceCriteriaBuilder- Specified by:
isNullin interfaceHibernateCriteriaBuilder- Specified by:
isNullin interfaceNodeBuilder
-
isNotNull
public SqmPredicate isNotNull(Expression<?> x)
- Specified by:
isNotNullin interfaceCriteriaBuilder- Specified by:
isNotNullin interfaceHibernateCriteriaBuilder- Specified by:
isNotNullin interfaceNodeBuilder
-
between
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)
- Specified by:
betweenin interfaceCriteriaBuilder- Specified by:
betweenin interfaceHibernateCriteriaBuilder- Specified by:
betweenin interfaceNodeBuilder
-
between
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value, Y lower, Y upper)
- Specified by:
betweenin interfaceCriteriaBuilder- Specified by:
betweenin interfaceHibernateCriteriaBuilder- Specified by:
betweenin interfaceNodeBuilder
-
equal
public SqmPredicate equal(Expression<?> x, Expression<?> y)
- Specified by:
equalin interfaceCriteriaBuilder- Specified by:
equalin interfaceHibernateCriteriaBuilder- Specified by:
equalin interfaceNodeBuilder
-
equal
public SqmPredicate equal(Expression<?> x, Object y)
- Specified by:
equalin interfaceCriteriaBuilder- Specified by:
equalin interfaceHibernateCriteriaBuilder- Specified by:
equalin interfaceNodeBuilder
-
notEqual
public SqmPredicate notEqual(Expression<?> x, Expression<?> y)
- Specified by:
notEqualin interfaceCriteriaBuilder- Specified by:
notEqualin interfaceHibernateCriteriaBuilder- Specified by:
notEqualin interfaceNodeBuilder
-
notEqual
public SqmPredicate notEqual(Expression<?> x, Object y)
- Specified by:
notEqualin interfaceCriteriaBuilder- Specified by:
notEqualin interfaceHibernateCriteriaBuilder- Specified by:
notEqualin interfaceNodeBuilder
-
distinctFrom
public SqmPredicate distinctFrom(Expression<?> x, Expression<?> y)
- Specified by:
distinctFromin interfaceHibernateCriteriaBuilder- Specified by:
distinctFromin interfaceNodeBuilder
-
distinctFrom
public SqmPredicate distinctFrom(Expression<?> x, Object y)
- Specified by:
distinctFromin interfaceHibernateCriteriaBuilder- Specified by:
distinctFromin interfaceNodeBuilder
-
notDistinctFrom
public SqmPredicate notDistinctFrom(Expression<?> x, Expression<?> y)
- Specified by:
notDistinctFromin interfaceHibernateCriteriaBuilder- Specified by:
notDistinctFromin interfaceNodeBuilder
-
notDistinctFrom
public SqmPredicate notDistinctFrom(Expression<?> x, Object y)
- Specified by:
notDistinctFromin interfaceHibernateCriteriaBuilder- Specified by:
notDistinctFromin interfaceNodeBuilder
-
greaterThan
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
greaterThanin interfaceCriteriaBuilder- Specified by:
greaterThanin interfaceHibernateCriteriaBuilder- Specified by:
greaterThanin interfaceNodeBuilder
-
greaterThan
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x, Y y)
- Specified by:
greaterThanin interfaceCriteriaBuilder- Specified by:
greaterThanin interfaceHibernateCriteriaBuilder- Specified by:
greaterThanin interfaceNodeBuilder
-
greaterThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
greaterThanOrEqualToin interfaceCriteriaBuilder- Specified by:
greaterThanOrEqualToin interfaceHibernateCriteriaBuilder- Specified by:
greaterThanOrEqualToin interfaceNodeBuilder
-
greaterThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x, Y y)
- Specified by:
greaterThanOrEqualToin interfaceCriteriaBuilder- Specified by:
greaterThanOrEqualToin interfaceHibernateCriteriaBuilder- Specified by:
greaterThanOrEqualToin interfaceNodeBuilder
-
lessThan
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
lessThanin interfaceCriteriaBuilder- Specified by:
lessThanin interfaceHibernateCriteriaBuilder- Specified by:
lessThanin interfaceNodeBuilder
-
lessThan
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x, Y y)
- Specified by:
lessThanin interfaceCriteriaBuilder- Specified by:
lessThanin interfaceHibernateCriteriaBuilder- Specified by:
lessThanin interfaceNodeBuilder
-
lessThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
lessThanOrEqualToin interfaceCriteriaBuilder- Specified by:
lessThanOrEqualToin interfaceHibernateCriteriaBuilder- Specified by:
lessThanOrEqualToin interfaceNodeBuilder
-
lessThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x, Y y)
- Specified by:
lessThanOrEqualToin interfaceCriteriaBuilder- Specified by:
lessThanOrEqualToin interfaceHibernateCriteriaBuilder- Specified by:
lessThanOrEqualToin interfaceNodeBuilder
-
gt
public SqmPredicate gt(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
gtin interfaceCriteriaBuilder- Specified by:
gtin interfaceHibernateCriteriaBuilder- Specified by:
gtin interfaceNodeBuilder
-
gt
public SqmPredicate gt(Expression<? extends Number> x, Number y)
- Specified by:
gtin interfaceCriteriaBuilder- Specified by:
gtin interfaceHibernateCriteriaBuilder- Specified by:
gtin interfaceNodeBuilder
-
ge
public SqmPredicate ge(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
gein interfaceCriteriaBuilder- Specified by:
gein interfaceHibernateCriteriaBuilder- Specified by:
gein interfaceNodeBuilder
-
ge
public SqmPredicate ge(Expression<? extends Number> x, Number y)
- Specified by:
gein interfaceCriteriaBuilder- Specified by:
gein interfaceHibernateCriteriaBuilder- Specified by:
gein interfaceNodeBuilder
-
lt
public SqmPredicate lt(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
ltin interfaceCriteriaBuilder- Specified by:
ltin interfaceHibernateCriteriaBuilder- Specified by:
ltin interfaceNodeBuilder
-
lt
public SqmPredicate lt(Expression<? extends Number> x, Number y)
- Specified by:
ltin interfaceCriteriaBuilder- Specified by:
ltin interfaceHibernateCriteriaBuilder- Specified by:
ltin interfaceNodeBuilder
-
le
public SqmPredicate le(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
lein interfaceCriteriaBuilder- Specified by:
lein interfaceHibernateCriteriaBuilder- Specified by:
lein interfaceNodeBuilder
-
le
public SqmPredicate le(Expression<? extends Number> x, Number y)
- Specified by:
lein interfaceCriteriaBuilder- Specified by:
lein interfaceHibernateCriteriaBuilder- Specified by:
lein interfaceNodeBuilder
-
isEmpty
public <C extends Collection<?>> SqmPredicate isEmpty(Expression<C> collection)
- Specified by:
isEmptyin interfaceCriteriaBuilder- Specified by:
isEmptyin interfaceHibernateCriteriaBuilder- Specified by:
isEmptyin interfaceNodeBuilder
-
isNotEmpty
public <C extends Collection<?>> SqmPredicate isNotEmpty(Expression<C> collection)
- Specified by:
isNotEmptyin interfaceCriteriaBuilder- Specified by:
isNotEmptyin interfaceHibernateCriteriaBuilder- Specified by:
isNotEmptyin interfaceNodeBuilder
-
isMember
public <E,C extends Collection<E>> SqmPredicate isMember(Expression<E> elem, Expression<C> collection)
- Specified by:
isMemberin interfaceCriteriaBuilder- Specified by:
isMemberin interfaceHibernateCriteriaBuilder- Specified by:
isMemberin interfaceNodeBuilder
-
isMember
public <E,C extends Collection<E>> SqmPredicate isMember(E elem, Expression<C> collection)
- Specified by:
isMemberin interfaceCriteriaBuilder- Specified by:
isMemberin interfaceHibernateCriteriaBuilder- Specified by:
isMemberin interfaceNodeBuilder
-
isNotMember
public <E,C extends Collection<E>> SqmPredicate isNotMember(Expression<E> elem, Expression<C> collection)
- Specified by:
isNotMemberin interfaceCriteriaBuilder- Specified by:
isNotMemberin interfaceHibernateCriteriaBuilder- Specified by:
isNotMemberin interfaceNodeBuilder
-
isNotMember
public <E,C extends Collection<E>> SqmPredicate isNotMember(E elem, Expression<C> collection)
- Specified by:
isNotMemberin interfaceCriteriaBuilder- Specified by:
isNotMemberin interfaceHibernateCriteriaBuilder- Specified by:
isNotMemberin interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern, char escapeChar)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern, char escapeChar)
- Specified by:
likein interfaceCriteriaBuilder- Specified by:
likein interfaceHibernateCriteriaBuilder- Specified by:
likein interfaceNodeBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern, char escapeChar)
- Specified by:
ilikein interfaceHibernateCriteriaBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern, char escapeChar)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern, char escapeChar)
- Specified by:
notLikein interfaceCriteriaBuilder- Specified by:
notLikein interfaceHibernateCriteriaBuilder- Specified by:
notLikein interfaceNodeBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern, char escapeChar)
- Specified by:
notIlikein interfaceHibernateCriteriaBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression)
- Specified by:
inin interfaceCriteriaBuilder- Specified by:
inin interfaceHibernateCriteriaBuilder- Specified by:
inin interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, Expression<? extends T>... values)
- Specified by:
inin interfaceHibernateCriteriaBuilder- Specified by:
inin interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, T... values)
- Specified by:
inin interfaceHibernateCriteriaBuilder- Specified by:
inin interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, Collection<T> values)
- Specified by:
inin interfaceHibernateCriteriaBuilder- Specified by:
inin interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)
- Specified by:
inin interfaceNodeBuilder
-
exists
public SqmPredicate exists(Subquery<?> subQuery)
- Specified by:
existsin interfaceCriteriaBuilder- Specified by:
existsin interfaceHibernateCriteriaBuilder- Specified by:
existsin interfaceNodeBuilder
-
isMapEmpty
public <M extends Map<?,?>> SqmPredicate isMapEmpty(JpaExpression<M> mapExpression)
Description copied from interface:HibernateCriteriaBuilderCreate a predicate that tests whether a Map is empty.- Specified by:
isMapEmptyin interfaceHibernateCriteriaBuilder- Specified by:
isMapEmptyin interfaceNodeBuilder- 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:HibernateCriteriaBuilderCreate a predicate that tests whether a Map is not empty.- Specified by:
isMapNotEmptyin interfaceHibernateCriteriaBuilder- Specified by:
isMapNotEmptyin interfaceNodeBuilder- 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:HibernateCriteriaBuilderEmbed nativepatternthat will be unquoted and embedded in the generated SQL. Occurrences of?in the pattern are replaced with the remainingargumentsof the function.- Specified by:
sqlin interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of this expression- Parameters:
pattern- native SQL patterntype- type of this expressionarguments- optional arguments to the SQL pattern- Returns:
- native SQL expression
-
format
public SqmFunction<String> format(Expression<? extends TemporalAccessor> datetime, String pattern)
Description copied from interface:HibernateCriteriaBuilderFormat a date, time, or datetime according to a pattern. The pattern must be written in a subset of the pattern language defined by Java’sDateTimeFormatter.See
Dialect.appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender, java.lang.String)for a full list of pattern elements.- Specified by:
formatin interfaceHibernateCriteriaBuilder- Parameters:
datetime- the datetime expression to formatpattern- the pattern to use for formatting- Returns:
- format expression
-
year
public SqmFunction<Integer> year(Expression<? extends TemporalAccessor> datetime)
Description copied from interface:HibernateCriteriaBuilderExtracts theTemporalUnit.YEARof a date, time, or datetime expression.- Specified by:
yearin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderExtracts theTemporalUnit.MONTHof a date, time, or datetime expression.- Specified by:
monthin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderExtracts theTemporalUnit.DAYof a date, time, or datetime expression.- Specified by:
dayin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderExtracts theTemporalUnit.HOURof a date, time, or datetime expression.- Specified by:
hourin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderExtracts theTemporalUnit.MINUTEof a date, time, or datetime expression.- Specified by:
minutein interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderExtracts theTemporalUnit.SECONDof a date, time, or datetime expression.- Specified by:
secondin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderTruncates a date, time or datetime expression to the givenTemporalUnit. 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
fieldhave been pruned. For hours, minutes and second this means setting them to00. For months and days, this means setting them to01.- Specified by:
truncatein interfaceHibernateCriteriaBuilder- Parameters:
datetime- the date, time or datetime expression to be truncatedtemporalUnit- the temporal unit for truncation- Returns:
- the truncated value
-
overlay
public SqmFunction<String> overlay(Expression<String> string, String replacement, int start)
- Specified by:
overlayin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, Expression<String> replacement, int start)
- Specified by:
overlayin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, String replacement, Expression<Integer> start)
- Specified by:
overlayin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)
- Specified by:
overlayin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, String replacement, int start, int length)
- Specified by:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:
overlayin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderOverlay thestringexpression with thereplacementexpression, starting from indexstartand substituting a number of characters corresponding to the length of thereplacementexpression or thelengthparameter if specified.- Specified by:
overlayin interfaceHibernateCriteriaBuilder- Parameters:
string- string expression to be manipulatedreplacement- string expression to replace in originalstart- start positionlength- optional, number of characters to substitute- Returns:
- overlay expression
-
pad
public SqmFunction<String> pad(Expression<String> x, int length)
- Specified by:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)
- Specified by:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, Expression<Integer> length)
- Specified by:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts, Expression<String> x, Expression<Integer> length)
- Specified by:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, int length, char padChar)
- Specified by:
padin interfaceHibernateCriteriaBuilder- 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:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, int length, Expression<Character> padChar)
- Specified by:
padin interfaceHibernateCriteriaBuilder- 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:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, Expression<Integer> length, char padChar)
- Specified by:
padin interfaceHibernateCriteriaBuilder- 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:
padin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)
- Specified by:
padin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderPad the specified string expression with whitespace or with thepadCharcharacter if specified. Optionally pass aCriteriaBuilder.Trimspecto pad the string expression withLEADINGorTRAILING(default) characters.- Specified by:
padin interfaceHibernateCriteriaBuilder- Parameters:
ts- optionalCriteriaBuilder.Trimspecx- string expression to padlength- length of the result string after paddingpadChar- optional pad character- Returns:
- pad expression
-
repeat
public JpaFunction<String> repeat(Expression<String> x, Expression<Integer> times)
Description copied from interface:HibernateCriteriaBuilderConcatenate the given string expression with itself the given number of times.- Specified by:
repeatin interfaceHibernateCriteriaBuilder- Parameters:
x- the string expression to concatenatetimes- 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:HibernateCriteriaBuilderConcatenate the given string expression with itself the given number of times.- Specified by:
repeatin interfaceHibernateCriteriaBuilder- Parameters:
x- the string expression to concatenatetimes- 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:HibernateCriteriaBuilderConcatenate the given string expression with itself the given number of times.- Specified by:
repeatin interfaceHibernateCriteriaBuilder- Parameters:
x- the string expression to concatenatetimes- the number of times it should be repeated- Returns:
- repeat expression
-
left
public SqmFunction<String> left(Expression<String> x, int length)
- Specified by:
leftin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.left(Expression, Expression)
-
left
public SqmFunction<String> left(Expression<String> x, Expression<Integer> length)
Description copied from interface:HibernateCriteriaBuilderExtract thelengthleftmost characters of a string.- Specified by:
leftin interfaceHibernateCriteriaBuilder- Parameters:
x- original stringlength- number of characters- Returns:
- left expression
-
right
public SqmFunction<String> right(Expression<String> x, int length)
- Specified by:
rightin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.right(Expression, Expression)
-
right
public SqmFunction<String> right(Expression<String> x, Expression<Integer> length)
Description copied from interface:HibernateCriteriaBuilderExtract thelengthrightmost characters of a string.- Specified by:
rightin interfaceHibernateCriteriaBuilder- Parameters:
x- original stringlength- number of characters- Returns:
- left expression
-
replace
public SqmFunction<String> replace(Expression<String> x, String pattern, String replacement)
- Specified by:
replacein interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
-
replace
public SqmFunction<String> replace(Expression<String> x, String pattern, Expression<String> replacement)
- Specified by:
replacein interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
-
replace
public SqmFunction<String> replace(Expression<String> x, Expression<String> pattern, String replacement)
- Specified by:
replacein interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderReplace all occurrences ofpatternwithin the original string withreplacement.- Specified by:
replacein interfaceHibernateCriteriaBuilder- Parameters:
x- original stringpattern- the string to be replacedreplacement- the new replacement string- Returns:
- replace expression
-
collate
public SqmFunction<String> collate(Expression<String> x, String collation)
- Specified by:
collatein interfaceHibernateCriteriaBuilder
-
log10
public SqmFunction<Double> log10(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the base-10 logarithm of its argument.- Specified by:
log10in interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- base-10 logarithm
-
log
public SqmFunction<Double> log(Number b, Expression<? extends Number> x)
- Specified by:
login interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.log(Expression, Expression)
-
log
public SqmFunction<Double> log(Expression<? extends Number> b, Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the logarithm ofxto the baseb.- Specified by:
login interfaceHibernateCriteriaBuilder- Parameters:
b- basex- expression- Returns:
- arbitrary-base logarithm
-
pi
public SqmFunction<Double> pi()
Description copied from interface:HibernateCriteriaBuilderLiteral expression corresponding to the value of pi.- Specified by:
piin interfaceHibernateCriteriaBuilder- Returns:
- pi expression
-
sin
public SqmFunction<Double> sin(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the sine of its argument.- Specified by:
sinin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- sine
-
cos
public SqmFunction<Double> cos(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the cosine of its argument.- Specified by:
cosin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- cosine
-
tan
public SqmFunction<Double> tan(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the tangent of its argument.- Specified by:
tanin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- tangent
-
asin
public SqmFunction<Double> asin(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the inverse sine of its argument.- Specified by:
asinin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- inverse sine
-
acos
public SqmFunction<Double> acos(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the inverse cosine of its argument.- Specified by:
acosin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- inverse cosine
-
atan
public SqmFunction<Double> atan(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the inverse tangent of its argument.- Specified by:
atanin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- inverse tangent
-
atan2
public SqmFunction<Double> atan2(Number y, Expression<? extends Number> x)
- Specified by:
atan2in interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.atan2(Expression, Expression)
-
atan2
public SqmFunction<Double> atan2(Expression<? extends Number> y, Number x)
- Specified by:
atan2in interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.atan2(Expression, Expression)
-
atan2
public SqmFunction<Double> atan2(Expression<? extends Number> y, Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the inverse tangent ofyoverx.- Specified by:
atan2in interfaceHibernateCriteriaBuilder- Parameters:
y- y coordinatex- x coordinate- Returns:
- 2-argument inverse tangent
-
sinh
public SqmFunction<Double> sinh(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the hyperbolic sine of its argument.- Specified by:
sinhin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- hyperbolic sine
-
cosh
public SqmFunction<Double> cosh(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the hyperbolic cosine of its argument.- Specified by:
coshin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- hyperbolic cosine
-
tanh
public SqmFunction<Double> tanh(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that returns the hyperbolic tangent of its argument.- Specified by:
tanhin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- hyperbolic tangent
-
degrees
public SqmFunction<Double> degrees(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.- Specified by:
degreesin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- degrees
-
radians
public SqmFunction<Double> radians(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilderCreate an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.- Specified by:
radiansin interfaceHibernateCriteriaBuilder- Parameters:
x- expression- Returns:
- radians
-
createWindow
public SqmWindow createWindow()
Description copied from interface:HibernateCriteriaBuilderCreate an emptyJpaWindowto use with window and aggregate functions.- Specified by:
createWindowin interfaceHibernateCriteriaBuilder- Returns:
- the empty window
-
frameUnboundedPreceding
public SqmWindowFrame frameUnboundedPreceding()
Description copied from interface:HibernateCriteriaBuilderCreate a window frame of typeFrameKind.UNBOUNDED_PRECEDINGto use withJpaWindows.- Specified by:
frameUnboundedPrecedingin interfaceHibernateCriteriaBuilder- Returns:
- the window frame
-
frameBetweenPreceding
public SqmWindowFrame frameBetweenPreceding(int offset)
- Specified by:
frameBetweenPrecedingin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.frameBetweenPreceding(Expression)
-
frameBetweenPreceding
public SqmWindowFrame frameBetweenPreceding(Expression<?> offset)
Description copied from interface:HibernateCriteriaBuilderCreate window frame of typeFrameKind.OFFSET_PRECEDINGto use withJpaWindows.- Specified by:
frameBetweenPrecedingin interfaceHibernateCriteriaBuilder- Parameters:
offset- theoffsetexpression- Returns:
- the window frame
-
frameCurrentRow
public SqmWindowFrame frameCurrentRow()
Description copied from interface:HibernateCriteriaBuilderCreate a window frame of typeFrameKind.CURRENT_ROWto use withJpaWindows.- Specified by:
frameCurrentRowin interfaceHibernateCriteriaBuilder- Returns:
- the window frame
-
frameBetweenFollowing
public SqmWindowFrame frameBetweenFollowing(int offset)
- Specified by:
frameBetweenFollowingin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.frameBetweenFollowing(Expression)
-
frameBetweenFollowing
public SqmWindowFrame frameBetweenFollowing(Expression<?> offset)
Description copied from interface:HibernateCriteriaBuilderCreate a window frame of typeFrameKind.OFFSET_FOLLOWINGto use withJpaWindows.- Specified by:
frameBetweenFollowingin interfaceHibernateCriteriaBuilder- Parameters:
offset- theoffsetexpression- Returns:
- the window frame
-
frameUnboundedFollowing
public SqmWindowFrame frameUnboundedFollowing()
Description copied from interface:HibernateCriteriaBuilderCreate a window frame of typeFrameKind.UNBOUNDED_FOLLOWINGto use withJpaWindows.- Specified by:
frameUnboundedFollowingin interfaceHibernateCriteriaBuilder- Returns:
- the window frame
-
windowFunction
public <T> SqmExpression<T> windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)
Description copied from interface:HibernateCriteriaBuilderCreate a generic window function expression that will be applied over the specifiedwindow.- Specified by:
windowFunctionin interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of this expression- Parameters:
name- name of the window functiontype- type of this expressionwindow- window over which the function will be appliedargs- arguments to the function- Returns:
- window function expression
-
rowNumber
public SqmExpression<Long> rowNumber(JpaWindow window)
Description copied from interface:HibernateCriteriaBuilderCreate arow_numberwindow function expression.- Specified by:
rowNumberin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate afirst_valuewindow function expression.- Specified by:
firstValuein interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of the expression- Parameters:
argument- argument expression to pass tofirst_valuewindow- 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:HibernateCriteriaBuilderCreate alast_valuewindow function expression.- Specified by:
lastValuein interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of the expression- Parameters:
argument- argument expression to pass tolast_valuewindow- 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:
nthValuein interfaceHibernateCriteriaBuilder- See Also:
nthValue
-
nthValue
public <T> SqmExpression<T> nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)
Description copied from interface:HibernateCriteriaBuilderCreate anth_valuewindow function expression.- Specified by:
nthValuein interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of the expression- Parameters:
argument- argument expression to pass tonth_valuen- theNargument for the functionwindow- 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:HibernateCriteriaBuilderCreate arankwindow function expression.- Specified by:
rankin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate adense_rankwindow function expression.- Specified by:
denseRankin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate apercent_rankwindow function expression.- Specified by:
percentRankin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate acume_distwindow function expression.- Specified by:
cumeDistin interfaceHibernateCriteriaBuilder- 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:
functionAggregatein interfaceHibernateCriteriaBuilder- 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:
functionAggregatein interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate a generic aggregate function expression.- Specified by:
functionAggregatein interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of this expression- Parameters:
name- name of the ordered set-aggregate functiontype- type of this expressionfilter- optional filter clausewindow- optional window over which to apply the functionargs- optional arguments to the function- Returns:
- aggregate function expression
-
sum
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument, JpaPredicate filter)
- Specified by:
sumin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)
-
sum
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument, JpaWindow window)
- Specified by:
sumin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate asumaggregate function expression.- Specified by:
sumin interfaceHibernateCriteriaBuilder- Type Parameters:
N- type of the input expression- Parameters:
argument- argument to the functionfilter- optional filter clausewindow- optional window over which to apply the function- Returns:
- aggregate function expression
- See Also:
HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
-
avg
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument, JpaPredicate filter)
- Specified by:
avgin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)
-
avg
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument, JpaWindow window)
- Specified by:
avgin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate anavgaggregate function expression.- Specified by:
avgin interfaceHibernateCriteriaBuilder- Type Parameters:
N- type of the input expression- Parameters:
argument- argument to the functionfilter- optional filter clausewindow- optional window over which to apply the function- Returns:
- aggregate function expression
- See Also:
HibernateCriteriaBuilder.functionAggregate(String, Class, JpaPredicate, JpaWindow, Expression...)
-
count
public SqmExpression<Long> count(Expression<?> argument, JpaPredicate filter)
- Specified by:
countin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
-
count
public SqmExpression<Long> count(Expression<?> argument, JpaWindow window)
- Specified by:
countin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
-
count
public SqmExpression<Long> count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
Description copied from interface:HibernateCriteriaBuilderCreate acountaggregate function expression.- Specified by:
countin interfaceHibernateCriteriaBuilder- Parameters:
argument- argument to the functionfilter- optional filter clausewindow- 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:
functionWithinGroupin interfaceHibernateCriteriaBuilder- 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:
functionWithinGroupin interfaceHibernateCriteriaBuilder- 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:
functionWithinGroupin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate a generic ordered set-aggregate function expression.- Specified by:
functionWithinGroupin interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of this expression- Parameters:
name- name of the ordered set-aggregate functiontype- type of this expressionorder- order by clause used in within groupfilter- optional filter clausewindow- optional window over which to apply the functionargs- optional arguments to the function- Returns:
- ordered set-aggregate function expression
-
listagg
public SqmExpression<String> listagg(JpaOrder order, Expression<String> argument, String separator)
- Specified by:
listaggin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.listagg(JpaOrder, JpaPredicate, JpaWindow, Expression, Expression)
-
listagg
public SqmExpression<String> listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
- Specified by:
listaggin interfaceHibernateCriteriaBuilder- 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:
listaggin interfaceHibernateCriteriaBuilder- 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:
listaggin interfaceHibernateCriteriaBuilder- 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:
listaggin interfaceHibernateCriteriaBuilder- 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:
listaggin interfaceHibernateCriteriaBuilder- 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:
listaggin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate alistaggordered set-aggregate function expression.- Specified by:
listaggin interfaceHibernateCriteriaBuilder- Parameters:
order- order by clause used in within groupfilter- optional filter clausewindow- optional window over which to apply the functionargument- values to joinseparator- the separator used to join the values- Returns:
- ordered set-aggregate expression
- See Also:
HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
mode
public <T> SqmExpression<T> mode(Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
- Specified by:
modein interfaceHibernateCriteriaBuilder- 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:
modein interfaceHibernateCriteriaBuilder- 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:
modein interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate amodeordered set-aggregate function expression.- Specified by:
modein interfaceHibernateCriteriaBuilder- Type Parameters:
T- type of this expression- Parameters:
filter- optional filter clausewindow- optional window over which to apply the functionsortExpression- the sort expressionsortOrder- the sort ordernullPrecedence- the null precedence- Returns:
- ordered set-aggregate expression
- See Also:
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)
-
percentileCont
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
-
percentileCont
public <T> SqmExpression<T> percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence 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:HibernateCriteriaBuilderCreate apercentile_contordered set-aggregate function expression.- Specified by:
percentileContin interfaceHibernateCriteriaBuilder- Parameters:
argument- argument to the functionfilter- optional filter clausewindow- optional window over which to apply the functionsortExpression- the sort expressionsortOrder- the sort ordernullPrecedence- the null precedence- Returns:
- ordered set-aggregate expression
- See Also:
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)
-
percentileDisc
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
-
percentileDisc
public <T> SqmExpression<T> percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence 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:HibernateCriteriaBuilderCreate apercentile_discordered set-aggregate function expression.- Specified by:
percentileDiscin interfaceHibernateCriteriaBuilder- Parameters:
argument- argument to the functionfilter- optional filter clausewindow- optional window over which to apply the functionsortExpression- the sort expressionsortOrder- the sort ordernullPrecedence- the null precedence- Returns:
- ordered set-aggregate expression
- See Also:
HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
rank
public SqmExpression<Long> rank(JpaOrder order, Expression<?>... arguments)
- Specified by:
rankin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
rank
public SqmExpression<Long> rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
- Specified by:
rankin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
rank
public SqmExpression<Long> rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
- Specified by:
rankin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate arankordered set-aggregate function expression.- Specified by:
rankin interfaceHibernateCriteriaBuilder- Parameters:
order- order by clause used in within groupfilter- optional filter clausewindow- optional window over which to apply the functionarguments- arguments to the function- Returns:
- ordered set-aggregate expression
- See Also:
HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
percentRank
public SqmExpression<Double> percentRank(JpaOrder order, Expression<?>... arguments)
- Specified by:
percentRankin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
percentRank
public SqmExpression<Double> percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
- Specified by:
percentRankin interfaceHibernateCriteriaBuilder- See Also:
HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
percentRank
public SqmExpression<Double> percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
- Specified by:
percentRankin interfaceHibernateCriteriaBuilder- 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:HibernateCriteriaBuilderCreate apercent_rankordered set-aggregate function expression.- Specified by:
percentRankin interfaceHibernateCriteriaBuilder- Parameters:
order- order by clause used in within groupfilter- optional filter clausewindow- optional window over which to apply the functionarguments- arguments to the function- Returns:
- ordered set-aggregate expression
- See Also:
HibernateCriteriaBuilder.functionWithinGroup(String, Class, JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
arrayAgg
public <T> SqmExpression<T[]> arrayAgg(JpaOrder order, Expression<? extends T> argument)
- Specified by:
arrayAggin interfaceHibernateCriteriaBuilder- Specified by:
arrayAggin interfaceNodeBuilder- See Also:
HibernateCriteriaBuilder.arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)
-
arrayAgg
public <T> SqmExpression<T[]> arrayAgg(JpaOrder order, JpaPredicate filter, Expression<? extends T> argument)
- Specified by:
arrayAggin interfaceHibernateCriteriaBuilder- Specified by:
arrayAggin interfaceNodeBuilder- See Also:
HibernateCriteriaBuilder.arrayAgg(JpaOrder, JpaPredicate, JpaWindow, Expression)
-
arrayAgg
public <T> SqmExpression<T[]> arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)
- Specified by:
arrayAggin interfaceHibernateCriteriaBuilder- Specified by:
arrayAggin interfaceNodeBuilder- 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:HibernateCriteriaBuilderCreate aarray_aggordered set-aggregate function expression.- Specified by:
arrayAggin interfaceHibernateCriteriaBuilder- Specified by:
arrayAggin interfaceNodeBuilder- Parameters:
order- order by clause used in within groupfilter- optional filter clausewindow- optional window over which to apply the functionargument- 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:HibernateCriteriaBuilderCreates an array literal with thearrayconstructor function.- Specified by:
arrayLiteralin interfaceHibernateCriteriaBuilder- Specified by:
arrayLiteralin interfaceNodeBuilder
-
arrayPosition
public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderDetermines the 1-based position of an element in an array.- Specified by:
arrayPositionin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionin interfaceNodeBuilder
-
arrayPosition
public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines the 1-based position of an element in an array.- Specified by:
arrayPositionin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionin interfaceNodeBuilder
-
arrayPositions
public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in an array.- Specified by:
arrayPositionsin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionsin interfaceNodeBuilder
-
arrayPositions
public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in an array.- Specified by:
arrayPositionsin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionsin interfaceNodeBuilder
-
arrayPositionsList
public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in an array.- Specified by:
arrayPositionsListin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionsListin interfaceNodeBuilder
-
arrayPositionsList
public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in an array.- Specified by:
arrayPositionsListin interfaceHibernateCriteriaBuilder- Specified by:
arrayPositionsListin interfaceNodeBuilder
-
arrayLength
public <T> SqmExpression<Integer> arrayLength(Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines the length of an array.- Specified by:
arrayLengthin interfaceHibernateCriteriaBuilder- Specified by:
arrayLengthin interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderConcatenates arrays with each other in order.- Specified by:
arrayConcatin interfaceHibernateCriteriaBuilder- Specified by:
arrayConcatin interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilderConcatenates arrays with each other in order.- Specified by:
arrayConcatin interfaceHibernateCriteriaBuilder- Specified by:
arrayConcatin interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderConcatenates arrays with each other in order.- Specified by:
arrayConcatin interfaceHibernateCriteriaBuilder- Specified by:
arrayConcatin interfaceNodeBuilder
-
arrayAppend
public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderAppends element to array.- Specified by:
arrayAppendin interfaceHibernateCriteriaBuilder- Specified by:
arrayAppendin interfaceNodeBuilder
-
arrayAppend
public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderAppends element to array.- Specified by:
arrayAppendin interfaceHibernateCriteriaBuilder- Specified by:
arrayAppendin interfaceNodeBuilder
-
arrayPrepend
public <T> SqmExpression<T[]> arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilderPrepends element to array.- Specified by:
arrayPrependin interfaceHibernateCriteriaBuilder- Specified by:
arrayPrependin interfaceNodeBuilder
-
arrayPrepend
public <T> SqmExpression<T[]> arrayPrepend(T element, Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilderPrepends element to array.- Specified by:
arrayPrependin interfaceHibernateCriteriaBuilder- Specified by:
arrayPrependin interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains an element.- Specified by:
arrayContainsin interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsin interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains an element.- Specified by:
arrayContainsin interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsin interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(T[] array, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains an element.- Specified by:
arrayContainsin interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsin interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains a nullable element.- Specified by:
arrayContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsNullablein interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains a nullable element.- Specified by:
arrayContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsNullablein interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(T[] array, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array contains a nullable element.- Specified by:
arrayContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayContainsNullablein interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array.- Specified by:
arrayIncludesin interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesin interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression, T[] subArray)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array.- Specified by:
arrayIncludesin interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesin interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(T[] array, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array.- Specified by:
arrayIncludesin interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesin interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesNullablein interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesNullablein interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilderWhether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIncludesNullablein interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array.- Specified by:
arrayIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsin interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array.- Specified by:
arrayIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsin interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array.- Specified by:
arrayIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsin interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array, supportingnullelements.- Specified by:
arrayIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsNullablein interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array, supportingnullelements.- Specified by:
arrayIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsNullablein interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one array has any elements common with another array, supportingnullelements.- Specified by:
arrayIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
arrayIntersectsNullablein interfaceNodeBuilder
-
arrayGet
public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilderAccesses the element of an array by 1-based index.- Specified by:
arrayGetin interfaceHibernateCriteriaBuilder- Specified by:
arrayGetin interfaceNodeBuilder
-
arrayGet
public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilderAccesses the element of an array by 1-based index.- Specified by:
arrayGetin interfaceHibernateCriteriaBuilder- Specified by:
arrayGetin interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element at given 1-based index.- Specified by:
arraySetin interfaceHibernateCriteriaBuilder- Specified by:
arraySetin interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element at given 1-based index.- Specified by:
arraySetin interfaceHibernateCriteriaBuilder- Specified by:
arraySetin interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element at given 1-based index.- Specified by:
arraySetin interfaceHibernateCriteriaBuilder- Specified by:
arraySetin interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Integer index, T element)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element at given 1-based index.- Specified by:
arraySetin interfaceHibernateCriteriaBuilder- Specified by:
arraySetin interfaceNodeBuilder
-
arrayRemove
public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element removed.- Specified by:
arrayRemovein interfaceHibernateCriteriaBuilder- Specified by:
arrayRemovein interfaceNodeBuilder
-
arrayRemove
public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with given element removed.- Specified by:
arrayRemovein interfaceHibernateCriteriaBuilder- Specified by:
arrayRemovein interfaceNodeBuilder
-
arrayRemoveIndex
public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with the element at the given 1-based index removed.- Specified by:
arrayRemoveIndexin interfaceHibernateCriteriaBuilder- Specified by:
arrayRemoveIndexin interfaceNodeBuilder
-
arrayRemoveIndex
public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilderCreates array copy with the element at the given 1-based index removed.- Specified by:
arrayRemoveIndexin interfaceHibernateCriteriaBuilder- Specified by:
arrayRemoveIndexin interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlicein interfaceHibernateCriteriaBuilder- Specified by:
arraySlicein interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlicein interfaceHibernateCriteriaBuilder- Specified by:
arraySlicein interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlicein interfaceHibernateCriteriaBuilder- Specified by:
arraySlicein interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlicein interfaceHibernateCriteriaBuilder- Specified by:
arraySlicein interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy replacing a given element with another.- Specified by:
arrayReplacein interfaceHibernateCriteriaBuilder- Specified by:
arrayReplacein interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)
Description copied from interface:HibernateCriteriaBuilderCreates array copy replacing a given element with another.- Specified by:
arrayReplacein interfaceHibernateCriteriaBuilder- Specified by:
arrayReplacein interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy replacing a given element with another.- Specified by:
arrayReplacein interfaceHibernateCriteriaBuilder- Specified by:
arrayReplacein interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)
Description copied from interface:HibernateCriteriaBuilderCreates array copy replacing a given element with another.- Specified by:
arrayReplacein interfaceHibernateCriteriaBuilder- Specified by:
arrayReplacein interfaceNodeBuilder
-
arrayTrim
public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array copy without the last N elements, specified by the second argument.- Specified by:
arrayTrimin interfaceHibernateCriteriaBuilder- Specified by:
arrayTrimin interfaceNodeBuilder
-
arrayTrim
public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilderCreates array copy without the last N elements, specified by the second argument.- Specified by:
arrayTrimin interfaceHibernateCriteriaBuilder- Specified by:
arrayTrimin interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array with the same element N times, as specified by the arguments.- Specified by:
arrayFillin interfaceHibernateCriteriaBuilder- Specified by:
arrayFillin interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilderCreates array with the same element N times, as specified by the arguments.- Specified by:
arrayFillin interfaceHibernateCriteriaBuilder- Specified by:
arrayFillin interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(T element, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilderCreates array with the same element N times, as specified by the arguments.- Specified by:
arrayFillin interfaceHibernateCriteriaBuilder- Specified by:
arrayFillin interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(T element, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilderCreates array with the same element N times, as specified by the arguments.- Specified by:
arrayFillin interfaceHibernateCriteriaBuilder- Specified by:
arrayFillin interfaceNodeBuilder
-
arrayToString
public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)
Description copied from interface:HibernateCriteriaBuilderConcatenates the non-null array elements with a separator, as specified by the arguments.- Specified by:
arrayToStringin interfaceHibernateCriteriaBuilder- Specified by:
arrayToStringin interfaceNodeBuilder
-
arrayToString
public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression, String separator)
Description copied from interface:HibernateCriteriaBuilderConcatenates the non-null array elements with a separator, as specified by the arguments.- Specified by:
arrayToStringin interfaceHibernateCriteriaBuilder- Specified by:
arrayToStringin interfaceNodeBuilder
-
collectionLiteral
public <E,C extends Collection<E>> SqmExpression<C> collectionLiteral(E... elements)
Description copied from interface:HibernateCriteriaBuilderCreates a basic collection literal with thearrayconstructor function.- Specified by:
collectionLiteralin interfaceHibernateCriteriaBuilder- Specified by:
collectionLiteralin interfaceNodeBuilder
-
collectionPosition
public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilderDetermines the 1-based position of an element in a basic collection.- Specified by:
collectionPositionin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionin interfaceNodeBuilder
-
collectionPosition
public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines the 1-based position of an element in a basic collection.- Specified by:
collectionPositionin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionin interfaceNodeBuilder
-
collectionPositions
public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionsin interfaceNodeBuilder
-
collectionPositions
public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionsin interfaceNodeBuilder
-
collectionPositionsList
public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsListin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionsListin interfaceNodeBuilder
-
collectionPositionsList
public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)
Description copied from interface:HibernateCriteriaBuilderDetermines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsListin interfaceHibernateCriteriaBuilder- Specified by:
collectionPositionsListin interfaceNodeBuilder
-
collectionLength
public SqmExpression<Integer> collectionLength(Expression<? extends Collection<?>> collectionExpression)
Description copied from interface:HibernateCriteriaBuilderDetermines the length of a basic collection.- Specified by:
collectionLengthin interfaceHibernateCriteriaBuilder- Specified by:
collectionLengthin interfaceNodeBuilder
-
collectionConcat
public <E,C extends Collection<? super E>> SqmExpression<C> collectionConcat(Expression<C> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderConcatenates basic collections with each other in order.- Specified by:
collectionConcatin interfaceHibernateCriteriaBuilder- Specified by:
collectionConcatin interfaceNodeBuilder
-
collectionConcat
public <E,C extends Collection<? super E>> SqmExpression<C> collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilderConcatenates basic collections with each other in order.- Specified by:
collectionConcatin interfaceHibernateCriteriaBuilder- Specified by:
collectionConcatin interfaceNodeBuilder
-
collectionConcat
public <E,C extends Collection<? super E>> SqmExpression<C> collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderConcatenates basic collections with each other in order.- Specified by:
collectionConcatin interfaceHibernateCriteriaBuilder- Specified by:
collectionConcatin interfaceNodeBuilder
-
collectionAppend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderAppends element to basic collection.- Specified by:
collectionAppendin interfaceHibernateCriteriaBuilder- Specified by:
collectionAppendin interfaceNodeBuilder
-
collectionAppend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionAppend(Expression<C> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilderAppends element to basic collection.- Specified by:
collectionAppendin interfaceHibernateCriteriaBuilder- Specified by:
collectionAppendin interfaceNodeBuilder
-
collectionPrepend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)
Description copied from interface:HibernateCriteriaBuilderPrepends element to basic collection.- Specified by:
collectionPrependin interfaceHibernateCriteriaBuilder- Specified by:
collectionPrependin interfaceNodeBuilder
-
collectionPrepend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionPrepend(E element, Expression<C> collectionExpression)
Description copied from interface:HibernateCriteriaBuilderPrepends element to basic collection.- Specified by:
collectionPrependin interfaceHibernateCriteriaBuilder- Specified by:
collectionPrependin interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains an element.- Specified by:
collectionContainsin interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsin interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains an element.- Specified by:
collectionContainsin interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsin interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Collection<E> collection, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains an element.- Specified by:
collectionContainsin interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsin interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains a nullable element.- Specified by:
collectionContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsNullablein interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains a nullable element.- Specified by:
collectionContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsNullablein interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection contains a nullable element.- Specified by:
collectionContainsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionContainsNullablein interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludesin interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesin interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludesin interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesin interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludesin interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesin interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesNullablein interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesNullablein interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilderWhether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIncludesNullablein interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsin interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsin interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersectsin interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsin interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection, supportingnullelements.- Specified by:
collectionIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsNullablein interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection, supportingnullelements.- Specified by:
collectionIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsNullablein interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilderWhether one basic collection has any elements common with another basic collection, supportingnullelements.- Specified by:
collectionIntersectsNullablein interfaceHibernateCriteriaBuilder- Specified by:
collectionIntersectsNullablein interfaceNodeBuilder
-
collectionGet
public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilderAccesses the element of the basic collection by 1-based index.- Specified by:
collectionGetin interfaceHibernateCriteriaBuilder- Specified by:
collectionGetin interfaceNodeBuilder
-
collectionGet
public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilderAccesses the element of the basic collection by 1-based index.- Specified by:
collectionGetin interfaceHibernateCriteriaBuilder- Specified by:
collectionGetin interfaceNodeBuilder
-
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:HibernateCriteriaBuilderCreates basic collection copy with given element at given 1-based index.- Specified by:
collectionSetin interfaceHibernateCriteriaBuilder- Specified by:
collectionSetin interfaceNodeBuilder
-
collectionSet
public <E,C extends Collection<? super E>> SqmExpression<C> collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with given element at given 1-based index.- Specified by:
collectionSetin interfaceHibernateCriteriaBuilder- Specified by:
collectionSetin interfaceNodeBuilder
-
collectionSet
public <E,C extends Collection<? super E>> SqmExpression<C> collectionSet(Expression<C> collectionExpression, Integer index, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with given element at given 1-based index.- Specified by:
collectionSetin interfaceHibernateCriteriaBuilder- Specified by:
collectionSetin interfaceNodeBuilder
-
collectionSet
public <E,C extends Collection<? super E>> SqmExpression<C> collectionSet(Expression<C> collectionExpression, Integer index, E element)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with given element at given 1-based index.- Specified by:
collectionSetin interfaceHibernateCriteriaBuilder- Specified by:
collectionSetin interfaceNodeBuilder
-
collectionRemove
public <E,C extends Collection<? super E>> SqmExpression<C> collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with given element removed.- Specified by:
collectionRemovein interfaceHibernateCriteriaBuilder- Specified by:
collectionRemovein interfaceNodeBuilder
-
collectionRemove
public <E,C extends Collection<? super E>> SqmExpression<C> collectionRemove(Expression<C> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with given element removed.- Specified by:
collectionRemovein interfaceHibernateCriteriaBuilder- Specified by:
collectionRemovein interfaceNodeBuilder
-
collectionRemoveIndex
public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with the element at the given 1-based index removed.- Specified by:
collectionRemoveIndexin interfaceHibernateCriteriaBuilder- Specified by:
collectionRemoveIndexin interfaceNodeBuilder
-
collectionRemoveIndex
public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy with the element at the given 1-based index removed.- Specified by:
collectionRemoveIndexin interfaceHibernateCriteriaBuilder- Specified by:
collectionRemoveIndexin interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlicein interfaceHibernateCriteriaBuilder- Specified by:
collectionSlicein interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlicein interfaceHibernateCriteriaBuilder- Specified by:
collectionSlicein interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlicein interfaceHibernateCriteriaBuilder- Specified by:
collectionSlicein interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilderCreates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlicein interfaceHibernateCriteriaBuilder- Specified by:
collectionSlicein interfaceNodeBuilder
-
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:HibernateCriteriaBuilderCreates basic collection copy replacing a given element with another.- Specified by:
collectionReplacein interfaceHibernateCriteriaBuilder- Specified by:
collectionReplacein interfaceNodeBuilder
-
collectionReplace
public <E,C extends Collection<? super E>> SqmExpression<C> collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, E newElement)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy replacing a given element with another.- Specified by:
collectionReplacein interfaceHibernateCriteriaBuilder- Specified by:
collectionReplacein interfaceNodeBuilder
-
collectionReplace
public <E,C extends Collection<? super E>> SqmExpression<C> collectionReplace(Expression<C> collectionExpression, E oldElement, Expression<? extends E> newElementExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy replacing a given element with another.- Specified by:
collectionReplacein interfaceHibernateCriteriaBuilder- Specified by:
collectionReplacein interfaceNodeBuilder
-
collectionReplace
public <E,C extends Collection<? super E>> SqmExpression<C> collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy replacing a given element with another.- Specified by:
collectionReplacein interfaceHibernateCriteriaBuilder- Specified by:
collectionReplacein interfaceNodeBuilder
-
collectionTrim
public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy without the last N elements, specified by the second argument.- Specified by:
collectionTrimin interfaceHibernateCriteriaBuilder- Specified by:
collectionTrimin interfaceNodeBuilder
-
collectionTrim
public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection copy without the last N elements, specified by the second argument.- Specified by:
collectionTrimin interfaceHibernateCriteriaBuilder- Specified by:
collectionTrimin interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFillin interfaceHibernateCriteriaBuilder- Specified by:
collectionFillin interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFillin interfaceHibernateCriteriaBuilder- Specified by:
collectionFillin interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(T element, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFillin interfaceHibernateCriteriaBuilder- Specified by:
collectionFillin interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(T element, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilderCreates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFillin interfaceHibernateCriteriaBuilder- Specified by:
collectionFillin interfaceNodeBuilder
-
collectionToString
public <T> SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)
Description copied from interface:HibernateCriteriaBuilderConcatenates the non-null basic collection elements with a separator, as specified by the arguments.- Specified by:
collectionToStringin interfaceHibernateCriteriaBuilder- Specified by:
collectionToStringin interfaceNodeBuilder
-
collectionToString
public <T> SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)
Description copied from interface:HibernateCriteriaBuilderConcatenates the non-null basic collection elements with a separator, as specified by the arguments.- Specified by:
collectionToStringin interfaceHibernateCriteriaBuilder- Specified by:
collectionToStringin interfaceNodeBuilder
-
-