javax.persistence.criteria
Interface CriteriaBuilder


public interface CriteriaBuilder

Interface to build criteria.

Since:
JPA 2.0

Nested Class Summary
static interface CriteriaBuilder.Case<R>
           
static interface CriteriaBuilder.Coalesce<T>
           
static interface CriteriaBuilder.In<T>
           
static interface CriteriaBuilder.SimpleCase<C,R>
           
static class CriteriaBuilder.Trimspec
           
 
Method Summary
<N extends java.lang.Number>
Expression<N>
abs(Expression<N> x)
           
<Y> Expression<Y>
all(Subquery<Y> subquery)
           
 Predicate and(Expression<java.lang.Boolean> x, Expression<java.lang.Boolean> y)
           
 Predicate and(Predicate... restrictions)
           
<Y> Expression<Y>
any(Subquery<Y> subquery)
           
 CompoundSelection<java.lang.Object[]> array(Selection<?>... selections)
           
 Order asc(Expression<?> x)
           
<N extends java.lang.Number>
Expression<java.lang.Double>
avg(Expression<N> x)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
between(Expression<? extends Y> v, Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
between(Expression<? extends Y> v, Y x, Y y)
           
<T> CriteriaBuilder.Coalesce<T>
coalesce()
           
<Y> Expression<Y>
coalesce(Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y> Expression<Y>
coalesce(Expression<? extends Y> x, Y y)
           
 Expression<java.lang.String> concat(Expression<java.lang.String> x, Expression<java.lang.String> y)
           
 Expression<java.lang.String> concat(Expression<java.lang.String> x, java.lang.String y)
           
 Expression<java.lang.String> concat(java.lang.String x, Expression<java.lang.String> y)
           
 Predicate conjunction()
           
<Y> CompoundSelection<Y>
construct(java.lang.Class<Y> resultClass, Selection<?>... selections)
           
 Expression<java.lang.Long> count(Expression<?> x)
           
 Expression<java.lang.Long> countDistinct(Expression<?> x)
           
 CriteriaQuery<java.lang.Object> createQuery()
           
<T> CriteriaQuery<T>
createQuery(java.lang.Class<T> resultClass)
           
 CriteriaQuery<Tuple> createTupleQuery()
           
 Expression<java.sql.Date> currentDate()
           
 Expression<java.sql.Time> currentTime()
           
 Expression<java.sql.Timestamp> currentTimestamp()
           
 Order desc(Expression<?> x)
           
<N extends java.lang.Number>
Expression<N>
diff(Expression<? extends N> x, Expression<? extends N> y)
           
<N extends java.lang.Number>
Expression<N>
diff(Expression<? extends N> x, N y)
           
<N extends java.lang.Number>
Expression<N>
diff(N x, Expression<? extends N> y)
           
 Predicate disjunction()
           
 Predicate equal(Expression<?> x, Expression<?> y)
           
 Predicate equal(Expression<?> x, java.lang.Object y)
           
 Predicate exists(Subquery<?> subquery)
           
<T> Expression<T>
function(java.lang.String name, java.lang.Class<T> type, Expression<?>... args)
           
 Predicate ge(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
           
 Predicate ge(Expression<? extends java.lang.Number> x, java.lang.Number y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
greaterThan(Expression<? extends Y> x, Y y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
greaterThanOrEqualTo(Expression<? extends Y> x, Y y)
           
<X extends java.lang.Comparable<? super X>>
Expression<X>
greatest(Expression<X> x)
           
 Predicate gt(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
           
 Predicate gt(Expression<? extends java.lang.Number> x, java.lang.Number y)
           
<T> CriteriaBuilder.In<T>
in(Expression<? extends T> expression)
           
<C extends java.util.Collection<?>>
Predicate
isEmpty(Expression<C> collection)
           
 Predicate isFalse(Expression<java.lang.Boolean> x)
           
<E,C extends java.util.Collection<E>>
Predicate
isMember(E elem, Expression<C> collection)
           
<E,C extends java.util.Collection<E>>
Predicate
isMember(Expression<E> elem, Expression<C> collection)
           
<C extends java.util.Collection<?>>
Predicate
isNotEmpty(Expression<C> collection)
           
<E,C extends java.util.Collection<E>>
Predicate
isNotMember(E elem, Expression<C> collection)
           
<E,C extends java.util.Collection<E>>
Predicate
isNotMember(Expression<E> elem, Expression<C> collection)
           
 Predicate isNotNull(Expression<?> x)
           
 Predicate isNull(Expression<?> x)
           
 Predicate isTrue(Expression<java.lang.Boolean> x)
           
<K,M extends java.util.Map<K,?>>
Expression<java.util.Set<K>>
keys(M map)
           
 Predicate le(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
           
 Predicate le(Expression<? extends java.lang.Number> x, java.lang.Number y)
           
<X extends java.lang.Comparable<? super X>>
Expression<X>
least(Expression<X> x)
           
 Expression<java.lang.Integer> length(Expression<java.lang.String> x)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
lessThan(Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
lessThan(Expression<? extends Y> x, Y y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)
           
<Y extends java.lang.Comparable<? super Y>>
Predicate
lessThanOrEqualTo(Expression<? extends Y> x, Y y)
           
 Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
           
 Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern, char escapeChar)
           
 Predicate like(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Character> escapeChar)
           
 Predicate like(Expression<java.lang.String> x, java.lang.String pattern)
           
 Predicate like(Expression<java.lang.String> x, java.lang.String pattern, char escapeChar)
           
 Predicate like(Expression<java.lang.String> x, java.lang.String pattern, Expression<java.lang.Character> escapeChar)
           
<T> Expression<T>
literal(T value)
           
 Expression<java.lang.Integer> locate(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
           
 Expression<java.lang.Integer> locate(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Integer> from)
           
 Expression<java.lang.Integer> locate(Expression<java.lang.String> x, java.lang.String pattern)
           
 Expression<java.lang.Integer> locate(Expression<java.lang.String> x, java.lang.String pattern, int from)
           
 Expression<java.lang.String> lower(Expression<java.lang.String> x)
           
 Predicate lt(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
           
 Predicate lt(Expression<? extends java.lang.Number> x, java.lang.Number y)
           
<N extends java.lang.Number>
Expression<N>
max(Expression<N> x)
           
<N extends java.lang.Number>
Expression<N>
min(Expression<N> x)
           
 Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x, Expression<java.lang.Integer> y)
           
 Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x, java.lang.Integer y)
           
 Expression<java.lang.Integer> mod(java.lang.Integer x, Expression<java.lang.Integer> y)
           
<N extends java.lang.Number>
Expression<N>
neg(Expression<N> x)
           
 Predicate not(Expression<java.lang.Boolean> restriction)
           
 Predicate notEqual(Expression<?> x, Expression<?> y)
           
 Predicate notEqual(Expression<?> x, java.lang.Object y)
           
 Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern)
           
 Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern, char escapeChar)
           
 Predicate notLike(Expression<java.lang.String> x, Expression<java.lang.String> pattern, Expression<java.lang.Character> escapeChar)
           
 Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern)
           
 Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern, char escapeChar)
           
 Predicate notLike(Expression<java.lang.String> x, java.lang.String pattern, Expression<java.lang.Character> escapeChar)
           
<Y> Expression<Y>
nullif(Expression<Y> x, Expression<?> y)
           
<Y> Expression<Y>
nullif(Expression<Y> x, Y y)
           
<T> Expression<T>
nullLiteral(java.lang.Class<T> resultClass)
           
 Predicate or(Expression<java.lang.Boolean> x, Expression<java.lang.Boolean> y)
           
 Predicate or(Predicate... restrictions)
           
<T> ParameterExpression<T>
parameter(java.lang.Class<T> paramClass)
           
<T> ParameterExpression<T>
parameter(java.lang.Class<T> paramClass, java.lang.String name)
           
<N extends java.lang.Number>
Expression<N>
prod(Expression<? extends N> x, Expression<? extends N> y)
           
<N extends java.lang.Number>
Expression<N>
prod(Expression<? extends N> x, N y)
           
<N extends java.lang.Number>
Expression<N>
prod(N x, Expression<? extends N> y)
           
 Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x, Expression<? extends java.lang.Number> y)
           
 Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x, java.lang.Number y)
           
 Expression<java.lang.Number> quot(java.lang.Number x, Expression<? extends java.lang.Number> y)
           
<R> CriteriaBuilder.Case<R>
selectCase()
           
<C,R> CriteriaBuilder.SimpleCase<C,R>
selectCase(Expression<? extends C> expression)
           
<C extends java.util.Collection<?>>
Expression<java.lang.Integer>
size(C collection)
           
<C extends java.util.Collection<?>>
Expression<java.lang.Integer>
size(Expression<C> collection)
           
<Y> Expression<Y>
some(Subquery<Y> subquery)
           
 Expression<java.lang.Double> sqrt(Expression<? extends java.lang.Number> x)
           
 Expression<java.lang.String> substring(Expression<java.lang.String> x, Expression<java.lang.Integer> from)
           
 Expression<java.lang.String> substring(Expression<java.lang.String> x, Expression<java.lang.Integer> from, Expression<java.lang.Integer> len)
           
 Expression<java.lang.String> substring(Expression<java.lang.String> x, int from)
           
 Expression<java.lang.String> substring(Expression<java.lang.String> x, int from, int len)
           
<N extends java.lang.Number>
Expression<N>
sum(Expression<? extends N> x, Expression<? extends N> y)
           
<N extends java.lang.Number>
Expression<N>
sum(Expression<? extends N> x, N y)
           
<N extends java.lang.Number>
Expression<N>
sum(Expression<N> x)
           
<N extends java.lang.Number>
Expression<N>
sum(N x, Expression<? extends N> y)
           
 Expression<java.lang.Double> sumAsDouble(Expression<java.lang.Float> x)
           
 Expression<java.lang.Long> sumAsLong(Expression<java.lang.Integer> x)
           
 Expression<java.math.BigDecimal> toBigDecimal(Expression<? extends java.lang.Number> number)
           
 Expression<java.math.BigInteger> toBigInteger(Expression<? extends java.lang.Number> number)
           
 Expression<java.lang.Double> toDouble(Expression<? extends java.lang.Number> number)
           
 Expression<java.lang.Float> toFloat(Expression<? extends java.lang.Number> number)
           
 Expression<java.lang.Integer> toInteger(Expression<? extends java.lang.Number> number)
           
 Expression<java.lang.Long> toLong(Expression<? extends java.lang.Number> number)
           
 Expression<java.lang.String> toString(Expression<java.lang.Character> expr)
           
 Expression<java.lang.String> trim(char t, Expression<java.lang.String> x)
           
 Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trimSpec, char t, Expression<java.lang.String> x)
           
 Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trimSpec, Expression<java.lang.Character> t, Expression<java.lang.String> x)
           
 Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trim, Expression<java.lang.String> x)
           
 Expression<java.lang.String> trim(Expression<java.lang.Character> t, Expression<java.lang.String> x)
           
 Expression<java.lang.String> trim(Expression<java.lang.String> x)
           
 CompoundSelection<Tuple> tuple(Selection<?>... selections)
           
 Expression<java.lang.String> upper(Expression<java.lang.String> x)
           
<V,M extends java.util.Map<?,V>>
Expression<java.util.Collection<V>>
values(M map)
           
 

Method Detail

createQuery

CriteriaQuery<java.lang.Object> createQuery()

createQuery

<T> CriteriaQuery<T> createQuery(java.lang.Class<T> resultClass)

createTupleQuery

CriteriaQuery<Tuple> createTupleQuery()

construct

<Y> CompoundSelection<Y> construct(java.lang.Class<Y> resultClass,
                                   Selection<?>... selections)

tuple

CompoundSelection<Tuple> tuple(Selection<?>... selections)

array

CompoundSelection<java.lang.Object[]> array(Selection<?>... selections)

asc

Order asc(Expression<?> x)

desc

Order desc(Expression<?> x)

avg

<N extends java.lang.Number> Expression<java.lang.Double> avg(Expression<N> x)

sum

<N extends java.lang.Number> Expression<N> sum(Expression<N> x)

sumAsLong

Expression<java.lang.Long> sumAsLong(Expression<java.lang.Integer> x)

sumAsDouble

Expression<java.lang.Double> sumAsDouble(Expression<java.lang.Float> x)

max

<N extends java.lang.Number> Expression<N> max(Expression<N> x)

min

<N extends java.lang.Number> Expression<N> min(Expression<N> x)

greatest

<X extends java.lang.Comparable<? super X>> Expression<X> greatest(Expression<X> x)

least

<X extends java.lang.Comparable<? super X>> Expression<X> least(Expression<X> x)

count

Expression<java.lang.Long> count(Expression<?> x)

countDistinct

Expression<java.lang.Long> countDistinct(Expression<?> x)

exists

Predicate exists(Subquery<?> subquery)

all

<Y> Expression<Y> all(Subquery<Y> subquery)

some

<Y> Expression<Y> some(Subquery<Y> subquery)

any

<Y> Expression<Y> any(Subquery<Y> subquery)

and

Predicate and(Expression<java.lang.Boolean> x,
              Expression<java.lang.Boolean> y)

and

Predicate and(Predicate... restrictions)

or

Predicate or(Expression<java.lang.Boolean> x,
             Expression<java.lang.Boolean> y)

or

Predicate or(Predicate... restrictions)

not

Predicate not(Expression<java.lang.Boolean> restriction)

conjunction

Predicate conjunction()

disjunction

Predicate disjunction()

isTrue

Predicate isTrue(Expression<java.lang.Boolean> x)

isFalse

Predicate isFalse(Expression<java.lang.Boolean> x)

isNull

Predicate isNull(Expression<?> x)

isNotNull

Predicate isNotNull(Expression<?> x)

equal

Predicate equal(Expression<?> x,
                Expression<?> y)

equal

Predicate equal(Expression<?> x,
                java.lang.Object y)

notEqual

Predicate notEqual(Expression<?> x,
                   Expression<?> y)

notEqual

Predicate notEqual(Expression<?> x,
                   java.lang.Object y)

greaterThan

<Y extends java.lang.Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
                                                                  Expression<? extends Y> y)

greaterThan

<Y extends java.lang.Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
                                                                  Y y)

greaterThanOrEqualTo

<Y extends java.lang.Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Expression<? extends Y> y)

greaterThanOrEqualTo

<Y extends java.lang.Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                                           Y y)

lessThan

<Y extends java.lang.Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
                                                               Expression<? extends Y> y)

lessThan

<Y extends java.lang.Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
                                                               Y y)

lessThanOrEqualTo

<Y extends java.lang.Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Expression<? extends Y> y)

lessThanOrEqualTo

<Y extends java.lang.Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                                        Y y)

between

<Y extends java.lang.Comparable<? super Y>> Predicate between(Expression<? extends Y> v,
                                                              Expression<? extends Y> x,
                                                              Expression<? extends Y> y)

between

<Y extends java.lang.Comparable<? super Y>> Predicate between(Expression<? extends Y> v,
                                                              Y x,
                                                              Y y)

gt

Predicate gt(Expression<? extends java.lang.Number> x,
             Expression<? extends java.lang.Number> y)

gt

Predicate gt(Expression<? extends java.lang.Number> x,
             java.lang.Number y)

ge

Predicate ge(Expression<? extends java.lang.Number> x,
             Expression<? extends java.lang.Number> y)

ge

Predicate ge(Expression<? extends java.lang.Number> x,
             java.lang.Number y)

lt

Predicate lt(Expression<? extends java.lang.Number> x,
             Expression<? extends java.lang.Number> y)

lt

Predicate lt(Expression<? extends java.lang.Number> x,
             java.lang.Number y)

le

Predicate le(Expression<? extends java.lang.Number> x,
             Expression<? extends java.lang.Number> y)

le

Predicate le(Expression<? extends java.lang.Number> x,
             java.lang.Number y)

neg

<N extends java.lang.Number> Expression<N> neg(Expression<N> x)

abs

<N extends java.lang.Number> Expression<N> abs(Expression<N> x)

sum

<N extends java.lang.Number> Expression<N> sum(Expression<? extends N> x,
                                               Expression<? extends N> y)

sum

<N extends java.lang.Number> Expression<N> sum(Expression<? extends N> x,
                                               N y)

sum

<N extends java.lang.Number> Expression<N> sum(N x,
                                               Expression<? extends N> y)

prod

<N extends java.lang.Number> Expression<N> prod(Expression<? extends N> x,
                                                Expression<? extends N> y)

prod

<N extends java.lang.Number> Expression<N> prod(Expression<? extends N> x,
                                                N y)

prod

<N extends java.lang.Number> Expression<N> prod(N x,
                                                Expression<? extends N> y)

diff

<N extends java.lang.Number> Expression<N> diff(Expression<? extends N> x,
                                                Expression<? extends N> y)

diff

<N extends java.lang.Number> Expression<N> diff(Expression<? extends N> x,
                                                N y)

diff

<N extends java.lang.Number> Expression<N> diff(N x,
                                                Expression<? extends N> y)

quot

Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x,
                                  Expression<? extends java.lang.Number> y)

quot

Expression<java.lang.Number> quot(Expression<? extends java.lang.Number> x,
                                  java.lang.Number y)

quot

Expression<java.lang.Number> quot(java.lang.Number x,
                                  Expression<? extends java.lang.Number> y)

mod

Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x,
                                  Expression<java.lang.Integer> y)

mod

Expression<java.lang.Integer> mod(Expression<java.lang.Integer> x,
                                  java.lang.Integer y)

mod

Expression<java.lang.Integer> mod(java.lang.Integer x,
                                  Expression<java.lang.Integer> y)

sqrt

Expression<java.lang.Double> sqrt(Expression<? extends java.lang.Number> x)

toLong

Expression<java.lang.Long> toLong(Expression<? extends java.lang.Number> number)

toInteger

Expression<java.lang.Integer> toInteger(Expression<? extends java.lang.Number> number)

toFloat

Expression<java.lang.Float> toFloat(Expression<? extends java.lang.Number> number)

toDouble

Expression<java.lang.Double> toDouble(Expression<? extends java.lang.Number> number)

toBigDecimal

Expression<java.math.BigDecimal> toBigDecimal(Expression<? extends java.lang.Number> number)

toBigInteger

Expression<java.math.BigInteger> toBigInteger(Expression<? extends java.lang.Number> number)

toString

Expression<java.lang.String> toString(Expression<java.lang.Character> expr)

literal

<T> Expression<T> literal(T value)

nullLiteral

<T> Expression<T> nullLiteral(java.lang.Class<T> resultClass)

parameter

<T> ParameterExpression<T> parameter(java.lang.Class<T> paramClass)

parameter

<T> ParameterExpression<T> parameter(java.lang.Class<T> paramClass,
                                     java.lang.String name)

isEmpty

<C extends java.util.Collection<?>> Predicate isEmpty(Expression<C> collection)

isNotEmpty

<C extends java.util.Collection<?>> Predicate isNotEmpty(Expression<C> collection)

size

<C extends java.util.Collection<?>> Expression<java.lang.Integer> size(Expression<C> collection)

size

<C extends java.util.Collection<?>> Expression<java.lang.Integer> size(C collection)

isMember

<E,C extends java.util.Collection<E>> Predicate isMember(Expression<E> elem,
                                                         Expression<C> collection)

isMember

<E,C extends java.util.Collection<E>> Predicate isMember(E elem,
                                                         Expression<C> collection)

isNotMember

<E,C extends java.util.Collection<E>> Predicate isNotMember(Expression<E> elem,
                                                            Expression<C> collection)

isNotMember

<E,C extends java.util.Collection<E>> Predicate isNotMember(E elem,
                                                            Expression<C> collection)

values

<V,M extends java.util.Map<?,V>> Expression<java.util.Collection<V>> values(M map)

keys

<K,M extends java.util.Map<K,?>> Expression<java.util.Set<K>> keys(M map)

like

Predicate like(Expression<java.lang.String> x,
               Expression<java.lang.String> pattern)

like

Predicate like(Expression<java.lang.String> x,
               java.lang.String pattern)

like

Predicate like(Expression<java.lang.String> x,
               Expression<java.lang.String> pattern,
               Expression<java.lang.Character> escapeChar)

like

Predicate like(Expression<java.lang.String> x,
               Expression<java.lang.String> pattern,
               char escapeChar)

like

Predicate like(Expression<java.lang.String> x,
               java.lang.String pattern,
               Expression<java.lang.Character> escapeChar)

like

Predicate like(Expression<java.lang.String> x,
               java.lang.String pattern,
               char escapeChar)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  Expression<java.lang.String> pattern)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  java.lang.String pattern)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  Expression<java.lang.String> pattern,
                  Expression<java.lang.Character> escapeChar)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  Expression<java.lang.String> pattern,
                  char escapeChar)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  java.lang.String pattern,
                  Expression<java.lang.Character> escapeChar)

notLike

Predicate notLike(Expression<java.lang.String> x,
                  java.lang.String pattern,
                  char escapeChar)

concat

Expression<java.lang.String> concat(Expression<java.lang.String> x,
                                    Expression<java.lang.String> y)

concat

Expression<java.lang.String> concat(Expression<java.lang.String> x,
                                    java.lang.String y)

concat

Expression<java.lang.String> concat(java.lang.String x,
                                    Expression<java.lang.String> y)

substring

Expression<java.lang.String> substring(Expression<java.lang.String> x,
                                       Expression<java.lang.Integer> from)

substring

Expression<java.lang.String> substring(Expression<java.lang.String> x,
                                       int from)

substring

Expression<java.lang.String> substring(Expression<java.lang.String> x,
                                       Expression<java.lang.Integer> from,
                                       Expression<java.lang.Integer> len)

substring

Expression<java.lang.String> substring(Expression<java.lang.String> x,
                                       int from,
                                       int len)

trim

Expression<java.lang.String> trim(Expression<java.lang.String> x)

trim

Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trim,
                                  Expression<java.lang.String> x)

trim

Expression<java.lang.String> trim(Expression<java.lang.Character> t,
                                  Expression<java.lang.String> x)

trim

Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trimSpec,
                                  Expression<java.lang.Character> t,
                                  Expression<java.lang.String> x)

trim

Expression<java.lang.String> trim(char t,
                                  Expression<java.lang.String> x)

trim

Expression<java.lang.String> trim(CriteriaBuilder.Trimspec trimSpec,
                                  char t,
                                  Expression<java.lang.String> x)

lower

Expression<java.lang.String> lower(Expression<java.lang.String> x)

upper

Expression<java.lang.String> upper(Expression<java.lang.String> x)

length

Expression<java.lang.Integer> length(Expression<java.lang.String> x)

locate

Expression<java.lang.Integer> locate(Expression<java.lang.String> x,
                                     Expression<java.lang.String> pattern)

locate

Expression<java.lang.Integer> locate(Expression<java.lang.String> x,
                                     java.lang.String pattern)

locate

Expression<java.lang.Integer> locate(Expression<java.lang.String> x,
                                     Expression<java.lang.String> pattern,
                                     Expression<java.lang.Integer> from)

locate

Expression<java.lang.Integer> locate(Expression<java.lang.String> x,
                                     java.lang.String pattern,
                                     int from)

currentDate

Expression<java.sql.Date> currentDate()

currentTimestamp

Expression<java.sql.Timestamp> currentTimestamp()

currentTime

Expression<java.sql.Time> currentTime()

in

<T> CriteriaBuilder.In<T> in(Expression<? extends T> expression)

coalesce

<Y> Expression<Y> coalesce(Expression<? extends Y> x,
                           Expression<? extends Y> y)

coalesce

<Y> Expression<Y> coalesce(Expression<? extends Y> x,
                           Y y)

nullif

<Y> Expression<Y> nullif(Expression<Y> x,
                         Expression<?> y)

nullif

<Y> Expression<Y> nullif(Expression<Y> x,
                         Y y)

coalesce

<T> CriteriaBuilder.Coalesce<T> coalesce()

selectCase

<C,R> CriteriaBuilder.SimpleCase<C,R> selectCase(Expression<? extends C> expression)

selectCase

<R> CriteriaBuilder.Case<R> selectCase()

function

<T> Expression<T> function(java.lang.String name,
                           java.lang.Class<T> type,
                           Expression<?>... args)