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 JPACriteriaBuilder
by using SQM nodes as the JPA Criteria nodes- See Also:
- Serialized Form
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from interface jakarta.persistence.criteria.CriteriaBuilder
CriteriaBuilder.Case<R extends Object>, CriteriaBuilder.Coalesce<T extends Object>, CriteriaBuilder.In<T extends Object>, CriteriaBuilder.SimpleCase<C extends Object,R extends Object>, CriteriaBuilder.Trimspec
-
-
Constructor Summary
Constructors Constructor Description SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, 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)
SqmPredicate
and(Expression<Boolean> x, Expression<Boolean> y)
SqmPredicate
and(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_agg
ordered set-aggregate function expression.<T> SqmExpression<T[]>
arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)
<T> SqmExpression<T[]>
arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Appends element to array.<T> SqmExpression<T[]>
arrayAppend(Expression<T[]> arrayExpression, T element)
Appends element to array.<T> SqmExpression<T[]>
arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Concatenates arrays with each other in order.<T> SqmExpression<T[]>
arrayConcat(Expression<T[]> arrayExpression1, T[] array2)
Concatenates arrays with each other in order.<T> SqmExpression<T[]>
arrayConcat(T[] array1, Expression<T[]> arrayExpression2)
Concatenates arrays with each other in order.<T> SqmPredicate
arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Whether an array contains an element.<T> SqmPredicate
arrayContains(Expression<T[]> arrayExpression, T element)
Whether an array contains an element.<T> SqmPredicate
arrayContains(T[] array, Expression<T> elementExpression)
Whether an array contains an element.<T> SqmPredicate
arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Whether an array contains a nullable element.<T> SqmPredicate
arrayContainsNullable(Expression<T[]> arrayExpression, T element)
Whether an array contains a nullable element.<T> SqmPredicate
arrayContainsNullable(T[] array, Expression<T> elementExpression)
Whether an array contains a nullable element.<T> SqmExpression<T[]>
arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Creates array with the same element N times, as specified by the arguments.<T> SqmExpression<T[]>
arrayFill(Expression<T> elementExpression, Integer elementCount)
Creates array with the same element N times, as specified by the arguments.<T> SqmExpression<T[]>
arrayFill(T element, Expression<Integer> elementCountExpression)
Creates array with the same element N times, as specified by the arguments.<T> SqmExpression<T[]>
arrayFill(T element, Integer elementCount)
Creates array with the same element N times, as specified by the arguments.<T> SqmExpression<T>
arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Accesses the element of an array by 1-based index.<T> SqmExpression<T>
arrayGet(Expression<T[]> arrayExpression, Integer index)
Accesses the element of an array by 1-based index.<T> SqmPredicate
arrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Whether an array is a subset of another array.<T> SqmPredicate
arrayIncludes(Expression<T[]> arrayExpression, T[] subArray)
Whether an array is a subset of another array.<T> SqmPredicate
arrayIncludes(T[] array, Expression<T[]> subArrayExpression)
Whether an array is a subset of another array.<T> SqmPredicate
arrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Whether an array is a subset of another array with nullable elements.<T> SqmPredicate
arrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)
Whether an array is a subset of another array with nullable elements.<T> SqmPredicate
arrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)
Whether an array is a subset of another array with nullable elements.<T> SqmPredicate
arrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Whether one array has any elements common with another array.<T> SqmPredicate
arrayIntersects(Expression<T[]> arrayExpression1, T[] array2)
Whether one array has any elements common with another array.<T> SqmPredicate
arrayIntersects(T[] array1, Expression<T[]> arrayExpression2)
Whether one array has any elements common with another array.<T> SqmPredicate
arrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Whether one array has any elements common with another array, supportingnull
elements.<T> SqmPredicate
arrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)
Whether one array has any elements common with another array, supportingnull
elements.<T> SqmPredicate
arrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)
Whether one array has any elements common with another array, supportingnull
elements.<T> SqmExpression<Integer>
arrayLength(Expression<T[]> arrayExpression)
Determines the length of an array.<T> SqmExpression<T[]>
arrayLiteral(T... elements)
Creates an array literal with thearray
constructor function.<T> SqmExpression<Integer>
arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Determines the 1-based position of an element in an array.<T> SqmExpression<Integer>
arrayPosition(Expression<T[]> arrayExpression, T element)
Determines the 1-based position of an element in an array.<T> SqmExpression<int[]>
arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Determines all 1-based positions of an element in an array.<T> SqmExpression<int[]>
arrayPositions(Expression<T[]> arrayExpression, T element)
Determines all 1-based positions of an element in an array.<T> SqmExpression<List<Integer>>
arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Determines all 1-based positions of an element in an array.<T> SqmExpression<List<Integer>>
arrayPositionsList(Expression<T[]> arrayExpression, T element)
Determines all 1-based positions of an element in an array.<T> SqmExpression<T[]>
arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)
Prepends element to array.<T> SqmExpression<T[]>
arrayPrepend(T element, Expression<T[]> arrayExpression)
Prepends element to array.<T> SqmExpression<T[]>
arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Creates array copy with given element removed.<T> SqmExpression<T[]>
arrayRemove(Expression<T[]> arrayExpression, T element)
Creates array copy with given element removed.<T> SqmExpression<T[]>
arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Creates array copy with the element at the given 1-based index removed.<T> SqmExpression<T[]>
arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)
Creates array copy with the element at the given 1-based index removed.<T> SqmExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)
Creates array copy replacing a given element with another.<T> SqmExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)
Creates array copy replacing a given element with another.<T> SqmExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)
Creates array copy replacing a given element with another.<T> SqmExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)
Creates array copy replacing a given element with another.<T> SqmExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)
Creates array copy with given element at given 1-based index.<T> SqmExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)
Creates array copy with given element at given 1-based index.<T> SqmExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)
Creates array copy with given element at given 1-based index.<T> SqmExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Integer index, T element)
Creates array copy with given element at given 1-based index.<T> SqmExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Creates a sub-array of the based on 1-based lower and upper index.<T> SqmExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Creates a sub-array of the based on 1-based lower and upper index.<T> SqmExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Creates a sub-array of the based on 1-based lower and upper index.<T> SqmExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)
Creates a sub-array of the based on 1-based lower and upper index.SqmExpression<String>
arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)
Concatenates the non-null array elements with a separator, as specified by the arguments.SqmExpression<String>
arrayToString(Expression<? extends Object[]> arrayExpression, String separator)
Concatenates the non-null array elements with a separator, as specified by the arguments.<T> SqmExpression<T[]>
arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)
Creates array copy without the last N elements, specified by the second argument.<T> SqmExpression<T[]>
arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)
Creates array copy without the last N elements, specified by the second argument.SqmSortSpecification
asc(Expression<?> x)
JpaOrder
asc(Expression<?> x, boolean nullsFirst)
Create an ordering by the ascending value of the expression.JpaSearchOrder
asc(JpaCteCriteriaAttribute x)
Create a search ordering by the ascending value of the CTE attribute.JpaSearchOrder
asc(JpaCteCriteriaAttribute x, boolean nullsFirst)
Create a search ordering by the ascending value of the CTE attribute.SqmFunction<Double>
asin(Expression<? extends Number> x)
Create an expression that returns the inverse sine of its argument.SqmFunction<Double>
atan(Expression<? extends Number> x)
Create an expression that returns the inverse tangent of its argument.SqmFunction<Double>
atan2(Expression<? extends Number> y, Expression<? extends Number> x)
Create an expression that returns the inverse tangent ofy
overx
.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 anavg
aggregate 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> SqmPredicate
collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)
Whether a basic collection contains an element.<E> SqmPredicate
collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Whether a basic collection contains an element.<E> SqmPredicate
collectionContains(Collection<E> collection, Expression<E> elementExpression)
Whether a basic collection contains an element.<E> SqmPredicate
collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)
Whether a basic collection contains a nullable element.<E> SqmPredicate
collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Whether a basic collection contains a nullable element.<E> SqmPredicate
collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)
Whether a basic collection contains a nullable element.<T> SqmExpression<Collection<T>>
collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Creates basic collection with the same element N times, as specified by the arguments.<T> SqmExpression<Collection<T>>
collectionFill(Expression<T> elementExpression, Integer elementCount)
Creates basic collection with the same element N times, as specified by the arguments.<T> SqmExpression<Collection<T>>
collectionFill(T element, Expression<Integer> elementCountExpression)
Creates basic collection with the same element N times, as specified by the arguments.<T> SqmExpression<Collection<T>>
collectionFill(T element, Integer elementCount)
Creates basic collection with the same element N times, as specified by the arguments.<E> SqmExpression<E>
collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)
Accesses the element of the basic collection by 1-based index.<E> SqmExpression<E>
collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)
Accesses the element of the basic collection by 1-based index.<E> SqmPredicate
collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Whether a basic collection is a subset of another basic collection.<E> SqmPredicate
collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Whether a basic collection is a subset of another basic collection.<E> SqmPredicate
collectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Whether a basic collection is a subset of another basic collection.<E> SqmPredicate
collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Whether a basic collection is a subset of another basic collection with nullable elements.<E> SqmPredicate
collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Whether a basic collection is a subset of another basic collection with nullable elements.<E> SqmPredicate
collectionIncludesNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Whether a basic collection is a subset of another basic collection with nullable elements.<E> SqmPredicate
collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Whether one basic collection has any elements common with another basic collection.<E> SqmPredicate
collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Whether one basic collection has any elements common with another basic collection.<E> SqmPredicate
collectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Whether one basic collection has any elements common with another basic collection.<E> SqmPredicate
collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.<E> SqmPredicate
collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.<E> SqmPredicate
collectionIntersectsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.SqmExpression<Integer>
collectionLength(Expression<? extends Collection<?>> collectionExpression)
Determines the length of a basic collection.<E,C extends Collection<E>>
SqmExpression<C>collectionLiteral(E... elements)
Creates a basic collection literal with thearray
constructor function.<E> SqmExpression<Integer>
collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)
Determines the 1-based position of an element in a basic collection.<E> SqmExpression<Integer>
collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)
Determines the 1-based position of an element in a basic collection.<T> SqmExpression<int[]>
collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Determines all 1-based positions of an element in a basic collection.<T> SqmExpression<int[]>
collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)
Determines all 1-based positions of an element in a basic collection.<T> SqmExpression<List<Integer>>
collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Determines all 1-based positions of an element in a basic collection.<T> SqmExpression<List<Integer>>
collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)
Determines all 1-based positions of an element in a basic collection.<E,C extends Collection<? super E>>
SqmExpression<C>collectionPrepend(E element, Expression<C> collectionExpression)
Prepends element to basic collection.<E,C extends Collection<? super E>>
SqmExpression<C>collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)
Prepends element to basic collection.<E,C extends Collection<? super E>>
SqmExpression<C>collectionRemove(Expression<C> collectionExpression, E element)
Creates basic collection copy with given element removed.<E,C extends Collection<? super E>>
SqmExpression<C>collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Creates basic collection copy with given element removed.<C extends Collection<?>>
SqmExpression<C>collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Creates basic collection copy with the element at the given 1-based index removed.<C extends Collection<?>>
SqmExpression<C>collectionRemoveIndex(Expression<C> collectionExpression, Integer index)
Creates basic collection copy with the element at the given 1-based index removed.<E,C extends Collection<? super E>>
SqmExpression<C>collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)
Creates basic collection copy replacing a given element with another.<E,C extends Collection<? super E>>
SqmExpression<C>collectionReplace(Expression<C> collectionExpression, E oldElement, Expression<? extends E> newElementExpression)
Creates basic collection copy replacing a given element with another.<E,C extends Collection<? super E>>
SqmExpression<C>collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, E newElement)
Creates basic collection copy replacing a given element with another.<E,C extends Collection<? super E>>
SqmExpression<C>collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, Expression<? extends E> newElementExpression)
Creates basic collection copy replacing a given element with another.<E,C extends Collection<? super E>>
SqmExpression<C>collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)
Creates basic collection copy with given element at given 1-based index.<E,C extends Collection<? super E>>
SqmExpression<C>collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, Expression<? extends E> elementExpression)
Creates basic collection copy with given element at given 1-based index.<E,C extends Collection<? super E>>
SqmExpression<C>collectionSet(Expression<C> collectionExpression, Integer index, E element)
Creates basic collection copy with given element at given 1-based index.<E,C extends Collection<? super E>>
SqmExpression<C>collectionSet(Expression<C> collectionExpression, Integer index, Expression<? extends E> elementExpression)
Creates basic collection copy with given element at given 1-based index.<C extends Collection<?>>
SqmExpression<C>collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Creates a sub-collection of the based on 1-based lower and upper index.<C extends Collection<?>>
SqmExpression<C>collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Creates a sub-collection of the based on 1-based lower and upper index.<C extends Collection<?>>
SqmExpression<C>collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Creates a sub-collection of the based on 1-based lower and upper index.<C extends Collection<?>>
SqmExpression<C>collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)
Creates a sub-collection of the based on 1-based lower and upper index.<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)
SqmPredicate
conjunction()
<Y> JpaCompoundSelection<Y>
construct(Class<Y> resultClass, Selection<?>[] arguments)
<Y> JpaCompoundSelection<Y>
construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
SqmFunction<Double>
cos(Expression<? extends Number> x)
Create an expression that returns the cosine of its argument.SqmFunction<Double>
cosh(Expression<? extends Number> x)
Create an expression that returns the hyperbolic cosine of its argument.SqmExpression<Long>
count()
Equivalent to HQLcount(*)
.SqmExpression<Long>
count(Expression<?> argument)
SqmExpression<Long>
count(Expression<?> argument, JpaPredicate filter)
SqmExpression<Long>
count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
Create acount
aggregate function expression.SqmExpression<Long>
count(Expression<?> argument, JpaWindow window)
SqmExpression<Long>
countDistinct(Expression<?> argument)
<T> SqmDeleteStatement<T>
createCriteriaDelete(Class<T> targetEntity)
<T> SqmInsertSelectStatement<T>
createCriteriaInsertSelect(Class<T> targetEntity)
<T> SqmInsertValuesStatement<T>
createCriteriaInsertValues(Class<T> targetEntity)
<T> SqmUpdateStatement<T>
createCriteriaUpdate(Class<T> targetEntity)
SqmSelectStatement<Object>
createQuery()
<T> SqmSelectStatement<T>
createQuery(Class<T> resultClass)
<T> SqmSelectStatement<T>
createQuery(String hql, Class<T> resultClass)
Transform the given HQLselect
query to an equivalent criteria query.SqmSelectStatement<Tuple>
createTupleQuery()
SqmWindow
createWindow()
Create an emptyJpaWindow
to use with window and aggregate functions.SqmExpression<Double>
cumeDist(JpaWindow window)
Create acume_dist
window function expression.SqmFunction<Date>
currentDate()
SqmFunction<Instant>
currentInstant()
SqmFunction<Time>
currentTime()
SqmFunction<Timestamp>
currentTimestamp()
SqmFunction<Integer>
day(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.DAY
of a date, time, or datetime expression.SqmFunction<Double>
degrees(Expression<? extends Number> x)
Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.SqmExpression<Long>
denseRank(JpaWindow window)
Create adense_rank
window function expression.SqmSortSpecification
desc(Expression<?> x)
JpaOrder
desc(Expression<?> x, boolean nullsFirst)
Create an ordering by the descending value of the expression.JpaSearchOrder
desc(JpaCteCriteriaAttribute x)
Create a search ordering by the descending value of the CTE attribute.JpaSearchOrder
desc(JpaCteCriteriaAttribute x, boolean nullsFirst)
Create a search ordering by the descending value of the CTE attribute.<N extends Number>
SqmExpression<N>diff(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number>
SqmExpression<N>diff(Expression<? extends N> x, N y)
<N extends Number>
SqmExpression<N>diff(N x, Expression<? extends N> y)
SqmPredicate
disjunction()
SqmPredicate
distinctFrom(Expression<?> x, Expression<?> y)
SqmPredicate
distinctFrom(Expression<?> x, Object y)
JpaExpression<Duration>
duration(long magnitude, TemporalUnit unit)
A 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 aDuration
to a numeric magnitude in the given units.JpaExpression<Duration>
durationDiff(Expression<Duration> x, Expression<Duration> y)
Subtract one duration from another.JpaExpression<Duration>
durationDiff(Expression<Duration> x, Duration y)
Subtract one duration from another.JpaExpression<Duration>
durationScaled(Expression<? extends Number> number, Expression<Duration> duration)
Scale a duration by a number.JpaExpression<Duration>
durationScaled(Expression<? extends Number> number, Duration duration)
Scale a duration by a number.JpaExpression<Duration>
durationScaled(Number number, Expression<Duration> duration)
Scale a duration by a number.JpaExpression<Duration>
durationSum(Expression<Duration> x, Expression<Duration> y)
Add two durations.JpaExpression<Duration>
durationSum(Expression<Duration> x, Duration y)
Add two durations.SqmPredicate
equal(Expression<?> x, Expression<?> y)
SqmPredicate
equal(Expression<?> x, Object y)
<T> JpaCriteriaQuery<T>
except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>
except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
SqmPredicate
exists(Subquery<?> subQuery)
JpaExpression<Double>
exp(Expression<? extends Number> x)
Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.<T> SqmExpression<T>
firstValue(Expression<T> argument, JpaWindow window)
Create afirst_value
window function expression.<P,F>
SqmExpression<F>fk(Path<P> path)
<N extends Number>
JpaExpression<N>floor(Expression<N> x)
Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.SqmFunction<String>
format(Expression<? extends TemporalAccessor> datetime, String pattern)
Format a date, time, or datetime according to a pattern.SqmWindowFrame
frameBetweenFollowing(int offset)
SqmWindowFrame
frameBetweenFollowing(Expression<?> offset)
Create a window frame of typeFrameKind.OFFSET_FOLLOWING
to use withJpaWindow
s.SqmWindowFrame
frameBetweenPreceding(int offset)
SqmWindowFrame
frameBetweenPreceding(Expression<?> offset)
Create window frame of typeFrameKind.OFFSET_PRECEDING
to use withJpaWindow
s.SqmWindowFrame
frameCurrentRow()
Create a window frame of typeFrameKind.CURRENT_ROW
to use withJpaWindow
s.SqmWindowFrame
frameUnboundedFollowing()
Create a window frame of typeFrameKind.UNBOUNDED_FOLLOWING
to use withJpaWindow
s.SqmWindowFrame
frameUnboundedPreceding()
Create a window frame of typeFrameKind.UNBOUNDED_PRECEDING
to use withJpaWindow
s.<T> SqmFunction<T>
function(String name, Class<T> type, Expression<?>[] args)
<T> SqmExpression<T>
functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)
<T> SqmExpression<T>
functionAggregate(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args)
Create a generic aggregate function expression.<T> SqmExpression<T>
functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)
<T> SqmExpression<T>
functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)
<T> SqmExpression<T>
functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)
<T> SqmExpression<T>
functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args)
Create a generic ordered set-aggregate function expression.<T> SqmExpression<T>
functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)
SqmPredicate
ge(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate
ge(Expression<? extends Number> x, Number y)
FunctionReturnTypeResolver
getAvgReturnTypeResolver()
BasicType<Boolean>
getBooleanType()
BasicType<Character>
getCharacterType()
JpaMetamodel
getDomainModel()
BasicType<Integer>
getIntegerType()
JpaMetamodelImplementor
getJpaMetamodel()
Access to the domain model metadataBasicType<Long>
getLongType()
QueryEngine
getQueryEngine()
SessionFactoryImplementor
getSessionFactory()
FunctionReturnTypeResolver
getSumReturnTypeResolver()
TypeConfiguration
getTypeConfiguration()
<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)
SqmPredicate
gt(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate
gt(Expression<? extends Number> x, Number y)
SqmFunction<Integer>
hour(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.HOUR
of a date, time, or datetime expression.SqmPredicate
ilike(Expression<String> searchString, Expression<String> pattern)
SqmPredicate
ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)
SqmPredicate
ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate
ilike(Expression<String> searchString, String pattern)
SqmPredicate
ilike(Expression<String> searchString, String pattern, char escapeChar)
SqmPredicate
ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
<T> SqmInPredicate<T>
in(Expression<? extends T> expression)
<T> SqmInPredicate<T>
in(Expression<? extends T> expression, Expression<? extends T>... values)
<T> SqmInPredicate<T>
in(Expression<? extends T> expression, Collection<T> values)
<T> SqmInPredicate<T>
in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)
<T> SqmInPredicate<T>
in(Expression<? extends T> expression, T... values)
<K,L extends List<?>>
SqmExpression<Set<K>>indexes(L list)
<T> JpaCriteriaQuery<T>
intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
<T> JpaSubQuery<T>
intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
<C extends Collection<?>>
SqmPredicateisEmpty(Expression<C> collection)
SqmPredicate
isFalse(Expression<Boolean> x)
boolean
isJpaQueryComplianceEnabled()
<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)
SqmPredicate
isNotNull(Expression<?> x)
SqmPredicate
isNull(Expression<?> x)
SqmPredicate
isTrue(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_value
window function expression.SqmPredicate
le(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate
le(Expression<? extends Number> x, Number y)
<X extends Comparable<? super X>>
SqmExpression<X>least(Expression<X> argument)
SqmFunction<String>
left(Expression<String> x, int length)
SqmFunction<String>
left(Expression<String> x, Expression<Integer> length)
Extract thelength
leftmost 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)
SqmPredicate
like(Expression<String> searchString, Expression<String> pattern)
SqmPredicate
like(Expression<String> searchString, Expression<String> pattern, char escapeChar)
SqmPredicate
like(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate
like(Expression<String> searchString, String pattern)
SqmPredicate
like(Expression<String> searchString, String pattern, char escapeChar)
SqmPredicate
like(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
SqmExpression<String>
listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
SqmExpression<String>
listagg(JpaOrder order, Expression<String> argument, String separator)
SqmExpression<String>
listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)
SqmExpression<String>
listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)
SqmExpression<String>
listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)
Create alistagg
ordered set-aggregate function expression.SqmExpression<String>
listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
SqmExpression<String>
listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
SqmExpression<String>
listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)
<T> 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 ofx
to 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)
SqmPredicate
lt(Expression<? extends Number> x, Expression<? extends Number> y)
SqmPredicate
lt(Expression<? extends Number> x, Number y)
<M extends Map<?,?>>
SqmExpression<Integer>mapSize(M map)
Create an expression that tests the size of a map.<M extends Map<?,?>>
SqmExpression<Integer>mapSize(JpaExpression<M> mapExpression)
Create an expression that tests the size of a map.<N extends Number>
SqmExpression<N>max(Expression<N> argument)
<N extends Number>
SqmExpression<N>min(Expression<N> argument)
SqmFunction<Integer>
minute(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.MINUTE
of a date, time, or datetime expression.SqmExpression<Integer>
mod(Expression<Integer> x, Expression<Integer> y)
SqmExpression<Integer>
mod(Expression<Integer> x, Integer y)
SqmExpression<Integer>
mod(Integer x, Expression<Integer> y)
<T> SqmExpression<T>
mode(Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
mode(JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
mode(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Create amode
ordered set-aggregate function expression.<T> SqmExpression<T>
mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
SqmFunction<Integer>
month(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.MONTH
of a date, time, or datetime expression.<N extends Number>
SqmExpression<N>neg(Expression<N> x)
SqmPredicate
not(Expression<Boolean> restriction)
SqmPredicate
notDistinctFrom(Expression<?> x, Expression<?> y)
SqmPredicate
notDistinctFrom(Expression<?> x, Object y)
SqmPredicate
notEqual(Expression<?> x, Expression<?> y)
SqmPredicate
notEqual(Expression<?> x, Object y)
SqmPredicate
notIlike(Expression<String> x, Expression<String> pattern)
SqmPredicate
notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
SqmPredicate
notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate
notIlike(Expression<String> x, String pattern)
SqmPredicate
notIlike(Expression<String> x, String pattern, char escapeChar)
SqmPredicate
notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
SqmPredicate
notLike(Expression<String> x, Expression<String> pattern)
SqmPredicate
notLike(Expression<String> x, Expression<String> pattern, char escapeChar)
SqmPredicate
notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
SqmPredicate
notLike(Expression<String> x, String pattern)
SqmPredicate
notLike(Expression<String> x, String pattern, char escapeChar)
SqmPredicate
notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)
<T> SqmExpression<T>
nthValue(Expression<T> argument, int n, JpaWindow window)
<T> SqmExpression<T>
nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)
Create anth_value
window function expression.<Y> SqmExpression<Y>
nullif(Expression<Y> x, Expression<?> y)
<Y> SqmExpression<Y>
nullif(Expression<Y> x, Y y)
<T> SqmExpression<T>
nullLiteral(Class<T> resultClass)
SqmPredicate
or(Expression<Boolean> x, Expression<Boolean> y)
SqmPredicate
or(Predicate... restrictions)
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 thestring
expression with thereplacement
expression, starting from indexstart
and substituting a number of characters corresponding to the length of thereplacement
expression or thelength
parameter if specified.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 thepadChar
character if specified.SqmFunction<String>
pad(Expression<String> x, int length)
SqmFunction<String>
pad(Expression<String> x, int length, char padChar)
SqmFunction<String>
pad(Expression<String> x, int length, Expression<Character> padChar)
SqmFunction<String>
pad(Expression<String> x, Expression<Integer> length)
SqmFunction<String>
pad(Expression<String> x, Expression<Integer> length, char padChar)
SqmFunction<String>
pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)
<T> JpaCriteriaParameter<T>
parameter(Class<T> paramClass)
<T> JpaCriteriaParameter<T>
parameter(Class<T> paramClass, String name)
<T> SqmExpression<T>
percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Create apercentile_cont
ordered set-aggregate function expression.<T> SqmExpression<T>
percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
<T> SqmExpression<T>
percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Create apercentile_disc
ordered set-aggregate function expression.<T> SqmExpression<T>
percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
SqmExpression<Double>
percentRank(JpaOrder order, Expression<?>... arguments)
SqmExpression<Double>
percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
SqmExpression<Double>
percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
Create apercent_rank
ordered set-aggregate function expression.SqmExpression<Double>
percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<Double>
percentRank(JpaWindow window)
Create apercent_rank
window function expression.SqmFunction<Double>
pi()
Literal expression corresponding to the value of pi.JpaExpression<Double>
power(Expression<? extends Number> x, Expression<? extends Number> y)
Create an expression that returns the first argument raised to the power of its second argument.JpaExpression<Double>
power(Expression<? extends Number> x, Number y)
Create an expression that returns the first argument raised to the power of its second argument.<N extends Number>
SqmExpression<N>prod(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number>
SqmExpression<N>prod(Expression<? extends N> x, N y)
<N extends Number>
SqmExpression<N>prod(N x, Expression<? extends N> y)
SqmExpression<Number>
quot(Expression<? extends Number> x, Expression<? extends Number> y)
SqmExpression<Number>
quot(Expression<? extends Number> x, Number y)
SqmExpression<Number>
quot(Number x, Expression<? extends Number> y)
SqmFunction<Double>
radians(Expression<? extends Number> x)
Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.SqmExpression<Long>
rank(JpaOrder order, Expression<?>... arguments)
SqmExpression<Long>
rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
SqmExpression<Long>
rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
Create arank
ordered set-aggregate function expression.SqmExpression<Long>
rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<Long>
rank(JpaWindow window)
Create arank
window function expression.JpaFunction<String>
repeat(Expression<String> x, int times)
Concatenate the given string expression with itself the given number of times.JpaFunction<String>
repeat(Expression<String> x, Expression<Integer> times)
Concatenate the given string expression with itself the given number of times.JpaFunction<String>
repeat(String x, Expression<Integer> times)
Concatenate the given string expression with itself the given number of times.SqmFunction<String>
replace(Expression<String> x, Expression<String> pattern, Expression<String> replacement)
Replace all occurrences ofpattern
within 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 thelength
rightmost characters of a string.<T extends Number>
JpaExpression<T>round(Expression<T> x, Integer n)
Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.SqmExpression<Long>
rowNumber(JpaWindow window)
Create arow_number
window function expression.JpaSearchOrder
search(JpaCteCriteriaAttribute sortExpression)
Create a search ordering based on the ascending value of the CTE attribute.JpaSearchOrder
search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder)
Create a search ordering based on the sort order of the value of the CTE attribute.JpaSearchOrder
search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.SqmFunction<Float>
second(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.SECOND
of 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,1
if its argument is positive,-1
if its argument is negative, or0
if its argument is exactly zero.SqmFunction<Double>
sin(Expression<? extends Number> x)
Create an expression that returns the sine of its argument.SqmFunction<Double>
sinh(Expression<? extends Number> x)
Create an expression that returns the hyperbolic sine of its argument.<C extends Collection<?>>
SqmExpression<Integer>size(C collection)
<C extends Collection<?>>
SqmExpression<Integer>size(Expression<C> collection)
<Y> SqmModifiedSubQueryExpression<Y>
some(Subquery<Y> subquery)
SqmSortSpecification
sort(JpaExpression<?> sortExpression)
SqmSortSpecification
sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
SqmSortSpecification
sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
SqmSortSpecification
sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence, boolean ignoreCase)
<T> SqmFunction<T>
sql(String pattern, Class<T> type, Expression<?>... arguments)
Embed nativepattern
that will be unquoted and embedded in the generated SQL.SqmExpression<Double>
sqrt(Expression<? extends Number> x)
SqmFunction<String>
substring(Expression<String> source, int from)
SqmFunction<String>
substring(Expression<String> source, int from, int len)
SqmFunction<String>
substring(Expression<String> source, Expression<Integer> from)
SqmFunction<String>
substring(Expression<String> source, Expression<Integer> from, Expression<Integer> len)
<T extends Temporal>
JpaExpression<T>subtractDuration(Expression<T> datetime, Expression<Duration> duration)
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.<T extends Temporal>
JpaExpression<T>subtractDuration(Expression<T> datetime, Duration duration)
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.<T extends Temporal>
JpaExpression<T>subtractDuration(T datetime, Expression<Duration> duration)
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.<N extends Number>
SqmExpression<N>sum(Expression<? extends N> x, Expression<? extends N> y)
<N extends Number>
SqmExpression<N>sum(Expression<? extends N> x, N y)
<N extends Number>
SqmExpression<N>sum(Expression<N> argument)
<N extends Number>
SqmExpression<Number>sum(Expression<N> argument, JpaPredicate filter)
<N extends Number>
SqmExpression<Number>sum(Expression<N> argument, JpaPredicate filter, JpaWindow window)
Create asum
aggregate function expression.<N extends Number>
SqmExpression<Number>sum(Expression<N> argument, JpaWindow window)
<N extends Number>
SqmExpression<N>sum(N x, Expression<? extends N> y)
SqmExpression<Double>
sumAsDouble(Expression<Float> argument)
SqmExpression<Long>
sumAsLong(Expression<Integer> argument)
SqmFunction<Double>
tan(Expression<? extends Number> x)
Create an expression that returns the tangent of its argument.SqmFunction<Double>
tanh(Expression<? extends Number> x)
Create an expression that returns the hyperbolic tangent of its argument.SqmExpression<BigDecimal>
toBigDecimal(Expression<? extends Number> number)
SqmExpression<BigInteger>
toBigInteger(Expression<? extends Number> number)
SqmExpression<Double>
toDouble(Expression<? extends Number> number)
SqmExpression<Float>
toFloat(Expression<? extends Number> number)
SqmExpression<Integer>
toInteger(Expression<? extends Number> number)
SqmExpression<Long>
toLong(Expression<? extends Number> number)
SqmExpression<String>
toString(Expression<Character> character)
<X,T,E extends T>
SqmBagJoin<X,E>treat(CollectionJoin<X,T> join, Class<E> type)
<X,T,V extends T>
SqmSingularJoin<X,V>treat(Join<X,T> join, Class<V> type)
<X,T,E extends T>
SqmListJoin<X,E>treat(ListJoin<X,T> join, Class<E> type)
<X,K,T,V extends T>
SqmMapJoin<X,K,V>treat(MapJoin<X,K,T> join, Class<V> type)
<X,T extends X>
SqmPath<T>treat(Path<X> path, Class<T> type)
<X,T extends X>
SqmRoot<T>treat(Root<X> root, Class<T> type)
<X,T,E extends T>
SqmSetJoin<X,E>treat(SetJoin<X,T> join, Class<E> type)
SqmFunction<String>
trim(char trimChar, Expression<String> source)
SqmFunction<String>
trim(CriteriaBuilder.Trimspec ts, char trimChar, Expression<String> source)
SqmFunction<String>
trim(CriteriaBuilder.Trimspec ts, Expression<Character> trimChar, Expression<String> source)
SqmFunction<String>
trim(CriteriaBuilder.Trimspec ts, Expression<String> source)
SqmFunction<String>
trim(Expression<Character> trimChar, Expression<String> source)
SqmFunction<String>
trim(Expression<String> source)
<T extends Number>
JpaExpression<T>truncate(Expression<T> x, Integer n)
Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.<T extends TemporalAccessor>
SqmFunction<T>truncate(Expression<T> datetime, TemporalUnit temporalUnit)
Truncates a date, time or datetime expression to the 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" informationSqmValues
values(Expression<?>... expressions)
SqmValues
values(List<? extends Expression<?>> expressions)
<V,M extends Map<?,V>>
Expression<Collection<V>>values(M map)
<T> SqmExpression<T>
windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)
Create a generic window function expression that will be applied over the specifiedwindow
.SqmPredicate
wrap(Expression<Boolean> expression)
SqmPredicate
wrap(Expression<Boolean>... expressions)
SqmFunction<Integer>
year(Expression<? extends TemporalAccessor> datetime)
Extracts theTemporalUnit.YEAR
of a date, time, or datetime expression.-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.hibernate.query.criteria.HibernateCriteriaBuilder
except, except, exceptAll, exceptAll, intersect, intersect, intersectAll, intersectAll, union, union, unionAll, unionAll
-
Methods inherited from interface org.hibernate.query.sqm.NodeBuilder
arrayContainsAll, arrayContainsAll, arrayContainsAll, arrayContainsAllNullable, arrayContainsAllNullable, arrayContainsAllNullable, arrayOverlaps, arrayOverlaps, arrayOverlaps, arrayOverlapsNullable, arrayOverlapsNullable, arrayOverlapsNullable, collectionContainsAll, collectionContainsAll, collectionContainsAll, collectionContainsAllNullable, collectionContainsAllNullable, collectionContainsAllNullable, collectionOverlaps, collectionOverlaps, collectionOverlaps, collectionOverlapsNullable, collectionOverlapsNullable, collectionOverlapsNullable
-
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:
getDomainModel
in interfaceNodeBuilder
-
getTypeConfiguration
public TypeConfiguration getTypeConfiguration()
- Specified by:
getTypeConfiguration
in interfaceNodeBuilder
- Specified by:
getTypeConfiguration
in interfaceSqmCreationContext
-
isJpaQueryComplianceEnabled
public boolean isJpaQueryComplianceEnabled()
- Specified by:
isJpaQueryComplianceEnabled
in interfaceNodeBuilder
-
getSessionFactory
public SessionFactoryImplementor getSessionFactory()
- Specified by:
getSessionFactory
in interfaceNodeBuilder
-
getBooleanType
public BasicType<Boolean> getBooleanType()
- Specified by:
getBooleanType
in interfaceNodeBuilder
-
getIntegerType
public BasicType<Integer> getIntegerType()
- Specified by:
getIntegerType
in interfaceNodeBuilder
-
getLongType
public BasicType<Long> getLongType()
- Specified by:
getLongType
in interfaceNodeBuilder
-
getCharacterType
public BasicType<Character> getCharacterType()
- Specified by:
getCharacterType
in interfaceNodeBuilder
-
getSumReturnTypeResolver
public FunctionReturnTypeResolver getSumReturnTypeResolver()
-
getAvgReturnTypeResolver
public FunctionReturnTypeResolver getAvgReturnTypeResolver()
-
getQueryEngine
public QueryEngine getQueryEngine()
- Specified by:
getQueryEngine
in interfaceNodeBuilder
- Specified by:
getQueryEngine
in interfaceSqmCreationContext
-
getJpaMetamodel
public JpaMetamodelImplementor getJpaMetamodel()
Description copied from interface:SqmCreationContext
Access to the domain model metadata- Specified by:
getJpaMetamodel
in interfaceSqmCreationContext
-
createQuery
public SqmSelectStatement<Object> createQuery()
- Specified by:
createQuery
in interfaceCriteriaBuilder
- Specified by:
createQuery
in interfaceHibernateCriteriaBuilder
- Specified by:
createQuery
in interfaceNodeBuilder
-
createQuery
public <T> SqmSelectStatement<T> createQuery(Class<T> resultClass)
- Specified by:
createQuery
in interfaceCriteriaBuilder
- Specified by:
createQuery
in interfaceHibernateCriteriaBuilder
- Specified by:
createQuery
in interfaceNodeBuilder
-
createQuery
public <T> SqmSelectStatement<T> createQuery(String hql, Class<T> resultClass)
Description copied from interface:HibernateCriteriaBuilder
Transform the given HQLselect
query to an equivalent criteria query.- Specified by:
createQuery
in interfaceHibernateCriteriaBuilder
- Specified by:
createQuery
in interfaceNodeBuilder
- Parameters:
hql
- The HQLselect
queryresultClass
- The result type of the query- Returns:
- The equivalent criteria query
-
createTupleQuery
public SqmSelectStatement<Tuple> createTupleQuery()
- Specified by:
createTupleQuery
in interfaceCriteriaBuilder
- Specified by:
createTupleQuery
in interfaceHibernateCriteriaBuilder
- Specified by:
createTupleQuery
in interfaceNodeBuilder
-
createCriteriaUpdate
public <T> SqmUpdateStatement<T> createCriteriaUpdate(Class<T> targetEntity)
- Specified by:
createCriteriaUpdate
in interfaceCriteriaBuilder
- Specified by:
createCriteriaUpdate
in interfaceHibernateCriteriaBuilder
- Specified by:
createCriteriaUpdate
in interfaceNodeBuilder
-
createCriteriaDelete
public <T> SqmDeleteStatement<T> createCriteriaDelete(Class<T> targetEntity)
- Specified by:
createCriteriaDelete
in interfaceCriteriaBuilder
- Specified by:
createCriteriaDelete
in interfaceHibernateCriteriaBuilder
- Specified by:
createCriteriaDelete
in interfaceNodeBuilder
-
createCriteriaInsertValues
public <T> SqmInsertValuesStatement<T> createCriteriaInsertValues(Class<T> targetEntity)
- Specified by:
createCriteriaInsertValues
in interfaceHibernateCriteriaBuilder
- Specified by:
createCriteriaInsertValues
in interfaceNodeBuilder
-
createCriteriaInsertSelect
public <T> SqmInsertSelectStatement<T> createCriteriaInsertSelect(Class<T> targetEntity)
- Specified by:
createCriteriaInsertSelect
in interfaceHibernateCriteriaBuilder
- Specified by:
createCriteriaInsertSelect
in interfaceNodeBuilder
-
values
public SqmValues values(Expression<?>... expressions)
- Specified by:
values
in interfaceHibernateCriteriaBuilder
- Specified by:
values
in interfaceNodeBuilder
-
values
public SqmValues values(List<? extends Expression<?>> expressions)
- Specified by:
values
in interfaceHibernateCriteriaBuilder
- Specified by:
values
in interfaceNodeBuilder
-
union
public <T> JpaCriteriaQuery<T> union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
union
in interfaceHibernateCriteriaBuilder
-
intersect
public <T> JpaCriteriaQuery<T> intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
intersect
in interfaceHibernateCriteriaBuilder
-
except
public <T> JpaCriteriaQuery<T> except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
- Specified by:
except
in interfaceHibernateCriteriaBuilder
-
union
public <T> JpaSubQuery<T> union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
union
in interfaceHibernateCriteriaBuilder
-
intersect
public <T> JpaSubQuery<T> intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
intersect
in interfaceHibernateCriteriaBuilder
-
except
public <T> JpaSubQuery<T> except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
- Specified by:
except
in interfaceHibernateCriteriaBuilder
-
cast
public <X,T> SqmExpression<X> cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
- Specified by:
cast
in interfaceHibernateCriteriaBuilder
- Specified by:
cast
in interfaceNodeBuilder
-
wrap
public SqmPredicate wrap(Expression<Boolean> expression)
- Specified by:
wrap
in interfaceHibernateCriteriaBuilder
- Specified by:
wrap
in interfaceNodeBuilder
-
wrap
@SafeVarargs public final SqmPredicate wrap(Expression<Boolean>... expressions)
- Specified by:
wrap
in interfaceHibernateCriteriaBuilder
- Specified by:
wrap
in interfaceNodeBuilder
-
unwrap
public <T extends HibernateCriteriaBuilder> T unwrap(Class<T> clazz)
- Specified by:
unwrap
in interfaceHibernateCriteriaBuilder
-
fk
public <P,F> SqmExpression<F> fk(Path<P> path)
- Specified by:
fk
in interfaceHibernateCriteriaBuilder
- Specified by:
fk
in interfaceNodeBuilder
-
treat
public <X,T extends X> SqmPath<T> treat(Path<X> path, Class<T> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,T extends X> SqmRoot<T> treat(Root<X> root, Class<T> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,T,V extends T> SqmSingularJoin<X,V> treat(Join<X,T> join, Class<V> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmBagJoin<X,E> treat(CollectionJoin<X,T> join, Class<E> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmSetJoin<X,E> treat(SetJoin<X,T> join, Class<E> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,T,E extends T> SqmListJoin<X,E> treat(ListJoin<X,T> join, Class<E> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
treat
public <X,K,T,V extends T> SqmMapJoin<X,K,V> treat(MapJoin<X,K,T> join, Class<V> type)
- Specified by:
treat
in interfaceCriteriaBuilder
- Specified by:
treat
in interfaceHibernateCriteriaBuilder
- Specified by:
treat
in interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
- Specified by:
sort
in interfaceHibernateCriteriaBuilder
- Specified by:
sort
in interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence, boolean ignoreCase)
- Specified by:
sort
in interfaceHibernateCriteriaBuilder
- Specified by:
sort
in interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
- Specified by:
sort
in interfaceHibernateCriteriaBuilder
- Specified by:
sort
in interfaceNodeBuilder
-
sort
public SqmSortSpecification sort(JpaExpression<?> sortExpression)
- Specified by:
sort
in interfaceHibernateCriteriaBuilder
- Specified by:
sort
in interfaceNodeBuilder
-
asc
public SqmSortSpecification asc(Expression<?> x)
- Specified by:
asc
in interfaceCriteriaBuilder
- Specified by:
asc
in interfaceHibernateCriteriaBuilder
- Specified by:
asc
in interfaceNodeBuilder
-
desc
public SqmSortSpecification desc(Expression<?> x)
- Specified by:
desc
in interfaceCriteriaBuilder
- Specified by:
desc
in interfaceHibernateCriteriaBuilder
- Specified by:
desc
in interfaceNodeBuilder
-
asc
public JpaOrder asc(Expression<?> x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilder
Create an ordering by the ascending value of the expression.- Specified by:
asc
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression used to define the orderingnullsFirst
- Whethernull
should be sorted first- Returns:
- ascending ordering corresponding to the expression
-
desc
public JpaOrder desc(Expression<?> x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilder
Create an ordering by the descending value of the expression.- Specified by:
desc
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression used to define the orderingnullsFirst
- Whethernull
should be sorted first- Returns:
- descending ordering corresponding to the expression
-
search
public JpaSearchOrder search(JpaCteCriteriaAttribute sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Description copied from interface:HibernateCriteriaBuilder
Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.- Specified by:
search
in 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:HibernateCriteriaBuilder
Create a search ordering based on the sort order of the value of the CTE attribute.- Specified by:
search
in 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:HibernateCriteriaBuilder
Create a search ordering based on the ascending value of the CTE attribute.- Specified by:
search
in 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:HibernateCriteriaBuilder
Create a search ordering by the ascending value of the CTE attribute.- Specified by:
asc
in 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:HibernateCriteriaBuilder
Create a search ordering by the descending value of the CTE attribute.- Specified by:
desc
in 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:HibernateCriteriaBuilder
Create a search ordering by the ascending value of the CTE attribute.- Specified by:
asc
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- CTE attribute used to define the orderingnullsFirst
- Whethernull
should be sorted first- Returns:
- ascending ordering corresponding to the CTE attribute
-
desc
public JpaSearchOrder desc(JpaCteCriteriaAttribute x, boolean nullsFirst)
Description copied from interface:HibernateCriteriaBuilder
Create a search ordering by the descending value of the CTE attribute.- Specified by:
desc
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- CTE attribute used to define the orderingnullsFirst
- Whethernull
should be sorted first- Returns:
- descending ordering corresponding to the CTE attribute
-
tuple
public JpaCompoundSelection<Tuple> tuple(Selection<?>[] selections)
- Specified by:
tuple
in interfaceCriteriaBuilder
- Specified by:
tuple
in interfaceHibernateCriteriaBuilder
- Specified by:
tuple
in interfaceNodeBuilder
-
tuple
public JpaCompoundSelection<Tuple> tuple(List<? extends JpaSelection<?>> selections)
- Specified by:
tuple
in interfaceHibernateCriteriaBuilder
- Specified by:
tuple
in interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(Class<R> tupleType, SqmExpression<?>... expressions)
- Specified by:
tuple
in interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(Class<R> tupleType, List<? extends SqmExpression<?>> expressions)
- Specified by:
tuple
in interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType, SqmExpression<?>... expressions)
- Specified by:
tuple
in interfaceNodeBuilder
-
tuple
public <R> SqmTuple<R> tuple(SqmExpressible<R> tupleType, List<? extends SqmExpression<?>> sqmExpressions)
- Specified by:
tuple
in interfaceNodeBuilder
-
array
public JpaCompoundSelection<Object[]> array(Selection<?>[] selections)
- Specified by:
array
in interfaceCriteriaBuilder
- Specified by:
array
in interfaceHibernateCriteriaBuilder
- Specified by:
array
in interfaceNodeBuilder
-
array
public JpaCompoundSelection<Object[]> array(List<? extends JpaSelection<?>> selections)
- Specified by:
array
in interfaceHibernateCriteriaBuilder
- Specified by:
array
in interfaceNodeBuilder
-
array
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass, Selection<?>[] selections)
- Specified by:
array
in interfaceHibernateCriteriaBuilder
-
array
public <Y> JpaCompoundSelection<Y> array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
- Specified by:
array
in interfaceHibernateCriteriaBuilder
-
construct
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass, Selection<?>[] arguments)
- Specified by:
construct
in interfaceCriteriaBuilder
- Specified by:
construct
in interfaceHibernateCriteriaBuilder
- Specified by:
construct
in interfaceNodeBuilder
-
construct
public <Y> JpaCompoundSelection<Y> construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
- Specified by:
construct
in interfaceHibernateCriteriaBuilder
- Specified by:
construct
in interfaceNodeBuilder
-
avg
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument)
- Specified by:
avg
in interfaceCriteriaBuilder
- Specified by:
avg
in interfaceHibernateCriteriaBuilder
- Specified by:
avg
in interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<N> argument)
- Specified by:
sum
in interfaceCriteriaBuilder
- Specified by:
sum
in interfaceHibernateCriteriaBuilder
- Specified by:
sum
in interfaceNodeBuilder
-
sumAsLong
public SqmExpression<Long> sumAsLong(Expression<Integer> argument)
- Specified by:
sumAsLong
in interfaceCriteriaBuilder
- Specified by:
sumAsLong
in interfaceHibernateCriteriaBuilder
- Specified by:
sumAsLong
in interfaceNodeBuilder
-
sumAsDouble
public SqmExpression<Double> sumAsDouble(Expression<Float> argument)
- Specified by:
sumAsDouble
in interfaceCriteriaBuilder
- Specified by:
sumAsDouble
in interfaceHibernateCriteriaBuilder
- Specified by:
sumAsDouble
in interfaceNodeBuilder
-
max
public <N extends Number> SqmExpression<N> max(Expression<N> argument)
- Specified by:
max
in interfaceCriteriaBuilder
- Specified by:
max
in interfaceHibernateCriteriaBuilder
- Specified by:
max
in interfaceNodeBuilder
-
min
public <N extends Number> SqmExpression<N> min(Expression<N> argument)
- Specified by:
min
in interfaceCriteriaBuilder
- Specified by:
min
in interfaceHibernateCriteriaBuilder
- Specified by:
min
in interfaceNodeBuilder
-
greatest
public <X extends Comparable<? super X>> SqmExpression<X> greatest(Expression<X> argument)
- Specified by:
greatest
in interfaceCriteriaBuilder
- Specified by:
greatest
in interfaceHibernateCriteriaBuilder
- Specified by:
greatest
in interfaceNodeBuilder
-
least
public <X extends Comparable<? super X>> SqmExpression<X> least(Expression<X> argument)
- Specified by:
least
in interfaceCriteriaBuilder
- Specified by:
least
in interfaceHibernateCriteriaBuilder
- Specified by:
least
in interfaceNodeBuilder
-
count
public SqmExpression<Long> count(Expression<?> argument)
- Specified by:
count
in interfaceCriteriaBuilder
- Specified by:
count
in interfaceHibernateCriteriaBuilder
- Specified by:
count
in interfaceNodeBuilder
-
countDistinct
public SqmExpression<Long> countDistinct(Expression<?> argument)
- Specified by:
countDistinct
in interfaceCriteriaBuilder
- Specified by:
countDistinct
in interfaceHibernateCriteriaBuilder
- Specified by:
countDistinct
in interfaceNodeBuilder
-
count
public SqmExpression<Long> count()
Description copied from interface:HibernateCriteriaBuilder
Equivalent to HQLcount(*)
.- Specified by:
count
in interfaceHibernateCriteriaBuilder
- Specified by:
count
in interfaceNodeBuilder
-
sign
public JpaExpression<Integer> sign(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the sign of its argument, that is,1
if its argument is positive,-1
if its argument is negative, or0
if its argument is exactly zero.- Specified by:
sign
in interfaceCriteriaBuilder
- Specified by:
sign
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- sign
-
ceiling
public <N extends Number> JpaExpression<N> ceiling(Expression<N> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.- Specified by:
ceiling
in interfaceCriteriaBuilder
- Specified by:
ceiling
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- ceiling
-
floor
public <N extends Number> JpaExpression<N> floor(Expression<N> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.- Specified by:
floor
in interfaceCriteriaBuilder
- Specified by:
floor
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- floor
-
exp
public JpaExpression<Double> exp(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.- Specified by:
exp
in interfaceCriteriaBuilder
- Specified by:
exp
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- exponential
-
ln
public JpaExpression<Double> ln(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the natural logarithm of its argument.- Specified by:
ln
in interfaceCriteriaBuilder
- Specified by:
ln
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- natural logarithm
-
power
public JpaExpression<Double> power(Expression<? extends Number> x, Expression<? extends Number> y)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the first argument raised to the power of its second argument.- Specified by:
power
in interfaceCriteriaBuilder
- Specified by:
power
in 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:HibernateCriteriaBuilder
Create an expression that returns the first argument raised to the power of its second argument.- Specified by:
power
in interfaceCriteriaBuilder
- Specified by:
power
in 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:HibernateCriteriaBuilder
Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.- Specified by:
round
in interfaceCriteriaBuilder
- Specified by:
round
in 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:HibernateCriteriaBuilder
Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.- Specified by:
truncate
in 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:
neg
in interfaceCriteriaBuilder
- Specified by:
neg
in interfaceHibernateCriteriaBuilder
- Specified by:
neg
in interfaceNodeBuilder
-
abs
public <N extends Number> SqmExpression<N> abs(Expression<N> x)
- Specified by:
abs
in interfaceCriteriaBuilder
- Specified by:
abs
in interfaceHibernateCriteriaBuilder
- Specified by:
abs
in interfaceNodeBuilder
-
duration
public JpaExpression<Duration> duration(long magnitude, TemporalUnit unit)
Description copied from interface:HibernateCriteriaBuilder
A literalDuration
, for example, "five days" or "30 minutes".- Specified by:
duration
in interfaceHibernateCriteriaBuilder
-
durationByUnit
public JpaExpression<Long> durationByUnit(TemporalUnit unit, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Convert aDuration
to a numeric magnitude in the given units.- Specified by:
durationByUnit
in 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:HibernateCriteriaBuilder
Add two durations.- Specified by:
durationSum
in interfaceHibernateCriteriaBuilder
-
durationSum
public JpaExpression<Duration> durationSum(Expression<Duration> x, Duration y)
Description copied from interface:HibernateCriteriaBuilder
Add two durations.- Specified by:
durationSum
in interfaceHibernateCriteriaBuilder
-
durationDiff
public JpaExpression<Duration> durationDiff(Expression<Duration> x, Expression<Duration> y)
Description copied from interface:HibernateCriteriaBuilder
Subtract one duration from another.- Specified by:
durationDiff
in interfaceHibernateCriteriaBuilder
-
durationDiff
public JpaExpression<Duration> durationDiff(Expression<Duration> x, Duration y)
Description copied from interface:HibernateCriteriaBuilder
Subtract one duration from another.- Specified by:
durationDiff
in interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Expression<? extends Number> number, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Scale a duration by a number.- Specified by:
durationScaled
in interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Number number, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Scale a duration by a number.- Specified by:
durationScaled
in interfaceHibernateCriteriaBuilder
-
durationScaled
public JpaExpression<Duration> durationScaled(Expression<? extends Number> number, Duration duration)
Description copied from interface:HibernateCriteriaBuilder
Scale a duration by a number.- Specified by:
durationScaled
in interfaceHibernateCriteriaBuilder
-
durationBetween
public <T extends Temporal> JpaExpression<Duration> durationBetween(Expression<T> x, Expression<T> y)
Description copied from interface:HibernateCriteriaBuilder
Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.- Specified by:
durationBetween
in interfaceHibernateCriteriaBuilder
-
durationBetween
public <T extends Temporal> JpaExpression<Duration> durationBetween(Expression<T> x, T y)
Description copied from interface:HibernateCriteriaBuilder
Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.- Specified by:
durationBetween
in interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(Expression<T> datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
addDuration
in interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(Expression<T> datetime, Duration duration)
Description copied from interface:HibernateCriteriaBuilder
Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
addDuration
in interfaceHibernateCriteriaBuilder
-
addDuration
public <T extends Temporal> JpaExpression<T> addDuration(T datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Add a duration to a date or datetime, that is, return a later date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
addDuration
in interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(Expression<T> datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
subtractDuration
in interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(Expression<T> datetime, Duration duration)
Description copied from interface:HibernateCriteriaBuilder
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
subtractDuration
in interfaceHibernateCriteriaBuilder
-
subtractDuration
public <T extends Temporal> JpaExpression<T> subtractDuration(T datetime, Expression<Duration> duration)
Description copied from interface:HibernateCriteriaBuilder
Subtract a duration to a date or datetime, that is, return an earlier date or datetime which is separated from the given date or datetime by the given duration.- Specified by:
subtractDuration
in interfaceHibernateCriteriaBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
sum
in interfaceCriteriaBuilder
- Specified by:
sum
in interfaceHibernateCriteriaBuilder
- Specified by:
sum
in interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(Expression<? extends N> x, N y)
- Specified by:
sum
in interfaceCriteriaBuilder
- Specified by:
sum
in interfaceHibernateCriteriaBuilder
- Specified by:
sum
in interfaceNodeBuilder
-
sum
public <N extends Number> SqmExpression<N> sum(N x, Expression<? extends N> y)
- Specified by:
sum
in interfaceCriteriaBuilder
- Specified by:
sum
in interfaceHibernateCriteriaBuilder
- Specified by:
sum
in interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
prod
in interfaceCriteriaBuilder
- Specified by:
prod
in interfaceHibernateCriteriaBuilder
- Specified by:
prod
in interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(Expression<? extends N> x, N y)
- Specified by:
prod
in interfaceCriteriaBuilder
- Specified by:
prod
in interfaceHibernateCriteriaBuilder
- Specified by:
prod
in interfaceNodeBuilder
-
prod
public <N extends Number> SqmExpression<N> prod(N x, Expression<? extends N> y)
- Specified by:
prod
in interfaceCriteriaBuilder
- Specified by:
prod
in interfaceHibernateCriteriaBuilder
- Specified by:
prod
in interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x, Expression<? extends N> y)
- Specified by:
diff
in interfaceCriteriaBuilder
- Specified by:
diff
in interfaceHibernateCriteriaBuilder
- Specified by:
diff
in interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(Expression<? extends N> x, N y)
- Specified by:
diff
in interfaceCriteriaBuilder
- Specified by:
diff
in interfaceHibernateCriteriaBuilder
- Specified by:
diff
in interfaceNodeBuilder
-
diff
public <N extends Number> SqmExpression<N> diff(N x, Expression<? extends N> y)
- Specified by:
diff
in interfaceCriteriaBuilder
- Specified by:
diff
in interfaceHibernateCriteriaBuilder
- Specified by:
diff
in interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
quot
in interfaceCriteriaBuilder
- Specified by:
quot
in interfaceHibernateCriteriaBuilder
- Specified by:
quot
in interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Expression<? extends Number> x, Number y)
- Specified by:
quot
in interfaceCriteriaBuilder
- Specified by:
quot
in interfaceHibernateCriteriaBuilder
- Specified by:
quot
in interfaceNodeBuilder
-
quot
public SqmExpression<Number> quot(Number x, Expression<? extends Number> y)
- Specified by:
quot
in interfaceCriteriaBuilder
- Specified by:
quot
in interfaceHibernateCriteriaBuilder
- Specified by:
quot
in interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Expression<Integer> x, Expression<Integer> y)
- Specified by:
mod
in interfaceCriteriaBuilder
- Specified by:
mod
in interfaceHibernateCriteriaBuilder
- Specified by:
mod
in interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Expression<Integer> x, Integer y)
- Specified by:
mod
in interfaceCriteriaBuilder
- Specified by:
mod
in interfaceHibernateCriteriaBuilder
- Specified by:
mod
in interfaceNodeBuilder
-
mod
public SqmExpression<Integer> mod(Integer x, Expression<Integer> y)
- Specified by:
mod
in interfaceCriteriaBuilder
- Specified by:
mod
in interfaceHibernateCriteriaBuilder
- Specified by:
mod
in interfaceNodeBuilder
-
sqrt
public SqmExpression<Double> sqrt(Expression<? extends Number> x)
- Specified by:
sqrt
in interfaceCriteriaBuilder
- Specified by:
sqrt
in interfaceHibernateCriteriaBuilder
- Specified by:
sqrt
in interfaceNodeBuilder
-
toLong
public SqmExpression<Long> toLong(Expression<? extends Number> number)
- Specified by:
toLong
in interfaceCriteriaBuilder
- Specified by:
toLong
in interfaceHibernateCriteriaBuilder
- Specified by:
toLong
in interfaceNodeBuilder
-
toInteger
public SqmExpression<Integer> toInteger(Expression<? extends Number> number)
- Specified by:
toInteger
in interfaceCriteriaBuilder
- Specified by:
toInteger
in interfaceHibernateCriteriaBuilder
- Specified by:
toInteger
in interfaceNodeBuilder
-
toFloat
public SqmExpression<Float> toFloat(Expression<? extends Number> number)
- Specified by:
toFloat
in interfaceCriteriaBuilder
- Specified by:
toFloat
in interfaceHibernateCriteriaBuilder
- Specified by:
toFloat
in interfaceNodeBuilder
-
toDouble
public SqmExpression<Double> toDouble(Expression<? extends Number> number)
- Specified by:
toDouble
in interfaceCriteriaBuilder
- Specified by:
toDouble
in interfaceHibernateCriteriaBuilder
- Specified by:
toDouble
in interfaceNodeBuilder
-
toBigDecimal
public SqmExpression<BigDecimal> toBigDecimal(Expression<? extends Number> number)
- Specified by:
toBigDecimal
in interfaceCriteriaBuilder
- Specified by:
toBigDecimal
in interfaceHibernateCriteriaBuilder
- Specified by:
toBigDecimal
in interfaceNodeBuilder
-
toBigInteger
public SqmExpression<BigInteger> toBigInteger(Expression<? extends Number> number)
- Specified by:
toBigInteger
in interfaceCriteriaBuilder
- Specified by:
toBigInteger
in interfaceHibernateCriteriaBuilder
- Specified by:
toBigInteger
in interfaceNodeBuilder
-
toString
public SqmExpression<String> toString(Expression<Character> character)
- Specified by:
toString
in interfaceCriteriaBuilder
- Specified by:
toString
in interfaceHibernateCriteriaBuilder
- Specified by:
toString
in interfaceNodeBuilder
-
literal
public <T> SqmLiteral<T> literal(T value, SqmExpression<? extends T> typeInferenceSource)
-
literal
public <T> SqmLiteral<T> literal(T value)
- Specified by:
literal
in interfaceCriteriaBuilder
- Specified by:
literal
in interfaceHibernateCriteriaBuilder
- Specified by:
literal
in interfaceNodeBuilder
-
literals
public <T> List<? extends SqmExpression<T>> literals(T[] values)
- Specified by:
literals
in interfaceHibernateCriteriaBuilder
- Specified by:
literals
in interfaceNodeBuilder
-
literals
public <T> List<? extends SqmExpression<T>> literals(List<T> values)
- Specified by:
literals
in interfaceHibernateCriteriaBuilder
- Specified by:
literals
in interfaceNodeBuilder
-
nullLiteral
public <T> SqmExpression<T> nullLiteral(Class<T> resultClass)
- Specified by:
nullLiteral
in interfaceCriteriaBuilder
- Specified by:
nullLiteral
in interfaceHibernateCriteriaBuilder
- Specified by:
nullLiteral
in interfaceNodeBuilder
-
parameter
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass)
- Specified by:
parameter
in interfaceCriteriaBuilder
- Specified by:
parameter
in interfaceHibernateCriteriaBuilder
- Specified by:
parameter
in interfaceNodeBuilder
- See Also:
JpaParameterExpression
-
parameter
public <T> JpaCriteriaParameter<T> parameter(Class<T> paramClass, String name)
- Specified by:
parameter
in interfaceCriteriaBuilder
- Specified by:
parameter
in interfaceHibernateCriteriaBuilder
- Specified by:
parameter
in interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(Expression<String> x, Expression<String> y)
- Specified by:
concat
in interfaceCriteriaBuilder
- Specified by:
concat
in interfaceHibernateCriteriaBuilder
- Specified by:
concat
in interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(Expression<String> x, String y)
- Specified by:
concat
in interfaceCriteriaBuilder
- Specified by:
concat
in interfaceHibernateCriteriaBuilder
- Specified by:
concat
in interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(String x, Expression<String> y)
- Specified by:
concat
in interfaceCriteriaBuilder
- Specified by:
concat
in interfaceHibernateCriteriaBuilder
- Specified by:
concat
in interfaceNodeBuilder
-
concat
public SqmExpression<String> concat(String x, String y)
- Specified by:
concat
in interfaceHibernateCriteriaBuilder
- Specified by:
concat
in interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, Expression<Integer> from)
- Specified by:
substring
in interfaceCriteriaBuilder
- Specified by:
substring
in interfaceHibernateCriteriaBuilder
- Specified by:
substring
in interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, int from)
- Specified by:
substring
in interfaceCriteriaBuilder
- Specified by:
substring
in interfaceHibernateCriteriaBuilder
- Specified by:
substring
in interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, Expression<Integer> from, Expression<Integer> len)
- Specified by:
substring
in interfaceCriteriaBuilder
- Specified by:
substring
in interfaceHibernateCriteriaBuilder
- Specified by:
substring
in interfaceNodeBuilder
-
substring
public SqmFunction<String> substring(Expression<String> source, int from, int len)
- Specified by:
substring
in interfaceCriteriaBuilder
- Specified by:
substring
in interfaceHibernateCriteriaBuilder
- Specified by:
substring
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(Expression<Character> trimChar, Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, Expression<Character> trimChar, Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(char trimChar, Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
trim
public SqmFunction<String> trim(CriteriaBuilder.Trimspec ts, char trimChar, Expression<String> source)
- Specified by:
trim
in interfaceCriteriaBuilder
- Specified by:
trim
in interfaceHibernateCriteriaBuilder
- Specified by:
trim
in interfaceNodeBuilder
-
lower
public SqmFunction<String> lower(Expression<String> x)
- Specified by:
lower
in interfaceCriteriaBuilder
- Specified by:
lower
in interfaceHibernateCriteriaBuilder
- Specified by:
lower
in interfaceNodeBuilder
-
upper
public SqmFunction<String> upper(Expression<String> x)
- Specified by:
upper
in interfaceCriteriaBuilder
- Specified by:
upper
in interfaceHibernateCriteriaBuilder
- Specified by:
upper
in interfaceNodeBuilder
-
length
public SqmFunction<Integer> length(Expression<String> argument)
- Specified by:
length
in interfaceCriteriaBuilder
- Specified by:
length
in interfaceHibernateCriteriaBuilder
- Specified by:
length
in interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, Expression<String> pattern)
- Specified by:
locate
in interfaceCriteriaBuilder
- Specified by:
locate
in interfaceHibernateCriteriaBuilder
- Specified by:
locate
in interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, String pattern)
- Specified by:
locate
in interfaceCriteriaBuilder
- Specified by:
locate
in interfaceHibernateCriteriaBuilder
- Specified by:
locate
in interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, Expression<String> pattern, Expression<Integer> startPosition)
- Specified by:
locate
in interfaceCriteriaBuilder
- Specified by:
locate
in interfaceHibernateCriteriaBuilder
- Specified by:
locate
in interfaceNodeBuilder
-
locate
public SqmFunction<Integer> locate(Expression<String> source, String pattern, int startPosition)
- Specified by:
locate
in interfaceCriteriaBuilder
- Specified by:
locate
in interfaceHibernateCriteriaBuilder
- Specified by:
locate
in interfaceNodeBuilder
-
currentDate
public SqmFunction<Date> currentDate()
- Specified by:
currentDate
in interfaceCriteriaBuilder
- Specified by:
currentDate
in interfaceHibernateCriteriaBuilder
- Specified by:
currentDate
in interfaceNodeBuilder
-
currentTimestamp
public SqmFunction<Timestamp> currentTimestamp()
- Specified by:
currentTimestamp
in interfaceCriteriaBuilder
- Specified by:
currentTimestamp
in interfaceHibernateCriteriaBuilder
- Specified by:
currentTimestamp
in interfaceNodeBuilder
-
currentTime
public SqmFunction<Time> currentTime()
- Specified by:
currentTime
in interfaceCriteriaBuilder
- Specified by:
currentTime
in interfaceHibernateCriteriaBuilder
- Specified by:
currentTime
in interfaceNodeBuilder
-
currentInstant
public SqmFunction<Instant> currentInstant()
- Specified by:
currentInstant
in interfaceHibernateCriteriaBuilder
- Specified by:
currentInstant
in interfaceNodeBuilder
-
localDate
public JpaExpression<LocalDate> localDate()
Description copied from interface:HibernateCriteriaBuilder
Create expression to return current local date.- Specified by:
localDate
in interfaceCriteriaBuilder
- Specified by:
localDate
in interfaceHibernateCriteriaBuilder
- Returns:
- expression for current date
-
localDateTime
public JpaExpression<LocalDateTime> localDateTime()
Description copied from interface:HibernateCriteriaBuilder
Create expression to return current local datetime.- Specified by:
localDateTime
in interfaceCriteriaBuilder
- Specified by:
localDateTime
in interfaceHibernateCriteriaBuilder
- Returns:
- expression for current timestamp
-
localTime
public JpaExpression<LocalTime> localTime()
Description copied from interface:HibernateCriteriaBuilder
Create expression to return current local time.- Specified by:
localTime
in interfaceCriteriaBuilder
- Specified by:
localTime
in interfaceHibernateCriteriaBuilder
- Returns:
- expression for current time
-
function
public <T> SqmFunction<T> function(String name, Class<T> type, Expression<?>[] args)
- Specified by:
function
in interfaceCriteriaBuilder
- Specified by:
function
in interfaceHibernateCriteriaBuilder
- Specified by:
function
in interfaceNodeBuilder
-
all
public <Y> SqmModifiedSubQueryExpression<Y> all(Subquery<Y> subquery)
- Specified by:
all
in interfaceCriteriaBuilder
- Specified by:
all
in interfaceHibernateCriteriaBuilder
- Specified by:
all
in interfaceNodeBuilder
-
some
public <Y> SqmModifiedSubQueryExpression<Y> some(Subquery<Y> subquery)
- Specified by:
some
in interfaceCriteriaBuilder
- Specified by:
some
in interfaceHibernateCriteriaBuilder
- Specified by:
some
in interfaceNodeBuilder
-
any
public <Y> SqmModifiedSubQueryExpression<Y> any(Subquery<Y> subquery)
- Specified by:
any
in interfaceCriteriaBuilder
- Specified by:
any
in interfaceHibernateCriteriaBuilder
- Specified by:
any
in interfaceNodeBuilder
-
keys
public <K,M extends Map<K,?>> SqmExpression<Set<K>> keys(M map)
- Specified by:
keys
in interfaceCriteriaBuilder
- Specified by:
keys
in interfaceHibernateCriteriaBuilder
- Specified by:
keys
in interfaceNodeBuilder
-
indexes
public <K,L extends List<?>> SqmExpression<Set<K>> indexes(L list)
- Specified by:
indexes
in interfaceHibernateCriteriaBuilder
- Specified by:
indexes
in 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:
value
in interfaceHibernateCriteriaBuilder
-
values
public <V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
- Specified by:
values
in interfaceCriteriaBuilder
- Specified by:
values
in interfaceHibernateCriteriaBuilder
- Specified by:
values
in interfaceNodeBuilder
-
size
public <C extends Collection<?>> SqmExpression<Integer> size(Expression<C> collection)
- Specified by:
size
in interfaceCriteriaBuilder
- Specified by:
size
in interfaceHibernateCriteriaBuilder
- Specified by:
size
in interfaceNodeBuilder
-
size
public <C extends Collection<?>> SqmExpression<Integer> size(C collection)
- Specified by:
size
in interfaceCriteriaBuilder
- Specified by:
size
in interfaceHibernateCriteriaBuilder
- Specified by:
size
in interfaceNodeBuilder
-
coalesce
public <T> SqmCoalesce<T> coalesce()
- Specified by:
coalesce
in interfaceCriteriaBuilder
- Specified by:
coalesce
in interfaceHibernateCriteriaBuilder
- Specified by:
coalesce
in interfaceNodeBuilder
-
coalesce
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
coalesce
in interfaceCriteriaBuilder
- Specified by:
coalesce
in interfaceHibernateCriteriaBuilder
- Specified by:
coalesce
in interfaceNodeBuilder
-
coalesce
public <Y> JpaCoalesce<Y> coalesce(Expression<? extends Y> x, Y y)
- Specified by:
coalesce
in interfaceCriteriaBuilder
- Specified by:
coalesce
in interfaceHibernateCriteriaBuilder
- Specified by:
coalesce
in interfaceNodeBuilder
-
nullif
public <Y> SqmExpression<Y> nullif(Expression<Y> x, Expression<?> y)
- Specified by:
nullif
in interfaceCriteriaBuilder
- Specified by:
nullif
in interfaceHibernateCriteriaBuilder
- Specified by:
nullif
in interfaceNodeBuilder
-
nullif
public <Y> SqmExpression<Y> nullif(Expression<Y> x, Y y)
- Specified by:
nullif
in interfaceCriteriaBuilder
- Specified by:
nullif
in interfaceHibernateCriteriaBuilder
- Specified by:
nullif
in interfaceNodeBuilder
-
selectCase
public <C,R> SqmCaseSimple<C,R> selectCase(Expression<? extends C> expression)
- Specified by:
selectCase
in interfaceCriteriaBuilder
- Specified by:
selectCase
in interfaceHibernateCriteriaBuilder
- Specified by:
selectCase
in interfaceNodeBuilder
-
selectCase
public <R> SqmCaseSearched<R> selectCase()
- Specified by:
selectCase
in interfaceCriteriaBuilder
- Specified by:
selectCase
in interfaceHibernateCriteriaBuilder
- Specified by:
selectCase
in interfaceNodeBuilder
-
mapSize
public <M extends Map<?,?>> SqmExpression<Integer> mapSize(JpaExpression<M> mapExpression)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that tests the size of a map.- Specified by:
mapSize
in interfaceHibernateCriteriaBuilder
- Specified by:
mapSize
in 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:HibernateCriteriaBuilder
Create an expression that tests the size of a map.- Specified by:
mapSize
in interfaceHibernateCriteriaBuilder
- Specified by:
mapSize
in 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:
and
in interfaceCriteriaBuilder
- Specified by:
and
in interfaceHibernateCriteriaBuilder
- Specified by:
and
in interfaceNodeBuilder
-
and
public SqmPredicate and(Predicate... restrictions)
- Specified by:
and
in interfaceCriteriaBuilder
- Specified by:
and
in interfaceHibernateCriteriaBuilder
- Specified by:
and
in interfaceNodeBuilder
-
or
public SqmPredicate or(Expression<Boolean> x, Expression<Boolean> y)
- Specified by:
or
in interfaceCriteriaBuilder
- Specified by:
or
in interfaceHibernateCriteriaBuilder
- Specified by:
or
in interfaceNodeBuilder
-
or
public SqmPredicate or(Predicate... restrictions)
- Specified by:
or
in interfaceCriteriaBuilder
- Specified by:
or
in interfaceHibernateCriteriaBuilder
- Specified by:
or
in interfaceNodeBuilder
-
not
public SqmPredicate not(Expression<Boolean> restriction)
- Specified by:
not
in interfaceCriteriaBuilder
- Specified by:
not
in interfaceHibernateCriteriaBuilder
- Specified by:
not
in interfaceNodeBuilder
-
conjunction
public SqmPredicate conjunction()
- Specified by:
conjunction
in interfaceCriteriaBuilder
- Specified by:
conjunction
in interfaceHibernateCriteriaBuilder
- Specified by:
conjunction
in interfaceNodeBuilder
-
disjunction
public SqmPredicate disjunction()
- Specified by:
disjunction
in interfaceCriteriaBuilder
- Specified by:
disjunction
in interfaceHibernateCriteriaBuilder
- Specified by:
disjunction
in interfaceNodeBuilder
-
isTrue
public SqmPredicate isTrue(Expression<Boolean> x)
- Specified by:
isTrue
in interfaceCriteriaBuilder
- Specified by:
isTrue
in interfaceHibernateCriteriaBuilder
- Specified by:
isTrue
in interfaceNodeBuilder
-
isFalse
public SqmPredicate isFalse(Expression<Boolean> x)
- Specified by:
isFalse
in interfaceCriteriaBuilder
- Specified by:
isFalse
in interfaceHibernateCriteriaBuilder
- Specified by:
isFalse
in interfaceNodeBuilder
-
isNull
public SqmPredicate isNull(Expression<?> x)
- Specified by:
isNull
in interfaceCriteriaBuilder
- Specified by:
isNull
in interfaceHibernateCriteriaBuilder
- Specified by:
isNull
in interfaceNodeBuilder
-
isNotNull
public SqmPredicate isNotNull(Expression<?> x)
- Specified by:
isNotNull
in interfaceCriteriaBuilder
- Specified by:
isNotNull
in interfaceHibernateCriteriaBuilder
- Specified by:
isNotNull
in interfaceNodeBuilder
-
between
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value, Expression<? extends Y> lower, Expression<? extends Y> upper)
- Specified by:
between
in interfaceCriteriaBuilder
- Specified by:
between
in interfaceHibernateCriteriaBuilder
- Specified by:
between
in interfaceNodeBuilder
-
between
public <Y extends Comparable<? super Y>> SqmPredicate between(Expression<? extends Y> value, Y lower, Y upper)
- Specified by:
between
in interfaceCriteriaBuilder
- Specified by:
between
in interfaceHibernateCriteriaBuilder
- Specified by:
between
in interfaceNodeBuilder
-
equal
public SqmPredicate equal(Expression<?> x, Expression<?> y)
- Specified by:
equal
in interfaceCriteriaBuilder
- Specified by:
equal
in interfaceHibernateCriteriaBuilder
- Specified by:
equal
in interfaceNodeBuilder
-
equal
public SqmPredicate equal(Expression<?> x, Object y)
- Specified by:
equal
in interfaceCriteriaBuilder
- Specified by:
equal
in interfaceHibernateCriteriaBuilder
- Specified by:
equal
in interfaceNodeBuilder
-
notEqual
public SqmPredicate notEqual(Expression<?> x, Expression<?> y)
- Specified by:
notEqual
in interfaceCriteriaBuilder
- Specified by:
notEqual
in interfaceHibernateCriteriaBuilder
- Specified by:
notEqual
in interfaceNodeBuilder
-
notEqual
public SqmPredicate notEqual(Expression<?> x, Object y)
- Specified by:
notEqual
in interfaceCriteriaBuilder
- Specified by:
notEqual
in interfaceHibernateCriteriaBuilder
- Specified by:
notEqual
in interfaceNodeBuilder
-
distinctFrom
public SqmPredicate distinctFrom(Expression<?> x, Expression<?> y)
- Specified by:
distinctFrom
in interfaceHibernateCriteriaBuilder
- Specified by:
distinctFrom
in interfaceNodeBuilder
-
distinctFrom
public SqmPredicate distinctFrom(Expression<?> x, Object y)
- Specified by:
distinctFrom
in interfaceHibernateCriteriaBuilder
- Specified by:
distinctFrom
in interfaceNodeBuilder
-
notDistinctFrom
public SqmPredicate notDistinctFrom(Expression<?> x, Expression<?> y)
- Specified by:
notDistinctFrom
in interfaceHibernateCriteriaBuilder
- Specified by:
notDistinctFrom
in interfaceNodeBuilder
-
notDistinctFrom
public SqmPredicate notDistinctFrom(Expression<?> x, Object y)
- Specified by:
notDistinctFrom
in interfaceHibernateCriteriaBuilder
- Specified by:
notDistinctFrom
in interfaceNodeBuilder
-
greaterThan
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
greaterThan
in interfaceCriteriaBuilder
- Specified by:
greaterThan
in interfaceHibernateCriteriaBuilder
- Specified by:
greaterThan
in interfaceNodeBuilder
-
greaterThan
public <Y extends Comparable<? super Y>> SqmPredicate greaterThan(Expression<? extends Y> x, Y y)
- Specified by:
greaterThan
in interfaceCriteriaBuilder
- Specified by:
greaterThan
in interfaceHibernateCriteriaBuilder
- Specified by:
greaterThan
in interfaceNodeBuilder
-
greaterThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
greaterThanOrEqualTo
in interfaceCriteriaBuilder
- Specified by:
greaterThanOrEqualTo
in interfaceHibernateCriteriaBuilder
- Specified by:
greaterThanOrEqualTo
in interfaceNodeBuilder
-
greaterThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate greaterThanOrEqualTo(Expression<? extends Y> x, Y y)
- Specified by:
greaterThanOrEqualTo
in interfaceCriteriaBuilder
- Specified by:
greaterThanOrEqualTo
in interfaceHibernateCriteriaBuilder
- Specified by:
greaterThanOrEqualTo
in interfaceNodeBuilder
-
lessThan
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
lessThan
in interfaceCriteriaBuilder
- Specified by:
lessThan
in interfaceHibernateCriteriaBuilder
- Specified by:
lessThan
in interfaceNodeBuilder
-
lessThan
public <Y extends Comparable<? super Y>> SqmPredicate lessThan(Expression<? extends Y> x, Y y)
- Specified by:
lessThan
in interfaceCriteriaBuilder
- Specified by:
lessThan
in interfaceHibernateCriteriaBuilder
- Specified by:
lessThan
in interfaceNodeBuilder
-
lessThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
- Specified by:
lessThanOrEqualTo
in interfaceCriteriaBuilder
- Specified by:
lessThanOrEqualTo
in interfaceHibernateCriteriaBuilder
- Specified by:
lessThanOrEqualTo
in interfaceNodeBuilder
-
lessThanOrEqualTo
public <Y extends Comparable<? super Y>> SqmPredicate lessThanOrEqualTo(Expression<? extends Y> x, Y y)
- Specified by:
lessThanOrEqualTo
in interfaceCriteriaBuilder
- Specified by:
lessThanOrEqualTo
in interfaceHibernateCriteriaBuilder
- Specified by:
lessThanOrEqualTo
in interfaceNodeBuilder
-
gt
public SqmPredicate gt(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
gt
in interfaceCriteriaBuilder
- Specified by:
gt
in interfaceHibernateCriteriaBuilder
- Specified by:
gt
in interfaceNodeBuilder
-
gt
public SqmPredicate gt(Expression<? extends Number> x, Number y)
- Specified by:
gt
in interfaceCriteriaBuilder
- Specified by:
gt
in interfaceHibernateCriteriaBuilder
- Specified by:
gt
in interfaceNodeBuilder
-
ge
public SqmPredicate ge(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
ge
in interfaceCriteriaBuilder
- Specified by:
ge
in interfaceHibernateCriteriaBuilder
- Specified by:
ge
in interfaceNodeBuilder
-
ge
public SqmPredicate ge(Expression<? extends Number> x, Number y)
- Specified by:
ge
in interfaceCriteriaBuilder
- Specified by:
ge
in interfaceHibernateCriteriaBuilder
- Specified by:
ge
in interfaceNodeBuilder
-
lt
public SqmPredicate lt(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
lt
in interfaceCriteriaBuilder
- Specified by:
lt
in interfaceHibernateCriteriaBuilder
- Specified by:
lt
in interfaceNodeBuilder
-
lt
public SqmPredicate lt(Expression<? extends Number> x, Number y)
- Specified by:
lt
in interfaceCriteriaBuilder
- Specified by:
lt
in interfaceHibernateCriteriaBuilder
- Specified by:
lt
in interfaceNodeBuilder
-
le
public SqmPredicate le(Expression<? extends Number> x, Expression<? extends Number> y)
- Specified by:
le
in interfaceCriteriaBuilder
- Specified by:
le
in interfaceHibernateCriteriaBuilder
- Specified by:
le
in interfaceNodeBuilder
-
le
public SqmPredicate le(Expression<? extends Number> x, Number y)
- Specified by:
le
in interfaceCriteriaBuilder
- Specified by:
le
in interfaceHibernateCriteriaBuilder
- Specified by:
le
in interfaceNodeBuilder
-
isEmpty
public <C extends Collection<?>> SqmPredicate isEmpty(Expression<C> collection)
- Specified by:
isEmpty
in interfaceCriteriaBuilder
- Specified by:
isEmpty
in interfaceHibernateCriteriaBuilder
- Specified by:
isEmpty
in interfaceNodeBuilder
-
isNotEmpty
public <C extends Collection<?>> SqmPredicate isNotEmpty(Expression<C> collection)
- Specified by:
isNotEmpty
in interfaceCriteriaBuilder
- Specified by:
isNotEmpty
in interfaceHibernateCriteriaBuilder
- Specified by:
isNotEmpty
in interfaceNodeBuilder
-
isMember
public <E,C extends Collection<E>> SqmPredicate isMember(Expression<E> elem, Expression<C> collection)
- Specified by:
isMember
in interfaceCriteriaBuilder
- Specified by:
isMember
in interfaceHibernateCriteriaBuilder
- Specified by:
isMember
in interfaceNodeBuilder
-
isMember
public <E,C extends Collection<E>> SqmPredicate isMember(E elem, Expression<C> collection)
- Specified by:
isMember
in interfaceCriteriaBuilder
- Specified by:
isMember
in interfaceHibernateCriteriaBuilder
- Specified by:
isMember
in interfaceNodeBuilder
-
isNotMember
public <E,C extends Collection<E>> SqmPredicate isNotMember(Expression<E> elem, Expression<C> collection)
- Specified by:
isNotMember
in interfaceCriteriaBuilder
- Specified by:
isNotMember
in interfaceHibernateCriteriaBuilder
- Specified by:
isNotMember
in interfaceNodeBuilder
-
isNotMember
public <E,C extends Collection<E>> SqmPredicate isNotMember(E elem, Expression<C> collection)
- Specified by:
isNotMember
in interfaceCriteriaBuilder
- Specified by:
isNotMember
in interfaceHibernateCriteriaBuilder
- Specified by:
isNotMember
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, Expression<String> pattern, char escapeChar)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
like
public SqmPredicate like(Expression<String> searchString, String pattern, char escapeChar)
- Specified by:
like
in interfaceCriteriaBuilder
- Specified by:
like
in interfaceHibernateCriteriaBuilder
- Specified by:
like
in interfaceNodeBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
ilike
public SqmPredicate ilike(Expression<String> searchString, String pattern, char escapeChar)
- Specified by:
ilike
in interfaceHibernateCriteriaBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, Expression<String> pattern, char escapeChar)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern, Expression<Character> escapeChar)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notLike
public SqmPredicate notLike(Expression<String> x, String pattern, char escapeChar)
- Specified by:
notLike
in interfaceCriteriaBuilder
- Specified by:
notLike
in interfaceHibernateCriteriaBuilder
- Specified by:
notLike
in interfaceNodeBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
notIlike
public SqmPredicate notIlike(Expression<String> x, String pattern, char escapeChar)
- Specified by:
notIlike
in interfaceHibernateCriteriaBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression)
- Specified by:
in
in interfaceCriteriaBuilder
- Specified by:
in
in interfaceHibernateCriteriaBuilder
- Specified by:
in
in interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, Expression<? extends T>... values)
- Specified by:
in
in interfaceHibernateCriteriaBuilder
- Specified by:
in
in interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, T... values)
- Specified by:
in
in interfaceHibernateCriteriaBuilder
- Specified by:
in
in interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, Collection<T> values)
- Specified by:
in
in interfaceHibernateCriteriaBuilder
- Specified by:
in
in interfaceNodeBuilder
-
in
public <T> SqmInPredicate<T> in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)
- Specified by:
in
in interfaceNodeBuilder
-
exists
public SqmPredicate exists(Subquery<?> subQuery)
- Specified by:
exists
in interfaceCriteriaBuilder
- Specified by:
exists
in interfaceHibernateCriteriaBuilder
- Specified by:
exists
in interfaceNodeBuilder
-
isMapEmpty
public <M extends Map<?,?>> SqmPredicate isMapEmpty(JpaExpression<M> mapExpression)
Description copied from interface:HibernateCriteriaBuilder
Create a predicate that tests whether a Map is empty.- Specified by:
isMapEmpty
in interfaceHibernateCriteriaBuilder
- Specified by:
isMapEmpty
in 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:HibernateCriteriaBuilder
Create a predicate that tests whether a Map is not empty.- Specified by:
isMapNotEmpty
in interfaceHibernateCriteriaBuilder
- Specified by:
isMapNotEmpty
in 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:HibernateCriteriaBuilder
Embed nativepattern
that will be unquoted and embedded in the generated SQL. Occurrences of?
in the pattern are replaced with the remainingarguments
of the function.- Specified by:
sql
in 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:HibernateCriteriaBuilder
Format a date, time, or datetime according to a pattern. The pattern must be written in a subset of the pattern language defined by Java’sDateTimeFormatter
.See
Dialect.appendDatetimeFormat(org.hibernate.sql.ast.spi.SqlAppender, java.lang.String)
for a full list of pattern elements.- Specified by:
format
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.YEAR
of a date, time, or datetime expression.- Specified by:
year
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.MONTH
of a date, time, or datetime expression.- Specified by:
month
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.DAY
of a date, time, or datetime expression.- Specified by:
day
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.HOUR
of a date, time, or datetime expression.- Specified by:
hour
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.MINUTE
of a date, time, or datetime expression.- Specified by:
minute
in 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:HibernateCriteriaBuilder
Extracts theTemporalUnit.SECOND
of a date, time, or datetime expression.- Specified by:
second
in 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:HibernateCriteriaBuilder
Truncates 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
field
have been pruned. For hours, minutes and second this means setting them to00
. For months and days, this means setting them to01
.- Specified by:
truncate
in 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:
overlay
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, Expression<String> replacement, int start)
- Specified by:
overlay
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.overlay(Expression, Expression, Expression, Expression)
-
overlay
public SqmFunction<String> overlay(Expression<String> string, String replacement, Expression<Integer> start)
- Specified by:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:
overlay
in 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:HibernateCriteriaBuilder
Overlay thestring
expression with thereplacement
expression, starting from indexstart
and substituting a number of characters corresponding to the length of thereplacement
expression or thelength
parameter if specified.- Specified by:
overlay
in 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:
pad
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(CriteriaBuilder.Trimspec ts, Expression<String> x, int length)
- Specified by:
pad
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, Expression<Integer> length)
- Specified by:
pad
in 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:
pad
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, int length, char padChar)
- Specified by:
pad
in 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:
pad
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, int length, Expression<Character> padChar)
- Specified by:
pad
in 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:
pad
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.pad(Trimspec, Expression, Expression, Expression)
-
pad
public SqmFunction<String> pad(Expression<String> x, Expression<Integer> length, char padChar)
- Specified by:
pad
in 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:
pad
in 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:
pad
in 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:HibernateCriteriaBuilder
Pad the specified string expression with whitespace or with thepadChar
character if specified. Optionally pass aCriteriaBuilder.Trimspec
to pad the string expression withLEADING
orTRAILING
(default) characters.- Specified by:
pad
in interfaceHibernateCriteriaBuilder
- Parameters:
ts
- optionalCriteriaBuilder.Trimspec
x
- 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:HibernateCriteriaBuilder
Concatenate the given string expression with itself the given number of times.- Specified by:
repeat
in 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:HibernateCriteriaBuilder
Concatenate the given string expression with itself the given number of times.- Specified by:
repeat
in 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:HibernateCriteriaBuilder
Concatenate the given string expression with itself the given number of times.- Specified by:
repeat
in 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:
left
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.left(Expression, Expression)
-
left
public SqmFunction<String> left(Expression<String> x, Expression<Integer> length)
Description copied from interface:HibernateCriteriaBuilder
Extract thelength
leftmost characters of a string.- Specified by:
left
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- original stringlength
- number of characters- Returns:
- left expression
-
right
public SqmFunction<String> right(Expression<String> x, int length)
- Specified by:
right
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.right(Expression, Expression)
-
right
public SqmFunction<String> right(Expression<String> x, Expression<Integer> length)
Description copied from interface:HibernateCriteriaBuilder
Extract thelength
rightmost characters of a string.- Specified by:
right
in 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:
replace
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
-
replace
public SqmFunction<String> replace(Expression<String> x, String pattern, Expression<String> replacement)
- Specified by:
replace
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.replace(Expression, Expression, Expression)
-
replace
public SqmFunction<String> replace(Expression<String> x, Expression<String> pattern, String replacement)
- Specified by:
replace
in 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:HibernateCriteriaBuilder
Replace all occurrences ofpattern
within the original string withreplacement
.- Specified by:
replace
in 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:
collate
in interfaceHibernateCriteriaBuilder
-
log10
public SqmFunction<Double> log10(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the base-10 logarithm of its argument.- Specified by:
log10
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- base-10 logarithm
-
log
public SqmFunction<Double> log(Number b, Expression<? extends Number> x)
- Specified by:
log
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.log(Expression, Expression)
-
log
public SqmFunction<Double> log(Expression<? extends Number> b, Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the logarithm ofx
to the baseb
.- Specified by:
log
in interfaceHibernateCriteriaBuilder
- Parameters:
b
- basex
- expression- Returns:
- arbitrary-base logarithm
-
pi
public SqmFunction<Double> pi()
Description copied from interface:HibernateCriteriaBuilder
Literal expression corresponding to the value of pi.- Specified by:
pi
in interfaceHibernateCriteriaBuilder
- Returns:
- pi expression
-
sin
public SqmFunction<Double> sin(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the sine of its argument.- Specified by:
sin
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- sine
-
cos
public SqmFunction<Double> cos(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the cosine of its argument.- Specified by:
cos
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- cosine
-
tan
public SqmFunction<Double> tan(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the tangent of its argument.- Specified by:
tan
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- tangent
-
asin
public SqmFunction<Double> asin(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the inverse sine of its argument.- Specified by:
asin
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- inverse sine
-
acos
public SqmFunction<Double> acos(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the inverse cosine of its argument.- Specified by:
acos
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- inverse cosine
-
atan
public SqmFunction<Double> atan(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the inverse tangent of its argument.- Specified by:
atan
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- inverse tangent
-
atan2
public SqmFunction<Double> atan2(Number y, Expression<? extends Number> x)
- Specified by:
atan2
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.atan2(Expression, Expression)
-
atan2
public SqmFunction<Double> atan2(Expression<? extends Number> y, Number x)
- Specified by:
atan2
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.atan2(Expression, Expression)
-
atan2
public SqmFunction<Double> atan2(Expression<? extends Number> y, Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the inverse tangent ofy
overx
.- Specified by:
atan2
in 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:HibernateCriteriaBuilder
Create an expression that returns the hyperbolic sine of its argument.- Specified by:
sinh
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- hyperbolic sine
-
cosh
public SqmFunction<Double> cosh(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the hyperbolic cosine of its argument.- Specified by:
cosh
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- hyperbolic cosine
-
tanh
public SqmFunction<Double> tanh(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that returns the hyperbolic tangent of its argument.- Specified by:
tanh
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- hyperbolic tangent
-
degrees
public SqmFunction<Double> degrees(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.- Specified by:
degrees
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- degrees
-
radians
public SqmFunction<Double> radians(Expression<? extends Number> x)
Description copied from interface:HibernateCriteriaBuilder
Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.- Specified by:
radians
in interfaceHibernateCriteriaBuilder
- Parameters:
x
- expression- Returns:
- radians
-
createWindow
public SqmWindow createWindow()
Description copied from interface:HibernateCriteriaBuilder
Create an emptyJpaWindow
to use with window and aggregate functions.- Specified by:
createWindow
in interfaceHibernateCriteriaBuilder
- Returns:
- the empty window
-
frameUnboundedPreceding
public SqmWindowFrame frameUnboundedPreceding()
Description copied from interface:HibernateCriteriaBuilder
Create a window frame of typeFrameKind.UNBOUNDED_PRECEDING
to use withJpaWindow
s.- Specified by:
frameUnboundedPreceding
in interfaceHibernateCriteriaBuilder
- Returns:
- the window frame
-
frameBetweenPreceding
public SqmWindowFrame frameBetweenPreceding(int offset)
- Specified by:
frameBetweenPreceding
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.frameBetweenPreceding(Expression)
-
frameBetweenPreceding
public SqmWindowFrame frameBetweenPreceding(Expression<?> offset)
Description copied from interface:HibernateCriteriaBuilder
Create window frame of typeFrameKind.OFFSET_PRECEDING
to use withJpaWindow
s.- Specified by:
frameBetweenPreceding
in interfaceHibernateCriteriaBuilder
- Parameters:
offset
- theoffset
expression- Returns:
- the window frame
-
frameCurrentRow
public SqmWindowFrame frameCurrentRow()
Description copied from interface:HibernateCriteriaBuilder
Create a window frame of typeFrameKind.CURRENT_ROW
to use withJpaWindow
s.- Specified by:
frameCurrentRow
in interfaceHibernateCriteriaBuilder
- Returns:
- the window frame
-
frameBetweenFollowing
public SqmWindowFrame frameBetweenFollowing(int offset)
- Specified by:
frameBetweenFollowing
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.frameBetweenFollowing(Expression)
-
frameBetweenFollowing
public SqmWindowFrame frameBetweenFollowing(Expression<?> offset)
Description copied from interface:HibernateCriteriaBuilder
Create a window frame of typeFrameKind.OFFSET_FOLLOWING
to use withJpaWindow
s.- Specified by:
frameBetweenFollowing
in interfaceHibernateCriteriaBuilder
- Parameters:
offset
- theoffset
expression- Returns:
- the window frame
-
frameUnboundedFollowing
public SqmWindowFrame frameUnboundedFollowing()
Description copied from interface:HibernateCriteriaBuilder
Create a window frame of typeFrameKind.UNBOUNDED_FOLLOWING
to use withJpaWindow
s.- Specified by:
frameUnboundedFollowing
in interfaceHibernateCriteriaBuilder
- Returns:
- the window frame
-
windowFunction
public <T> SqmExpression<T> windowFunction(String name, Class<T> type, JpaWindow window, Expression<?>... args)
Description copied from interface:HibernateCriteriaBuilder
Create a generic window function expression that will be applied over the specifiedwindow
.- Specified by:
windowFunction
in 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:HibernateCriteriaBuilder
Create arow_number
window function expression.- Specified by:
rowNumber
in 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:HibernateCriteriaBuilder
Create afirst_value
window function expression.- Specified by:
firstValue
in interfaceHibernateCriteriaBuilder
- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tofirst_value
window
- window over which the function will be applied- Returns:
- window function expression
- See Also:
HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
-
lastValue
public <T> SqmExpression<T> lastValue(Expression<T> argument, JpaWindow window)
Description copied from interface:HibernateCriteriaBuilder
Create alast_value
window function expression.- Specified by:
lastValue
in interfaceHibernateCriteriaBuilder
- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tolast_value
window
- window over which the function will be applied- Returns:
- window function expression
- See Also:
HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
-
nthValue
public <T> SqmExpression<T> nthValue(Expression<T> argument, int n, JpaWindow window)
- Specified by:
nthValue
in interfaceHibernateCriteriaBuilder
- See Also:
nthValue
-
nthValue
public <T> SqmExpression<T> nthValue(Expression<T> argument, Expression<Integer> n, JpaWindow window)
Description copied from interface:HibernateCriteriaBuilder
Create anth_value
window function expression.- Specified by:
nthValue
in interfaceHibernateCriteriaBuilder
- Type Parameters:
T
- type of the expression- Parameters:
argument
- argument expression to pass tonth_value
n
- theN
argument for the functionwindow
- window over which the function will be applied- Returns:
- window function expression
- See Also:
HibernateCriteriaBuilder.windowFunction(java.lang.String, java.lang.Class<T>, org.hibernate.query.criteria.JpaWindow, jakarta.persistence.criteria.Expression<?>...)
-
rank
public SqmExpression<Long> rank(JpaWindow window)
Description copied from interface:HibernateCriteriaBuilder
Create arank
window function expression.- Specified by:
rank
in 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:HibernateCriteriaBuilder
Create adense_rank
window function expression.- Specified by:
denseRank
in 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:HibernateCriteriaBuilder
Create apercent_rank
window function expression.- Specified by:
percentRank
in 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:HibernateCriteriaBuilder
Create acume_dist
window function expression.- Specified by:
cumeDist
in 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:
functionAggregate
in 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:
functionAggregate
in 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:HibernateCriteriaBuilder
Create a generic aggregate function expression.- Specified by:
functionAggregate
in 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:
sum
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.sum(Expression, JpaPredicate, JpaWindow)
-
sum
public <N extends Number> SqmExpression<Number> sum(Expression<N> argument, JpaWindow window)
- Specified by:
sum
in 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:HibernateCriteriaBuilder
Create asum
aggregate function expression.- Specified by:
sum
in 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:
avg
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.avg(Expression, JpaPredicate, JpaWindow)
-
avg
public <N extends Number> SqmExpression<Double> avg(Expression<N> argument, JpaWindow window)
- Specified by:
avg
in 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:HibernateCriteriaBuilder
Create anavg
aggregate function expression.- Specified by:
avg
in 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:
count
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
-
count
public SqmExpression<Long> count(Expression<?> argument, JpaWindow window)
- Specified by:
count
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.count(Expression, JpaPredicate, JpaWindow)
-
count
public SqmExpression<Long> count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
Description copied from interface:HibernateCriteriaBuilder
Create acount
aggregate function expression.- Specified by:
count
in 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:
functionWithinGroup
in 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:
functionWithinGroup
in 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:
functionWithinGroup
in 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:HibernateCriteriaBuilder
Create a generic ordered set-aggregate function expression.- Specified by:
functionWithinGroup
in 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:
listagg
in 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:
listagg
in 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:
listagg
in 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:
listagg
in 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:
listagg
in 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:
listagg
in 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:
listagg
in 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:HibernateCriteriaBuilder
Create alistagg
ordered set-aggregate function expression.- Specified by:
listagg
in 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:
mode
in 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:
mode
in 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:
mode
in 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:HibernateCriteriaBuilder
Create amode
ordered set-aggregate function expression.- Specified by:
mode
in 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:HibernateCriteriaBuilder
Create apercentile_cont
ordered set-aggregate function expression.- Specified by:
percentileCont
in 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:HibernateCriteriaBuilder
Create apercentile_disc
ordered set-aggregate function expression.- Specified by:
percentileDisc
in 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:
rank
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
rank
public SqmExpression<Long> rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
- Specified by:
rank
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.rank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
rank
public SqmExpression<Long> rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
- Specified by:
rank
in 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:HibernateCriteriaBuilder
Create arank
ordered set-aggregate function expression.- Specified by:
rank
in 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:
percentRank
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
percentRank
public SqmExpression<Double> percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
- Specified by:
percentRank
in interfaceHibernateCriteriaBuilder
- See Also:
HibernateCriteriaBuilder.percentRank(JpaOrder, JpaPredicate, JpaWindow, Expression...)
-
percentRank
public SqmExpression<Double> percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
- Specified by:
percentRank
in 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:HibernateCriteriaBuilder
Create apercent_rank
ordered set-aggregate function expression.- Specified by:
percentRank
in 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:
arrayAgg
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAgg
in 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:
arrayAgg
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAgg
in 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:
arrayAgg
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAgg
in 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:HibernateCriteriaBuilder
Create aarray_agg
ordered set-aggregate function expression.- Specified by:
arrayAgg
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAgg
in 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:HibernateCriteriaBuilder
Creates an array literal with thearray
constructor function.- Specified by:
arrayLiteral
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayLiteral
in interfaceNodeBuilder
-
arrayPosition
public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Determines the 1-based position of an element in an array.- Specified by:
arrayPosition
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPosition
in interfaceNodeBuilder
-
arrayPosition
public <T> SqmExpression<Integer> arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines the 1-based position of an element in an array.- Specified by:
arrayPosition
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPosition
in interfaceNodeBuilder
-
arrayPositions
public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in an array.- Specified by:
arrayPositions
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPositions
in interfaceNodeBuilder
-
arrayPositions
public <T> SqmExpression<int[]> arrayPositions(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in an array.- Specified by:
arrayPositions
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPositions
in interfaceNodeBuilder
-
arrayPositionsList
public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in an array.- Specified by:
arrayPositionsList
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPositionsList
in interfaceNodeBuilder
-
arrayPositionsList
public <T> SqmExpression<List<Integer>> arrayPositionsList(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in an array.- Specified by:
arrayPositionsList
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPositionsList
in interfaceNodeBuilder
-
arrayLength
public <T> SqmExpression<Integer> arrayLength(Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines the length of an array.- Specified by:
arrayLength
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayLength
in interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Concatenates arrays with each other in order.- Specified by:
arrayConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayConcat
in interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilder
Concatenates arrays with each other in order.- Specified by:
arrayConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayConcat
in interfaceNodeBuilder
-
arrayConcat
public <T> SqmExpression<T[]> arrayConcat(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Concatenates arrays with each other in order.- Specified by:
arrayConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayConcat
in interfaceNodeBuilder
-
arrayAppend
public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Appends element to array.- Specified by:
arrayAppend
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAppend
in interfaceNodeBuilder
-
arrayAppend
public <T> SqmExpression<T[]> arrayAppend(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Appends element to array.- Specified by:
arrayAppend
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayAppend
in interfaceNodeBuilder
-
arrayPrepend
public <T> SqmExpression<T[]> arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Prepends element to array.- Specified by:
arrayPrepend
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPrepend
in interfaceNodeBuilder
-
arrayPrepend
public <T> SqmExpression<T[]> arrayPrepend(T element, Expression<T[]> arrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Prepends element to array.- Specified by:
arrayPrepend
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayPrepend
in interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains an element.- Specified by:
arrayContains
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContains
in interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains an element.- Specified by:
arrayContains
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContains
in interfaceNodeBuilder
-
arrayContains
public <T> SqmPredicate arrayContains(T[] array, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains an element.- Specified by:
arrayContains
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContains
in interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains a nullable element.- Specified by:
arrayContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContainsNullable
in interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains a nullable element.- Specified by:
arrayContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContainsNullable
in interfaceNodeBuilder
-
arrayContainsNullable
public <T> SqmPredicate arrayContainsNullable(T[] array, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array contains a nullable element.- Specified by:
arrayContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayContainsNullable
in interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array.- Specified by:
arrayIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludes
in interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(Expression<T[]> arrayExpression, T[] subArray)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array.- Specified by:
arrayIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludes
in interfaceNodeBuilder
-
arrayIncludes
public <T> SqmPredicate arrayIncludes(T[] array, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array.- Specified by:
arrayIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludes
in interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludesNullable
in interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(Expression<T[]> arrayExpression, T[] subArray)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludesNullable
in interfaceNodeBuilder
-
arrayIncludesNullable
public <T> SqmPredicate arrayIncludesNullable(T[] array, Expression<T[]> subArrayExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether an array is a subset of another array with nullable elements.- Specified by:
arrayIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIncludesNullable
in interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array.- Specified by:
arrayIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersects
in interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array.- Specified by:
arrayIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersects
in interfaceNodeBuilder
-
arrayIntersects
public <T> SqmPredicate arrayIntersects(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array.- Specified by:
arrayIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersects
in interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array, supportingnull
elements.- Specified by:
arrayIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersectsNullable
in interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(Expression<T[]> arrayExpression1, T[] array2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array, supportingnull
elements.- Specified by:
arrayIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersectsNullable
in interfaceNodeBuilder
-
arrayIntersectsNullable
public <T> SqmPredicate arrayIntersectsNullable(T[] array1, Expression<T[]> arrayExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one array has any elements common with another array, supportingnull
elements.- Specified by:
arrayIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayIntersectsNullable
in interfaceNodeBuilder
-
arrayGet
public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilder
Accesses the element of an array by 1-based index.- Specified by:
arrayGet
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayGet
in interfaceNodeBuilder
-
arrayGet
public <T> SqmExpression<T> arrayGet(Expression<T[]> arrayExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilder
Accesses the element of an array by 1-based index.- Specified by:
arrayGet
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayGet
in interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element at given 1-based index.- Specified by:
arraySet
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySet
in interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element at given 1-based index.- Specified by:
arraySet
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySet
in interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element at given 1-based index.- Specified by:
arraySet
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySet
in interfaceNodeBuilder
-
arraySet
public <T> SqmExpression<T[]> arraySet(Expression<T[]> arrayExpression, Integer index, T element)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element at given 1-based index.- Specified by:
arraySet
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySet
in interfaceNodeBuilder
-
arrayRemove
public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element removed.- Specified by:
arrayRemove
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayRemove
in interfaceNodeBuilder
-
arrayRemove
public <T> SqmExpression<T[]> arrayRemove(Expression<T[]> arrayExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with given element removed.- Specified by:
arrayRemove
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayRemove
in interfaceNodeBuilder
-
arrayRemoveIndex
public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with the element at the given 1-based index removed.- Specified by:
arrayRemoveIndex
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayRemoveIndex
in interfaceNodeBuilder
-
arrayRemoveIndex
public <T> SqmExpression<T[]> arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy with the element at the given 1-based index removed.- Specified by:
arrayRemoveIndex
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayRemoveIndex
in interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlice
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySlice
in interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlice
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySlice
in interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlice
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySlice
in interfaceNodeBuilder
-
arraySlice
public <T> SqmExpression<T[]> arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-array of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
arraySlice
in interfaceHibernateCriteriaBuilder
- Specified by:
arraySlice
in interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy replacing a given element with another.- Specified by:
arrayReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayReplace
in interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy replacing a given element with another.- Specified by:
arrayReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayReplace
in interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy replacing a given element with another.- Specified by:
arrayReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayReplace
in interfaceNodeBuilder
-
arrayReplace
public <T> SqmExpression<T[]> arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy replacing a given element with another.- Specified by:
arrayReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayReplace
in interfaceNodeBuilder
-
arrayTrim
public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy without the last N elements, specified by the second argument.- Specified by:
arrayTrim
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayTrim
in interfaceNodeBuilder
-
arrayTrim
public <T> SqmExpression<T[]> arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilder
Creates array copy without the last N elements, specified by the second argument.- Specified by:
arrayTrim
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayTrim
in interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array with the same element N times, as specified by the arguments.- Specified by:
arrayFill
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayFill
in interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(Expression<T> elementExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilder
Creates array with the same element N times, as specified by the arguments.- Specified by:
arrayFill
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayFill
in interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(T element, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates array with the same element N times, as specified by the arguments.- Specified by:
arrayFill
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayFill
in interfaceNodeBuilder
-
arrayFill
public <T> SqmExpression<T[]> arrayFill(T element, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilder
Creates array with the same element N times, as specified by the arguments.- Specified by:
arrayFill
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayFill
in interfaceNodeBuilder
-
arrayToString
public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)
Description copied from interface:HibernateCriteriaBuilder
Concatenates the non-null array elements with a separator, as specified by the arguments.- Specified by:
arrayToString
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayToString
in interfaceNodeBuilder
-
arrayToString
public SqmExpression<String> arrayToString(Expression<? extends Object[]> arrayExpression, String separator)
Description copied from interface:HibernateCriteriaBuilder
Concatenates the non-null array elements with a separator, as specified by the arguments.- Specified by:
arrayToString
in interfaceHibernateCriteriaBuilder
- Specified by:
arrayToString
in interfaceNodeBuilder
-
collectionLiteral
public <E,C extends Collection<E>> SqmExpression<C> collectionLiteral(E... elements)
Description copied from interface:HibernateCriteriaBuilder
Creates a basic collection literal with thearray
constructor function.- Specified by:
collectionLiteral
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionLiteral
in interfaceNodeBuilder
-
collectionPosition
public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Determines the 1-based position of an element in a basic collection.- Specified by:
collectionPosition
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPosition
in interfaceNodeBuilder
-
collectionPosition
public <E> SqmExpression<Integer> collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines the 1-based position of an element in a basic collection.- Specified by:
collectionPosition
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPosition
in interfaceNodeBuilder
-
collectionPositions
public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositions
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPositions
in interfaceNodeBuilder
-
collectionPositions
public <T> SqmExpression<int[]> collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositions
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPositions
in interfaceNodeBuilder
-
collectionPositionsList
public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsList
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPositionsList
in interfaceNodeBuilder
-
collectionPositionsList
public <T> SqmExpression<List<Integer>> collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)
Description copied from interface:HibernateCriteriaBuilder
Determines all 1-based positions of an element in a basic collection.- Specified by:
collectionPositionsList
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPositionsList
in interfaceNodeBuilder
-
collectionLength
public SqmExpression<Integer> collectionLength(Expression<? extends Collection<?>> collectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Determines the length of a basic collection.- Specified by:
collectionLength
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionLength
in 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:HibernateCriteriaBuilder
Concatenates basic collections with each other in order.- Specified by:
collectionConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionConcat
in interfaceNodeBuilder
-
collectionConcat
public <E,C extends Collection<? super E>> SqmExpression<C> collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilder
Concatenates basic collections with each other in order.- Specified by:
collectionConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionConcat
in interfaceNodeBuilder
-
collectionConcat
public <E,C extends Collection<? super E>> SqmExpression<C> collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilder
Concatenates basic collections with each other in order.- Specified by:
collectionConcat
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionConcat
in interfaceNodeBuilder
-
collectionAppend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Appends element to basic collection.- Specified by:
collectionAppend
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionAppend
in interfaceNodeBuilder
-
collectionAppend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionAppend(Expression<C> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Appends element to basic collection.- Specified by:
collectionAppend
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionAppend
in interfaceNodeBuilder
-
collectionPrepend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Prepends element to basic collection.- Specified by:
collectionPrepend
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPrepend
in interfaceNodeBuilder
-
collectionPrepend
public <E,C extends Collection<? super E>> SqmExpression<C> collectionPrepend(E element, Expression<C> collectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Prepends element to basic collection.- Specified by:
collectionPrepend
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionPrepend
in interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains an element.- Specified by:
collectionContains
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContains
in interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains an element.- Specified by:
collectionContains
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContains
in interfaceNodeBuilder
-
collectionContains
public <E> SqmPredicate collectionContains(Collection<E> collection, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains an element.- Specified by:
collectionContains
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContains
in interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains a nullable element.- Specified by:
collectionContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContainsNullable
in interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains a nullable element.- Specified by:
collectionContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContainsNullable
in interfaceNodeBuilder
-
collectionContainsNullable
public <E> SqmPredicate collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection contains a nullable element.- Specified by:
collectionContainsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionContainsNullable
in interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludes
in interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludes
in interfaceNodeBuilder
-
collectionIncludes
public <E> SqmPredicate collectionIncludes(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection.- Specified by:
collectionIncludes
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludes
in interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludesNullable
in interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludesNullable
in interfaceNodeBuilder
-
collectionIncludesNullable
public <E> SqmPredicate collectionIncludesNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Description copied from interface:HibernateCriteriaBuilder
Whether a basic collection is a subset of another basic collection with nullable elements.- Specified by:
collectionIncludesNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIncludesNullable
in interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersects
in interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersects
in interfaceNodeBuilder
-
collectionIntersects
public <E> SqmPredicate collectionIntersects(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection.- Specified by:
collectionIntersects
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersects
in interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.- Specified by:
collectionIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersectsNullable
in interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.- Specified by:
collectionIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersectsNullable
in interfaceNodeBuilder
-
collectionIntersectsNullable
public <E> SqmPredicate collectionIntersectsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Description copied from interface:HibernateCriteriaBuilder
Whether one basic collection has any elements common with another basic collection, supportingnull
elements.- Specified by:
collectionIntersectsNullable
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionIntersectsNullable
in interfaceNodeBuilder
-
collectionGet
public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilder
Accesses the element of the basic collection by 1-based index.- Specified by:
collectionGet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionGet
in interfaceNodeBuilder
-
collectionGet
public <E> SqmExpression<E> collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilder
Accesses the element of the basic collection by 1-based index.- Specified by:
collectionGet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionGet
in 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:HibernateCriteriaBuilder
Creates basic collection copy with given element at given 1-based index.- Specified by:
collectionSet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSet
in interfaceNodeBuilder
-
collectionSet
public <E,C extends Collection<? super E>> SqmExpression<C> collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with given element at given 1-based index.- Specified by:
collectionSet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSet
in 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:HibernateCriteriaBuilder
Creates basic collection copy with given element at given 1-based index.- Specified by:
collectionSet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSet
in interfaceNodeBuilder
-
collectionSet
public <E,C extends Collection<? super E>> SqmExpression<C> collectionSet(Expression<C> collectionExpression, Integer index, E element)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with given element at given 1-based index.- Specified by:
collectionSet
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSet
in interfaceNodeBuilder
-
collectionRemove
public <E,C extends Collection<? super E>> SqmExpression<C> collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with given element removed.- Specified by:
collectionRemove
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionRemove
in interfaceNodeBuilder
-
collectionRemove
public <E,C extends Collection<? super E>> SqmExpression<C> collectionRemove(Expression<C> collectionExpression, E element)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with given element removed.- Specified by:
collectionRemove
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionRemove
in interfaceNodeBuilder
-
collectionRemoveIndex
public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with the element at the given 1-based index removed.- Specified by:
collectionRemoveIndex
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionRemoveIndex
in interfaceNodeBuilder
-
collectionRemoveIndex
public <C extends Collection<?>> SqmExpression<C> collectionRemoveIndex(Expression<C> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy with the element at the given 1-based index removed.- Specified by:
collectionRemoveIndex
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionRemoveIndex
in interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlice
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSlice
in interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlice
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSlice
in interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlice
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSlice
in interfaceNodeBuilder
-
collectionSlice
public <C extends Collection<?>> SqmExpression<C> collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)
Description copied from interface:HibernateCriteriaBuilder
Creates a sub-collection of the based on 1-based lower and upper index. Both indexes are inclusive.- Specified by:
collectionSlice
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionSlice
in 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:HibernateCriteriaBuilder
Creates basic collection copy replacing a given element with another.- Specified by:
collectionReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionReplace
in 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:HibernateCriteriaBuilder
Creates basic collection copy replacing a given element with another.- Specified by:
collectionReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionReplace
in 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:HibernateCriteriaBuilder
Creates basic collection copy replacing a given element with another.- Specified by:
collectionReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionReplace
in interfaceNodeBuilder
-
collectionReplace
public <E,C extends Collection<? super E>> SqmExpression<C> collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy replacing a given element with another.- Specified by:
collectionReplace
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionReplace
in interfaceNodeBuilder
-
collectionTrim
public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy without the last N elements, specified by the second argument.- Specified by:
collectionTrim
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionTrim
in interfaceNodeBuilder
-
collectionTrim
public <C extends Collection<?>> SqmExpression<C> collectionTrim(Expression<C> collectionExpression, Integer index)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection copy without the last N elements, specified by the second argument.- Specified by:
collectionTrim
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionTrim
in interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFill
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionFill
in interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(Expression<T> elementExpression, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFill
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionFill
in interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(T element, Expression<Integer> elementCountExpression)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFill
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionFill
in interfaceNodeBuilder
-
collectionFill
public <T> SqmExpression<Collection<T>> collectionFill(T element, Integer elementCount)
Description copied from interface:HibernateCriteriaBuilder
Creates basic collection with the same element N times, as specified by the arguments.- Specified by:
collectionFill
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionFill
in interfaceNodeBuilder
-
collectionToString
public <T> SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)
Description copied from interface:HibernateCriteriaBuilder
Concatenates the non-null basic collection elements with a separator, as specified by the arguments.- Specified by:
collectionToString
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionToString
in interfaceNodeBuilder
-
collectionToString
public <T> SqmExpression<String> collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)
Description copied from interface:HibernateCriteriaBuilder
Concatenates the non-null basic collection elements with a separator, as specified by the arguments.- Specified by:
collectionToString
in interfaceHibernateCriteriaBuilder
- Specified by:
collectionToString
in interfaceNodeBuilder
-
-