jakarta.persistence.criteria.CriteriaBuilder by
using SQM nodes as the JPA Criteria nodes
| Modifier and Type | Class and Description |
|---|---|
| pack-priv class |
| Modifier and Type | Field and Description |
|---|---|
| private transient BasicType | |
| private transient BasicType | |
| private final transient ValueHandlingMode | |
| private final transient Map | |
| private transient BasicType | |
| private final transient boolean | |
| private static final CoreMessageLogger | |
| private transient BasicType | |
| private final String | |
| private final transient QueryEngine | |
| private final transient Supplier | |
| private final String |
| Access | Constructor and Description |
|---|---|
| public | SqmCriteriaNodeBuilder(String uuid, String name, QueryEngine queryEngine, boolean jpaComplianceEnabled, ValueHandlingMode criteriaValueHandlingMode, Supplier<SessionFactoryImplementor> sessionFactory)
|
| Modifier and Type | Method and Description |
|---|---|
| public <N extends Number> SqmExpression | abs(Expression<N>
expression x)Implements org. |
| public SqmFunction | acos(Expression<? extends Number>
expression x)Implements org. |
| public <T extends Temporal> JpaExpression | addDuration(Expression<T> datetime, Expression<Duration> duration)
Implements org. |
| public <T extends Temporal> JpaExpression | addDuration(Expression<T> datetime, Duration duration)
Implements org. |
| public <T extends Temporal> JpaExpression | addDuration(T datetime, Expression<Duration> duration)
Implements org. |
| public <Y> SqmModifiedSubQueryExpression | all(Subquery<Y>
subquery subquery)Implements org. |
| public SqmPredicate | and(Expression<Boolean>
boolean expression x, Expression<Boolean> boolean expression y)Implements org. |
| public SqmPredicate | and(Predicate...
zero or more restriction predicates restrictions)Implements org. |
| public <Y> SqmModifiedSubQueryExpression | any(Subquery<Y>
subquery subquery)Implements org. |
| public JpaCompoundSelection | array(Selection<?>[]
selection items selections)Implements org. |
| public JpaCompoundSelection | array(List<? extends JpaSelection<?>> selections)
Implements org. |
| public <Y> JpaCompoundSelection | array(Class<Y> resultClass, Selection<?>[] selections)
Implements org. |
| public <Y> JpaCompoundSelection | array(Class<Y> resultClass, List<? extends JpaSelection<?>> selections)
Implements org. |
| public <T> SqmExpression | arrayAgg(JpaOrder order, Expression<? extends T> argument)
Implements org. |
| public <T> SqmExpression | arrayAgg(JpaOrder order, JpaPredicate filter, Expression<? extends T> argument)
Implements org. |
| public <T> SqmExpression | arrayAgg(JpaOrder order, JpaWindow window, Expression<? extends T> argument)
Implements org. |
| public <T> SqmExpression | 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. array_agg ordered set-aggregate function expression.
|
| public <T> SqmExpression | arrayAppend(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayAppend(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmExpression | arrayConcat(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Implements org. |
| public <T> SqmExpression | arrayConcat(Expression<T[]> arrayExpression1, T[] array2)
Implements org. |
| public <T> SqmExpression | arrayConcat(T[] array1, Expression<T[]> arrayExpression2)
Implements org. |
| public <T> SqmPredicate | arrayContains(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmPredicate | arrayContains(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmPredicate | arrayContains(T[] array, Expression<T> elementExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsAll(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsAll(Expression<T[]> arrayExpression, T[] subArray)
Implements org. |
| public <T> SqmPredicate | arrayContainsAll(T[] array, Expression<T[]> subArrayExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsAllNullable(Expression<T[]> arrayExpression, Expression<T[]> subArrayExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsAllNullable(Expression<T[]> arrayExpression, T[] subArray)
Implements org. |
| public <T> SqmPredicate | arrayContainsAllNullable(T[] array, Expression<T[]> subArrayExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsNullable(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmPredicate | arrayContainsNullable(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmPredicate | arrayContainsNullable(T[] array, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Implements org. |
| public <T> SqmExpression | arrayFill(Expression<T> elementExpression, Integer elementCount)
Implements org. |
| public <T> SqmExpression | arrayFill(T element, Expression<Integer> elementCountExpression)
Implements org. |
| public <T> SqmExpression | arrayFill(T element, Integer elementCount)
Implements org. |
| public <T> SqmExpression | arrayGet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Implements org. |
| public <T> SqmExpression | arrayGet(Expression<T[]> arrayExpression, Integer index)
Implements org. |
| public <T> SqmExpression | arrayLength(Expression<T[]> arrayExpression)
Implements org. |
| public <T> SqmExpression | arrayLiteral(T... elements)
Implements org. array constructor function.
|
| public <T> SqmPredicate | arrayOverlaps(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Implements org. |
| public <T> SqmPredicate | arrayOverlaps(Expression<T[]> arrayExpression1, T[] array2)
Implements org. |
| public <T> SqmPredicate | arrayOverlaps(T[] array1, Expression<T[]> arrayExpression2)
Implements org. |
| public <T> SqmPredicate | arrayOverlapsNullable(Expression<T[]> arrayExpression1, Expression<T[]> arrayExpression2)
Implements org. null elements.
|
| public <T> SqmPredicate | arrayOverlapsNullable(Expression<T[]> arrayExpression1, T[] array2)
Implements org. null elements.
|
| public <T> SqmPredicate | arrayOverlapsNullable(T[] array1, Expression<T[]> arrayExpression2)
Implements org. null elements.
|
| public <T> SqmExpression | arrayPosition(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmExpression | arrayPosition(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayPositions(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayPositions(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmExpression | arrayPositionsList(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayPositionsList(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmExpression | arrayPrepend(Expression<T> elementExpression, Expression<T[]> arrayExpression)
Implements org. |
| public <T> SqmExpression | arrayPrepend(T element, Expression<T[]> arrayExpression)
Implements org. |
| public <T> SqmExpression | arrayRemove(Expression<T[]> arrayExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arrayRemove(Expression<T[]> arrayExpression, T element)
Implements org. |
| public <T> SqmExpression | arrayRemoveIndex(Expression<T[]> arrayExpression, Expression<Integer> indexExpression)
Implements org. |
| public <T> SqmExpression | arrayRemoveIndex(Expression<T[]> arrayExpression, Integer index)
Implements org. |
| public <T> SqmExpression | arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, Expression<T> newElementExpression)
Implements org. |
| public <T> SqmExpression | arrayReplace(Expression<T[]> arrayExpression, Expression<T> oldElementExpression, T newElement)
Implements org. |
| public <T> SqmExpression | arrayReplace(Expression<T[]> arrayExpression, T oldElement, Expression<T> newElementExpression)
Implements org. |
| public <T> SqmExpression | arrayReplace(Expression<T[]> arrayExpression, T oldElement, T newElement)
Implements org. |
| public <T> SqmExpression | arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arraySet(Expression<T[]> arrayExpression, Expression<Integer> indexExpression, T element)
Implements org. |
| public <T> SqmExpression | arraySet(Expression<T[]> arrayExpression, Integer index, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | arraySet(Expression<T[]> arrayExpression, Integer index, T element)
Implements org. |
| public <T> SqmExpression | arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Implements org. |
| public <T> SqmExpression | arraySlice(Expression<T[]> arrayExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Implements org. |
| public <T> SqmExpression | arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Implements org. |
| public <T> SqmExpression | arraySlice(Expression<T[]> arrayExpression, Integer lowerIndex, Integer upperIndex)
Implements org. |
| public <T> SqmExpression | arrayToString(Expression<? extends Object[]> arrayExpression, Expression<String> separatorExpression)
Implements org. |
| public <T> SqmExpression | arrayToString(Expression<? extends Object[]> arrayExpression, String separator)
Implements org. |
| public <T> SqmExpression | arrayTrim(Expression<T[]> arrayExpression, Expression<Integer> elementCountExpression)
Implements org. |
| public <T> SqmExpression | arrayTrim(Expression<T[]> arrayExpression, Integer elementCount)
Implements org. |
| public SqmSortSpecification | asc(Expression<?>
expression used to define the ordering x)Implements org. |
| public JpaOrder | asc(Expression<?>
expression used to define the ordering x, boolean Whether nullsFirst)null should be sorted firstImplements org. |
| public JpaSearchOrder | asc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering x)Implements org. |
| public JpaSearchOrder | asc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering x, boolean Whether nullsFirst)null should be sorted firstImplements org. |
| public SqmFunction | asin(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | atan(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | atan2(Number y, Expression<? extends Number> x)
Implements org. |
| public SqmFunction | atan2(Expression<? extends Number> y, Number x)
Implements org. |
| public SqmFunction | atan2(Expression<? extends Number>
y coordinate y, Expression<? extends Number> x coordinate x)Implements org. y over x.
|
| public <N extends Number> SqmExpression | avg(Expression<N>
expression representing input value to avg operation argument)Implements org. |
| public <N extends Number> SqmExpression | avg(Expression<N> argument, JpaPredicate filter)
Implements org. |
| public <N extends Number> SqmExpression | avg(Expression<N> argument, JpaWindow window)
Implements org. |
| public <N extends Number> SqmExpression | 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. avg aggregate function expression.
|
| public <Y extends Comparable | between(Expression<? extends Y>
expression value, Expression<? extends Y> expression lower, Expression<? extends Y> expression upper)Implements org. |
| public <Y extends Comparable | between(Expression<? extends Y>
expression value, Y value lower, Y value upper)Implements org. |
| public <X, T> SqmExpression | cast(JpaExpression<T> expression, Class<X> castTargetJavaType)
Implements org. |
| public <N extends Number> JpaExpression | ceiling(Expression<N>
expression x)Implements org. |
| 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
|
| public <T> SqmCoalesce | |
| public <Y> JpaCoalesce | coalesce(Expression<? extends Y>
expression x, Expression<? extends Y> expression y)Implements org. |
| public <Y> JpaCoalesce | coalesce(Expression<? extends Y>
expression x, Y value y)Implements org. |
| public SqmFunction | collate(Expression<String> x, String collation)
Implements org. |
| public <E, C extends Collection | collectionAppend(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Implements org. |
| public <E, C extends Collection | collectionAppend(Expression<C> collectionExpression, E element)
Implements org. |
| public <E, C extends Collection | collectionConcat(Expression<C> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. |
| public <E, C extends Collection | collectionConcat(Expression<C> collectionExpression1, Collection<? extends E> collection2)
Implements org. |
| public <E, C extends Collection | collectionConcat(C collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. |
| public <E> SqmPredicate | collectionContains(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Implements org. |
| public <E> SqmPredicate | collectionContains(Expression<? extends Collection<E>> collectionExpression, E element)
Implements org. |
| public <E> SqmPredicate | collectionContains(Collection<E> collection, Expression<E> elementExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsAll(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Implements org. |
| public <E> SqmPredicate | collectionContainsAll(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends Collection<? extends E>> subCollectionExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsAllNullable(Expression<? extends Collection<E>> collectionExpression, Collection<? extends E> subCollection)
Implements org. |
| public <E> SqmPredicate | collectionContainsAllNullable(Collection<E> collection, Expression<? extends Collection<? extends E>> subCollectionExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, Expression<? extends E> elementExpression)
Implements org. |
| public <E> SqmPredicate | collectionContainsNullable(Expression<? extends Collection<E>> collectionExpression, E element)
Implements org. |
| public <E> SqmPredicate | collectionContainsNullable(Collection<E> collection, Expression<E> elementExpression)
Implements org. |
| public <T> SqmExpression | collectionFill(Expression<T> elementExpression, Expression<Integer> elementCountExpression)
Implements org. |
| public <T> SqmExpression | collectionFill(Expression<T> elementExpression, Integer elementCount)
Implements org. |
| public <T> SqmExpression | collectionFill(T element, Expression<Integer> elementCountExpression)
Implements org. |
| public <T> SqmExpression | collectionFill(T element, Integer elementCount)
Implements org. |
| public <E> SqmExpression | collectionGet(Expression<? extends Collection<E>> collectionExpression, Expression<Integer> indexExpression)
Implements org. |
| public <E> SqmExpression | collectionGet(Expression<? extends Collection<E>> collectionExpression, Integer index)
Implements org. |
| public SqmExpression | collectionLength(Expression<? extends Collection<?>> collectionExpression)
Implements org. |
| public <E, C extends Collection | collectionLiteral(E... elements)
Implements org. array constructor function.
|
| public <E> SqmPredicate | collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. |
| public <E> SqmPredicate | collectionOverlaps(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Implements org. |
| public <E> SqmPredicate | collectionOverlaps(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. |
| public <E> SqmPredicate | collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. null elements.
|
| public <E> SqmPredicate | collectionOverlapsNullable(Expression<? extends Collection<E>> collectionExpression1, Collection<? extends E> collection2)
Implements org. null elements.
|
| public <E> SqmPredicate | collectionOverlapsNullable(Collection<E> collection1, Expression<? extends Collection<? extends E>> collectionExpression2)
Implements org. null elements.
|
| public <E> SqmExpression | collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, E element)
Implements org. |
| public <E> SqmExpression | collectionPosition(Expression<? extends Collection<? extends E>> collectionExpression, Expression<E> elementExpression)
Implements org. |
| public <T> SqmExpression | collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | collectionPositions(Expression<? extends Collection<? super T>> collectionExpression, T element)
Implements org. |
| public <T> SqmExpression | collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, Expression<T> elementExpression)
Implements org. |
| public <T> SqmExpression | collectionPositionsList(Expression<? extends Collection<? super T>> collectionExpression, T element)
Implements org. |
| public <E, C extends Collection | collectionPrepend(Expression<? extends E> elementExpression, Expression<C> collectionExpression)
Implements org. |
| public <E, C extends Collection | collectionPrepend(E element, Expression<C> collectionExpression)
Implements org. |
| public <E, C extends Collection | collectionRemove(Expression<C> collectionExpression, Expression<? extends E> elementExpression)
Implements org. |
| public <E, C extends Collection | collectionRemove(Expression<C> collectionExpression, E element)
Implements org. |
| public <C extends Collection | collectionRemoveIndex(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Implements org. |
| public <C extends Collection | collectionRemoveIndex(Expression<C> collectionExpression, Integer index)
Implements org. |
| public <E, C extends Collection | collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, Expression<? extends E> newElementExpression)
Implements org. |
| public <E, C extends Collection | collectionReplace(Expression<C> collectionExpression, Expression<? extends E> oldElementExpression, E newElement)
Implements org. |
| public <E, C extends Collection | collectionReplace(Expression<C> collectionExpression, E oldElement, Expression<? extends E> newElementExpression)
Implements org. |
| public <E, C extends Collection | collectionReplace(Expression<C> collectionExpression, E oldElement, E newElement)
Implements org. |
| public <E, C extends Collection | collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, Expression<? extends E> elementExpression)
Implements org. |
| public <E, C extends Collection | collectionSet(Expression<C> collectionExpression, Expression<Integer> indexExpression, E element)
Implements org. |
| public <E, C extends Collection | collectionSet(Expression<C> collectionExpression, Integer index, Expression<? extends E> elementExpression)
Implements org. |
| public <E, C extends Collection | collectionSet(Expression<C> collectionExpression, Integer index, E element)
Implements org. |
| public <C extends Collection | collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Expression<Integer> upperIndexExpression)
Implements org. |
| public <C extends Collection | collectionSlice(Expression<C> collectionExpression, Expression<Integer> lowerIndexExpression, Integer upperIndex)
Implements org. |
| public <C extends Collection | collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Expression<Integer> upperIndexExpression)
Implements org. |
| public <C extends Collection | collectionSlice(Expression<C> collectionExpression, Integer lowerIndex, Integer upperIndex)
Implements org. |
| public <T> SqmExpression | collectionToString(Expression<? extends Collection<?>> collectionExpression, Expression<String> separatorExpression)
Implements org. |
| public <T> SqmExpression | collectionToString(Expression<? extends Collection<?>> collectionExpression, String separator)
Implements org. |
| public <C extends Collection | collectionTrim(Expression<C> collectionExpression, Expression<Integer> indexExpression)
Implements org. |
| public <C extends Collection | collectionTrim(Expression<C> collectionExpression, Integer index)
Implements org. |
| private <E> SqmExpression | |
| private <E> ValueBindJpaCriteriaParameter | |
| private <T> void | collectQueryPartsAndCtes(SqmSelectQuery<T> query, List<SqmQueryPart<T>> queryParts, Map<String, SqmCteStatement<?>> cteStatements)
|
| public SqmExpression | concat(Expression<String>
string expression x, Expression<String> string expression y)Implements org. |
| public SqmExpression | concat(Expression<String>
string expression x, String string y)Implements org. |
| public SqmExpression | concat(String
string x, Expression<String> string expression y)Implements org. |
| public SqmExpression | |
| public SqmPredicate | conjunction()
Implements org. |
| public <Y> JpaCompoundSelection | construct(Class<Y>
class whose instance is to be constructed resultClass, Selection<?>[] arguments to the constructor arguments)Implements org. |
| public <Y> JpaCompoundSelection | construct(Class<Y> resultClass, List<? extends JpaSelection<?>> arguments)
Implements org. |
| public SqmFunction | cos(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | cosh(Expression<? extends Number>
expression x)Implements org. |
| public SqmExpression | count(Expression<?>
expression representing input value to count
operation argument)Implements org. |
| public SqmExpression | count(Expression<?> argument, JpaPredicate filter)
Implements org. |
| public SqmExpression | count(Expression<?> argument, JpaWindow window)
Implements org. |
| public SqmExpression | count(Expression<?>
argument to the function argument, JpaPredicate optional filter clause filter, JpaWindow optional window over which to apply the function window)Implements org. count aggregate function expression.
|
| public SqmExpression | countDistinct(Expression<?>
expression representing input value to
count distinct operation argument)Implements org. |
| public <T> SqmDeleteStatement | createCriteriaDelete(Class<T>
target type for delete operation targetEntity)Implements org. CriteriaDelete query object to perform a bulk delete operation.
|
| public <T> SqmInsertSelectStatement | createCriteriaInsertSelect(Class<T> targetEntity)
Implements org. |
| public <T> SqmInsertValuesStatement | createCriteriaInsertValues(Class<T> targetEntity)
Implements org. |
| public <T> SqmUpdateStatement | createCriteriaUpdate(Class<T>
target type for update operation targetEntity)Implements org. CriteriaUpdate query object to perform a bulk update operation.
|
| private SqmFunction | createLocateFunctionNode(SqmExpression<String> source, SqmExpression<String> pattern, SqmExpression<Integer> startPosition)
|
| private <Y> SqmExpression | |
| public SqmSelectStatement | createQuery()
Implements org. CriteriaQuery object.
|
| public <T> SqmSelectStatement | createQuery(Class<T>
type of the query result resultClass)Implements org. CriteriaQuery object with the specified result
type.
|
| public <T> SqmSelectStatement | createQuery(String
The HQL hql, Class<T> select queryThe result type of the query resultClass)Implements org. select query to an equivalent criteria query.
|
| private <N> SqmExpression | createSqmArithmeticNode(BinaryArithmeticOperator operator, SqmExpression<?> leftHandExpression, SqmExpression<?> rightHandExpression)
|
| private SqmMemberOfPredicate | createSqmMemberOfPredicate(SqmExpression<?> elem, SqmPath<?> collection, boolean negated, NodeBuilder nodeBuilder)
|
| private SqmFunction | createSubstringNode(SqmExpression<String> source, SqmExpression<Integer> from, SqmExpression<Integer> len)
|
| private SqmFunction | createTrimNode(TrimSpec trimSpecification, SqmExpression<Character> trimCharacter, SqmExpression<String> source)
|
| public SqmSelectStatement | createTupleQuery()
Implements org. CriteriaQuery object that returns a tuple of
objects as its result.
|
| public SqmWindow | createWindow()
Implements org. JpaWindow to use with window and aggregate functions.
|
| public SqmExpression | cumeDist(JpaWindow
window over which the function will be applied window)Implements org. cume_dist window function expression.
|
| public SqmFunction | currentDate()
Implements org. |
| public SqmFunction | |
| public SqmFunction | currentTime()
Implements org. |
| public SqmFunction | currentTimestamp()
Implements org. |
| public SqmFunction | day(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|
| public SqmFunction | degrees(Expression<? extends Number>
expression x)Implements org. |
| public SqmExpression | denseRank(JpaWindow
window over which the function will be applied window)Implements org. dense_rank window function expression.
|
| public SqmSortSpecification | desc(Expression<?>
expression used to define the ordering x)Implements org. |
| public JpaOrder | desc(Expression<?>
expression used to define the ordering x, boolean Whether nullsFirst)null should be sorted firstImplements org. |
| public JpaSearchOrder | desc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering x)Implements org. |
| public JpaSearchOrder | desc(JpaCteCriteriaAttribute
CTE attribute used to define the ordering x, boolean Whether nullsFirst)null should be sorted firstImplements org. |
| public <N extends Number> SqmExpression | diff(Expression<? extends N>
expression x, Expression<? extends N> expression y)Implements org. |
| public <N extends Number> SqmExpression | diff(Expression<? extends N>
expression x, N value y)Implements org. |
| public <N extends Number> SqmExpression | diff(N
value x, Expression<? extends N> expression y)Implements org. |
| public SqmPredicate | disjunction()
Implements org. |
| public SqmPredicate | distinctFrom(Expression<?> x, Expression<?> y)
Implements org. |
| public SqmPredicate | |
| public JpaExpression | duration(long magnitude, TemporalUnit unit)
Implements org. Duration, for example, "five days" or "30 minutes".
|
| public <T extends Temporal> JpaExpression | durationBetween(Expression<T> x, Expression<T> y)
Implements org. |
| public <T extends Temporal> JpaExpression | durationBetween(Expression<T> x, T y)
Implements org. |
| public JpaExpression | durationByUnit(TemporalUnit
a choice of temporal granularity unit, Expression<Duration> the duration in a "unit-free" form duration)Implements org. Duration to a numeric magnitude in the given units.
|
| public JpaExpression | durationDiff(Expression<Duration> x, Expression<Duration> y)
Implements org. |
| public JpaExpression | durationDiff(Expression<Duration> x, Duration y)
Implements org. |
| public JpaExpression | durationScaled(Expression<? extends Number> number, Expression<Duration> duration)
Implements org. |
| public JpaExpression | durationScaled(Number number, Expression<Duration> duration)
Implements org. |
| public JpaExpression | durationScaled(Expression<? extends Number> number, Duration duration)
Implements org. |
| public JpaExpression | durationSum(Expression<Duration> x, Expression<Duration> y)
Implements org. |
| public JpaExpression | durationSum(Expression<Duration> x, Duration y)
Implements org. |
| public SqmPredicate | equal(Expression<?>
expression x, Expression<?> expression y)Implements org. |
| public SqmPredicate | equal(Expression<?>
expression x, Object object y)Implements org. |
| public <T> JpaCriteriaQuery | except(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
Implements org. |
| public <T> JpaSubQuery | except(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
Implements org. |
| public SqmPredicate | exists(Subquery<?>
subquery whose result is to be tested subQuery)Implements org. |
| public JpaExpression | exp(Expression<? extends Number>
expression x)Implements org. |
| private static List | |
| private <T> SqmFunction | |
| public <T> SqmExpression | firstValue(Expression<T>
argument expression to pass to argument, JpaWindow first_valuewindow over which the function will be applied window)Implements org. first_value window function expression.
|
| public <P, F> SqmExpression | |
| public <N extends Number> JpaExpression | floor(Expression<N>
expression x)Implements org. |
| public SqmFunction | format(Expression<? extends TemporalAccessor>
the datetime expression to format datetime, String the pattern to use for formatting pattern)Implements org. |
| public SqmWindowFrame | frameBetweenFollowing(int offset)
Implements org. |
| public SqmWindowFrame | frameBetweenFollowing(Expression<?>
the offset)offset expressionImplements org. FrameKind#OFFSET_FOLLOWING to use with JpaWindows.
|
| public SqmWindowFrame | frameBetweenPreceding(int offset)
Implements org. |
| public SqmWindowFrame | frameBetweenPreceding(Expression<?>
the offset)offset expressionImplements org. FrameKind#OFFSET_PRECEDING to use with JpaWindows.
|
| public SqmWindowFrame | frameCurrentRow()
Implements org. FrameKind#CURRENT_ROW to use with JpaWindows.
|
| public SqmWindowFrame | frameUnboundedFollowing()
Implements org. FrameKind#UNBOUNDED_FOLLOWING to use with JpaWindows.
|
| public SqmWindowFrame | frameUnboundedPreceding()
Implements org. FrameKind#UNBOUNDED_PRECEDING to use with JpaWindows.
|
| public <T> SqmFunction | function(String
function name name, Class<T> expected result type type, Expression<?>[] function arguments args)Implements org. |
| public <T> SqmExpression | functionAggregate(String name, Class<T> type, JpaPredicate filter, Expression<?>... args)
Implements org. |
| public <T> SqmExpression | functionAggregate(String name, Class<T> type, JpaWindow window, Expression<?>... args)
Implements org. |
| public <T> SqmExpression | 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. |
| public <T> SqmExpression | functionWithinGroup(String name, Class<T> type, JpaOrder order, Expression<?>... args)
Implements org. |
| public <T> SqmExpression | functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaPredicate filter, Expression<?>... args)
Implements org. |
| public <T> SqmExpression | functionWithinGroup(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args)
Implements org. |
| public <T> SqmExpression | 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. |
| public SqmPredicate | ge(Expression<? extends Number>
expression x, Expression<? extends Number> expression y)Implements org. |
| public SqmPredicate | ge(Expression<? extends Number>
expression x, Number value y)Implements org. |
| public BasicType | |
| public BasicType | |
| public JpaMetamodel | |
| private SqmFunctionDescriptor | |
| private <T> SqmFunctionDescriptor | |
| public BasicType | |
| public JpaMetamodelImplementor | getJpaMetamodel()
Implements org. |
| public BasicType | |
| private MappingMetamodelImplementor | |
| private static SqmExpressible | |
| private <T> BindableType | |
| public QueryEngine | |
| public SessionFactoryImplementor | getSessionFactory()
Implements org.
Deprecated
as a consequence of
SessionFactoryImplementor being deprecated.
|
| public TypeConfiguration | |
| public <Y extends Comparable | greaterThan(Expression<? extends Y>
expression x, Expression<? extends Y> expression y)Implements org. |
| public <Y extends Comparable | greaterThan(Expression<? extends Y>
expression x, Y value y)Implements org. |
| public <Y extends Comparable | greaterThanOrEqualTo(Expression<? extends Y>
expression x, Expression<? extends Y> expression y)Implements org. |
| public <Y extends Comparable | greaterThanOrEqualTo(Expression<? extends Y>
expression x, Y value y)Implements org. |
| public <X extends Comparable | greatest(Expression<X>
expression representing input value to greatest
operation argument)Implements org. |
| public SqmPredicate | gt(Expression<? extends Number>
expression x, Expression<? extends Number> expression y)Implements org. |
| public SqmPredicate | gt(Expression<? extends Number>
expression x, Number value y)Implements org. |
| public SqmFunction | hour(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|
| public SqmPredicate | ilike(Expression<String> searchString, Expression<String> pattern)
Implements org. |
| public SqmPredicate | ilike(Expression<String> searchString, String pattern)
Implements org. |
| public SqmPredicate | ilike(Expression<String> searchString, Expression<String> pattern, Expression<Character> escapeChar)
Implements org. |
| public SqmPredicate | ilike(Expression<String> searchString, Expression<String> pattern, char escapeChar)
Implements org. |
| public SqmPredicate | ilike(Expression<String> searchString, String pattern, Expression<Character> escapeChar)
Implements org. |
| public SqmPredicate | ilike(Expression<String> searchString, String pattern, char escapeChar)
Implements org. |
| public <T> SqmInPredicate | in(Expression<? extends T>
to be tested against list of values expression)Implements org. |
| public <T> SqmInPredicate | in(Expression<? extends T> expression, Expression<? extends T>... values)
Implements org. |
| public <T> SqmInPredicate | in(Expression<? extends T> expression, T... values)
Implements org. |
| public <T> SqmInPredicate | in(Expression<? extends T> expression, Collection<T> values)
Implements org. |
| public <T> SqmInPredicate | in(Expression<? extends T> expression, SqmSubQuery<T> subQuery)
Implements org. |
| public <K, L extends List | |
| private <T> boolean | |
| public <T> JpaCriteriaQuery | intersect(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
Implements org. |
| public <T> JpaSubQuery | intersect(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
Implements org. |
| public <C extends Collection | isEmpty(Expression<C>
expression collection)Implements org. |
| public SqmPredicate | isFalse(Expression<Boolean>
expression to be tested x)Implements org. |
| private <T> boolean | |
| public boolean | |
| public <M extends Map | isMapEmpty(JpaExpression<M>
The expression resolving to a Map which we
want to check for emptiness mapExpression)Implements org. |
| public <M extends Map | isMapNotEmpty(JpaExpression<M>
The expression resolving to a Map which we
want to check for non-emptiness mapExpression)Implements org. |
| public <E, C extends Collection | isMember(Expression<E>
element expression elem, Expression<C> expression collection)Implements org. |
| public <E, C extends Collection | isMember(E
element elem, Expression<C> expression collection)Implements org. |
| public <C extends Collection | isNotEmpty(Expression<C>
expression collection)Implements org. |
| public <E, C extends Collection | isNotMember(Expression<E>
element expression elem, Expression<C> expression collection)Implements org. |
| public <E, C extends Collection | isNotMember(E
element elem, Expression<C> expression collection)Implements org. |
| public SqmPredicate | isNotNull(Expression<?>
expression x)Implements org. |
| public SqmPredicate | isNull(Expression<?>
expression x)Implements org. |
| public SqmPredicate | isTrue(Expression<Boolean>
expression to be tested x)Implements org. |
| public <K, M extends Map | keys(M
map map)Implements org. |
| public <T> SqmExpression | lastValue(Expression<T>
argument expression to pass to argument, JpaWindow last_valuewindow over which the function will be applied window)Implements org. last_value window function expression.
|
| public SqmPredicate | le(Expression<? extends Number>
expression x, Expression<? extends Number> expression y)Implements org. |
| public SqmPredicate | le(Expression<? extends Number>
expression x, Number value y)Implements org. |
| public <X extends Comparable | least(Expression<X>
expression representing input value to least
operation argument)Implements org. |
| public SqmFunction | left(Expression<String> x, int length)
Implements org. |
| public SqmFunction | left(Expression<String>
original string x, Expression<Integer> number of characters length)Implements org. length leftmost characters of a string.
|
| public SqmFunction | length(Expression<String>
string expression argument)Implements org. |
| public <Y extends Comparable | lessThan(Expression<? extends Y>
expression x, Expression<? extends Y> expression y)Implements org. |
| public <Y extends Comparable | lessThan(Expression<? extends Y>
expression x, Y value y)Implements org. |
| public <Y extends Comparable | lessThanOrEqualTo(Expression<? extends Y>
expression x, Expression<? extends Y> expression y)Implements org. |
| public <Y extends Comparable | lessThanOrEqualTo(Expression<? extends Y>
expression x, Y value y)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, Expression<String> string expression pattern)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, String string pattern)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, Expression<String> string expression pattern, Expression<Character> escape character expression escapeChar)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, Expression<String> string expression pattern, char escape character escapeChar)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, String string pattern, Expression<Character> escape character expression escapeChar)Implements org. |
| public SqmPredicate | like(Expression<String>
string expression searchString, String string pattern, char escape character escapeChar)Implements org. |
| public SqmExpression | listagg(JpaOrder order, Expression<String> argument, String separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, Expression<String> argument, Expression<String> separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, String separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, JpaPredicate filter, Expression<String> argument, Expression<String> separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, JpaWindow window, Expression<String> argument, String separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
Implements org. |
| public SqmExpression | listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
Implements org. |
| public SqmExpression | 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. listagg ordered set-aggregate function expression.
|
| public <T> SqmLiteral | |
| public <T> SqmLiteral | literal(T
value represented by the expression value)Implements org. |
| public <T> List | |
| public <T> List | |
| public JpaExpression | ln(Expression<? extends Number>
expression x)Implements org. |
| public JpaExpression | localDate()
Implements org. |
| public JpaExpression | localDateTime()
Implements org. |
| public JpaExpression | localTime()
Implements org. |
| public SqmFunction | locate(Expression<String>
expression for string to be searched source, Expression<String> expression for string to be located pattern)Implements org. |
| public SqmFunction | locate(Expression<String>
expression for string to be searched source, String string to be located pattern)Implements org. |
| public SqmFunction | 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. |
| public SqmFunction | 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. |
| private static SessionFactory | |
| public SqmFunction | log(Number b, Expression<? extends Number> x)
Implements org. |
| public SqmFunction | log(Expression<? extends Number>
base b, Expression<? extends Number> expression x)Implements org. x to the base b.
|
| public SqmFunction | log10(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | lower(Expression<String>
string expression x)Implements org. |
| public SqmPredicate | lt(Expression<? extends Number>
expression x, Expression<? extends Number> expression y)Implements org. |
| public SqmPredicate | lt(Expression<? extends Number>
expression x, Number value y)Implements org. |
| public <M extends Map | mapSize(JpaExpression<M>
The expression resolving to a Map for which we
want to know the size mapExpression)Implements org. |
| public <M extends Map | mapSize(M
The Map for which we want to know the size map)Implements org. |
| public <N extends Number> SqmExpression | max(Expression<N>
expression representing input value to max operation argument)Implements org. |
| public <N extends Number> SqmExpression | min(Expression<N>
expression representing input value to min operation argument)Implements org. |
| public SqmFunction | minute(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|
| public SqmExpression | mod(Expression<Integer>
expression x, Expression<Integer> expression y)Implements org. |
| public SqmExpression | mod(Expression<Integer>
expression x, Integer value y)Implements org. |
| public SqmExpression | mod(Integer
value x, Expression<Integer> expression y)Implements org. |
| public <T> SqmExpression | mode(Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | mode(JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | 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. mode ordered set-aggregate function expression.
|
| public SqmFunction | month(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|
| public <N extends Number> SqmExpression | neg(Expression<N>
expression x)Implements org. |
| public SqmPredicate | not(Expression<Boolean>
restriction expression restriction)Implements org. |
| public SqmPredicate | notDistinctFrom(Expression<?> x, Expression<?> y)
Implements org. |
| public SqmPredicate | notDistinctFrom(Expression<?> x, Object y)
Implements org. |
| public SqmPredicate | notEqual(Expression<?>
expression x, Expression<?> expression y)Implements org. |
| public SqmPredicate | notEqual(Expression<?>
expression x, Object object y)Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, Expression<String> pattern)
Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, String pattern)
Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar)
Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, Expression<String> pattern, char escapeChar)
Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, String pattern, Expression<Character> escapeChar)
Implements org. |
| public SqmPredicate | notIlike(Expression<String> x, String pattern, char escapeChar)
Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, Expression<String> string expression pattern)Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, String string pattern)Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, Expression<String> string expression pattern, Expression<Character> escape character expression escapeChar)Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, Expression<String> string expression pattern, char escape character escapeChar)Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, String string pattern, Expression<Character> escape character expression escapeChar)Implements org. |
| public SqmPredicate | notLike(Expression<String>
string expression x, String string pattern, char escape character escapeChar)Implements org. |
| public <T> SqmExpression | nthValue(Expression<T> argument, int n, JpaWindow window)
Implements org. |
| public <T> SqmExpression | nthValue(Expression<T>
argument expression to pass to argument, Expression<Integer> nth_valuethe n, JpaWindow N argument for the functionwindow over which the function will be applied window)Implements org. nth_value window function expression.
|
| public <Y> SqmExpression | nullif(Expression<Y>
expression x, Expression<?> expression y)Implements org. |
| public <Y> SqmExpression | nullif(Expression<Y>
expression x, Y value y)Implements org. |
| public <T> SqmExpression | nullLiteral(Class<T>
type of the null literal resultClass)Implements org. |
| public SqmPredicate | or(Expression<Boolean>
boolean expression x, Expression<Boolean> boolean expression y)Implements org. |
| public SqmPredicate | or(Predicate...
zero or more restriction predicates restrictions)Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, int start)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, Expression<String> replacement, int start)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, Expression<Integer> start)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, int start, int length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, Expression<String> replacement, int start, int length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, Expression<Integer> start, int length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, Expression<String> replacement, Expression<Integer> start, int length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, int start, Expression<Integer> length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, Expression<String> replacement, int start, Expression<Integer> length)
Implements org. |
| public SqmFunction | overlay(Expression<String> string, String replacement, Expression<Integer> start, Expression<Integer> length)
Implements org. |
| public SqmFunction | 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. 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 | pad(Expression<String> x, int length)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
Implements org. |
| public SqmFunction | pad(Expression<String> x, Expression<Integer> length)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
Implements org. |
| public SqmFunction | pad(Expression<String> x, int length, char padChar)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
Implements org. |
| public SqmFunction | pad(Expression<String> x, int length, Expression<Character> padChar)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
Implements org. |
| public SqmFunction | pad(Expression<String> x, Expression<Integer> length, char padChar)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
Implements org. |
| public SqmFunction | pad(Expression<String> x, Expression<Integer> length, Expression<Character> padChar)
Implements org. |
| public SqmFunction | pad(CriteriaBuilder.
string expression to pad x, Expression<Integer> length of the result string after padding length, Expression<Character> optional pad character padChar)Implements org. padChar character if specified.
|
| public <T> JpaCriteriaParameter | parameter(Class<T>
parameter class paramClass)Implements org. |
| public <T> JpaCriteriaParameter | parameter(Class<T>
parameter class paramClass, String name that can be used to refer to
the parameter name)Implements org. |
| public <T> SqmExpression | percentileCont(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | percentileCont(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | 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. percentile_cont ordered set-aggregate function expression.
|
| public <T> SqmExpression | percentileDisc(Expression<? extends Number> argument, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public <T> SqmExpression | 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. percentile_disc ordered set-aggregate function expression.
|
| public SqmExpression | percentRank(JpaWindow
window over which the function will be applied window)Implements org. percent_rank window function expression.
|
| public SqmExpression | percentRank(JpaOrder order, Expression<?>... arguments)
Implements org. |
| public SqmExpression | percentRank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
Implements org. |
| public SqmExpression | percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
Implements org. |
| public SqmExpression | 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. percent_rank ordered set-aggregate function expression.
|
| public SqmFunction | pi()
Implements org. |
| public JpaExpression | power(Expression<? extends Number>
base x, Expression<? extends Number> exponent y)Implements org. |
| public JpaExpression | power(Expression<? extends Number>
base x, Number exponent y)Implements org. |
| public <N extends Number> SqmExpression | prod(Expression<? extends N>
expression x, Expression<? extends N> expression y)Implements org. |
| public <N extends Number> SqmExpression | prod(Expression<? extends N>
expression x, N value y)Implements org. |
| public <N extends Number> SqmExpression | prod(N
value x, Expression<? extends N> expression y)Implements org. |
| public SqmExpression | quot(Expression<? extends Number>
expression x, Expression<? extends Number> expression y)Implements org. |
| public SqmExpression | quot(Expression<? extends Number>
expression x, Number value y)Implements org. |
| public SqmExpression | quot(Number
value x, Expression<? extends Number> expression y)Implements org. |
| public SqmFunction | radians(Expression<? extends Number>
expression x)Implements org. |
| public SqmExpression | rank(JpaWindow
window over which the function will be applied window)Implements org. rank window function expression.
|
| public SqmExpression | rank(JpaOrder order, Expression<?>... arguments)
Implements org. |
| public SqmExpression | rank(JpaOrder order, JpaPredicate filter, Expression<?>... arguments)
Implements org. |
| public SqmExpression | rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
Implements org. |
| public SqmExpression | 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. rank ordered set-aggregate function expression.
|
| private Object | Returns: The resolved node builder to use.Custom serialization hook defined by Java spec. |
| public JpaFunction | repeat(Expression<String>
the string expression to concatenate x, Expression<Integer> the number of times it should be repeated times)Implements org. |
| public JpaFunction | repeat(Expression<String>
the string expression to concatenate x, int the number of times it should be repeated times)Implements org. |
| public JpaFunction | repeat(String
the string expression to concatenate x, Expression<Integer> the number of times it should be repeated times)Implements org. |
| public SqmFunction | replace(Expression<String> x, String pattern, String replacement)
Implements org. |
| public SqmFunction | replace(Expression<String> x, String pattern, Expression<String> replacement)
Implements org. |
| public SqmFunction | replace(Expression<String> x, Expression<String> pattern, String replacement)
Implements org. |
| public SqmFunction | replace(Expression<String>
original string x, Expression<String> the string to be replaced pattern, Expression<String> the new replacement string replacement)Implements org. pattern within the original string with replacement.
|
| private static <T> BindableType | resolveInferredParameterType(T value, SqmExpression<? extends T> typeInferenceSource, TypeConfiguration typeConfiguration)
|
| private static <T> SqmExpressible | resolveInferredType(T value, SqmExpression<? extends T> typeInferenceSource, TypeConfiguration typeConfiguration)
|
| public SqmFunction | right(Expression<String> x, int length)
Implements org. |
| public SqmFunction | right(Expression<String>
original string x, Expression<Integer> number of characters length)Implements org. length rightmost characters of a string.
|
| public <T extends Number> JpaExpression | round(Expression<T>
base x, Integer number of decimal places n)Implements org. |
| public SqmExpression | rowNumber(JpaWindow
window over which the function will be applied window)Implements org. 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. |
| public JpaSearchOrder | search(JpaCteCriteriaAttribute
CTE attribute used to define the ordering sortExpression, SortDirection The sort order sortOrder)Implements org. |
| public JpaSearchOrder | search(JpaCteCriteriaAttribute
CTE attribute used to define the ordering sortExpression)Implements org. |
| public SqmFunction | second(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|
| public <C, R> SqmCaseSimple | selectCase(Expression<? extends C>
to be tested against the case conditions expression)Implements org. |
| public <R> SqmCaseSearched | selectCase()
Implements org. |
| private <T> JpaCriteriaQuery | setOperation(SetOperator operator, CriteriaQuery<? extends T> criteriaQuery, CriteriaQuery<?>... queries)
|
| private <T> JpaSubQuery | |
| public JpaExpression | sign(Expression<? extends Number>
expression x)Implements org. 1 if its argument is
positive, -1 if its argument is negative,
or 0 if its argument is exactly zero.
|
| public SqmFunction | sin(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | sinh(Expression<? extends Number>
expression x)Implements org. |
| public <C extends Collection | size(Expression<C>
expression collection)Implements org. |
| public <C extends Collection | size(C
collection collection)Implements org. |
| public <Y> SqmModifiedSubQueryExpression | some(Subquery<Y>
subquery subquery)Implements org. |
| public SqmSortSpecification | sort(JpaExpression<?> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence)
Implements org. |
| public SqmSortSpecification | sort(JpaExpression<?> sortExpression, SortDirection sortOrder)
Implements org. |
| public SqmSortSpecification | |
| public <T> SqmFunction | sql(String
native SQL pattern pattern, Class<T> type of this expression type, Expression<?>... optional arguments to the SQL pattern arguments)Implements org. pattern that will be unquoted and embedded in the generated SQL.
|
| public SqmExpression | sqrt(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | substring(Expression<String>
string expression source, Expression<Integer> start position expression from)Implements org. |
| public SqmFunction | substring(Expression<String>
string expression source, int start position from)Implements org. |
| public SqmFunction | substring(Expression<String>
string expression source, Expression<Integer> start position expression from, Expression<Integer> length expression len)Implements org. |
| public SqmFunction | substring(Expression<String>
string expression source, int start position from, int length len)Implements org. |
| public <T extends Temporal> JpaExpression | subtractDuration(Expression<T> datetime, Expression<Duration> duration)
Implements org. |
| public <T extends Temporal> JpaExpression | subtractDuration(Expression<T> datetime, Duration duration)
Implements org. |
| public <T extends Temporal> JpaExpression | subtractDuration(T datetime, Expression<Duration> duration)
Implements org. |
| public <N extends Number> SqmExpression | sum(Expression<N>
expression representing input value to sum operation argument)Implements org. |
| public <N extends Number> SqmExpression | sum(Expression<? extends N>
expression x, Expression<? extends N> expression y)Implements org. |
| public <N extends Number> SqmExpression | sum(Expression<? extends N>
expression x, N value y)Implements org. |
| public <N extends Number> SqmExpression | sum(N
value x, Expression<? extends N> expression y)Implements org. |
| public <N extends Number> SqmExpression | sum(Expression<N>
expression argument, JpaPredicate value filter)Implements org. |
| public <N extends Number> SqmExpression | sum(Expression<N>
expression argument, JpaWindow value window)Implements org. |
| public <N extends Number> SqmExpression | 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. sum aggregate function expression.
|
| public SqmExpression | sumAsDouble(Expression<Float>
expression representing input value to sum operation argument)Implements org. |
| public SqmExpression | sumAsLong(Expression<Integer>
expression representing input value to sum operation argument)Implements org. |
| public SqmFunction | tan(Expression<? extends Number>
expression x)Implements org. |
| public SqmFunction | tanh(Expression<? extends Number>
expression x)Implements org. |
| public SqmExpression | toBigDecimal(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toBigInteger(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toDouble(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toFloat(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toInteger(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toLong(Expression<? extends Number>
numeric expression number)Implements org. |
| public SqmExpression | toString(Expression<Character>
expression character)Implements org. |
| public <X, T extends X> SqmPath | treat(Path<X>
path path, Class<T> type to be downcast to type)Implements org. |
| public <X, T extends X> SqmRoot | treat(Root<X>
root root, Class<T> type to be downcast to type)Implements org. |
| public <X, T, V extends T> SqmSingularJoin | treat(Join<X, T>
Join object join, Class<V> type to be downcast to type)Implements org. |
| public <X, T, E extends T> SqmBagJoin | treat(CollectionJoin<X, T>
CollectionJoin object join, Class<E> type to be downcast to type)Implements org. |
| public <X, T, E extends T> SqmSetJoin | treat(SetJoin<X, T>
SetJoin object join, Class<E> type to be downcast to type)Implements org. |
| public <X, T, E extends T> SqmListJoin | treat(ListJoin<X, T>
ListJoin object join, Class<E> type to be downcast to type)Implements org. |
| public <X, K, T, V extends T> SqmMapJoin | treat(MapJoin<X, K, T>
MapJoin object join, Class<V> type to be downcast to type)Implements org. |
| public SqmFunction | trim(Expression<String>
expression for string to trim source)Implements org. |
| public SqmFunction | trim(CriteriaBuilder.
trim specification ts,expression for string to trim source)Implements org. |
| public SqmFunction | trim(Expression<Character>
expression for character to be trimmed trimChar, Expression<String> expression for string to trim source)Implements org. |
| public SqmFunction | trim(CriteriaBuilder.
trim specification ts,expression for character to be trimmed trimChar, Expression<String> expression for string to trim source)Implements org. |
| public SqmFunction | trim(char
character to be trimmed trimChar, Expression<String> expression for string to trim source)Implements org. |
| public SqmFunction | trim(CriteriaBuilder.
trim specification ts,character to be trimmed trimChar, Expression<String> expression for string to trim source)Implements org. |
| public <T extends Number> JpaExpression | truncate(Expression<T>
base x, Integer number of decimal places n)Implements org. |
| public <T extends TemporalAccessor> SqmFunction | truncate(Expression<T>
the date, time or datetime expression to be truncated datetime, TemporalUnit the temporal unit for truncation temporalUnit)Implements org. TemporalUnit.
|
| public JpaCompoundSelection | tuple(Selection<?>[]
selection items selections)Implements org. |
| public JpaCompoundSelection | tuple(List<? extends JpaSelection<?>> selections)
Implements org. |
| public <R> SqmTuple | tuple(Class<R> tupleType, SqmExpression<?>... expressions)
Implements org. |
| public <R> SqmTuple | tuple(Class<R> tupleType, List<? extends SqmExpression<?>> expressions)
Implements org. |
| public <R> SqmTuple | tuple(SqmExpressible<R> tupleType, SqmExpression<?>... expressions)
Implements org. |
| public <R> SqmTuple | tuple(SqmExpressible<R> tupleType, List<? extends SqmExpression<?>> sqmExpressions)
Implements org. |
| public <T> JpaCriteriaQuery | union(boolean all, CriteriaQuery<? extends T> query1, CriteriaQuery<?>... queries)
Implements org. |
| public <T> JpaSubQuery | union(boolean all, Subquery<? extends T> query1, Subquery<?>... queries)
Implements org. |
| public <T extends HibernateCriteriaBuilder> T | |
| public SqmFunction | upper(Expression<String>
string expression x)Implements org. |
| public <T> SqmExpression | value(T value, SqmExpression<? extends T> typeInferenceSource)
Creates an expression for the value with the given "type inference" information |
| public <T> SqmExpression | |
| private <T> ValueBindJpaCriteriaParameter | |
| private <T> ValueBindJpaCriteriaParameter | |
| public <V, C extends Collection | values(C
map collection)Implements org. |
| public <V, M extends Map | values(M
map map)Implements org. |
| public <T> SqmExpression | 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. window.
|
| public SqmPredicate | |
| public final SqmPredicate | |
| public SqmFunction | year(Expression<? extends TemporalAccessor>
the date, time, or datetime to extract the value from datetime)Implements org. org. of a date, time, or datetime expression.
|