Interface HibernateCriteriaBuilder

    • Method Detail

      • createQuery

        JpaCriteriaQuery<Object> createQuery()
        Specified by:
        createQuery in interface jakarta.persistence.criteria.CriteriaBuilder
      • createQuery

        <T> JpaCriteriaQuery<T> createQuery​(Class<T> resultClass)
        Specified by:
        createQuery in interface jakarta.persistence.criteria.CriteriaBuilder
      • createTupleQuery

        JpaCriteriaQuery<jakarta.persistence.Tuple> createTupleQuery()
        Specified by:
        createTupleQuery in interface jakarta.persistence.criteria.CriteriaBuilder
      • createCriteriaUpdate

        <T> JpaCriteriaUpdate<T> createCriteriaUpdate​(Class<T> targetEntity)
        Specified by:
        createCriteriaUpdate in interface jakarta.persistence.criteria.CriteriaBuilder
      • createCriteriaDelete

        <T> JpaCriteriaDelete<T> createCriteriaDelete​(Class<T> targetEntity)
        Specified by:
        createCriteriaDelete in interface jakarta.persistence.criteria.CriteriaBuilder
      • unionAll

        default <T> JpaCriteriaQuery<T> unionAll​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                                 jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • union

        default <T> JpaCriteriaQuery<T> union​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                              jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • union

        <T> JpaCriteriaQuery<T> union​(boolean all,
                                      jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                      jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • intersectAll

        default <T> JpaCriteriaQuery<T> intersectAll​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                                     jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • intersect

        default <T> JpaCriteriaQuery<T> intersect​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                                  jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • intersect

        <T> JpaCriteriaQuery<T> intersect​(boolean all,
                                          jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                          jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • exceptAll

        default <T> JpaCriteriaQuery<T> exceptAll​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                                  jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • except

        default <T> JpaCriteriaQuery<T> except​(jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                               jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • except

        <T> JpaCriteriaQuery<T> except​(boolean all,
                                       jakarta.persistence.criteria.CriteriaQuery<? extends T> query1,
                                       jakarta.persistence.criteria.CriteriaQuery<?>... queries)
      • unionAll

        default <T> JpaSubQuery<T> unionAll​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                            jakarta.persistence.criteria.Subquery<?>... queries)
      • union

        default <T> JpaSubQuery<T> union​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                         jakarta.persistence.criteria.Subquery<?>... queries)
      • union

        <T> JpaSubQuery<T> union​(boolean all,
                                 jakarta.persistence.criteria.Subquery<? extends T> query1,
                                 jakarta.persistence.criteria.Subquery<?>... queries)
      • intersectAll

        default <T> JpaSubQuery<T> intersectAll​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                                jakarta.persistence.criteria.Subquery<?>... queries)
      • intersect

        default <T> JpaSubQuery<T> intersect​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                             jakarta.persistence.criteria.Subquery<?>... queries)
      • intersect

        <T> JpaSubQuery<T> intersect​(boolean all,
                                     jakarta.persistence.criteria.Subquery<? extends T> query1,
                                     jakarta.persistence.criteria.Subquery<?>... queries)
      • exceptAll

        default <T> JpaSubQuery<T> exceptAll​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                             jakarta.persistence.criteria.Subquery<?>... queries)
      • except

        default <T> JpaSubQuery<T> except​(jakarta.persistence.criteria.Subquery<? extends T> query1,
                                          jakarta.persistence.criteria.Subquery<?>... queries)
      • except

        <T> JpaSubQuery<T> except​(boolean all,
                                  jakarta.persistence.criteria.Subquery<? extends T> query1,
                                  jakarta.persistence.criteria.Subquery<?>... queries)
      • sign

        JpaExpression<Integer> sign​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero.
        Specified by:
        sign in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - expression
        Returns:
        sign
      • ceiling

        <N extends NumberJpaExpression<N> ceiling​(jakarta.persistence.criteria.Expression<N> x)
        Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument.
        Specified by:
        ceiling in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - expression
        Returns:
        ceiling
      • floor

        <N extends NumberJpaExpression<N> floor​(jakarta.persistence.criteria.Expression<N> x)
        Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument.
        Specified by:
        floor in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - expression
        Returns:
        floor
      • exp

        JpaExpression<Double> exp​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument.
        Specified by:
        exp in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - expression
        Returns:
        exponential
      • ln

        JpaExpression<Double> ln​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the natural logarithm of its argument.
        Specified by:
        ln in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - expression
        Returns:
        natural logarithm
      • power

        JpaExpression<Double> power​(jakarta.persistence.criteria.Expression<? extends Number> x,
                                    jakarta.persistence.criteria.Expression<? extends Number> y)
        Create an expression that returns the first argument raised to the power of its second argument.
        Specified by:
        power in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - base
        y - exponent
        Returns:
        the base raised to the power of the exponent
      • power

        JpaExpression<Double> power​(jakarta.persistence.criteria.Expression<? extends Number> x,
                                    Number y)
        Create an expression that returns the first argument raised to the power of its second argument.
        Specified by:
        power in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - base
        y - exponent
        Returns:
        the base raised to the power of the exponent
      • round

        <T extends NumberJpaExpression<T> round​(jakarta.persistence.criteria.Expression<T> x,
                                                  Integer n)
        Create an expression that returns the first argument rounded to the number of decimal places given by the second argument.
        Specified by:
        round in interface jakarta.persistence.criteria.CriteriaBuilder
        Parameters:
        x - base
        n - number of decimal places
        Returns:
        the rounded value
      • truncate

        <T extends NumberJpaExpression<T> truncate​(jakarta.persistence.criteria.Expression<T> x,
                                                     Integer n)
        Create an expression that returns the first argument truncated to the number of decimal places given by the second argument.
        Parameters:
        x - base
        n - number of decimal places
        Returns:
        the truncated value
      • localDate

        JpaExpression<LocalDate> localDate()
        Create expression to return current local date.
        Specified by:
        localDate in interface jakarta.persistence.criteria.CriteriaBuilder
        Returns:
        expression for current date
      • localDateTime

        JpaExpression<LocalDateTime> localDateTime()
        Create expression to return current local datetime.
        Specified by:
        localDateTime in interface jakarta.persistence.criteria.CriteriaBuilder
        Returns:
        expression for current timestamp
      • localTime

        JpaExpression<LocalTime> localTime()
        Create expression to return current local time.
        Specified by:
        localTime in interface jakarta.persistence.criteria.CriteriaBuilder
        Returns:
        expression for current time
      • fk

        <P,​F> JpaExpression<F> fk​(jakarta.persistence.criteria.Path<P> path)
      • treat

        <X,​T extends X> JpaPath<T> treat​(jakarta.persistence.criteria.Path<X> path,
                                               Class<T> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​T extends X> JpaRoot<T> treat​(jakarta.persistence.criteria.Root<X> root,
                                               Class<T> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​T,​V extends T> JpaJoin<X,​V> treat​(jakarta.persistence.criteria.Join<X,​T> join,
                                                               Class<V> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​T,​E extends T> JpaCollectionJoin<X,​E> treat​(jakarta.persistence.criteria.CollectionJoin<X,​T> join,
                                                                         Class<E> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​T,​E extends T> JpaSetJoin<X,​E> treat​(jakarta.persistence.criteria.SetJoin<X,​T> join,
                                                                  Class<E> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​T,​E extends T> JpaListJoin<X,​E> treat​(jakarta.persistence.criteria.ListJoin<X,​T> join,
                                                                   Class<E> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • treat

        <X,​K,​T,​V extends T> JpaMapJoin<X,​K,​V> treat​(jakarta.persistence.criteria.MapJoin<X,​K,​T> join,
                                                                                  Class<V> type)
        Specified by:
        treat in interface jakarta.persistence.criteria.CriteriaBuilder
      • construct

        <Y> JpaCompoundSelection<Y> construct​(Class<Y> resultClass,
                                              jakarta.persistence.criteria.Selection<?>[] selections)
        Specified by:
        construct in interface jakarta.persistence.criteria.CriteriaBuilder
      • tuple

        JpaCompoundSelection<jakarta.persistence.Tuple> tuple​(jakarta.persistence.criteria.Selection<?>[] selections)
        Specified by:
        tuple in interface jakarta.persistence.criteria.CriteriaBuilder
      • array

        JpaCompoundSelection<Object[]> array​(jakarta.persistence.criteria.Selection<?>[] selections)
        Specified by:
        array in interface jakarta.persistence.criteria.CriteriaBuilder
      • array

        <Y> JpaCompoundSelection<Y> array​(Class<Y> resultClass,
                                          jakarta.persistence.criteria.Selection<?>[] selections)
      • avg

        <N extends NumberJpaExpression<Double> avg​(jakarta.persistence.criteria.Expression<N> argument)
        Specified by:
        avg in interface jakarta.persistence.criteria.CriteriaBuilder
      • sum

        <N extends NumberJpaExpression<N> sum​(jakarta.persistence.criteria.Expression<N> argument)
        Specified by:
        sum in interface jakarta.persistence.criteria.CriteriaBuilder
      • sumAsLong

        JpaExpression<Long> sumAsLong​(jakarta.persistence.criteria.Expression<Integer> argument)
        Specified by:
        sumAsLong in interface jakarta.persistence.criteria.CriteriaBuilder
      • sumAsDouble

        JpaExpression<Double> sumAsDouble​(jakarta.persistence.criteria.Expression<Float> argument)
        Specified by:
        sumAsDouble in interface jakarta.persistence.criteria.CriteriaBuilder
      • max

        <N extends NumberJpaExpression<N> max​(jakarta.persistence.criteria.Expression<N> argument)
        Specified by:
        max in interface jakarta.persistence.criteria.CriteriaBuilder
      • min

        <N extends NumberJpaExpression<N> min​(jakarta.persistence.criteria.Expression<N> argument)
        Specified by:
        min in interface jakarta.persistence.criteria.CriteriaBuilder
      • greatest

        <X extends Comparable<? super X>> JpaExpression<X> greatest​(jakarta.persistence.criteria.Expression<X> argument)
        Specified by:
        greatest in interface jakarta.persistence.criteria.CriteriaBuilder
      • least

        <X extends Comparable<? super X>> JpaExpression<X> least​(jakarta.persistence.criteria.Expression<X> argument)
        Specified by:
        least in interface jakarta.persistence.criteria.CriteriaBuilder
      • count

        JpaExpression<Long> count​(jakarta.persistence.criteria.Expression<?> argument)
        Specified by:
        count in interface jakarta.persistence.criteria.CriteriaBuilder
      • countDistinct

        JpaExpression<Long> countDistinct​(jakarta.persistence.criteria.Expression<?> x)
        Specified by:
        countDistinct in interface jakarta.persistence.criteria.CriteriaBuilder
      • neg

        <N extends NumberJpaExpression<N> neg​(jakarta.persistence.criteria.Expression<N> x)
        Specified by:
        neg in interface jakarta.persistence.criteria.CriteriaBuilder
      • abs

        <N extends NumberJpaExpression<N> abs​(jakarta.persistence.criteria.Expression<N> x)
        Specified by:
        abs in interface jakarta.persistence.criteria.CriteriaBuilder
      • sum

        <N extends NumberJpaExpression<N> sum​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        sum in interface jakarta.persistence.criteria.CriteriaBuilder
      • sum

        <N extends NumberJpaExpression<N> sum​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                N y)
        Specified by:
        sum in interface jakarta.persistence.criteria.CriteriaBuilder
      • sum

        <N extends NumberJpaExpression<N> sum​(N x,
                                                jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        sum in interface jakarta.persistence.criteria.CriteriaBuilder
      • prod

        <N extends NumberJpaExpression<N> prod​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                 jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        prod in interface jakarta.persistence.criteria.CriteriaBuilder
      • prod

        <N extends NumberJpaExpression<N> prod​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                 N y)
        Specified by:
        prod in interface jakarta.persistence.criteria.CriteriaBuilder
      • prod

        <N extends NumberJpaExpression<N> prod​(N x,
                                                 jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        prod in interface jakarta.persistence.criteria.CriteriaBuilder
      • diff

        <N extends NumberJpaExpression<N> diff​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                 jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        diff in interface jakarta.persistence.criteria.CriteriaBuilder
      • diff

        <N extends NumberJpaExpression<N> diff​(jakarta.persistence.criteria.Expression<? extends N> x,
                                                 N y)
        Specified by:
        diff in interface jakarta.persistence.criteria.CriteriaBuilder
      • diff

        <N extends NumberJpaExpression<N> diff​(N x,
                                                 jakarta.persistence.criteria.Expression<? extends N> y)
        Specified by:
        diff in interface jakarta.persistence.criteria.CriteriaBuilder
      • quot

        JpaExpression<Number> quot​(jakarta.persistence.criteria.Expression<? extends Number> x,
                                   jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        quot in interface jakarta.persistence.criteria.CriteriaBuilder
      • quot

        JpaExpression<Number> quot​(jakarta.persistence.criteria.Expression<? extends Number> x,
                                   Number y)
        Specified by:
        quot in interface jakarta.persistence.criteria.CriteriaBuilder
      • quot

        JpaExpression<Number> quot​(Number x,
                                   jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        quot in interface jakarta.persistence.criteria.CriteriaBuilder
      • mod

        JpaExpression<Integer> mod​(jakarta.persistence.criteria.Expression<Integer> x,
                                   jakarta.persistence.criteria.Expression<Integer> y)
        Specified by:
        mod in interface jakarta.persistence.criteria.CriteriaBuilder
      • mod

        JpaExpression<Integer> mod​(jakarta.persistence.criteria.Expression<Integer> x,
                                   Integer y)
        Specified by:
        mod in interface jakarta.persistence.criteria.CriteriaBuilder
      • mod

        JpaExpression<Integer> mod​(Integer x,
                                   jakarta.persistence.criteria.Expression<Integer> y)
        Specified by:
        mod in interface jakarta.persistence.criteria.CriteriaBuilder
      • sqrt

        JpaExpression<Double> sqrt​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Specified by:
        sqrt in interface jakarta.persistence.criteria.CriteriaBuilder
      • toLong

        JpaExpression<Long> toLong​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toLong in interface jakarta.persistence.criteria.CriteriaBuilder
      • toInteger

        JpaExpression<Integer> toInteger​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toInteger in interface jakarta.persistence.criteria.CriteriaBuilder
      • toFloat

        JpaExpression<Float> toFloat​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toFloat in interface jakarta.persistence.criteria.CriteriaBuilder
      • toDouble

        JpaExpression<Double> toDouble​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toDouble in interface jakarta.persistence.criteria.CriteriaBuilder
      • toBigDecimal

        JpaExpression<BigDecimal> toBigDecimal​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toBigDecimal in interface jakarta.persistence.criteria.CriteriaBuilder
      • toBigInteger

        JpaExpression<BigInteger> toBigInteger​(jakarta.persistence.criteria.Expression<? extends Number> number)
        Specified by:
        toBigInteger in interface jakarta.persistence.criteria.CriteriaBuilder
      • toString

        JpaExpression<String> toString​(jakarta.persistence.criteria.Expression<Character> character)
        Specified by:
        toString in interface jakarta.persistence.criteria.CriteriaBuilder
      • literal

        <T> JpaExpression<T> literal​(T value)
        Specified by:
        literal in interface jakarta.persistence.criteria.CriteriaBuilder
      • nullLiteral

        <T> JpaExpression<T> nullLiteral​(Class<T> resultClass)
        Specified by:
        nullLiteral in interface jakarta.persistence.criteria.CriteriaBuilder
      • parameter

        <T> JpaParameterExpression<T> parameter​(Class<T> paramClass)
        Specified by:
        parameter in interface jakarta.persistence.criteria.CriteriaBuilder
      • parameter

        <T> JpaParameterExpression<T> parameter​(Class<T> paramClass,
                                                String name)
        Specified by:
        parameter in interface jakarta.persistence.criteria.CriteriaBuilder
      • concat

        JpaExpression<String> concat​(jakarta.persistence.criteria.Expression<String> x,
                                     jakarta.persistence.criteria.Expression<String> y)
        Specified by:
        concat in interface jakarta.persistence.criteria.CriteriaBuilder
      • concat

        JpaExpression<String> concat​(jakarta.persistence.criteria.Expression<String> x,
                                     String y)
        Specified by:
        concat in interface jakarta.persistence.criteria.CriteriaBuilder
      • concat

        JpaExpression<String> concat​(String x,
                                     jakarta.persistence.criteria.Expression<String> y)
        Specified by:
        concat in interface jakarta.persistence.criteria.CriteriaBuilder
      • substring

        JpaFunction<String> substring​(jakarta.persistence.criteria.Expression<String> x,
                                      jakarta.persistence.criteria.Expression<Integer> from)
        Specified by:
        substring in interface jakarta.persistence.criteria.CriteriaBuilder
      • substring

        JpaFunction<String> substring​(jakarta.persistence.criteria.Expression<String> x,
                                      int from)
        Specified by:
        substring in interface jakarta.persistence.criteria.CriteriaBuilder
      • substring

        JpaFunction<String> substring​(jakarta.persistence.criteria.Expression<String> x,
                                      jakarta.persistence.criteria.Expression<Integer> from,
                                      jakarta.persistence.criteria.Expression<Integer> len)
        Specified by:
        substring in interface jakarta.persistence.criteria.CriteriaBuilder
      • substring

        JpaFunction<String> substring​(jakarta.persistence.criteria.Expression<String> x,
                                      int from,
                                      int len)
        Specified by:
        substring in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                                 jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(jakarta.persistence.criteria.Expression<Character> t,
                                 jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                                 jakarta.persistence.criteria.Expression<Character> t,
                                 jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(char t,
                                 jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • trim

        JpaFunction<String> trim​(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                                 char t,
                                 jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        trim in interface jakarta.persistence.criteria.CriteriaBuilder
      • lower

        JpaFunction<String> lower​(jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        lower in interface jakarta.persistence.criteria.CriteriaBuilder
      • upper

        JpaFunction<String> upper​(jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        upper in interface jakarta.persistence.criteria.CriteriaBuilder
      • length

        JpaFunction<Integer> length​(jakarta.persistence.criteria.Expression<String> x)
        Specified by:
        length in interface jakarta.persistence.criteria.CriteriaBuilder
      • locate

        JpaFunction<Integer> locate​(jakarta.persistence.criteria.Expression<String> x,
                                    jakarta.persistence.criteria.Expression<String> pattern)
        Specified by:
        locate in interface jakarta.persistence.criteria.CriteriaBuilder
      • locate

        JpaFunction<Integer> locate​(jakarta.persistence.criteria.Expression<String> x,
                                    String pattern)
        Specified by:
        locate in interface jakarta.persistence.criteria.CriteriaBuilder
      • locate

        JpaFunction<Integer> locate​(jakarta.persistence.criteria.Expression<String> x,
                                    jakarta.persistence.criteria.Expression<String> pattern,
                                    jakarta.persistence.criteria.Expression<Integer> from)
        Specified by:
        locate in interface jakarta.persistence.criteria.CriteriaBuilder
      • locate

        JpaFunction<Integer> locate​(jakarta.persistence.criteria.Expression<String> x,
                                    String pattern,
                                    int from)
        Specified by:
        locate in interface jakarta.persistence.criteria.CriteriaBuilder
      • currentDate

        JpaFunction<Date> currentDate()
        Specified by:
        currentDate in interface jakarta.persistence.criteria.CriteriaBuilder
      • currentTime

        JpaFunction<Time> currentTime()
        Specified by:
        currentTime in interface jakarta.persistence.criteria.CriteriaBuilder
      • currentTimestamp

        JpaFunction<Timestamp> currentTimestamp()
        Specified by:
        currentTimestamp in interface jakarta.persistence.criteria.CriteriaBuilder
      • function

        <T> JpaFunction<T> function​(String name,
                                    Class<T> type,
                                    jakarta.persistence.criteria.Expression<?>[] args)
        Specified by:
        function in interface jakarta.persistence.criteria.CriteriaBuilder
      • all

        <Y> JpaExpression<Y> all​(jakarta.persistence.criteria.Subquery<Y> subquery)
        Specified by:
        all in interface jakarta.persistence.criteria.CriteriaBuilder
      • some

        <Y> JpaExpression<Y> some​(jakarta.persistence.criteria.Subquery<Y> subquery)
        Specified by:
        some in interface jakarta.persistence.criteria.CriteriaBuilder
      • any

        <Y> JpaExpression<Y> any​(jakarta.persistence.criteria.Subquery<Y> subquery)
        Specified by:
        any in interface jakarta.persistence.criteria.CriteriaBuilder
      • keys

        <K,​M extends Map<K,​?>> JpaExpression<Set<K>> keys​(M map)
        Specified by:
        keys in interface jakarta.persistence.criteria.CriteriaBuilder
      • values

        <V,​M extends Map<?,​V>> jakarta.persistence.criteria.Expression<Collection<V>> values​(M map)
        Specified by:
        values in interface jakarta.persistence.criteria.CriteriaBuilder
      • size

        <C extends Collection<?>> JpaExpression<Integer> size​(jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        size in interface jakarta.persistence.criteria.CriteriaBuilder
      • size

        <C extends Collection<?>> JpaExpression<Integer> size​(C collection)
        Specified by:
        size in interface jakarta.persistence.criteria.CriteriaBuilder
      • coalesce

        <T> JpaCoalesce<T> coalesce()
        Specified by:
        coalesce in interface jakarta.persistence.criteria.CriteriaBuilder
      • coalesce

        <Y> JpaCoalesce<Y> coalesce​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                    jakarta.persistence.criteria.Expression<? extends Y> y)
        Specified by:
        coalesce in interface jakarta.persistence.criteria.CriteriaBuilder
      • coalesce

        <Y> JpaCoalesce<Y> coalesce​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                    Y y)
        Specified by:
        coalesce in interface jakarta.persistence.criteria.CriteriaBuilder
      • nullif

        <Y> JpaExpression<Y> nullif​(jakarta.persistence.criteria.Expression<Y> x,
                                    jakarta.persistence.criteria.Expression<?> y)
        Specified by:
        nullif in interface jakarta.persistence.criteria.CriteriaBuilder
      • nullif

        <Y> JpaExpression<Y> nullif​(jakarta.persistence.criteria.Expression<Y> x,
                                    Y y)
        Specified by:
        nullif in interface jakarta.persistence.criteria.CriteriaBuilder
      • selectCase

        <C,​R> JpaSimpleCase<C,​R> selectCase​(jakarta.persistence.criteria.Expression<? extends C> expression)
        Specified by:
        selectCase in interface jakarta.persistence.criteria.CriteriaBuilder
      • selectCase

        <R> JpaSearchedCase<R> selectCase()
        Specified by:
        selectCase in interface jakarta.persistence.criteria.CriteriaBuilder
      • and

        JpaPredicate and​(jakarta.persistence.criteria.Expression<Boolean> x,
                         jakarta.persistence.criteria.Expression<Boolean> y)
        Specified by:
        and in interface jakarta.persistence.criteria.CriteriaBuilder
      • and

        JpaPredicate and​(jakarta.persistence.criteria.Predicate... restrictions)
        Specified by:
        and in interface jakarta.persistence.criteria.CriteriaBuilder
      • or

        JpaPredicate or​(jakarta.persistence.criteria.Expression<Boolean> x,
                        jakarta.persistence.criteria.Expression<Boolean> y)
        Specified by:
        or in interface jakarta.persistence.criteria.CriteriaBuilder
      • or

        JpaPredicate or​(jakarta.persistence.criteria.Predicate... restrictions)
        Specified by:
        or in interface jakarta.persistence.criteria.CriteriaBuilder
      • not

        JpaPredicate not​(jakarta.persistence.criteria.Expression<Boolean> restriction)
        Specified by:
        not in interface jakarta.persistence.criteria.CriteriaBuilder
      • conjunction

        JpaPredicate conjunction()
        Specified by:
        conjunction in interface jakarta.persistence.criteria.CriteriaBuilder
      • disjunction

        JpaPredicate disjunction()
        Specified by:
        disjunction in interface jakarta.persistence.criteria.CriteriaBuilder
      • isTrue

        JpaPredicate isTrue​(jakarta.persistence.criteria.Expression<Boolean> x)
        Specified by:
        isTrue in interface jakarta.persistence.criteria.CriteriaBuilder
      • isFalse

        JpaPredicate isFalse​(jakarta.persistence.criteria.Expression<Boolean> x)
        Specified by:
        isFalse in interface jakarta.persistence.criteria.CriteriaBuilder
      • isNull

        JpaPredicate isNull​(jakarta.persistence.criteria.Expression<?> x)
        Specified by:
        isNull in interface jakarta.persistence.criteria.CriteriaBuilder
      • isNotNull

        JpaPredicate isNotNull​(jakarta.persistence.criteria.Expression<?> x)
        Specified by:
        isNotNull in interface jakarta.persistence.criteria.CriteriaBuilder
      • equal

        JpaPredicate equal​(jakarta.persistence.criteria.Expression<?> x,
                           jakarta.persistence.criteria.Expression<?> y)
        Specified by:
        equal in interface jakarta.persistence.criteria.CriteriaBuilder
      • equal

        JpaPredicate equal​(jakarta.persistence.criteria.Expression<?> x,
                           Object y)
        Specified by:
        equal in interface jakarta.persistence.criteria.CriteriaBuilder
      • notEqual

        JpaPredicate notEqual​(jakarta.persistence.criteria.Expression<?> x,
                              jakarta.persistence.criteria.Expression<?> y)
        Specified by:
        notEqual in interface jakarta.persistence.criteria.CriteriaBuilder
      • notEqual

        JpaPredicate notEqual​(jakarta.persistence.criteria.Expression<?> x,
                              Object y)
        Specified by:
        notEqual in interface jakarta.persistence.criteria.CriteriaBuilder
      • distinctFrom

        JpaPredicate distinctFrom​(jakarta.persistence.criteria.Expression<?> x,
                                  jakarta.persistence.criteria.Expression<?> y)
      • distinctFrom

        JpaPredicate distinctFrom​(jakarta.persistence.criteria.Expression<?> x,
                                  Object y)
      • notDistinctFrom

        JpaPredicate notDistinctFrom​(jakarta.persistence.criteria.Expression<?> x,
                                     jakarta.persistence.criteria.Expression<?> y)
      • notDistinctFrom

        JpaPredicate notDistinctFrom​(jakarta.persistence.criteria.Expression<?> x,
                                     Object y)
      • greaterThan

        <Y extends Comparable<? super Y>> JpaPredicate greaterThan​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                   jakarta.persistence.criteria.Expression<? extends Y> y)
        Specified by:
        greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder
      • greaterThan

        <Y extends Comparable<? super Y>> JpaPredicate greaterThan​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                   Y y)
        Specified by:
        greaterThan in interface jakarta.persistence.criteria.CriteriaBuilder
      • greaterThanOrEqualTo

        <Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                            jakarta.persistence.criteria.Expression<? extends Y> y)
        Specified by:
        greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder
      • greaterThanOrEqualTo

        <Y extends Comparable<? super Y>> JpaPredicate greaterThanOrEqualTo​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                            Y y)
        Specified by:
        greaterThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder
      • lessThan

        <Y extends Comparable<? super Y>> JpaPredicate lessThan​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                jakarta.persistence.criteria.Expression<? extends Y> y)
        Specified by:
        lessThan in interface jakarta.persistence.criteria.CriteriaBuilder
      • lessThan

        <Y extends Comparable<? super Y>> JpaPredicate lessThan​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                Y y)
        Specified by:
        lessThan in interface jakarta.persistence.criteria.CriteriaBuilder
      • lessThanOrEqualTo

        <Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                         jakarta.persistence.criteria.Expression<? extends Y> y)
        Specified by:
        lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder
      • lessThanOrEqualTo

        <Y extends Comparable<? super Y>> JpaPredicate lessThanOrEqualTo​(jakarta.persistence.criteria.Expression<? extends Y> x,
                                                                         Y y)
        Specified by:
        lessThanOrEqualTo in interface jakarta.persistence.criteria.CriteriaBuilder
      • between

        <Y extends Comparable<? super Y>> JpaPredicate between​(jakarta.persistence.criteria.Expression<? extends Y> value,
                                                               jakarta.persistence.criteria.Expression<? extends Y> lower,
                                                               jakarta.persistence.criteria.Expression<? extends Y> upper)
        Specified by:
        between in interface jakarta.persistence.criteria.CriteriaBuilder
      • between

        <Y extends Comparable<? super Y>> JpaPredicate between​(jakarta.persistence.criteria.Expression<? extends Y> value,
                                                               Y lower,
                                                               Y upper)
        Specified by:
        between in interface jakarta.persistence.criteria.CriteriaBuilder
      • gt

        JpaPredicate gt​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        gt in interface jakarta.persistence.criteria.CriteriaBuilder
      • gt

        JpaPredicate gt​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        Number y)
        Specified by:
        gt in interface jakarta.persistence.criteria.CriteriaBuilder
      • ge

        JpaPredicate ge​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        ge in interface jakarta.persistence.criteria.CriteriaBuilder
      • ge

        JpaPredicate ge​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        Number y)
        Specified by:
        ge in interface jakarta.persistence.criteria.CriteriaBuilder
      • lt

        JpaPredicate lt​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        lt in interface jakarta.persistence.criteria.CriteriaBuilder
      • lt

        JpaPredicate lt​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        Number y)
        Specified by:
        lt in interface jakarta.persistence.criteria.CriteriaBuilder
      • le

        JpaPredicate le​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        jakarta.persistence.criteria.Expression<? extends Number> y)
        Specified by:
        le in interface jakarta.persistence.criteria.CriteriaBuilder
      • le

        JpaPredicate le​(jakarta.persistence.criteria.Expression<? extends Number> x,
                        Number y)
        Specified by:
        le in interface jakarta.persistence.criteria.CriteriaBuilder
      • isEmpty

        <C extends Collection<?>> JpaPredicate isEmpty​(jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isEmpty in interface jakarta.persistence.criteria.CriteriaBuilder
      • isNotEmpty

        <C extends Collection<?>> JpaPredicate isNotEmpty​(jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isNotEmpty in interface jakarta.persistence.criteria.CriteriaBuilder
      • isMember

        <E,​C extends Collection<E>> JpaPredicate isMember​(jakarta.persistence.criteria.Expression<E> elem,
                                                                jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isMember in interface jakarta.persistence.criteria.CriteriaBuilder
      • isMember

        <E,​C extends Collection<E>> JpaPredicate isMember​(E elem,
                                                                jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isMember in interface jakarta.persistence.criteria.CriteriaBuilder
      • isNotMember

        <E,​C extends Collection<E>> JpaPredicate isNotMember​(jakarta.persistence.criteria.Expression<E> elem,
                                                                   jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder
      • isNotMember

        <E,​C extends Collection<E>> JpaPredicate isNotMember​(E elem,
                                                                   jakarta.persistence.criteria.Expression<C> collection)
        Specified by:
        isNotMember in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          jakarta.persistence.criteria.Expression<String> pattern)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          String pattern)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          jakarta.persistence.criteria.Expression<String> pattern,
                          jakarta.persistence.criteria.Expression<Character> escapeChar)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          jakarta.persistence.criteria.Expression<String> pattern,
                          char escapeChar)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          String pattern,
                          jakarta.persistence.criteria.Expression<Character> escapeChar)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • like

        JpaPredicate like​(jakarta.persistence.criteria.Expression<String> x,
                          String pattern,
                          char escapeChar)
        Specified by:
        like in interface jakarta.persistence.criteria.CriteriaBuilder
      • ilike

        JpaPredicate ilike​(jakarta.persistence.criteria.Expression<String> x,
                           jakarta.persistence.criteria.Expression<String> pattern)
      • ilike

        JpaPredicate ilike​(jakarta.persistence.criteria.Expression<String> x,
                           jakarta.persistence.criteria.Expression<String> pattern,
                           jakarta.persistence.criteria.Expression<Character> escapeChar)
      • ilike

        JpaPredicate ilike​(jakarta.persistence.criteria.Expression<String> x,
                           jakarta.persistence.criteria.Expression<String> pattern,
                           char escapeChar)
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             jakarta.persistence.criteria.Expression<String> pattern)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             String pattern)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             jakarta.persistence.criteria.Expression<String> pattern,
                             jakarta.persistence.criteria.Expression<Character> escapeChar)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             jakarta.persistence.criteria.Expression<String> pattern,
                             char escapeChar)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             String pattern,
                             jakarta.persistence.criteria.Expression<Character> escapeChar)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notLike

        JpaPredicate notLike​(jakarta.persistence.criteria.Expression<String> x,
                             String pattern,
                             char escapeChar)
        Specified by:
        notLike in interface jakarta.persistence.criteria.CriteriaBuilder
      • notIlike

        JpaPredicate notIlike​(jakarta.persistence.criteria.Expression<String> x,
                              jakarta.persistence.criteria.Expression<String> pattern)
      • notIlike

        JpaPredicate notIlike​(jakarta.persistence.criteria.Expression<String> x,
                              jakarta.persistence.criteria.Expression<String> pattern,
                              jakarta.persistence.criteria.Expression<Character> escapeChar)
      • notIlike

        JpaPredicate notIlike​(jakarta.persistence.criteria.Expression<String> x,
                              jakarta.persistence.criteria.Expression<String> pattern,
                              char escapeChar)
      • notIlike

        JpaPredicate notIlike​(jakarta.persistence.criteria.Expression<String> x,
                              String pattern,
                              jakarta.persistence.criteria.Expression<Character> escapeChar)
      • notIlike

        JpaPredicate notIlike​(jakarta.persistence.criteria.Expression<String> x,
                              String pattern,
                              char escapeChar)
      • in

        <T> JpaInPredicate<T> in​(jakarta.persistence.criteria.Expression<? extends T> expression)
        Specified by:
        in in interface jakarta.persistence.criteria.CriteriaBuilder
      • in

        <T> JpaInPredicate<T> in​(jakarta.persistence.criteria.Expression<? extends T> expression,
                                 jakarta.persistence.criteria.Expression<? extends T>... values)
      • in

        <T> JpaInPredicate<T> in​(jakarta.persistence.criteria.Expression<? extends T> expression,
                                 T... values)
      • in

        <T> JpaInPredicate<T> in​(jakarta.persistence.criteria.Expression<? extends T> expression,
                                 Collection<T> values)
      • exists

        JpaPredicate exists​(jakarta.persistence.criteria.Subquery<?> subquery)
        Specified by:
        exists in interface jakarta.persistence.criteria.CriteriaBuilder
      • isMapEmpty

        <M extends Map<?,​?>> JpaPredicate isMapEmpty​(JpaExpression<M> mapExpression)
        Create a predicate that tests whether a Map is empty.

        NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isEmpty(jakarta.persistence.criteria.Expression<C>)

        Parameters:
        mapExpression - The expression resolving to a Map which we want to check for emptiness
        Returns:
        is-empty predicate
      • isMapNotEmpty

        <M extends Map<?,​?>> JpaPredicate isMapNotEmpty​(JpaExpression<M> mapExpression)
        Create a predicate that tests whether a Map is not empty.

        NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.isNotEmpty(jakarta.persistence.criteria.Expression<C>)

        Parameters:
        mapExpression - The expression resolving to a Map which we want to check for non-emptiness
        Returns:
        is-not-empty predicate
      • mapSize

        <M extends Map<?,​?>> JpaExpression<Integer> mapSize​(JpaExpression<M> mapExpression)
        Create an expression that tests the size of a map.

        NOTE : Due to type-erasure we cannot name this the same as CriteriaBuilder.size(jakarta.persistence.criteria.Expression<C>)

        Parameters:
        mapExpression - The expression resolving to a Map for which we want to know the size
        Returns:
        size expression
      • mapSize

        <M extends Map<?,​?>> JpaExpression<Integer> mapSize​(M map)
        Create an expression that tests the size of a map.
        Parameters:
        map - The Map for which we want to know the size
        Returns:
        size expression
      • asc

        JpaOrder asc​(jakarta.persistence.criteria.Expression<?> x)
        Specified by:
        asc in interface jakarta.persistence.criteria.CriteriaBuilder
      • desc

        JpaOrder desc​(jakarta.persistence.criteria.Expression<?> x)
        Specified by:
        desc in interface jakarta.persistence.criteria.CriteriaBuilder
      • asc

        JpaOrder asc​(jakarta.persistence.criteria.Expression<?> x,
                     boolean nullsFirst)
        Create an ordering by the ascending value of the expression.
        Parameters:
        x - expression used to define the ordering
        nullsFirst - Whether null should be sorted first
        Returns:
        ascending ordering corresponding to the expression
      • desc

        JpaOrder desc​(jakarta.persistence.criteria.Expression<?> x,
                      boolean nullsFirst)
        Create an ordering by the descending value of the expression.
        Parameters:
        x - expression used to define the ordering
        nullsFirst - Whether null should be sorted first
        Returns:
        descending ordering corresponding to the expression
      • search

        JpaSearchOrder search​(JpaCteCriteriaAttribute cteAttribute,
                              SortOrder sortOrder,
                              NullPrecedence nullPrecedence)
        Create a search ordering based on the sort order and null precedence of the value of the CTE attribute.
        Parameters:
        cteAttribute - CTE attribute used to define the ordering
        sortOrder - The sort order
        nullPrecedence - The null precedence
        Returns:
        ordering corresponding to the CTE attribute
      • search

        JpaSearchOrder search​(JpaCteCriteriaAttribute cteAttribute,
                              SortOrder sortOrder)
        Create a search ordering based on the sort order of the value of the CTE attribute.
        Parameters:
        cteAttribute - CTE attribute used to define the ordering
        sortOrder - The sort order
        Returns:
        ordering corresponding to the CTE attribute
      • search

        JpaSearchOrder search​(JpaCteCriteriaAttribute cteAttribute)
        Create a search ordering based on the ascending value of the CTE attribute.
        Parameters:
        cteAttribute - CTE attribute used to define the ordering
        Returns:
        ascending ordering corresponding to the CTE attribute
      • asc

        JpaSearchOrder asc​(JpaCteCriteriaAttribute x)
        Create a search ordering by the ascending value of the CTE attribute.
        Parameters:
        x - CTE attribute used to define the ordering
        Returns:
        ascending ordering corresponding to the CTE attribute
      • desc

        JpaSearchOrder desc​(JpaCteCriteriaAttribute x)
        Create a search ordering by the descending value of the CTE attribute.
        Parameters:
        x - CTE attribute used to define the ordering
        Returns:
        descending ordering corresponding to the CTE attribute
      • asc

        JpaSearchOrder asc​(JpaCteCriteriaAttribute x,
                           boolean nullsFirst)
        Create a search ordering by the ascending value of the CTE attribute.
        Parameters:
        x - CTE attribute used to define the ordering
        nullsFirst - Whether null should be sorted first
        Returns:
        ascending ordering corresponding to the CTE attribute
      • desc

        JpaSearchOrder desc​(JpaCteCriteriaAttribute x,
                            boolean nullsFirst)
        Create a search ordering by the descending value of the CTE attribute.
        Parameters:
        x - CTE attribute used to define the ordering
        nullsFirst - Whether null should be sorted first
        Returns:
        descending ordering corresponding to the CTE attribute
      • sql

        <T> JpaExpression<T> sql​(String pattern,
                                 Class<T> type,
                                 jakarta.persistence.criteria.Expression<?>... arguments)
        Embed native pattern that will be unquoted and embedded in the generated SQL. Occurrences of ? in the pattern are replaced with the remaining arguments of the function.
        Type Parameters:
        T - type of this expression
        Parameters:
        pattern - native SQL pattern
        type - type of this expression
        arguments - optional arguments to the SQL pattern
        Returns:
        native SQL expression
      • year

        JpaFunction<Integer> year​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.YEAR of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • month

        JpaFunction<Integer> month​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.MONTH of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • day

        JpaFunction<Integer> day​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.DAY of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • hour

        JpaFunction<Integer> hour​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.HOUR of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • minute

        JpaFunction<Integer> minute​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.MINUTE of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • second

        JpaFunction<Float> second​(jakarta.persistence.criteria.Expression<? extends TemporalAccessor> datetime)
        Extracts the TemporalUnit.SECOND of a date, time, or datetime expression.
        Parameters:
        datetime - the date, time, or datetime to extract the value from
        Returns:
        the extracted value
      • overlay

        JpaFunction<String> overlay​(jakarta.persistence.criteria.Expression<String> string,
                                    jakarta.persistence.criteria.Expression<String> replacement,
                                    jakarta.persistence.criteria.Expression<Integer> start,
                                    jakarta.persistence.criteria.Expression<Integer> length)
        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.
        Parameters:
        string - string expression to be manipulated
        replacement - string expression to replace in original
        start - start position
        length - optional, number of characters to substitute
        Returns:
        overlay expression
      • pad

        JpaFunction<String> pad​(jakarta.persistence.criteria.CriteriaBuilder.Trimspec ts,
                                jakarta.persistence.criteria.Expression<String> x,
                                jakarta.persistence.criteria.Expression<Integer> length,
                                jakarta.persistence.criteria.Expression<Character> padChar)
        Pad the specified string expression with whitespace or with the padChar character if specified. Optionally pass a CriteriaBuilder.Trimspec to pad the string expression with LEADING or TRAILING (default) characters.
        Parameters:
        ts - optional CriteriaBuilder.Trimspec
        x - string expression to pad
        length - length of the result string after padding
        padChar - optional pad character
        Returns:
        pad expression
      • left

        JpaFunction<String> left​(jakarta.persistence.criteria.Expression<String> x,
                                 jakarta.persistence.criteria.Expression<Integer> length)
        Extract the length leftmost characters of a string.
        Parameters:
        x - original string
        length - number of characters
        Returns:
        left expression
      • right

        JpaFunction<String> right​(jakarta.persistence.criteria.Expression<String> x,
                                  jakarta.persistence.criteria.Expression<Integer> length)
        Extract the length rightmost characters of a string.
        Parameters:
        x - original string
        length - number of characters
        Returns:
        left expression
      • replace

        JpaFunction<String> replace​(jakarta.persistence.criteria.Expression<String> x,
                                    jakarta.persistence.criteria.Expression<String> pattern,
                                    jakarta.persistence.criteria.Expression<String> replacement)
        Replace all occurrences of pattern within the original string with replacement.
        Parameters:
        x - original string
        pattern - the string to be replaced
        replacement - the new replacement string
        Returns:
        replace expression
      • log10

        JpaExpression<Double> log10​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the base-10 logarithm of its argument.
        Parameters:
        x - expression
        Returns:
        base-10 logarithm
      • log

        JpaExpression<Double> log​(jakarta.persistence.criteria.Expression<? extends Number> b,
                                  jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the logarithm of x to the base b.
        Parameters:
        b - base
        x - expression
        Returns:
        arbitrary-base logarithm
      • pi

        JpaExpression<Double> pi()
        Literal expression corresponding to the value of pi.
        Returns:
        pi expression
      • sin

        JpaExpression<Double> sin​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the sine of its argument.
        Parameters:
        x - expression
        Returns:
        sine
      • cos

        JpaExpression<Double> cos​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the cosine of its argument.
        Parameters:
        x - expression
        Returns:
        cosine
      • tan

        JpaExpression<Double> tan​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the tangent of its argument.
        Parameters:
        x - expression
        Returns:
        tangent
      • asin

        JpaExpression<Double> asin​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the inverse sine of its argument.
        Parameters:
        x - expression
        Returns:
        inverse sine
      • acos

        JpaExpression<Double> acos​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the inverse cosine of its argument.
        Parameters:
        x - expression
        Returns:
        inverse cosine
      • atan

        JpaExpression<Double> atan​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the inverse tangent of its argument.
        Parameters:
        x - expression
        Returns:
        inverse tangent
      • atan2

        JpaExpression<Double> atan2​(jakarta.persistence.criteria.Expression<? extends Number> y,
                                    jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the inverse tangent of y over x.
        Parameters:
        y - y coordinate
        x - x coordinate
        Returns:
        2-argument inverse tangent
      • sinh

        JpaExpression<Double> sinh​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the hyperbolic sine of its argument.
        Parameters:
        x - expression
        Returns:
        hyperbolic sine
      • cosh

        JpaExpression<Double> cosh​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the hyperbolic cosine of its argument.
        Parameters:
        x - expression
        Returns:
        hyperbolic cosine
      • tanh

        JpaExpression<Double> tanh​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that returns the hyperbolic tangent of its argument.
        Parameters:
        x - expression
        Returns:
        hyperbolic tangent
      • degrees

        JpaExpression<Double> degrees​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that converts an angle measured in radians to an approximately equivalent angle measured in degrees.
        Parameters:
        x - expression
        Returns:
        degrees
      • radians

        JpaExpression<Double> radians​(jakarta.persistence.criteria.Expression<? extends Number> x)
        Create an expression that converts an angle measured in degrees to an approximately equivalent angle measured in radians.
        Parameters:
        x - expression
        Returns:
        radians
      • createWindow

        JpaWindow createWindow()
        Create an empty JpaWindow to use with window and aggregate functions.
        Returns:
        the empty window
      • frameBetweenPreceding

        JpaWindowFrame frameBetweenPreceding​(jakarta.persistence.criteria.Expression<?> offset)
        Create window frame of type FrameKind.OFFSET_PRECEDING to use with JpaWindows.
        Parameters:
        offset - the offset expression
        Returns:
        the window frame
      • frameBetweenFollowing

        JpaWindowFrame frameBetweenFollowing​(jakarta.persistence.criteria.Expression<?> offset)
        Create a window frame of type FrameKind.OFFSET_FOLLOWING to use with JpaWindows.
        Parameters:
        offset - the offset expression
        Returns:
        the window frame
      • windowFunction

        <T> JpaExpression<T> windowFunction​(String name,
                                            Class<T> type,
                                            JpaWindow window,
                                            jakarta.persistence.criteria.Expression<?>... args)
        Create a generic window function expression that will be applied over the specified window.
        Type Parameters:
        T - type of this expression
        Parameters:
        name - name of the window function
        type - type of this expression
        window - window over which the function will be applied
        args - arguments to the function
        Returns:
        window function expression
      • functionAggregate

        <T> JpaExpression<T> functionAggregate​(String name,
                                               Class<T> type,
                                               JpaPredicate filter,
                                               JpaWindow window,
                                               jakarta.persistence.criteria.Expression<?>... args)
        Create a generic aggregate function expression.
        Type Parameters:
        T - type of this expression
        Parameters:
        name - name of the ordered set-aggregate function
        type - type of this expression
        filter - optional filter clause
        window - optional window over which to apply the function
        args - optional arguments to the function
        Returns:
        aggregate function expression
      • functionWithinGroup

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