Top Description Inners Fields Constructors Methods
org.hibernate.query.sqm.internal

public Class SqmCriteriaNodeBuilder

extends Object
implements NodeBuilder, SqmCreationContext, Serializable
Class Inheritance
All Implemented Interfaces
java.io.Serializable, org.hibernate.query.sqm.spi.SqmCreationContext, org.hibernate.query.sqm.NodeBuilder, org.hibernate.query.criteria.HibernateCriteriaBuilder, jakarta.persistence.criteria.CriteriaBuilder
Imports
java.io.InvalidObjectException, .Serializable, java.math.BigDecimal, .BigInteger, java.sql.Date, .Time, .Timestamp, java.time.Duration, .Instant, .LocalDate, .LocalDateTime, .LocalTime, java.time.temporal.Temporal, .TemporalAccessor, java.util.ArrayList, .Arrays, .Collection, .Collections, .HashMap, .HashSet, .LinkedHashMap, .List, .Map, .ServiceLoader, .Set, java.util.function.Supplier, org.hibernate.SessionFactory, org.hibernate.dialect.function.array.DdlTypeHelper, org.hibernate.engine.spi.SessionFactoryImplementor, org.hibernate.internal.CoreLogging, .CoreMessageLogger, .SessionFactoryRegistry, org.hibernate.internal.util.StringHelper, org.hibernate.internal.util.collections.CollectionHelper, org.hibernate.metamodel.model.domain.BasicDomainType, .DomainType, .JpaMetamodel, .SimpleDomainType, .SingularPersistentAttribute, org.hibernate.metamodel.model.domain.internal.BasicTypeImpl, org.hibernate.metamodel.model.domain.spi.JpaMetamodelImplementor, org.hibernate.metamodel.spi.MappingMetamodelImplementor, org.hibernate.query.BindableType, .NullPrecedence, .ReturnableType, .SemanticException, .SortDirection, org.hibernate.query.criteria.HibernateCriteriaBuilder, .JpaCoalesce, .JpaCompoundSelection, .JpaCriteriaQuery, .JpaCteCriteriaAttribute, .JpaExpression, .JpaFunction, .JpaOrder, .JpaPredicate, .JpaSearchOrder, .JpaSelection, .JpaSubQuery, .JpaWindow, .ValueHandlingMode, org.hibernate.query.criteria.spi.CriteriaBuilderExtension, org.hibernate.query.spi.QueryEngine, org.hibernate.query.sqm.BinaryArithmeticOperator, .ComparisonOperator, .FrameKind, .NodeBuilder, .SetOperator, .SqmExpressible, .SqmPathSource, .SqmQuerySource, .TemporalUnit, .TrimSpec, .UnaryArithmeticOperator, org.hibernate.query.sqm.function.NamedSqmFunctionDescriptor, .SqmFunctionDescriptor, org.hibernate.query.sqm.produce.function.FunctionArgumentException, .StandardFunctionReturnTypeResolvers, org.hibernate.query.sqm.spi.SqmCreationContext, org.hibernate.query.sqm.tree.SqmQuery, .SqmStatement, .SqmTypedNode, org.hibernate.query.sqm.tree.cte.SqmCteStatement, .SqmCteTableColumn, .SqmSearchClauseSpecification, org.hibernate.query.sqm.tree.delete.SqmDeleteStatement, org.hibernate.query.sqm.tree.domain.SqmBagJoin, .SqmEntityValuedSimplePath, .SqmFkExpression, .SqmListJoin, .SqmMapJoin, .SqmPath, .SqmPluralValuedSimplePath, .SqmSetJoin, .SqmSingularJoin, org.hibernate.query.sqm.tree.expression.JpaCriteriaParameter, .SqmBinaryArithmetic, .SqmByUnit, .SqmCaseSearched, .SqmCaseSimple, .SqmCastTarget, .SqmCoalesce, .SqmCollation, .SqmCollectionSize, .SqmDistinct, .SqmDurationUnit, .SqmExpression, .SqmExtractUnit, .SqmFormat, .SqmFunction, .SqmLiteral, .SqmLiteralNull, .SqmModifiedSubQueryExpression, .SqmOver, .SqmToDuration, .SqmTrimSpecification, .SqmTuple, .SqmUnaryOperation, .SqmWindow, .SqmWindowFrame, .ValueBindJpaCriteriaParameter, org.hibernate.query.sqm.tree.from.SqmRoot, org.hibernate.query.sqm.tree.insert.SqmInsertSelectStatement, .SqmInsertValuesStatement, org.hibernate.query.sqm.tree.predicate.SqmBetweenPredicate, .SqmBooleanExpressionPredicate, .SqmComparisonPredicate, .SqmEmptinessPredicate, .SqmExistsPredicate, .SqmInListPredicate, .SqmInPredicate, .SqmInSubQueryPredicate, .SqmJunctionPredicate, .SqmLikePredicate, .SqmMemberOfPredicate, .SqmNullnessPredicate, .SqmPredicate, org.hibernate.query.sqm.tree.select.SqmDynamicInstantiation, .SqmDynamicInstantiationArgument, .SqmJpaCompoundSelection, .SqmOrderByClause, .SqmQueryGroup, .SqmQueryPart, .SqmSelectQuery, .SqmSelectStatement, .SqmSelectableNode, .SqmSortSpecification, .SqmSubQuery, org.hibernate.query.sqm.tree.update.SqmUpdateStatement, org.hibernate.type.BasicType, .StandardBasicTypes, org.hibernate.type.descriptor.java.EnumJavaType, .JavaType, org.hibernate.type.descriptor.jdbc.JdbcType, org.hibernate.type.spi.TypeConfiguration, jakarta.persistence.Tuple, jakarta.persistence.criteria.CollectionJoin, .CriteriaQuery, .Expression, .Join, .ListJoin, .MapJoin, .Path, .Predicate, .Root, .Selection, .SetJoin, .Subquery, jakarta.persistence.metamodel.Bindable

Acts as a JPA jakarta.persistence.criteria.CriteriaBuilder by using SQM nodes as the JPA Criteria nodes
Author
Steve Ebersole

Nested and Inner Type Summary

Modifier and TypeClass and Description
pack-priv class

Field Summary

Modifier and TypeField and Description
private transient BasicType<Boolean>
private transient BasicType<Character>
private final transient ValueHandlingMode
private final transient Map<Class<? extends HibernateCriteriaBuilder>, HibernateCriteriaBuilder>
private transient BasicType<Integer>
private final transient boolean
private static final CoreMessageLogger
private transient BasicType<Long>
private final String
private final transient QueryEngine
private final transient Supplier<SessionFactoryImplementor>
private final String

Constructor Summary

AccessConstructor and Description
public
SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, boolean jpaComplianceEnabled, ValueHandlingMode criteriaValueHandlingMode, Supplier<SessionFactoryImplementor> sessionFactory)

Method Summary

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

Implements org.hibernate.query.sqm.NodeBuilder.abs.

Create an expression that returns the absolute value of its argument.
public SqmFunction<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> SqmModifiedSubQueryExpression<Y>
all(Subquery<Y>
subquery
subquery
)

Implements org.hibernate.query.sqm.NodeBuilder.all.

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

Implements org.hibernate.query.sqm.NodeBuilder.and.

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

Implements org.hibernate.query.sqm.NodeBuilder.and.

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

Implements org.hibernate.query.sqm.NodeBuilder.any.

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

Implements org.hibernate.query.sqm.NodeBuilder.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> SqmExpression<T[]>
public <T> SqmExpression<T[]>
public <T> SqmExpression<T[]>
arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)

Implements org.hibernate.query.sqm.NodeBuilder.arrayAgg.

public <T> SqmExpression<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.sqm.NodeBuilder.arrayAgg.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayAppend, org.hibernate.query.sqm.NodeBuilder.arrayAppend.

Appends element to array.
public <T> SqmExpression<T[]>
arrayAppend(Expression<T[]> arrayExpression, T element)

Implements org.hibernate.query.sqm.NodeBuilder.arrayAppend.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContains, org.hibernate.query.sqm.NodeBuilder.arrayContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsNullable, org.hibernate.query.sqm.NodeBuilder.arrayContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayFill, org.hibernate.query.sqm.NodeBuilder.arrayFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayFill, org.hibernate.query.sqm.NodeBuilder.arrayFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayGet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayGet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayLength.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayLiteral.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPosition.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPosition, org.hibernate.query.sqm.NodeBuilder.arrayPosition.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPositions, org.hibernate.query.sqm.NodeBuilder.arrayPositions.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPositions.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPositionsList, org.hibernate.query.sqm.NodeBuilder.arrayPositionsList.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPositionsList.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayPrepend, org.hibernate.query.sqm.NodeBuilder.arrayPrepend.

Prepends element to array.
public <T> SqmExpression<T[]>
arrayPrepend(T element, Expression<T[]> arrayExpression)

Implements org.hibernate.query.sqm.NodeBuilder.arrayPrepend.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayRemove, org.hibernate.query.sqm.NodeBuilder.arrayRemove.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayRemove.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayRemoveIndex.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayRemoveIndex.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayReplace, org.hibernate.query.sqm.NodeBuilder.arrayReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayReplace, org.hibernate.query.sqm.NodeBuilder.arrayReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySet, org.hibernate.query.sqm.NodeBuilder.arraySet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySet, org.hibernate.query.sqm.NodeBuilder.arraySet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySet.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.arraySlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayToString.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayToString.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayTrim.

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

Implements org.hibernate.query.sqm.NodeBuilder.arrayTrim.

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

Implements org.hibernate.query.sqm.NodeBuilder.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 SqmFunction<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 SqmFunction<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 SqmFunction<Double>
public SqmFunction<Double>
public SqmFunction<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> SqmExpression<Double>
avg(Expression<N>
expression representing input value to avg operation
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.avg.

Create an aggregate expression applying the avg operation.
public <N extends Number> SqmExpression<Double>
public <N extends Number> SqmExpression<Double>
public <N extends Number> SqmExpression<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>> SqmPredicate
between(Expression<? extends Y>
expression
value
,
Expression<? extends Y>
expression
lower
,
Expression<? extends Y>
expression
upper
)

Implements org.hibernate.query.sqm.NodeBuilder.between, org.hibernate.query.sqm.NodeBuilder.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>> SqmPredicate
between(Expression<? extends Y>
expression
value
,
Y
value
lower
,
Y
value
upper
)

Implements org.hibernate.query.sqm.NodeBuilder.between.

Create a predicate for testing whether the first argument is between the second and third arguments in value.
public <X, T> SqmExpression<X>
cast(JpaExpression<T> expression, Class<X> castTargetJavaType)

Implements org.hibernate.query.sqm.NodeBuilder.cast.

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.
pack-priv void
checkMultiselect(List<? extends JpaSelection<?>>
The selection varargs to check
selections
)

Package-protected method to centralize checking of criteria query multi-selects as defined by the CriteriaQuery#multiselect(List) method.

public <T> SqmCoalesce<T>
coalesce()

Implements org.hibernate.query.sqm.NodeBuilder.coalesce.

Create a coalesce expression.
public <Y> JpaCoalesce<Y>
coalesce(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.coalesce, org.hibernate.query.sqm.NodeBuilder.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.sqm.NodeBuilder.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 SqmFunction<String>
public <E, C extends Collection<? super E>> SqmExpression<C>
collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)

Implements org.hibernate.query.sqm.NodeBuilder.collectionAppend, org.hibernate.query.sqm.NodeBuilder.collectionAppend.

Appends element to basic collection.
public <E, C extends Collection<? super E>> SqmExpression<C>
collectionAppend(Expression<C> collectionExpression, E element)

Implements org.hibernate.query.sqm.NodeBuilder.collectionAppend.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionConcat, org.hibernate.query.sqm.NodeBuilder.collectionConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionConcat.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContains, org.hibernate.query.sqm.NodeBuilder.collectionContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContains.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAll.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsAllNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsNullable, org.hibernate.query.sqm.NodeBuilder.collectionContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionContainsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionFill, org.hibernate.query.sqm.NodeBuilder.collectionFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionFill, org.hibernate.query.sqm.NodeBuilder.collectionFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionFill.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionGet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionGet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionLength.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionLiteral.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlaps.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionOverlapsNullable.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPosition.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPosition, org.hibernate.query.sqm.NodeBuilder.collectionPosition.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPositions, org.hibernate.query.sqm.NodeBuilder.collectionPositions.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPositions.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPositionsList, org.hibernate.query.sqm.NodeBuilder.collectionPositionsList.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPositionsList.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPrepend, org.hibernate.query.sqm.NodeBuilder.collectionPrepend.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionPrepend.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionRemove, org.hibernate.query.sqm.NodeBuilder.collectionRemove.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionRemove.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionRemoveIndex.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionRemoveIndex.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionReplace, org.hibernate.query.sqm.NodeBuilder.collectionReplace, org.hibernate.query.sqm.NodeBuilder.collectionReplace, org.hibernate.query.sqm.NodeBuilder.collectionReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionReplace, org.hibernate.query.sqm.NodeBuilder.collectionReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionReplace, org.hibernate.query.sqm.NodeBuilder.collectionReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionReplace.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSet, org.hibernate.query.sqm.NodeBuilder.collectionSet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSet, org.hibernate.query.sqm.NodeBuilder.collectionSet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSet.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionSlice.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionToString.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionToString.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionTrim.

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

Implements org.hibernate.query.sqm.NodeBuilder.collectionTrim.

Creates basic collection copy without the last N elements, specified by the second argument.
private <E> SqmExpression<? extends Collection<?>>
collectionValue(Collection<E> value, SqmExpression<E> typeInferenceSource)

private <E> ValueBindJpaCriteriaParameter<? extends Collection<E>>
collectionValueParameter(Collection<E> value, SqmExpression<E> elementTypeInferenceSource)

private <T> void
collectQueryPartsAndCtes(SqmSelectQuery<T> query, List<SqmQueryPart<T>> queryParts, Map<String, SqmCteStatement<?>> cteStatements)

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

Implements org.hibernate.query.sqm.NodeBuilder.concat.

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

Implements org.hibernate.query.sqm.NodeBuilder.concat.

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

Implements org.hibernate.query.sqm.NodeBuilder.concat.

Create an expression for string concatenation.
public SqmExpression<String>
public SqmPredicate
conjunction()

Implements org.hibernate.query.sqm.NodeBuilder.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
arguments
)

Implements org.hibernate.query.sqm.NodeBuilder.construct.

Create a selection item corresponding to a constructor.
public <Y> JpaCompoundSelection<Y>
construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)

Implements org.hibernate.query.sqm.NodeBuilder.construct.

public SqmFunction<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 SqmFunction<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 SqmExpression<Long>
count(Expression<?>
expression representing input value to count operation
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.count.

Create an aggregate expression applying the count operation.
public SqmExpression<Long>
public SqmExpression<Long>
public SqmExpression<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 SqmExpression<Long>
countDistinct(Expression<?>
expression representing input value to count distinct operation
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.countDistinct.

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

Implements org.hibernate.query.sqm.NodeBuilder.createCriteriaDelete.

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

Implements org.hibernate.query.sqm.NodeBuilder.createCriteriaUpdate.

Create a CriteriaUpdate query object to perform a bulk update operation.
private SqmFunction<Integer>
private <Y> SqmExpression<Y>
public SqmSelectStatement<Object>
createQuery()

Implements org.hibernate.query.sqm.NodeBuilder.createQuery.

Create a CriteriaQuery object.
public <T> SqmSelectStatement<T>
createQuery(Class<T>
type of the query result
resultClass
)

Implements org.hibernate.query.sqm.NodeBuilder.createQuery.

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

Implements org.hibernate.query.sqm.NodeBuilder.createQuery.

Transform the given HQL select query to an equivalent criteria query.
private <N> SqmExpression<N>
createSqmArithmeticNode(BinaryArithmeticOperator operator, SqmExpression<?> leftHandExpression, SqmExpression<?> rightHandExpression)

private SqmMemberOfPredicate
createSqmMemberOfPredicate(SqmExpression<?> elem, SqmPath<?> collection, boolean negated, NodeBuilder nodeBuilder)

private SqmFunction<String>
private SqmFunction<String>
createTrimNode(TrimSpec trimSpecification, SqmExpression<Character> trimCharacter, SqmExpression<String> source)

public SqmSelectStatement<Tuple>
createTupleQuery()

Implements org.hibernate.query.sqm.NodeBuilder.createTupleQuery.

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

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

Create an empty JpaWindow to use with window and aggregate functions.
public SqmExpression<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 SqmFunction<Date>
currentDate()

Implements org.hibernate.query.sqm.NodeBuilder.currentDate.

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

Implements org.hibernate.query.sqm.NodeBuilder.currentTime.

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

Implements org.hibernate.query.sqm.NodeBuilder.currentTimestamp.

Create expression to return current timestamp.
public SqmFunction<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 SqmFunction<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 SqmExpression<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 SqmSortSpecification
desc(Expression<?>
expression used to define the ordering
x
)

Implements org.hibernate.query.sqm.NodeBuilder.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> SqmExpression<N>
diff(Expression<? extends N>
expression
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.diff, org.hibernate.query.sqm.NodeBuilder.diff, org.hibernate.query.sqm.NodeBuilder.diff.

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

Implements org.hibernate.query.sqm.NodeBuilder.diff.

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

Implements org.hibernate.query.sqm.NodeBuilder.diff.

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

Implements org.hibernate.query.sqm.NodeBuilder.disjunction.

Create a disjunction (with zero disjuncts).
public SqmPredicate
public SqmPredicate
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 SqmPredicate
equal(Expression<?>
expression
x
,
Expression<?>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.equal.

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

Implements org.hibernate.query.sqm.NodeBuilder.equal.

Create a predicate for testing the arguments for equality.
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(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)

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

public SqmPredicate
exists(Subquery<?>
subquery whose result is to be tested
subQuery
)

Implements org.hibernate.query.sqm.NodeBuilder.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.
private static List<SqmExpression<?>>
expressionList(Expression<?>[] jpaExpressions)

private <T> SqmFunction<T>
extract(Expression<? extends TemporalAccessor> datetime, TemporalUnit temporalUnit, Class<T> type)

public <T> SqmExpression<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> SqmExpression<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 SqmFunction<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 SqmWindowFrame
public SqmWindowFrame
public SqmWindowFrame
public SqmWindowFrame
public SqmWindowFrame
public SqmWindowFrame
public SqmWindowFrame
public <T> SqmFunction<T>
function(String
function name
name
,
Class<T>
expected result type
type
,
Expression<?>[]
function arguments
args
)

Implements org.hibernate.query.sqm.NodeBuilder.function.

Create an expression for the execution of a database function.
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<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> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<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 SqmPredicate
ge(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.ge.

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

Implements org.hibernate.query.sqm.NodeBuilder.ge.

Create a predicate for testing whether the first argument is greater than or equal to the second.
public BasicType<Boolean>
public BasicType<Character>
public JpaMetamodel
private SqmFunctionDescriptor
private <T> SqmFunctionDescriptor
getFunctionTemplate(String name, BasicType<T> resultType)

public BasicType<Integer>
public JpaMetamodelImplementor
public BasicType<Long>
private MappingMetamodelImplementor
private static SqmExpressible<?>
getNodeType(SqmExpression<?> expression)

private <T> BindableType<? super T>
public QueryEngine
public SessionFactoryImplementor
getSessionFactory()

Implements org.hibernate.query.sqm.NodeBuilder.getSessionFactory.

Deprecated as a consequence of SessionFactoryImplementor being deprecated.
public TypeConfiguration
public <Y extends Comparable<? super Y>> SqmPredicate
greaterThan(Expression<? extends Y>
expression
x
,
Expression<? extends Y>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.greaterThan, org.hibernate.query.sqm.NodeBuilder.greaterThan.

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

Implements org.hibernate.query.sqm.NodeBuilder.greaterThan.

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

Implements org.hibernate.query.sqm.NodeBuilder.greaterThanOrEqualTo, org.hibernate.query.sqm.NodeBuilder.greaterThanOrEqualTo.

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

Implements org.hibernate.query.sqm.NodeBuilder.greaterThanOrEqualTo.

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

Implements org.hibernate.query.sqm.NodeBuilder.greatest.

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

Implements org.hibernate.query.sqm.NodeBuilder.gt.

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

Implements org.hibernate.query.sqm.NodeBuilder.gt.

Create a predicate for testing whether the first argument is greater than the second.
public SqmFunction<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 SqmPredicate
public SqmPredicate
public SqmPredicate
public SqmPredicate
public SqmPredicate
public SqmPredicate
public <T> SqmInPredicate<T>
in(Expression<? extends T>
to be tested against list of values
expression
)

Implements org.hibernate.query.sqm.NodeBuilder.in.

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

Implements org.hibernate.query.sqm.NodeBuilder.in, org.hibernate.query.sqm.NodeBuilder.in.

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

Implements org.hibernate.query.sqm.NodeBuilder.in.

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

Implements org.hibernate.query.sqm.NodeBuilder.in.

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

Implements org.hibernate.query.sqm.NodeBuilder.in.

public <K, L extends List<?>> SqmExpression<Set<K>>
private <T> boolean
inlineValue(T value)

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

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

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

Implements org.hibernate.query.sqm.NodeBuilder.isEmpty.

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

Implements org.hibernate.query.sqm.NodeBuilder.isFalse.

Create a predicate testing for a false value.
private <T> boolean
isInstance(BindableType<T> bindableType, T value)

public boolean
public <M extends Map<?, ?>> SqmPredicate
isMapEmpty(JpaExpression<M>
The expression resolving to a Map which we want to check for emptiness
mapExpression
)

Implements org.hibernate.query.sqm.NodeBuilder.isMapEmpty.

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

Implements org.hibernate.query.sqm.NodeBuilder.isMapNotEmpty.

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

Implements org.hibernate.query.sqm.NodeBuilder.isMember, org.hibernate.query.sqm.NodeBuilder.isMember.

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

Implements org.hibernate.query.sqm.NodeBuilder.isMember.

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

Implements org.hibernate.query.sqm.NodeBuilder.isNotEmpty.

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

Implements org.hibernate.query.sqm.NodeBuilder.isNotMember, org.hibernate.query.sqm.NodeBuilder.isNotMember.

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

Implements org.hibernate.query.sqm.NodeBuilder.isNotMember.

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

Implements org.hibernate.query.sqm.NodeBuilder.isNotNull.

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

Implements org.hibernate.query.sqm.NodeBuilder.isNull.

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

Implements org.hibernate.query.sqm.NodeBuilder.isTrue.

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

Implements org.hibernate.query.sqm.NodeBuilder.keys.

Create an expression that returns the keys of a map.
public <T> SqmExpression<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 SqmPredicate
le(Expression<? extends Number>
expression
x
,
Expression<? extends Number>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.le.

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

Implements org.hibernate.query.sqm.NodeBuilder.le.

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

Implements org.hibernate.query.sqm.NodeBuilder.least.

Create an aggregate expression for finding the least of the values (strings, dates, etc).
public SqmFunction<String>
public SqmFunction<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 SqmFunction<Integer>
length(Expression<String>
string expression
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.length.

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

Implements org.hibernate.query.sqm.NodeBuilder.lessThan, org.hibernate.query.sqm.NodeBuilder.lessThan.

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

Implements org.hibernate.query.sqm.NodeBuilder.lessThan.

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

Implements org.hibernate.query.sqm.NodeBuilder.lessThanOrEqualTo, org.hibernate.query.sqm.NodeBuilder.lessThanOrEqualTo.

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

Implements org.hibernate.query.sqm.NodeBuilder.lessThanOrEqualTo.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

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

Implements org.hibernate.query.sqm.NodeBuilder.like.

Create a predicate for testing whether the expression satisfies the given pattern.
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<String>
public SqmExpression<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> SqmLiteral<T>
literal(T value, SqmExpression<? extends T> typeInferenceSource)

public <T> SqmLiteral<T>
literal(T
value represented by the expression
value
)

Implements org.hibernate.query.sqm.NodeBuilder.literal.

Create an expression for a literal.
public <T> List<? extends SqmExpression<T>>
public <T> List<? extends SqmExpression<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 SqmFunction<Integer>
locate(Expression<String>
expression for string to be searched
source
,
Expression<String>
expression for string to be located
pattern
)

Implements org.hibernate.query.sqm.NodeBuilder.locate.

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

Implements org.hibernate.query.sqm.NodeBuilder.locate.

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

Implements org.hibernate.query.sqm.NodeBuilder.locate.

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

Implements org.hibernate.query.sqm.NodeBuilder.locate.

Create expression to locate the position of one string within another, returning position of first character if found.
private static SessionFactory
public SqmFunction<Double>
public SqmFunction<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 SqmFunction<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 SqmFunction<String>
lower(Expression<String>
string expression
x
)

Implements org.hibernate.query.sqm.NodeBuilder.lower.

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

Implements org.hibernate.query.sqm.NodeBuilder.lt.

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

Implements org.hibernate.query.sqm.NodeBuilder.lt.

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

Implements org.hibernate.query.sqm.NodeBuilder.mapSize, org.hibernate.query.sqm.NodeBuilder.mapSize.

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

Implements org.hibernate.query.sqm.NodeBuilder.mapSize.

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

Implements org.hibernate.query.sqm.NodeBuilder.max.

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

Implements org.hibernate.query.sqm.NodeBuilder.min.

Create an aggregate expression applying the numerical min operation.
public SqmFunction<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 SqmExpression<Integer>
mod(Expression<Integer>
expression
x
,
Expression<Integer>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.mod.

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

Implements org.hibernate.query.sqm.NodeBuilder.mod.

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

Implements org.hibernate.query.sqm.NodeBuilder.mod.

Create an expression that returns the modulus (remainder under integer division) of its arguments.
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<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 SqmFunction<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> SqmExpression<N>
neg(Expression<N>
expression
x
)

Implements org.hibernate.query.sqm.NodeBuilder.neg.

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

Implements org.hibernate.query.sqm.NodeBuilder.not.

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

Implements org.hibernate.query.sqm.NodeBuilder.notEqual.

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

Implements org.hibernate.query.sqm.NodeBuilder.notEqual.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

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

Implements org.hibernate.query.sqm.NodeBuilder.notLike.

Create a predicate for testing whether the expression does not satisfy the given pattern.
public <T> SqmExpression<T>
public <T> SqmExpression<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> SqmExpression<Y>
nullif(Expression<Y>
expression
x
,
Expression<?>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.nullif, org.hibernate.query.sqm.NodeBuilder.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> SqmExpression<Y>
nullif(Expression<Y>
expression
x
,
Y
value
y
)

Implements org.hibernate.query.sqm.NodeBuilder.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> SqmExpression<T>
nullLiteral(Class<T>
type of the null literal
resultClass
)

Implements org.hibernate.query.sqm.NodeBuilder.nullLiteral.

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

Implements org.hibernate.query.sqm.NodeBuilder.or.

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

Implements org.hibernate.query.sqm.NodeBuilder.or.

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

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

public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<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 SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<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> JpaCriteriaParameter<T>
parameter(Class<T>
parameter class
paramClass
)

Implements org.hibernate.query.sqm.NodeBuilder.parameter.

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

Implements org.hibernate.query.sqm.NodeBuilder.parameter.

Create a parameter expression with the given name.
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<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> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<T>
public <T> SqmExpression<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 SqmExpression<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 SqmExpression<Double>
public SqmExpression<Double>
public SqmExpression<Double>
public SqmExpression<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 SqmFunction<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> SqmExpression<N>
prod(Expression<? extends N>
expression
x
,
Expression<? extends N>
expression
y
)

Implements org.hibernate.query.sqm.NodeBuilder.prod, org.hibernate.query.sqm.NodeBuilder.prod, org.hibernate.query.sqm.NodeBuilder.prod.

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

Implements org.hibernate.query.sqm.NodeBuilder.prod.

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

Implements org.hibernate.query.sqm.NodeBuilder.prod.

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

Implements org.hibernate.query.sqm.NodeBuilder.quot.

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

Implements org.hibernate.query.sqm.NodeBuilder.quot.

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

Implements org.hibernate.query.sqm.NodeBuilder.quot.

Create an expression that returns the quotient of its arguments.
public SqmFunction<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 SqmExpression<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 SqmExpression<Long>
public SqmExpression<Long>
public SqmExpression<Long>
public SqmExpression<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.
private Object

Returns:

The resolved node builder to use.
readResolve
()

Custom serialization hook defined by Java spec.

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 SqmFunction<String>
public SqmFunction<String>
public SqmFunction<String>
public SqmFunction<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.
private static <T> BindableType<T>
resolveInferredParameterType(T value, SqmExpression<? extends T> typeInferenceSource, TypeConfiguration typeConfiguration)

private static <T> SqmExpressible<T>
resolveInferredType(T value, SqmExpression<? extends T> typeInferenceSource, TypeConfiguration typeConfiguration)

public SqmFunction<String>
public SqmFunction<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 SqmExpression<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
sortExpression
,
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
sortExpression
,
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
sortExpression
)

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

Create a search ordering based on the ascending value of the CTE attribute.
public SqmFunction<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> SqmCaseSimple<C, R>
selectCase(Expression<? extends C>
to be tested against the case conditions
expression
)

Implements org.hibernate.query.sqm.NodeBuilder.selectCase.

Create a simple case expression.
public <R> SqmCaseSearched<R>
selectCase()

Implements org.hibernate.query.sqm.NodeBuilder.selectCase.

Create a general case expression.
private <T> JpaCriteriaQuery<T>
setOperation(SetOperator operator, CriteriaQuery<? extends T> criteriaQuery, CriteriaQuery<?>... queries)

private <T> JpaSubQuery<T>
setOperation(SetOperator operator, Subquery<? extends T> subquery, Subquery<?>... queries)

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 SqmFunction<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 SqmFunction<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<?>> SqmExpression<Integer>
size(Expression<C>
expression
collection
)

Implements org.hibernate.query.sqm.NodeBuilder.size, org.hibernate.query.sqm.NodeBuilder.size.

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

Implements org.hibernate.query.sqm.NodeBuilder.size.

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

Implements org.hibernate.query.sqm.NodeBuilder.some.

Create a some expression over the subquery results.
public SqmSortSpecification
sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)

Implements org.hibernate.query.sqm.NodeBuilder.sort.

public SqmSortSpecification
public SqmSortSpecification
public <T> SqmFunction<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 SqmExpression<Double>
sqrt(Expression<? extends Number>
expression
x
)

Implements org.hibernate.query.sqm.NodeBuilder.sqrt.

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

Implements org.hibernate.query.sqm.NodeBuilder.substring.

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

Implements org.hibernate.query.sqm.NodeBuilder.substring.

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

Implements org.hibernate.query.sqm.NodeBuilder.substring.

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

Implements org.hibernate.query.sqm.NodeBuilder.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> SqmExpression<N>
sum(Expression<N>
expression representing input value to sum operation
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.sum.

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

Implements org.hibernate.query.sqm.NodeBuilder.sum, org.hibernate.query.sqm.NodeBuilder.sum, org.hibernate.query.sqm.NodeBuilder.sum.

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

Implements org.hibernate.query.sqm.NodeBuilder.sum.

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

Implements org.hibernate.query.sqm.NodeBuilder.sum.

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

Implements org.hibernate.query.sqm.NodeBuilder.sum.

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

Implements org.hibernate.query.sqm.NodeBuilder.sum.

Create an expression that returns the sum of its arguments.
public <N extends Number> SqmExpression<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 SqmExpression<Double>
sumAsDouble(Expression<Float>
expression representing input value to sum operation
argument
)

Implements org.hibernate.query.sqm.NodeBuilder.sumAsDouble.

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

Implements org.hibernate.query.sqm.NodeBuilder.sumAsLong.

Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.
public SqmFunction<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 SqmFunction<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 SqmExpression<BigDecimal>
toBigDecimal(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.sqm.NodeBuilder.toBigDecimal.

Typecast.
public SqmExpression<BigInteger>
toBigInteger(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.sqm.NodeBuilder.toBigInteger.

Typecast.
public SqmExpression<Double>
toDouble(Expression<? extends Number>
numeric expression
number
)

Implements org.hibernate.query.sqm.NodeBuilder.toDouble.

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

Implements org.hibernate.query.sqm.NodeBuilder.toFloat.

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

Implements org.hibernate.query.sqm.NodeBuilder.toInteger.

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

Implements org.hibernate.query.sqm.NodeBuilder.toLong.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.treat.

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

Implements org.hibernate.query.sqm.NodeBuilder.trim.

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

Implements org.hibernate.query.sqm.NodeBuilder.trim.

Create expression to trim blanks from a string.
public SqmFunction<String>
trim(Expression<Character>
expression for character to be trimmed
trimChar
,
Expression<String>
expression for string to trim
source
)

Implements org.hibernate.query.sqm.NodeBuilder.trim.

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

Implements org.hibernate.query.sqm.NodeBuilder.trim.

Create expression to trim character from a string.
public SqmFunction<String>
trim(char
character to be trimmed
trimChar
,
Expression<String>
expression for string to trim
source
)

Implements org.hibernate.query.sqm.NodeBuilder.trim.

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

Implements org.hibernate.query.sqm.NodeBuilder.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> SqmFunction<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.sqm.NodeBuilder.tuple.

Create a tuple-valued selection item.
public JpaCompoundSelection<Tuple>
public <R> SqmTuple<R>
tuple(Class<R> tupleType, SqmExpression<?>... expressions)

Implements org.hibernate.query.sqm.NodeBuilder.tuple.

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

Implements org.hibernate.query.sqm.NodeBuilder.tuple.

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

Implements org.hibernate.query.sqm.NodeBuilder.tuple.

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(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)

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

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

Implements org.hibernate.query.sqm.NodeBuilder.upper.

Create expression for converting a string to uppercase.
public <T> SqmExpression<T>
value(T value, SqmExpression<? extends T> typeInferenceSource)

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

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

private <T> ValueBindJpaCriteriaParameter<T>
valueParameter(T value)

public <V, C extends Collection<V>> SqmExpression<Collection<V>>
values(C
map
collection
)

Implements org.hibernate.query.sqm.NodeBuilder.values, org.hibernate.query.sqm.NodeBuilder.values.

Create an expression that returns the values of a map.
public <V, M extends Map<?, V>> Expression<Collection<V>>
values(M
map
map
)

Implements org.hibernate.query.sqm.NodeBuilder.values, org.hibernate.query.sqm.NodeBuilder.values.

Create an expression that returns the values of a map.
public <T> SqmExpression<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 SqmPredicate
public final SqmPredicate
public SqmFunction<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