Top Fields Constructors Methods
org.hibernate.query.criteria.spi

public Class HibernateCriteriaBuilderDelegate

extends Object
implements HibernateCriteriaBuilder
Class Inheritance
All Implemented Interfaces
org.hibernate.query.criteria.HibernateCriteriaBuilder, jakarta.persistence.criteria.CriteriaBuilder
Known Direct Subclasses
org.hibernate.query.criteria.CriteriaDefinition
Imports
java.math.BigDecimal, .BigInteger, java.sql.Date, .Time, .Timestamp, java.time.Duration, .Instant, .LocalDate, .LocalDateTime, .LocalTime, java.time.temporal.Temporal, .TemporalAccessor, java.util.Collection, .List, .Map, .Set, jakarta.persistence.criteria.CriteriaBuilder, .CollectionJoin, .CriteriaQuery, .Expression, .Join, .ListJoin, .MapJoin, .Path, .Predicate, .Root, .Selection, .SetJoin, .Subquery, org.hibernate.Incubating, org.hibernate.query.SortDirection, .NullPrecedence, org.hibernate.query.criteria.HibernateCriteriaBuilder, .JpaCoalesce, .JpaCollectionJoin, .JpaCompoundSelection, .JpaCriteriaDelete, .JpaCriteriaInsertSelect, .JpaCriteriaInsertValues, .JpaCriteriaQuery, .JpaCriteriaUpdate, .JpaCteCriteriaAttribute, .JpaExpression, .JpaFunction, .JpaInPredicate, .JpaJoin, .JpaListJoin, .JpaMapJoin, .JpaOrder, .JpaParameterExpression, .JpaPath, .JpaPredicate, .JpaRoot, .JpaSearchOrder, .JpaSearchedCase, .JpaSelection, .JpaSetJoin, .JpaSimpleCase, .JpaSubQuery, .JpaWindow, .JpaWindowFrame, org.hibernate.query.sqm.TemporalUnit, org.hibernate.query.sqm.tree.expression.SqmExpression, jakarta.persistence.Tuple

Field Summary

Modifier and TypeField and Description
private final HibernateCriteriaBuilder

Constructor Summary

AccessConstructor and Description
public
public

Method Summary

Modifier and TypeMethod and Description
public <N extends Number> JpaExpression<N>
abs(Expression<N>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.abs.

Create an expression that returns the absolute value of its argument.
public JpaExpression<Double>
acos(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.acos.

Create an expression that returns the inverse cosine of its argument.
public <T extends Temporal> JpaExpression<T>
addDuration(Expression<T> datetime, Expression<Duration> duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.addDuration, org.hibernate.query.criteria.HibernateCriteriaBuilder.addDuration.

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.
public <T extends Temporal> JpaExpression<T>
addDuration(Expression<T> datetime, Duration duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.addDuration.

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.
public <T extends Temporal> JpaExpression<T>
addDuration(T datetime, Expression<Duration> duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.addDuration.

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.
public <Y> JpaExpression<Y>
all(Subquery<Y>
subquery
subquery
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.all.

Create an all expression over the subquery results.
public JpaPredicate
and(Expression<Boolean>
boolean expression
x
,
Expression<Boolean>
boolean expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.and.

Create a conjunction of the given boolean expressions.
public JpaPredicate
and(Predicate...
zero or more restriction predicates
restrictions
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.and.

Create a conjunction of the given restriction predicates.
public <Y> JpaExpression<Y>
any(Subquery<Y>
subquery
subquery
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.any.

Create an any expression over the subquery results.
public JpaCompoundSelection<Object[]>
array(Selection<?>...
selection items
selections
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.array.

Create an array-valued selection item.
public JpaCompoundSelection<Object[]>
public <Y> JpaCompoundSelection<Y>
public <Y> JpaCompoundSelection<Y>
array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.array.

public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
arrayAgg(JpaOrder
order by clause used in within group
order
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<? extends T>
values to aggregate
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayAgg.

Create a array_agg ordered set-aggregate function expression.
public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
arrayAppend(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayAppend.

Appends element to array.
public <T> JpaExpression<T[]>
arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayConcat.

Concatenates arrays with each other in order.
public <T> JpaExpression<T[]>
arrayConcat(Expression<T[]> arrayExpression1, T[] array2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayConcat.

Concatenates arrays with each other in order.
public <T> JpaExpression<T[]>
arrayConcat(T[] array1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayConcat.

Concatenates arrays with each other in order.
public <T> JpaPredicate
public <T> JpaPredicate
arrayContains(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContains.

Whether an array contains an element.
public <T> JpaPredicate
arrayContains(T[] array, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContains.

Whether an array contains an element.
public <T> JpaPredicate
arrayContainsAll(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAll.

Whether an array contains another array.
public <T> JpaPredicate
arrayContainsAll(Expression<T[]> arrayExpression, T[] subArray)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAll.

Whether an array contains another array.
public <T> JpaPredicate
arrayContainsAll(T[] array, Expression<T[]> subArrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAll.

Whether an array contains another array.
public <T> JpaPredicate
arrayContainsAllNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAllNullable.

Whether an array contains another array with nullable elements.
public <T> JpaPredicate
arrayContainsAllNullable(Expression<T[]> arrayExpression, T[] subArray)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAllNullable.

Whether an array contains another array with nullable elements.
public <T> JpaPredicate
arrayContainsAllNullable(T[] array, Expression<T[]> subArrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsAllNullable.

Whether an array contains another array with nullable elements.
public <T> JpaPredicate
public <T> JpaPredicate
arrayContainsNullable(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsNullable.

Whether an array contains a nullable element.
public <T> JpaPredicate
arrayContainsNullable(T[] array, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayContainsNullable.

Whether an array contains a nullable element.
public <T> JpaExpression<T[]>
arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill.

Creates array with the same element N times, as specified by the arguments.
public <T> JpaExpression<T[]>
arrayFill(Expression<T> elementExpression, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill.

Creates array with the same element N times, as specified by the arguments.
public <T> JpaExpression<T[]>
arrayFill(T element, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill.

Creates array with the same element N times, as specified by the arguments.
public <T> JpaExpression<T[]>
arrayFill(T element, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayFill.

Creates array with the same element N times, as specified by the arguments.
public <T> JpaExpression<T>
arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayGet.

Accesses the element of an array by 1-based index.
public <T> JpaExpression<T>
arrayGet(Expression<T[]> arrayExpression, Integer index)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayGet.

Accesses the element of an array by 1-based index.
public <T> JpaExpression<Integer>
arrayLength(Expression<T[]> arrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayLength.

Determines the length of an array.
public <T> JpaExpression<T[]>
arrayLiteral(T... elements)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayLiteral.

Creates an array literal with the array constructor function.
public <T> JpaPredicate
arrayOverlaps(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlaps.

Whether one array has any elements common with another array.
public <T> JpaPredicate
arrayOverlaps(Expression<T[]> arrayExpression1, T[] array2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlaps.

Whether one array has any elements common with another array.
public <T> JpaPredicate
arrayOverlaps(T[] array1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlaps.

Whether one array has any elements common with another array.
public <T> JpaPredicate
arrayOverlapsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlapsNullable.

Whether one array has any elements common with another array, supporting null elements.
public <T> JpaPredicate
arrayOverlapsNullable(Expression<T[]> arrayExpression1, T[] array2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlapsNullable.

Whether one array has any elements common with another array, supporting null elements.
public <T> JpaPredicate
arrayOverlapsNullable(T[] array1, Expression<T[]> arrayExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayOverlapsNullable.

Whether one array has any elements common with another array, supporting null elements.
public <T> JpaExpression<Integer>
arrayPosition(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPosition.

Determines the 1-based position of an element in an array.
public <T> JpaExpression<Integer>
arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPosition, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPosition.

Determines the 1-based position of an element in an array.
public <T> JpaExpression<int[]>
arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPositions, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPositions.

Determines all 1-based positions of an element in an array.
public <T> JpaExpression<int[]>
arrayPositions(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPositions.

Determines all 1-based positions of an element in an array.
public <T> JpaExpression<List<Integer>>
public <T> JpaExpression<List<Integer>>
arrayPositionsList(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPositionsList.

Determines all 1-based positions of an element in an array.
public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
arrayPrepend(T element, Expression<T[]> arrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayPrepend.

Prepends element to array.
public <T> JpaExpression<T[]>
arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayRemove, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayRemove.

Creates array copy with given element removed.
public <T> JpaExpression<T[]>
arrayRemove(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayRemove.

Creates array copy with given element removed.
public <T> JpaExpression<T[]>
arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayRemoveIndex.

Creates array copy with the element at the given 1-based index removed.
public <T> JpaExpression<T[]>
arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayRemoveIndex.

Creates array copy with the element at the given 1-based index removed.
public <T> JpaExpression<T[]>
public <T> JpaExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayReplace, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayReplace.

Creates array copy replacing a given element with another.
public <T> JpaExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayReplace, org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayReplace.

Creates array copy replacing a given element with another.
public <T> JpaExpression<T[]>
arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayReplace.

Creates array copy replacing a given element with another.
public <T> JpaExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet, org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet.

Creates array copy with given element at given 1-based index.
public <T> JpaExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet.

Creates array copy with given element at given 1-based index.
public <T> JpaExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet, org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet.

Creates array copy with given element at given 1-based index.
public <T> JpaExpression<T[]>
arraySet(Expression<T[]> arrayExpression, Integer index, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySet.

Creates array copy with given element at given 1-based index.
public <T> JpaExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySlice.

Creates a sub-array of the based on 1-based lower and upper index.
public <T> JpaExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySlice.

Creates a sub-array of the based on 1-based lower and upper index.
public <T> JpaExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySlice.

Creates a sub-array of the based on 1-based lower and upper index.
public <T> JpaExpression<T[]>
arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arraySlice.

Creates a sub-array of the based on 1-based lower and upper index.
public <T> JpaExpression<String>
arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayToString.

Concatenates the non-null array elements with a separator, as specified by the arguments.
public <T> JpaExpression<String>
arrayToString(Expression<? extends Object[]> arrayExpression, String separator)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayToString.

Concatenates the non-null array elements with a separator, as specified by the arguments.
public <T> JpaExpression<T[]>
arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayTrim.

Creates array copy without the last N elements, specified by the second argument.
public <T> JpaExpression<T[]>
arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.arrayTrim.

Creates array copy without the last N elements, specified by the second argument.
public JpaOrder
asc(Expression<?>
expression used to define the ordering
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.asc.

Create an ordering by the ascending value of the expression.
public JpaOrder
asc(Expression<?>
expression used to define the ordering
x
,
boolean
Whether null should be sorted first
nullsFirst
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.asc.

Create an ordering by the ascending value of the expression.
public JpaSearchOrder
asc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.asc.

Create a search ordering by the ascending value of the CTE attribute.
public JpaSearchOrder
asc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
x
,
boolean
Whether null should be sorted first
nullsFirst
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.asc.

Create a search ordering by the ascending value of the CTE attribute.
public JpaExpression<Double>
asin(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.asin.

Create an expression that returns the inverse sine of its argument.
public JpaExpression<Double>
atan(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.atan.

Create an expression that returns the inverse tangent of its argument.
public JpaExpression<Double>
public JpaExpression<Double>
public JpaExpression<Double>
atan2(Expression<? extends Number>
y coordinate
y
,
Expression<? extends Number>
x coordinate
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.atan2.

Create an expression that returns the inverse tangent of y over x.
public <N extends Number> JpaExpression<Double>
avg(Expression<N>
expression representing input value to avg operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.avg.

Create an aggregate expression applying the avg operation.
public <N extends Number> JpaExpression<Double>
public <N extends Number> JpaExpression<Double>
public <N extends Number> JpaExpression<Double>
avg(Expression<N>
argument to the function
argument
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.avg.

Create an avg aggregate function expression.
public <Y extends Comparable<? super Y>> JpaPredicate
between(Expression<? extends Y>
expression
value
,
Expression<? extends Y>
expression
lower
,
Expression<? extends Y>
expression
upper
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.between, org.hibernate.query.criteria.HibernateCriteriaBuilder.between.

Create a predicate for testing whether the first argument is between the second and third arguments in value.
public <Y extends Comparable<? super Y>> JpaPredicate
between(Expression<? extends Y>
expression
value
,
Y
value
lower
,
Y
value
upper
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.between.

Create a predicate for testing whether the first argument is between the second and third arguments in value.
public <X, T> JpaExpression<X>
public <N extends Number> JpaExpression<N>
ceiling(Expression<N>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.ceiling.

Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
public <T> JpaCoalesce<T>
public <Y> JpaCoalesce<Y>
coalesce(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.coalesce, org.hibernate.query.criteria.HibernateCriteriaBuilder.coalesce.

Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
public <Y> JpaCoalesce<Y>
coalesce(Expression<? extends Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.coalesce.

Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
public JpaFunction<String>
public <E, C extends Collection<? super E>> JpaExpression<C>
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionAppend(Expression<C> collectionExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionAppend.

Appends element to basic collection.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionConcat(Expression<C> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionConcat, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionConcat.

Concatenates basic collections with each other in order.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionConcat.

Concatenates basic collections with each other in order.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionConcat.

Concatenates basic collections with each other in order.
public <E> JpaPredicate
collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContains, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContains.

Whether a basic collection contains an element.
public <E> JpaPredicate
collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContains.

Whether a basic collection contains an element.
public <E> JpaPredicate
collectionContains(Collection<E> collection, Expression<E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContains.

Whether a basic collection contains an element.
public <E> JpaPredicate
collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAll.

Whether a basic collection contains another basic collection.
public <E> JpaPredicate
collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAll.

Whether a basic collection contains another basic collection.
public <E> JpaPredicate
collectionContainsAll(Collection<E> collection, Expression<? extends Collection<? extends E>> subArrayExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAll.

Whether a basic collection contains another basic collection.
public <E> JpaPredicate
collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAllNullable.

Whether a basic collection contains another basic collection with nullable elements.
public <E> JpaPredicate
collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAllNullable.

Whether a basic collection contains another basic collection with nullable elements.
public <E> JpaPredicate
collectionContainsAllNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsAllNullable.

Whether a basic collection contains another basic collection with nullable elements.
public <E> JpaPredicate
public <E> JpaPredicate
collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsNullable.

Whether a basic collection contains a nullable element.
public <E> JpaPredicate
collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionContainsNullable.

Whether a basic collection contains a nullable element.
public <T> JpaExpression<Collection<T>>
collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill.

Creates basic collection with the same element N times, as specified by the arguments.
public <T> JpaExpression<Collection<T>>
collectionFill(Expression<T> elementExpression, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill.

Creates basic collection with the same element N times, as specified by the arguments.
public <T> JpaExpression<Collection<T>>
collectionFill(T element, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill.

Creates basic collection with the same element N times, as specified by the arguments.
public <T> JpaExpression<Collection<T>>
collectionFill(T element, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionFill.

Creates basic collection with the same element N times, as specified by the arguments.
public <E> JpaExpression<E>
collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionGet.

Accesses the element of the basic collection by 1-based index.
public <E> JpaExpression<E>
collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionGet.

Accesses the element of the basic collection by 1-based index.
public JpaExpression<Integer>
collectionLength(Expression<? extends Collection<?>> collectionExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionLength.

Determines the length of a basic collection.
public <E, C extends Collection<E>> JpaExpression<C>
collectionLiteral(E... elements)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionLiteral.

Creates a basic collection literal with the array constructor function.
public <E> JpaPredicate
collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlaps.

Whether one basic collection has any elements common with another basic collection.
public <E> JpaPredicate
collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlaps.

Whether one basic collection has any elements common with another basic collection.
public <E> JpaPredicate
collectionOverlaps(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlaps.

Whether one basic collection has any elements common with another basic collection.
public <E> JpaPredicate
collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlapsNullable.

Whether one basic collection has any elements common with another basic collection, supporting null elements.
public <E> JpaPredicate
collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlapsNullable.

Whether one basic collection has any elements common with another basic collection, supporting null elements.
public <E> JpaPredicate
collectionOverlapsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionOverlapsNullable.

Whether one basic collection has any elements common with another basic collection, supporting null elements.
public <E> JpaExpression<Integer>
collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPosition.

Determines the 1-based position of an element in a basic collection.
public <E> JpaExpression<Integer>
collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPosition, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPosition.

Determines the 1-based position of an element in a basic collection.
public <T> JpaExpression<int[]>
collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositions, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositions.

Determines all 1-based positions of an element in a basic collection.
public <T> JpaExpression<int[]>
collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositions.

Determines all 1-based positions of an element in a basic collection.
public <T> JpaExpression<List<Integer>>
collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositionsList, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositionsList.

Determines all 1-based positions of an element in a basic collection.
public <T> JpaExpression<List<Integer>>
collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPositionsList.

Determines all 1-based positions of an element in a basic collection.
public <E, C extends Collection<? super E>> JpaExpression<C>
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionPrepend(E element, Expression<C> collectionExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionPrepend.

Prepends element to basic collection.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionRemove, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionRemove.

Creates basic collection copy with given element removed.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionRemove(Expression<C> collectionExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionRemove.

Creates basic collection copy with given element removed.
public <C extends Collection<?>> JpaExpression<C>
collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionRemoveIndex.

Creates basic collection copy with the element at the given 1-based index removed.
public <C extends Collection<?>> JpaExpression<C>
collectionRemoveIndex(Expression<C> collectionExpression, Integer index)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionRemoveIndex.

Creates basic collection copy with the element at the given 1-based index removed.
public <E, C extends Collection<? super E>> JpaExpression<C>
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, E newElement)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionReplace, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionReplace.

Creates basic collection copy replacing a given element with another.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionReplace(Expression<C> collectionExpression, E oldElement, Expression<? extends E> newElementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionReplace, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionReplace.

Creates basic collection copy replacing a given element with another.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionReplace.

Creates basic collection copy replacing a given element with another.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, Expression<? extends E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet.

Creates basic collection copy with given element at given 1-based index.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet.

Creates basic collection copy with given element at given 1-based index.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionSet(Expression<C> collectionExpression, Integer index, Expression<? extends E> elementExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet, org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet.

Creates basic collection copy with given element at given 1-based index.
public <E, C extends Collection<? super E>> JpaExpression<C>
collectionSet(Expression<C> collectionExpression, Integer index, E element)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSet.

Creates basic collection copy with given element at given 1-based index.
public <C extends Collection<?>> JpaExpression<C>
collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSlice.

Creates a sub-collection of the based on 1-based lower and upper index.
public <C extends Collection<?>> JpaExpression<C>
collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSlice.

Creates a sub-collection of the based on 1-based lower and upper index.
public <C extends Collection<?>> JpaExpression<C>
collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSlice.

Creates a sub-collection of the based on 1-based lower and upper index.
public <C extends Collection<?>> JpaExpression<C>
collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionSlice.

Creates a sub-collection of the based on 1-based lower and upper index.
public <T> JpaExpression<String>
collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionToString.

Concatenates the non-null basic collection elements with a separator, as specified by the arguments.
public <T> JpaExpression<String>
collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionToString.

Concatenates the non-null basic collection elements with a separator, as specified by the arguments.
public <C extends Collection<?>> JpaExpression<C>
collectionTrim(Expression<C> arrayExpression, Expression<Integer> elementCountExpression)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionTrim.

Creates basic collection copy without the last N elements, specified by the second argument.
public <C extends Collection<?>> JpaExpression<C>
collectionTrim(Expression<C> arrayExpression, Integer elementCount)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.collectionTrim.

Creates basic collection copy without the last N elements, specified by the second argument.
public JpaExpression<String>
concat(Expression<String>
string expression
x
,
Expression<String>
string expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.concat.

Create an expression for string concatenation.
public JpaExpression<String>
concat(Expression<String>
string expression
x
,
String
string
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.concat.

Create an expression for string concatenation.
public JpaExpression<String>
concat(String
string
x
,
Expression<String>
string expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.concat.

Create an expression for string concatenation.
public JpaExpression<String>
public JpaPredicate
conjunction()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.conjunction.

Create a conjunction (with zero conjuncts).
public <Y> JpaCompoundSelection<Y>
construct(Class<Y>
class whose instance is to be constructed
resultClass
,
Selection<?>...
arguments to the constructor
selections
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.construct.

Create a selection item corresponding to a constructor.
public <Y> JpaCompoundSelection<Y>
public JpaExpression<Double>
cos(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.cos.

Create an expression that returns the cosine of its argument.
public JpaExpression<Double>
cosh(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.cosh.

Create an expression that returns the hyperbolic cosine of its argument.
public JpaExpression<Long>
count(Expression<?>
expression representing input value to count operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.count.

Create an aggregate expression applying the count operation.
public JpaExpression<Long>
public JpaExpression<Long>
public JpaExpression<Long>
count(Expression<?>
argument to the function
argument
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.count.

Create a count aggregate function expression.
public JpaExpression<Long>
countDistinct(Expression<?>
expression representing input value to count distinct operation
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.countDistinct.

Create an aggregate expression applying the count distinct operation.
public <T> JpaCriteriaDelete<T>
createCriteriaDelete(Class<T>
target type for delete operation
targetEntity
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createCriteriaDelete.

Create a CriteriaDelete query object to perform a bulk delete operation.
public <T> JpaCriteriaInsertSelect<T>
public <T> JpaCriteriaInsertValues<T>
public <T> JpaCriteriaUpdate<T>
createCriteriaUpdate(Class<T>
target type for update operation
targetEntity
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createCriteriaUpdate.

Create a CriteriaUpdate query object to perform a bulk update operation.
public JpaCriteriaQuery<Object>
public <T> JpaCriteriaQuery<T>
createQuery(Class<T>
type of the query result
resultClass
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createQuery.

Create a CriteriaQuery object with the specified result type.
public <T> JpaCriteriaQuery<T>
createQuery(String
The HQL select query
hql
,
Class<T>
The result type of the query
resultClass
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createQuery.

Transform the given HQL select query to an equivalent criteria query.
public JpaCriteriaQuery<Tuple>
createTupleQuery()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createTupleQuery.

Create a CriteriaQuery object that returns a tuple of objects as its result.
public JpaWindow
createWindow()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.createWindow.

Create an empty JpaWindow to use with window and aggregate functions.
public JpaExpression<Double>
cumeDist(JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.cumeDist.

Create a cume_dist window function expression.
public JpaFunction<Date>
currentDate()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.currentDate.

Create expression to return current date.
public JpaFunction<Instant>
public JpaFunction<Time>
currentTime()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.currentTime.

Create expression to return current time.
public JpaFunction<Timestamp>
currentTimestamp()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.currentTimestamp.

Create expression to return current timestamp.
public JpaFunction<Integer>
day(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.day.

Extracts the org.hibernate.query.sqm.TemporalUnit#DAY of a date, time, or datetime expression.
public JpaExpression<Double>
degrees(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.degrees.

Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
public JpaExpression<Long>
denseRank(JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.denseRank.

Create a dense_rank window function expression.
public JpaOrder
desc(Expression<?>
expression used to define the ordering
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.desc.

Create an ordering by the descending value of the expression.
public JpaOrder
desc(Expression<?>
expression used to define the ordering
x
,
boolean
Whether null should be sorted first
nullsFirst
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.desc.

Create an ordering by the descending value of the expression.
public JpaSearchOrder
desc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.desc.

Create a search ordering by the descending value of the CTE attribute.
public JpaSearchOrder
desc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
x
,
boolean
Whether null should be sorted first
nullsFirst
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.desc.

Create a search ordering by the descending value of the CTE attribute.
public <N extends Number> JpaExpression<N>
diff(Expression<? extends N>
expression
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.diff, org.hibernate.query.criteria.HibernateCriteriaBuilder.diff, org.hibernate.query.criteria.HibernateCriteriaBuilder.diff.

Create an expression that returns the difference between its arguments.
public <N extends Number> JpaExpression<N>
diff(Expression<? extends N>
expression
x
,
N
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.diff.

Create an expression that returns the difference between its arguments.
public <N extends Number> JpaExpression<N>
diff(N
value
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.diff.

Create an expression that returns the difference between its arguments.
public JpaPredicate
disjunction()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.disjunction.

Create a disjunction (with zero disjuncts).
public JpaPredicate
public JpaPredicate
public JpaExpression<Duration>
duration(long magnitude, TemporalUnit unit)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.duration.

A literal Duration, for example, "five days" or "30 minutes".
public <T extends Temporal> JpaExpression<Duration>
durationBetween(Expression<T> x, Expression<T> y)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.durationBetween, org.hibernate.query.criteria.HibernateCriteriaBuilder.durationBetween.

Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.
public <T extends Temporal> JpaExpression<Duration>
durationBetween(Expression<T> x, T y)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.durationBetween.

Subtract two dates or two datetimes, returning the duration between the two dates or between two datetimes.
public JpaExpression<Long>
durationByUnit(TemporalUnit
a choice of temporal granularity
unit
,
Expression<Duration>
the duration in a "unit-free" form
duration
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.durationByUnit.

Convert a Duration to a numeric magnitude in the given units.
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaExpression<Duration>
public JpaPredicate
equal(Expression<?>
expression
x
,
Expression<?>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.equal.

Create a predicate for testing the arguments for equality.
public JpaPredicate
equal(Expression<?>
expression
x
,
Object
object
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.equal.

Create a predicate for testing the arguments for equality.
public <T> JpaCriteriaQuery<T>
public <T> JpaCriteriaQuery<T>
except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.except.

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

Overrides default org.hibernate.query.criteria.HibernateCriteriaBuilder.except.

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

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.except.

public <T> JpaCriteriaQuery<T>
public <T> JpaSubQuery<T>
public JpaPredicate
exists(Subquery<?>
subquery whose result is to be tested
subquery
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.exists.

Create a predicate testing the existence of a subquery result.
public JpaExpression<Double>
exp(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.exp.

Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
public <T> JpaExpression<T>
firstValue(Expression<T>
argument expression to pass to first_value
argument
,
JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.firstValue.

Create a first_value window function expression.
public <P, F> JpaExpression<F>
public <N extends Number> JpaExpression<N>
floor(Expression<N>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.floor.

Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
public JpaFunction<String>
format(Expression<? extends TemporalAccessor>
the datetime expression to format
datetime
,
String
the pattern to use for formatting
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.format.

Format a date, time, or datetime according to a pattern.
public JpaWindowFrame
public JpaWindowFrame
public JpaWindowFrame
public JpaWindowFrame
public JpaWindowFrame
public JpaWindowFrame
public JpaWindowFrame
public <T> JpaFunction<T>
function(String
function name
name
,
Class<T>
expected result type
type
,
Expression<?>...
function arguments
args
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.function.

Create an expression for the execution of a database function.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
functionAggregate(String
name of the ordered set-aggregate function
name
,
Class<T>
type of this expression
type
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<?>...
optional arguments to the function
args
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.functionAggregate.

Create a generic aggregate function expression.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
functionWithinGroup(String
name of the ordered set-aggregate function
name
,
Class<T>
type of this expression
type
,
JpaOrder
order by clause used in within group
order
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<?>...
optional arguments to the function
args
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.functionWithinGroup.

Create a generic ordered set-aggregate function expression.
public JpaPredicate
ge(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.ge.

Create a predicate for testing whether the first argument is greater than or equal to the second.
public JpaPredicate
ge(Expression<? extends Number>
expression
x
,
Number
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.ge.

Create a predicate for testing whether the first argument is greater than or equal to the second.
protected HibernateCriteriaBuilder
public <Y extends Comparable<? super Y>> JpaPredicate
greaterThan(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThan, org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThan.

Create a predicate for testing whether the first argument is greater than the second.
public <Y extends Comparable<? super Y>> JpaPredicate
greaterThan(Expression<? extends Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThan.

Create a predicate for testing whether the first argument is greater than the second.
public <Y extends Comparable<? super Y>> JpaPredicate
greaterThanOrEqualTo(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThanOrEqualTo, org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThanOrEqualTo.

Create a predicate for testing whether the first argument is greater than or equal to the second.
public <Y extends Comparable<? super Y>> JpaPredicate
greaterThanOrEqualTo(Expression<? extends Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.greaterThanOrEqualTo.

Create a predicate for testing whether the first argument is greater than or equal to the second.
public <X extends Comparable<? super X>> JpaExpression<X>
greatest(Expression<X>
expression representing input value to greatest operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.greatest.

Create an aggregate expression for finding the greatest of the values (strings, dates, etc).
public JpaPredicate
gt(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.gt.

Create a predicate for testing whether the first argument is greater than the second.
public JpaPredicate
gt(Expression<? extends Number>
expression
x
,
Number
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.gt.

Create a predicate for testing whether the first argument is greater than the second.
public JpaFunction<Integer>
hour(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.hour.

Extracts the org.hibernate.query.sqm.TemporalUnit#HOUR of a date, time, or datetime expression.
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public <T> JpaInPredicate<T>
in(Expression<? extends T>
to be tested against list of values
expression
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.in.

Create predicate to test whether given expression is contained in a list of values.
public final <T> JpaInPredicate<T>
public final <T> JpaInPredicate<T>
in(Expression<? extends T> expression, T... values)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.in.

public <T> JpaInPredicate<T>
public <K, L extends List<?>> JpaExpression<Set<K>>
public <T> JpaCriteriaQuery<T>
public <T> JpaCriteriaQuery<T>
public <T> JpaSubQuery<T>
public <T> JpaSubQuery<T>
intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.intersect.

public <T> JpaCriteriaQuery<T>
public <T> JpaSubQuery<T>
public <C extends Collection<?>> JpaPredicate
isEmpty(Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isEmpty.

Create a predicate that tests whether a collection is empty.
public JpaPredicate
isFalse(Expression<Boolean>
expression to be tested
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isFalse.

Create a predicate testing for a false value.
public <M extends Map<?, ?>> JpaPredicate
isMapEmpty(JpaExpression<M>
The expression resolving to a Map which we want to check for emptiness
mapExpression
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isMapEmpty.

Create a predicate that tests whether a Map is empty.
public <M extends Map<?, ?>> JpaPredicate
isMapNotEmpty(JpaExpression<M>
The expression resolving to a Map which we want to check for non-emptiness
mapExpression
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isMapNotEmpty.

Create a predicate that tests whether a Map is not empty.
public <E, C extends Collection<E>> JpaPredicate
isMember(Expression<E>
element expression
elem
,
Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isMember, org.hibernate.query.criteria.HibernateCriteriaBuilder.isMember.

Create a predicate that tests whether an element is a member of a collection.
public <E, C extends Collection<E>> JpaPredicate
isMember(E
element
elem
,
Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isMember.

Create a predicate that tests whether an element is a member of a collection.
public <C extends Collection<?>> JpaPredicate
isNotEmpty(Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isNotEmpty.

Create a predicate that tests whether a collection is not empty.
public <E, C extends Collection<E>> JpaPredicate
isNotMember(Expression<E>
element expression
elem
,
Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isNotMember, org.hibernate.query.criteria.HibernateCriteriaBuilder.isNotMember.

Create a predicate that tests whether an element is not a member of a collection.
public <E, C extends Collection<E>> JpaPredicate
isNotMember(E
element
elem
,
Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isNotMember.

Create a predicate that tests whether an element is not a member of a collection.
public JpaPredicate
isNotNull(Expression<?>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isNotNull.

Create a predicate to test whether the expression is not null.
public JpaPredicate
isNull(Expression<?>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isNull.

Create a predicate to test whether the expression is null.
public JpaPredicate
isTrue(Expression<Boolean>
expression to be tested
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.isTrue.

Create a predicate testing for a true value.
public <K, M extends Map<K, ?>> JpaExpression<Set<K>>
keys(M
map
map
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.keys.

Create an expression that returns the keys of a map.
public <T> JpaExpression<T>
lastValue(Expression<T>
argument expression to pass to last_value
argument
,
JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lastValue.

Create a last_value window function expression.
public JpaPredicate
le(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.le.

Create a predicate for testing whether the first argument is less than or equal to the second.
public JpaPredicate
le(Expression<? extends Number>
expression
x
,
Number
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.le.

Create a predicate for testing whether the first argument is less than or equal to the second.
public <X extends Comparable<? super X>> JpaExpression<X>
least(Expression<X>
expression representing input value to least operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.least.

Create an aggregate expression for finding the least of the values (strings, dates, etc).
public JpaFunction<String>
public JpaFunction<String>
left(Expression<String>
original string
x
,
Expression<Integer>
number of characters
length
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.left.

Extract the length leftmost characters of a string.
public JpaFunction<Integer>
length(Expression<String>
string expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.length.

Create expression to return length of a string.
public <Y extends Comparable<? super Y>> JpaPredicate
lessThan(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThan, org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThan.

Create a predicate for testing whether the first argument is less than the second.
public <Y extends Comparable<? super Y>> JpaPredicate
lessThan(Expression<? extends Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThan.

Create a predicate for testing whether the first argument is less than the second.
public <Y extends Comparable<? super Y>> JpaPredicate
lessThanOrEqualTo(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThanOrEqualTo, org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThanOrEqualTo.

Create a predicate for testing whether the first argument is less than or equal to the second.
public <Y extends Comparable<? super Y>> JpaPredicate
lessThanOrEqualTo(Expression<? extends Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lessThanOrEqualTo.

Create a predicate for testing whether the first argument is less than or equal to the second.
public JpaPredicate
like(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaPredicate
like(Expression<String>
string expression
x
,
String
string
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaPredicate
like(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
,
Expression<Character>
escape character expression
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaPredicate
like(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
,
char
escape character
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaPredicate
like(Expression<String>
string expression
x
,
String
string
pattern
,
Expression<Character>
escape character expression
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaPredicate
like(Expression<String>
string expression
x
,
String
string
pattern
,
char
escape character
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
public JpaExpression<String>
listagg(JpaOrder
order by clause used in within group
order
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<String>
values to join
argument
,
Expression<String>
the separator used to join the values
separator
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.listagg.

Create a listagg ordered set-aggregate function expression.
public <T> JpaExpression<T>
literal(T
value represented by the expression
value
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.literal.

Create an expression for a literal.
public final <T> List<? extends JpaExpression<T>>
public <T> List<? extends JpaExpression<T>>
public JpaExpression<Double>
ln(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.ln.

Create an expression that returns the natural logarithm of its argument.
public JpaExpression<LocalDate>
localDate()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.localDate.

Create expression to return current local date.
public JpaExpression<LocalDateTime>
localDateTime()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.localDateTime.

Create expression to return current local datetime.
public JpaExpression<LocalTime>
localTime()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.localTime.

Create expression to return current local time.
public JpaFunction<Integer>
locate(Expression<String>
expression for string to be searched
x
,
Expression<String>
expression for string to be located
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.locate.

Create expression to locate the position of one string within another, returning position of first character if found.
public JpaFunction<Integer>
locate(Expression<String>
expression for string to be searched
x
,
String
string to be located
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.locate.

Create expression to locate the position of one string within another, returning position of first character if found.
public JpaFunction<Integer>
locate(Expression<String>
expression for string to be searched
x
,
Expression<String>
expression for string to be located
pattern
,
Expression<Integer>
expression for position at which to start search
from
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.locate.

Create expression to locate the position of one string within another, returning position of first character if found.
public JpaFunction<Integer>
locate(Expression<String>
expression for string to be searched
x
,
String
string to be located
pattern
,
int
position at which to start search
from
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.locate.

Create expression to locate the position of one string within another, returning position of first character if found.
public JpaExpression<Double>
public JpaExpression<Double>
log(Expression<? extends Number>
base
b
,
Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.log.

Create an expression that returns the logarithm of x to the base b.
public JpaExpression<Double>
log10(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.log10.

Create an expression that returns the base-10 logarithm of its argument.
public JpaFunction<String>
lower(Expression<String>
string expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lower.

Create expression for converting a string to lowercase.
public JpaPredicate
lt(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lt.

Create a predicate for testing whether the first argument is less than the second.
public JpaPredicate
lt(Expression<? extends Number>
expression
x
,
Number
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.lt.

Create a predicate for testing whether the first argument is less than the second.
public <M extends Map<?, ?>> JpaExpression<Integer>
mapSize(JpaExpression<M>
The expression resolving to a Map for which we want to know the size
mapExpression
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mapSize, org.hibernate.query.criteria.HibernateCriteriaBuilder.mapSize.

Create an expression that tests the size of a map.
public <M extends Map<?, ?>> JpaExpression<Integer>
mapSize(M
The Map for which we want to know the size
map
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mapSize.

Create an expression that tests the size of a map.
public <N extends Number> JpaExpression<N>
max(Expression<N>
expression representing input value to max operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.max.

Create an aggregate expression applying the numerical max operation.
public <N extends Number> JpaExpression<N>
min(Expression<N>
expression representing input value to min operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.min.

Create an aggregate expression applying the numerical min operation.
public JpaFunction<Integer>
minute(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.minute.

Extracts the org.hibernate.query.sqm.TemporalUnit#MINUTE of a date, time, or datetime expression.
public JpaExpression<Integer>
mod(Expression<Integer>
expression
x
,
Expression<Integer>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mod.

Create an expression that returns the modulus (remainder under integer division) of its arguments.
public JpaExpression<Integer>
mod(Expression<Integer>
expression
x
,
Integer
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mod.

Create an expression that returns the modulus (remainder under integer division) of its arguments.
public JpaExpression<Integer>
mod(Integer
value
x
,
Expression<Integer>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mod.

Create an expression that returns the modulus (remainder under integer division) of its arguments.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
mode(JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<T>
the sort expression
sortExpression
,
SortDirection
the sort order
sortOrder
,
NullPrecedence
the null precedence
nullPrecedence
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.mode.

Create a mode ordered set-aggregate function expression.
public JpaFunction<Integer>
month(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.month.

Extracts the org.hibernate.query.sqm.TemporalUnit#MONTH of a date, time, or datetime expression.
public <N extends Number> JpaExpression<N>
neg(Expression<N>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.neg.

Create an expression that returns the arithmetic negation of its argument.
public JpaPredicate
not(Expression<Boolean>
restriction expression
restriction
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.not.

Create a negation of the given restriction.
public JpaPredicate
public JpaPredicate
public JpaPredicate
notEqual(Expression<?>
expression
x
,
Expression<?>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notEqual.

Create a predicate for testing the arguments for inequality.
public JpaPredicate
notEqual(Expression<?>
expression
x
,
Object
object
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notEqual.

Create a predicate for testing the arguments for inequality.
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
public JpaPredicate
notLike(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public JpaPredicate
notLike(Expression<String>
string expression
x
,
String
string
pattern
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public JpaPredicate
notLike(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
,
Expression<Character>
escape character expression
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public JpaPredicate
notLike(Expression<String>
string expression
x
,
Expression<String>
string expression
pattern
,
char
escape character
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public JpaPredicate
notLike(Expression<String>
string expression
x
,
String
string
pattern
,
Expression<Character>
escape character expression
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public JpaPredicate
notLike(Expression<String>
string expression
x
,
String
string
pattern
,
char
escape character
escapeChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
nthValue(Expression<T>
argument expression to pass to nth_value
argument
,
Expression<Integer>
the N argument for the function
n
,
JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.nthValue.

Create a nth_value window function expression.
public <Y> JpaExpression<Y>
nullif(Expression<Y>
expression
x
,
Expression<?>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.nullif, org.hibernate.query.criteria.HibernateCriteriaBuilder.nullif.

Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
public <Y> JpaExpression<Y>
nullif(Expression<Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.nullif.

Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
public <T> JpaExpression<T>
nullLiteral(Class<T>
type of the null literal
resultClass
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.nullLiteral.

Create an expression for a null literal with the given type.
public JpaPredicate
or(Expression<Boolean>
boolean expression
x
,
Expression<Boolean>
boolean expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.or.

Create a disjunction of the given boolean expressions.
public JpaPredicate
or(Predicate...
zero or more restriction predicates
restrictions
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.or.

Create a disjunction of the given restriction predicates.
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
overlay(Expression<String> string, String replacement, int start, int length)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.overlay.

public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
overlay(Expression<String>
string expression to be manipulated
string
,
Expression<String>
string expression to replace in original
replacement
,
Expression<Integer>
start position
start
,
Expression<Integer>
optional, number of characters to substitute
length
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.overlay.

Overlay the string expression with the replacement expression, starting from index start and substituting a number of characters corresponding to the length of the replacement expression or the length parameter if specified.
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
pad(CriteriaBuilder.Trimspec ts, Expression<String>
string expression to pad
x
,
Expression<Integer>
length of the result string after padding
length
,
Expression<Character>
optional pad character
padChar
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.pad.

Pad the specified string expression with whitespace or with the padChar character if specified.
public <T> JpaParameterExpression<T>
parameter(Class<T>
parameter class
paramClass
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.parameter.

Create a parameter expression.
public <T> JpaParameterExpression<T>
parameter(Class<T>
parameter class
paramClass
,
String
name that can be used to refer to the parameter
name
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.parameter.

Create a parameter expression with the given name.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
percentileCont(Expression<? extends Number>
argument to the function
argument
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<T>
the sort expression
sortExpression
,
SortDirection
the sort order
sortOrder
,
NullPrecedence
the null precedence
nullPrecedence
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.percentileCont.

Create a percentile_cont ordered set-aggregate function expression.
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
public <T> JpaExpression<T>
percentileDisc(Expression<? extends Number>
argument to the function
argument
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<T>
the sort expression
sortExpression
,
SortDirection
the sort order
sortOrder
,
NullPrecedence
the null precedence
nullPrecedence
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.percentileDisc.

Create a percentile_disc ordered set-aggregate function expression.
public JpaExpression<Double>
percentRank(JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.percentRank.

Create a percent_rank window function expression.
public JpaExpression<Double>
public JpaExpression<Double>
public JpaExpression<Double>
public JpaExpression<Double>
percentRank(JpaOrder
order by clause used in within group
order
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<?>...
arguments to the function
arguments
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.percentRank.

Create a percent_rank ordered set-aggregate function expression.
public JpaExpression<Double>
pi()

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.pi.

Literal expression corresponding to the value of pi.
public JpaExpression<Double>
power(Expression<? extends Number>
base
x
,
Expression<? extends Number>
exponent
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.power.

Create an expression that returns the first argument raised to the power of its second argument.
public JpaExpression<Double>
power(Expression<? extends Number>
base
x
,
Number
exponent
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.power.

Create an expression that returns the first argument raised to the power of its second argument.
public <N extends Number> JpaExpression<N>
prod(Expression<? extends N>
expression
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.prod, org.hibernate.query.criteria.HibernateCriteriaBuilder.prod, org.hibernate.query.criteria.HibernateCriteriaBuilder.prod.

Create an expression that returns the product of its arguments.
public <N extends Number> JpaExpression<N>
prod(Expression<? extends N>
expression
x
,
N
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.prod.

Create an expression that returns the product of its arguments.
public <N extends Number> JpaExpression<N>
prod(N
value
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.prod.

Create an expression that returns the product of its arguments.
public JpaExpression<Number>
quot(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.quot.

Create an expression that returns the quotient of its arguments.
public JpaExpression<Number>
quot(Expression<? extends Number>
expression
x
,
Number
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.quot.

Create an expression that returns the quotient of its arguments.
public JpaExpression<Number>
quot(Number
value
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.quot.

Create an expression that returns the quotient of its arguments.
public JpaExpression<Double>
radians(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.radians.

Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
public JpaExpression<Long>
rank(JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.rank.

Create a rank window function expression.
public JpaExpression<Long>
public JpaExpression<Long>
public JpaExpression<Long>
public JpaExpression<Long>
rank(JpaOrder
order by clause used in within group
order
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
,
Expression<?>...
arguments to the function
arguments
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.rank.

Create a rank ordered set-aggregate function expression.
public JpaFunction<String>
repeat(Expression<String>
the string expression to concatenate
x
,
Expression<Integer>
the number of times it should be repeated
times
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.repeat.

Concatenate the given string expression with itself the given number of times.
public JpaFunction<String>
repeat(Expression<String>
the string expression to concatenate
x
,
int
the number of times it should be repeated
times
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.repeat.

Concatenate the given string expression with itself the given number of times.
public JpaFunction<String>
repeat(String
the string expression to concatenate
x
,
Expression<Integer>
the number of times it should be repeated
times
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.repeat.

Concatenate the given string expression with itself the given number of times.
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
public JpaFunction<String>
replace(Expression<String>
original string
x
,
Expression<String>
the string to be replaced
pattern
,
Expression<String>
the new replacement string
replacement
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.replace.

Replace all occurrences of pattern within the original string with replacement.
public JpaFunction<String>
public JpaFunction<String>
right(Expression<String>
original string
x
,
Expression<Integer>
number of characters
length
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.right.

Extract the length rightmost characters of a string.
public <T extends Number> JpaExpression<T>
round(Expression<T>
base
x
,
Integer
number of decimal places
n
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.round.

Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
public JpaExpression<Long>
rowNumber(JpaWindow
window over which the function will be applied
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.rowNumber.

Create a row_number window function expression.
public JpaSearchOrder
search(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
cteAttribute
,
SortDirection
The sort order
sortOrder
,
NullPrecedence
The null precedence
nullPrecedence
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.search.

Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
public JpaSearchOrder
search(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
cteAttribute
,
SortDirection
The sort order
sortOrder
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.search.

Create a search ordering based on the sort order of the value of the CTE attribute.
public JpaSearchOrder
search(JpaCteCriteriaAttribute
CTE attribute used to define the ordering
cteAttribute
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.search.

Create a search ordering based on the ascending value of the CTE attribute.
public JpaFunction<Float>
second(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.second.

Extracts the org.hibernate.query.sqm.TemporalUnit#SECOND of a date, time, or datetime expression.
public <C, R> JpaSimpleCase<C, R>
selectCase(Expression<? extends C>
to be tested against the case conditions
expression
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.selectCase.

Create a simple case expression.
public <R> JpaSearchedCase<R>
public JpaExpression<Integer>
sign(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sign.

Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
public JpaExpression<Double>
sin(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sin.

Create an expression that returns the sine of its argument.
public JpaExpression<Double>
sinh(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sinh.

Create an expression that returns the hyperbolic sine of its argument.
public <C extends Collection<?>> JpaExpression<Integer>
size(Expression<C>
expression
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.size, org.hibernate.query.criteria.HibernateCriteriaBuilder.size.

Create an expression that tests the size of a collection.
public <C extends Collection<?>> JpaExpression<Integer>
size(C
collection
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.size.

Create an expression that tests the size of a collection.
public <Y> JpaExpression<Y>
some(Subquery<Y>
subquery
subquery
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.some.

Create a some expression over the subquery results.
public JpaOrder
public JpaOrder
public JpaOrder
public <T> JpaExpression<T>
sql(String
native SQL pattern
pattern
,
Class<T>
type of this expression
type
,
Expression<?>...
optional arguments to the SQL pattern
arguments
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sql.

Embed native pattern that will be unquoted and embedded in the generated SQL.
public JpaExpression<Double>
sqrt(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sqrt.

Create an expression that returns the square root of its argument.
public JpaFunction<String>
substring(Expression<String>
string expression
x
,
Expression<Integer>
start position expression
from
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.substring.

Create an expression for substring extraction.
public JpaFunction<String>
substring(Expression<String>
string expression
x
,
int
start position
from
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.substring.

Create an expression for substring extraction.
public JpaFunction<String>
substring(Expression<String>
string expression
x
,
Expression<Integer>
start position expression
from
,
Expression<Integer>
length expression
len
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.substring.

Create an expression for substring extraction.
public JpaFunction<String>
substring(Expression<String>
string expression
x
,
int
start position
from
,
int
length
len
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.substring.

Create an expression for substring extraction.
public <T extends Temporal> JpaExpression<T>
subtractDuration(Expression<T> datetime, Expression<Duration> duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.subtractDuration, org.hibernate.query.criteria.HibernateCriteriaBuilder.subtractDuration.

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.
public <T extends Temporal> JpaExpression<T>
subtractDuration(Expression<T> datetime, Duration duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.subtractDuration.

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.
public <T extends Temporal> JpaExpression<T>
subtractDuration(T datetime, Expression<Duration> duration)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.subtractDuration.

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.
public <N extends Number> JpaExpression<N>
sum(Expression<N>
expression representing input value to sum operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an aggregate expression applying the sum operation.
public <N extends Number> JpaExpression<N>
sum(Expression<? extends N>
expression
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum, org.hibernate.query.criteria.HibernateCriteriaBuilder.sum, org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> JpaExpression<N>
sum(Expression<? extends N>
expression
x
,
N
value
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> JpaExpression<N>
sum(N
value
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> JpaExpression<Number>
sum(Expression<N>
expression
argument
,
JpaPredicate
value
filter
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum, org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> JpaExpression<Number>
sum(Expression<N>
expression
argument
,
JpaWindow
value
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum, org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> JpaExpression<Number>
sum(Expression<N>
argument to the function
argument
,
JpaPredicate
optional filter clause
filter
,
JpaWindow
optional window over which to apply the function
window
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sum.

Create a sum aggregate function expression.
public JpaExpression<Double>
sumAsDouble(Expression<Float>
expression representing input value to sum operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sumAsDouble.

Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.
public JpaExpression<Long>
sumAsLong(Expression<Integer>
expression representing input value to sum operation
argument
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.sumAsLong.

Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.
public JpaExpression<Double>
tan(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.tan.

Create an expression that returns the tangent of its argument.
public JpaExpression<Double>
tanh(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.tanh.

Create an expression that returns the hyperbolic tangent of its argument.
public JpaExpression<BigDecimal>
public JpaExpression<BigInteger>
public JpaExpression<Double>
toDouble(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.toDouble.

Typecast.
public JpaExpression<Float>
toFloat(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.toFloat.

Typecast.
public JpaExpression<Integer>
toInteger(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.toInteger.

Typecast.
public JpaExpression<Long>
toLong(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.toLong.

Typecast.
public JpaExpression<String>
public <X, T extends X> JpaPath<T>
treat(Path<X>
path
path
,
Class<T>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast Path object to the specified type.
public <X, T extends X> JpaRoot<T>
treat(Root<X>
root
root
,
Class<T>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast Root object to the specified type.
public <X, T, V extends T> JpaJoin<X, V>
treat(Join<X, T>
Join object
join
,
Class<V>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast Join object to the specified type.
public <X, T, E extends T> JpaCollectionJoin<X, E>
treat(CollectionJoin<X, T>
CollectionJoin object
join
,
Class<E>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast CollectionJoin object to the specified type.
public <X, T, E extends T> JpaSetJoin<X, E>
treat(SetJoin<X, T>
SetJoin object
join
,
Class<E>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast SetJoin object to the specified type.
public <X, T, E extends T> JpaListJoin<X, E>
treat(ListJoin<X, T>
ListJoin object
join
,
Class<E>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast ListJoin object to the specified type.
public <X, K, T, V extends T> JpaMapJoin<X, K, V>
treat(MapJoin<X, K, T>
MapJoin object
join
,
Class<V>
type to be downcast to
type
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.treat.

Downcast MapJoin object to the specified type.
public JpaFunction<String>
trim(Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim blanks from both ends of a string.
public JpaFunction<String>
trim(CriteriaBuilder.Trimspec
trim specification
ts
,
Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim blanks from a string.
public JpaFunction<String>
trim(Expression<Character>
expression for character to be trimmed
t
,
Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim character from both ends of a string.
public JpaFunction<String>
trim(CriteriaBuilder.Trimspec
trim specification
ts
,
Expression<Character>
expression for character to be trimmed
t
,
Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim character from a string.
public JpaFunction<String>
trim(char
character to be trimmed
t
,
Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim character from both ends of a string.
public JpaFunction<String>
trim(CriteriaBuilder.Trimspec
trim specification
ts
,
char
character to be trimmed
t
,
Expression<String>
expression for string to trim
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.trim.

Create expression to trim character from a string.
public <T extends Number> JpaExpression<T>
truncate(Expression<T>
base
x
,
Integer
number of decimal places
n
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.truncate.

Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
public <T extends TemporalAccessor> JpaFunction<T>
truncate(Expression<T>
the date, time or datetime expression to be truncated
datetime
,
TemporalUnit
the temporal unit for truncation
temporalUnit
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.truncate.

Truncates a date, time or datetime expression to the given TemporalUnit.
public JpaCompoundSelection<Tuple>
tuple(Selection<?>...
selection items
selections
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.tuple.

Create a tuple-valued selection item.
public JpaCompoundSelection<Tuple>
public <T> JpaCriteriaQuery<T>
public <T> JpaCriteriaQuery<T>
union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.union.

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

Overrides default org.hibernate.query.criteria.HibernateCriteriaBuilder.union.

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

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.union.

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

Overrides default org.hibernate.query.criteria.HibernateCriteriaBuilder.unionAll.

public <T extends HibernateCriteriaBuilder> T
public JpaFunction<String>
upper(Expression<String>
string expression
x
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.upper.

Create expression for converting a string to uppercase.
public <T> JpaExpression<T>
public <V, C extends Collection<V>> JpaExpression<Collection<V>>
values(C
map
collection
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.values, org.hibernate.query.criteria.HibernateCriteriaBuilder.values.

Create an expression that returns the values of a map.
public <V, M extends Map<?, V>> Expression<Collection<V>>
public <T> JpaExpression<T>
windowFunction(String
name of the window function
name
,
Class<T>
type of this expression
type
,
JpaWindow
window over which the function will be applied
window
,
Expression<?>...
arguments to the function
args
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.windowFunction.

Create a generic window function expression that will be applied over the specified window.
public JpaPredicate
public final JpaPredicate
public JpaFunction<Integer>
year(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from
datetime
)

Implements org.hibernate.query.criteria.HibernateCriteriaBuilder.year.

Extracts the org.hibernate.query.sqm.TemporalUnit#YEAR of a date, time, or datetime expression.
Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait