CriteriaBuilderImpl (JBoss Application Server: Build 7.1.2.Final API)

java.lang.Object
- org.hibernate.ejb.criteria.CriteriaBuilderImpl

All Implemented Interfaces:

Serializable, CriteriaBuilder
```
public class CriteriaBuilderImpl
extends Object
implements CriteriaBuilder, Serializable
```
Hibernate implementation of the JPA CriteriaBuilder contract.

Author:

Steve Ebersole

See Also:
Serialized Form

Nested Class Summary
- Nested classes/interfaces inherited from interface javax.persistence.criteria.CriteriaBuilder
  CriteriaBuilder.Case<R>, CriteriaBuilder.Coalesce<T>, CriteriaBuilder.In<T>, CriteriaBuilder.SimpleCase<C,R>, CriteriaBuilder.Trimspec

Constructor Summary

Constructors
Constructor and Description

CriteriaBuilderImpl(EntityManagerFactoryImpl entityManagerFactory)

Constructors
Constructor and Description
`CriteriaBuilderImpl(EntityManagerFactoryImpl entityManagerFactory)`

Method Summary

Methods
Modifier and Type	Method and Description
`<N extends Number> Expression<N>`	`abs(Expression<N> expression)` Create an expression that returns the absolute value of its argument.
`<Y> Expression<Y>`	`all(Subquery<Y> subquery)` Create an all expression over the subquery results.
`Predicate`	`and(Expression<Boolean> x, Expression<Boolean> y)` Create a conjunction of the given boolean expressions.
`Predicate`	`and(Predicate... restrictions)` Create a conjunction of the given restriction predicates.
`<Y> Expression<Y>`	`any(Subquery<Y> subquery)` Create an any expression over the subquery results.
`<Y> CompoundSelection<Y>`	`array(Class<Y> type, List<Selection<?>> selections)` Version of `array(Selection[])` taking a list of selections, as well as the type of array.
`CompoundSelection<Object[]>`	`array(List<Selection<?>> selections)` Version of `array(Selection[])` taking a list of selections.
`CompoundSelection<Object[]>`	`array(Selection<?>... selections)` Create an array-valued selection item.
`Order`	`asc(Expression<?> x)` Create an ordering by the ascending value of the expression.
`<N extends Number> Expression<Double>`	`avg(Expression<N> x)` Create an aggregate expression applying the avg operation.
`<Y extends Comparable<? super Y>> Predicate`	`between(Expression<? extends Y> expression, Expression<? extends Y> lowerBound, Expression<? extends Y> upperBound)` Create a predicate for testing whether the first argument is between the second and third arguments in value.
`<Y extends Comparable<? super Y>> Predicate`	`between(Expression<? extends Y> expression, Y lowerBound, Y upperBound)` Create a predicate for testing whether the first argument is between the second and third arguments in value.
`<T> CriteriaBuilder.Coalesce<T>`	`coalesce()` Create a coalesce expression.
`<T> CriteriaBuilder.Coalesce<T>`	`coalesce(Class<T> type)`
`<Y> Expression<Y>`	`coalesce(Class<Y> type, Expression<? extends Y> exp1, Expression<? extends Y> exp2)`
`<Y> Expression<Y>`	`coalesce(Class<Y> type, Expression<? extends Y> exp1, Y exp2)`
`<Y> Expression<Y>`	`coalesce(Expression<? extends Y> exp1, Expression<? extends Y> exp2)` Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
`<Y> Expression<Y>`	`coalesce(Expression<? extends Y> exp1, Y exp2)` Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
`Expression<String>`	`concat(Expression<String> string1, Expression<String> string2)` Create an expression for string concatenation.
`Expression<String>`	`concat(Expression<String> string1, String string2)` Create an expression for string concatenation.
`Expression<String>`	`concat(String string1, Expression<String> string2)` Create an expression for string concatenation.
`Predicate`	`conjunction()` Create a conjunction (with zero conjuncts).
`<Y> CompoundSelection<Y>`	`construct(Class<Y> result, List<Selection<?>> selections)` Version of `construct(Class,Selection[])` taking the to-be-constructed type as well as a list of selections.
`<Y> CompoundSelection<Y>`	`construct(Class<Y> result, Selection<?>... selections)` Create a selection item corresponding to a constructor.
`Expression<Long>`	`count(Expression<?> x)` Create an aggregate expression applying the count operation.
`Expression<Long>`	`countDistinct(Expression<?> x)` Create an aggregate expression applying the count distinct operation.
`CriteriaQuery<Object>`	`createQuery()` Create a `CriteriaQuery` object.
`<T> CriteriaQuery<T>`	`createQuery(Class<T> resultClass)` Create a `CriteriaQuery` object with the specified result type.
`CriteriaQuery<Tuple>`	`createTupleQuery()` Create a `CriteriaQuery` object that returns a tuple of objects as its result.
`Expression<Date>`	`currentDate()` Create expression to return current date.
`Expression<Time>`	`currentTime()` Create expression to return current time.
`Expression<Timestamp>`	`currentTimestamp()` Create expression to return current timestamp.
`Order`	`desc(Expression<?> x)` Create an ordering by the descending value of the expression.
`<N extends Number> Expression<N>`	`diff(Expression<? extends N> expression1, Expression<? extends N> expression2)` Create an expression that returns the difference between its arguments.
`<N extends Number> Expression<N>`	`diff(Expression<? extends N> expression, N n)` Create an expression that returns the difference between its arguments.
`<N extends Number> Expression<N>`	`diff(N n, Expression<? extends N> expression)` Create an expression that returns the difference between its arguments.
`Predicate`	`disjunction()` Create a disjunction (with zero disjuncts).
`Predicate`	`equal(Expression<?> x, Expression<?> y)` Create a predicate for testing the arguments for equality.
`Predicate`	`equal(Expression<?> x, Object y)` Create a predicate for testing the arguments for equality.
`Predicate`	`exists(Subquery<?> subquery)` Create a predicate testing the existence of a subquery result.
`<T> Expression<T>`	`function(String name, Class<T> returnType)` Create a reference to a function taking no params.
`<T> Expression<T>`	`function(String name, Class<T> returnType, Expression<?>... arguments)` Create an expression for the execution of a database function.
`Predicate`	`ge(Expression<? extends Number> x, Expression<? extends Number> y)` Create a predicate for testing whether the first argument is greater than or equal to the second.
`Predicate`	`ge(Expression<? extends Number> x, Number y)` Create a predicate for testing whether the first argument is greater than or equal to the second.
`EntityManagerFactoryImpl`	`getEntityManagerFactory()` Provides protected access to the underlying `EntityManagerFactoryImpl`.
`<Y extends Comparable<? super Y>> Predicate`	`greaterThan(Expression<? extends Y> x, Expression<? extends Y> y)` Create a predicate for testing whether the first argument is greater than the second.
`<Y extends Comparable<? super Y>> Predicate`	`greaterThan(Expression<? extends Y> x, Y y)` Create a predicate for testing whether the first argument is greater than the second.
`<Y extends Comparable<? super Y>> Predicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)` Create a predicate for testing whether the first argument is greater than or equal to the second.
`<Y extends Comparable<? super Y>> Predicate`	`greaterThanOrEqualTo(Expression<? extends Y> x, Y y)` Create a predicate for testing whether the first argument is greater than or equal to the second.
`<X extends Comparable<? super X>> Expression<X>`	`greatest(Expression<X> x)` Create an aggregate expression for finding the greatest of the values (strings, dates, etc).
`Predicate`	`gt(Expression<? extends Number> x, Expression<? extends Number> y)` Create a predicate for testing whether the first argument is greater than the second.
`Predicate`	`gt(Expression<? extends Number> x, Number y)` Create a predicate for testing whether the first argument is greater than the second.
`<T> CriteriaBuilder.In<T>`	`in(Expression<? extends T> expression)` Create predicate to test whether given expression is contained in a list of values.
`<T> CriteriaBuilder.In<T>`	`in(Expression<? extends T> expression, Collection<T> values)`
`<T> CriteriaBuilder.In<T>`	`in(Expression<? extends T> expression, Expression<? extends T>... values)`
`<T> CriteriaBuilder.In<T>`	`in(Expression<? extends T> expression, T... values)`
`<C extends Collection<?>> Predicate`	`isEmpty(Expression<C> collectionExpression)` Create a predicate that tests whether a collection is empty.
`Predicate`	`isFalse(Expression<Boolean> expression)` Create a predicate testing for a false value.
`<E,C extends Collection<E>> Predicate`	`isMember(E e, Expression<C> collectionExpression)` Create a predicate that tests whether an element is a member of a collection.
`<E,C extends Collection<E>> Predicate`	`isMember(Expression<E> elementExpression, Expression<C> collectionExpression)` Create a predicate that tests whether an element is a member of a collection.
`<C extends Collection<?>> Predicate`	`isNotEmpty(Expression<C> collectionExpression)` Create a predicate that tests whether a collection is not empty.
`<E,C extends Collection<E>> Predicate`	`isNotMember(E e, Expression<C> cExpression)` Create a predicate that tests whether an element is not a member of a collection.
`<E,C extends Collection<E>> Predicate`	`isNotMember(Expression<E> eExpression, Expression<C> cExpression)` Create a predicate that tests whether an element is not a member of a collection.
`Predicate`	`isNotNull(Expression<?> x)` Create a predicate to test whether the expression is not null.
`Predicate`	`isNull(Expression<?> x)` s Create a predicate to test whether the expression is null.
`Predicate`	`isTrue(Expression<Boolean> expression)` Create a predicate testing for a true value.
`<K,M extends Map<K,?>> Expression<Set<K>>`	`keys(M map)` Create an expression that returns the keys of a map.
`Predicate`	`le(Expression<? extends Number> x, Expression<? extends Number> y)` Create a predicate for testing whether the first argument is less than or equal to the second.
`Predicate`	`le(Expression<? extends Number> x, Number y)` Create a predicate for testing whether the first argument is less than or equal to the second.
`<X extends Comparable<? super X>> Expression<X>`	`least(Expression<X> x)` Create an aggregate expression for finding the least of the values (strings, dates, etc).
`Expression<Integer>`	`length(Expression<String> value)` Create expression to return length of a string.
`<Y extends Comparable<? super Y>> Predicate`	`lessThan(Expression<? extends Y> x, Expression<? extends Y> y)` Create a predicate for testing whether the first argument is less than the second.
`<Y extends Comparable<? super Y>> Predicate`	`lessThan(Expression<? extends Y> x, Y y)` Create a predicate for testing whether the first argument is less than the second.
`<Y extends Comparable<? super Y>> Predicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Expression<? extends Y> y)` Create a predicate for testing whether the first argument is less than or equal to the second.
`<Y extends Comparable<? super Y>> Predicate`	`lessThanOrEqualTo(Expression<? extends Y> x, Y y)` Create a predicate for testing whether the first argument is less than or equal to the second.
`Predicate`	`like(Expression<String> matchExpression, Expression<String> pattern)` Create a predicate for testing whether the expression satisfies the given pattern.
`Predicate`	`like(Expression<String> matchExpression, Expression<String> pattern, char escapeCharacter)` Create a predicate for testing whether the expression satisfies the given pattern.
`Predicate`	`like(Expression<String> matchExpression, Expression<String> pattern, Expression<Character> escapeCharacter)` Create a predicate for testing whether the expression satisfies the given pattern.
`Predicate`	`like(Expression<String> matchExpression, String pattern)` Create a predicate for testing whether the expression satisfies the given pattern.
`Predicate`	`like(Expression<String> matchExpression, String pattern, char escapeCharacter)` Create a predicate for testing whether the expression satisfies the given pattern.
`Predicate`	`like(Expression<String> matchExpression, String pattern, Expression<Character> escapeCharacter)` Create a predicate for testing whether the expression satisfies the given pattern.
`<T> Expression<T>`	`literal(T value)` Create an expression for a literal.
`Expression<Integer>`	`locate(Expression<String> string, Expression<String> pattern)` Create expression to locate the position of one string within another, returning position of first character if found.
`Expression<Integer>`	`locate(Expression<String> string, Expression<String> pattern, Expression<Integer> start)` Create expression to locate the position of one string within another, returning position of first character if found.
`Expression<Integer>`	`locate(Expression<String> string, String pattern)` Create expression to locate the position of one string within another, returning position of first character if found.
`Expression<Integer>`	`locate(Expression<String> string, String pattern, int start)` Create expression to locate the position of one string within another, returning position of first character if found.
`Expression<String>`	`lower(Expression<String> value)` Create expression for converting a string to lowercase.
`Predicate`	`lt(Expression<? extends Number> x, Expression<? extends Number> y)` Create a predicate for testing whether the first argument is less than the second.
`Predicate`	`lt(Expression<? extends Number> x, Number y)` Create a predicate for testing whether the first argument is less than the second.
`<N extends Number> Expression<N>`	`max(Expression<N> x)` Create an aggregate expression applying the numerical max operation.
`<N extends Number> Expression<N>`	`min(Expression<N> x)` Create an aggregate expression applying the numerical min operation.
`Expression<Integer>`	`mod(Expression<Integer> expression1, Expression<Integer> expression2)` Create an expression that returns the modulus of its arguments.
`Expression<Integer>`	`mod(Expression<Integer> expression, Integer integer)` Create an expression that returns the modulus of its arguments.
`Expression<Integer>`	`mod(Integer integer, Expression<Integer> expression)` Create an expression that returns the modulus of its arguments.
`<N extends Number> Expression<N>`	`neg(Expression<N> expression)` Create an expression that returns the arithmetic negation of its argument.
`Predicate`	`not(Expression<Boolean> expression)` Create a negation of the given restriction.
`Predicate`	`notEqual(Expression<?> x, Expression<?> y)` Create a predicate for testing the arguments for inequality.
`Predicate`	`notEqual(Expression<?> x, Object y)` Create a predicate for testing the arguments for inequality.
`Predicate`	`notLike(Expression<String> matchExpression, Expression<String> pattern)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`Predicate`	`notLike(Expression<String> matchExpression, Expression<String> pattern, char escapeCharacter)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`Predicate`	`notLike(Expression<String> matchExpression, Expression<String> pattern, Expression<Character> escapeCharacter)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`Predicate`	`notLike(Expression<String> matchExpression, String pattern)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`Predicate`	`notLike(Expression<String> matchExpression, String pattern, char escapeCharacter)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`Predicate`	`notLike(Expression<String> matchExpression, String pattern, Expression<Character> escapeCharacter)` Create a predicate for testing whether the expression does not satisfy the given pattern.
`<Y> Expression<Y>`	`nullif(Class<Y> type, Expression<Y> exp1, Expression<?> exp2)`
`<Y> Expression<Y>`	`nullif(Class<Y> type, Expression<Y> exp1, Y exp2)`
`<Y> Expression<Y>`	`nullif(Expression<Y> exp1, Expression<?> exp2)` Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
`<Y> Expression<Y>`	`nullif(Expression<Y> exp1, Y exp2)` Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
`<T> Expression<T>`	`nullLiteral(Class<T> resultClass)` Create an expression for a null literal with the given type.
`Predicate`	`or(Expression<Boolean> x, Expression<Boolean> y)` Create a disjunction of the given boolean expressions.
`Predicate`	`or(Predicate... restrictions)` Create a disjunction of the given restriction predicates.
`<T> ParameterExpression<T>`	`parameter(Class<T> paramClass)` Create a parameter expression.
`<T> ParameterExpression<T>`	`parameter(Class<T> paramClass, String name)` Create a parameter expression with the given name.
`<N extends Number> Expression<N>`	`prod(Expression<? extends N> expression1, Expression<? extends N> expression2)` Create an expression that returns the product of its arguments.
`<N extends Number> Expression<N>`	`prod(Expression<? extends N> expression, N n)` Create an expression that returns the product of its arguments.
`<N extends Number> Expression<N>`	`prod(N n, Expression<? extends N> expression)` Create an expression that returns the product of its arguments.
`Expression<Number>`	`quot(Expression<? extends Number> expression1, Expression<? extends Number> expression2)` Create an expression that returns the quotient of its arguments.
`Expression<Number>`	`quot(Expression<? extends Number> expression, Number number)` Create an expression that returns the quotient of its arguments.
`Expression<Number>`	`quot(Number number, Expression<? extends Number> expression)` Create an expression that returns the quotient of its arguments.
`<R> CriteriaBuilder.Case<R>`	`selectCase()` Create a general case expression.
`<R> CriteriaBuilder.Case<R>`	`selectCase(Class<R> type)`
`<C,R> CriteriaBuilder.SimpleCase<C,R>`	`selectCase(Class<R> type, Expression<? extends C> expression)`
`<C,R> CriteriaBuilder.SimpleCase<C,R>`	`selectCase(Expression<? extends C> expression)` Create a simple case expression.
`<C extends Collection<?>> Expression<Integer>`	`size(C c)` Create an expression that tests the size of a collection.
`<C extends Collection<?>> Expression<Integer>`	`size(Expression<C> exp)` Create an expression that tests the size of a collection.
`<Y> Expression<Y>`	`some(Subquery<Y> subquery)` Create a some expression over the subquery results.
`Expression<Double>`	`sqrt(Expression<? extends Number> expression)` Create an expression that returns the square root of its argument.
`Expression<String>`	`substring(Expression<String> value, Expression<Integer> start)` Create an expression for substring extraction.
`Expression<String>`	`substring(Expression<String> value, Expression<Integer> start, Expression<Integer> length)` Create an expression for substring extraction.
`Expression<String>`	`substring(Expression<String> value, int start)` Create an expression for substring extraction.
`Expression<String>`	`substring(Expression<String> value, int start, int length)` Create an expression for substring extraction.
`<N extends Number> Expression<N>`	`sum(Expression<? extends N> expression1, Expression<? extends N> expression2)` Create an expression that returns the sum of its arguments.
`<N extends Number> Expression<N>`	`sum(Expression<? extends N> expression, N n)` Create an expression that returns the sum of its arguments.
`<N extends Number> Expression<N>`	`sum(Expression<N> x)` Create an aggregate expression applying the sum operation.
`<N extends Number> Expression<N>`	`sum(N n, Expression<? extends N> expression)` Create an expression that returns the sum of its arguments.
`Expression<Double>`	`sumAsDouble(Expression<Float> x)` Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.
`Expression<Long>`	`sumAsLong(Expression<Integer> x)` Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.
`ExpressionImplementor<BigDecimal>`	`toBigDecimal(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<BigInteger>`	`toBigInteger(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<Double>`	`toDouble(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<Float>`	`toFloat(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<Integer>`	`toInteger(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<Long>`	`toLong(Expression<? extends Number> expression)` Typecast.
`ExpressionImplementor<String>`	`toString(Expression<Character> characterExpression)` Typecast.
`Expression<String>`	`trim(char trimCharacter, Expression<String> trimSource)` Create expression to trim character from both ends of a string.
`Expression<String>`	`trim(CriteriaBuilder.Trimspec trimspec, char trimCharacter, Expression<String> trimSource)` Create expression to trim character from a string.
`Expression<String>`	`trim(CriteriaBuilder.Trimspec trimspec, Expression<Character> trimCharacter, Expression<String> trimSource)` Create expression to trim character from a string.
`Expression<String>`	`trim(CriteriaBuilder.Trimspec trimspec, Expression<String> trimSource)` Create expression to trim blanks from a string.
`Expression<String>`	`trim(Expression<Character> trimCharacter, Expression<String> trimSource)` Create expression to trim character from both ends of a string.
`Expression<String>`	`trim(Expression<String> trimSource)` Create expression to trim blanks from both ends of a string.
`CompoundSelection<Tuple>`	`tuple(List<Selection<?>> selections)` Version of `tuple(Selection[])` taking a list.
`CompoundSelection<Tuple>`	`tuple(Selection<?>... selections)` Create a tuple-valued selection item.
`Expression<String>`	`upper(Expression<String> value)` Create expression for converting a string to uppercase.
`<V,M extends Map<?,V>> Expression<Collection<V>>`	`values(M map)` Create an expression that returns the values of a map.
`Predicate`	`wrap(Expression<Boolean> expression)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - CriteriaBuilderImpl
```
public CriteriaBuilderImpl(EntityManagerFactoryImpl entityManagerFactory)
```
- Method Detail
  - getEntityManagerFactory
```
public EntityManagerFactoryImpl getEntityManagerFactory()
```
    Provides protected access to the underlying EntityManagerFactoryImpl.
    
    Returns:
    The underlying EntityManagerFactoryImpl
  - createQuery
```
public CriteriaQuery<Object> createQuery()
```
    Create a CriteriaQuery object.
    
    Specified by:
    
    createQuery in interface CriteriaBuilder
    
    Returns:
    criteria query object
  - createQuery
```
public <T> CriteriaQuery<T> createQuery(Class<T> resultClass)
```
    Create a CriteriaQuery object with the specified result type.
    
    Specified by:
    
    createQuery in interface CriteriaBuilder
    
    Parameters:
    resultClass - type of the query result
    
    Returns:
    criteria query object
  - createTupleQuery
```
public CriteriaQuery<Tuple> createTupleQuery()
```
    Create a CriteriaQuery object that returns a tuple of objects as its result.
    
    Specified by:
    
    createTupleQuery in interface CriteriaBuilder
    
    Returns:
    criteria query object
  - tuple
```
public CompoundSelection<Tuple> tuple(Selection<?>... selections)
```
    Create a tuple-valued selection item.
    
    Specified by:
    
    tuple in interface CriteriaBuilder
    
    Parameters:
    selections - selection items
    
    Returns:
    tuple-valued compound selection
  - tuple
```
public CompoundSelection<Tuple> tuple(List<Selection<?>> selections)
```
    Version of tuple(Selection[]) taking a list.
    
    Parameters:
    selections - List of selections.
    
    Returns:
    The tuple compound selection
  - array
```
public CompoundSelection<Object[]> array(Selection<?>... selections)
```
    Create an array-valued selection item.
    
    Specified by:
    
    array in interface CriteriaBuilder
    
    Parameters:
    selections - selection items
    
    Returns:
    array-valued compound selection
  - array
```
public CompoundSelection<Object[]> array(List<Selection<?>> selections)
```
    Version of array(Selection[]) taking a list of selections.
    
    Parameters:
    selections - List of selections.
    
    Returns:
    The array compound selection
  - array
```
public <Y> CompoundSelection<Y> array(Class<Y> type,
                             List<Selection<?>> selections)
```
    Version of array(Selection[]) taking a list of selections, as well as the type of array.
    
    Parameters:
    type - The type of array
    selections - List of selections.
    
    Returns:
    The array compound selection
  - construct
```
public <Y> CompoundSelection<Y> construct(Class<Y> result,
                                 Selection<?>... selections)
```
    Create a selection item corresponding to a constructor. This method is used to specify a constructor that will be applied to the results of the query execution. If the constructor is for an entity class, the resulting entities will be in the new state after the query is executed.
    
    Specified by:
    
    construct in interface CriteriaBuilder
    
    Parameters:
    result - class whose instance is to be constructed
    selections - arguments to the constructor
    
    Returns:
    compound selection item
  - construct
```
public <Y> CompoundSelection<Y> construct(Class<Y> result,
                                 List<Selection<?>> selections)
```
    Version of construct(Class,Selection[]) taking the to-be-constructed type as well as a list of selections.
    
    Parameters:
    result - The result class to be constructed.
    selections - The selections to use in the constructor call.
    
    Returns:
    The view compound selection.
  - asc
```
public Order asc(Expression<?> x)
```
    Create an ordering by the ascending value of the expression.
    
    Specified by:
    
    asc in interface CriteriaBuilder
    
    Parameters:
    x - expression used to define the ordering
    
    Returns:
    ascending ordering corresponding to the expression
  - desc
```
public Order desc(Expression<?> x)
```
    Create an ordering by the descending value of the expression.
    
    Specified by:
    
    desc in interface CriteriaBuilder
    
    Parameters:
    x - expression used to define the ordering
    
    Returns:
    descending ordering corresponding to the expression
  - wrap
```
public Predicate wrap(Expression<Boolean> expression)
```
  - not
```
public Predicate not(Expression<Boolean> expression)
```
    Create a negation of the given restriction.
    
    Specified by:
    
    not in interface CriteriaBuilder
    
    Parameters:
    expression - restriction expression
    
    Returns:
    not predicate
  - and
```
public Predicate and(Expression<Boolean> x,
            Expression<Boolean> y)
```
    Create a conjunction of the given boolean expressions.
    
    Specified by:
    
    and in interface CriteriaBuilder
    
    Parameters:
    x - boolean expression
    y - boolean expression
    
    Returns:
    and predicate
  - or
```
public Predicate or(Expression<Boolean> x,
           Expression<Boolean> y)
```
    Create a disjunction of the given boolean expressions.
    
    Specified by:
    
    or in interface CriteriaBuilder
    
    Parameters:
    x - boolean expression
    y - boolean expression
    
    Returns:
    or predicate
  - and
```
public Predicate and(Predicate... restrictions)
```
    Create a conjunction of the given restriction predicates. A conjunction of zero predicates is true.
    
    Specified by:
    
    and in interface CriteriaBuilder
    
    Parameters:
    restrictions - zero or more restriction predicates
    
    Returns:
    and predicate
  - or
```
public Predicate or(Predicate... restrictions)
```
    Create a disjunction of the given restriction predicates. A disjunction of zero predicates is false.
    
    Specified by:
    
    or in interface CriteriaBuilder
    
    Parameters:
    restrictions - zero or more restriction predicates
    
    Returns:
    or predicate
  - conjunction
```
public Predicate conjunction()
```
    Create a conjunction (with zero conjuncts). A conjunction with zero conjuncts is true.
    
    Specified by:
    
    conjunction in interface CriteriaBuilder
    
    Returns:
    and predicate
  - disjunction
```
public Predicate disjunction()
```
    Create a disjunction (with zero disjuncts). A disjunction with zero disjuncts is false.
    
    Specified by:
    
    disjunction in interface CriteriaBuilder
    
    Returns:
    or predicate
  - isTrue
```
public Predicate isTrue(Expression<Boolean> expression)
```
    Create a predicate testing for a true value.
    
    Specified by:
    
    isTrue in interface CriteriaBuilder
    
    Parameters:
    expression - expression to be tested
    
    Returns:
    predicate
  - isFalse
```
public Predicate isFalse(Expression<Boolean> expression)
```
    Create a predicate testing for a false value.
    
    Specified by:
    
    isFalse in interface CriteriaBuilder
    
    Parameters:
    expression - expression to be tested
    
    Returns:
    predicate
  - isNull
```
public Predicate isNull(Expression<?> x)
```
    s Create a predicate to test whether the expression is null.
    
    Specified by:
    
    isNull in interface CriteriaBuilder
    
    Parameters:
    x - expression
    
    Returns:
    is-null predicate
  - isNotNull
```
public Predicate isNotNull(Expression<?> x)
```
    Create a predicate to test whether the expression is not null.
    
    Specified by:
    
    isNotNull in interface CriteriaBuilder
    
    Parameters:
    x - expression
    
    Returns:
    is-not-null predicate
  - equal
```
public Predicate equal(Expression<?> x,
              Expression<?> y)
```
    Create a predicate for testing the arguments for equality.
    
    Specified by:
    
    equal in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    equality predicate
  - notEqual
```
public Predicate notEqual(Expression<?> x,
                 Expression<?> y)
```
    Create a predicate for testing the arguments for inequality.
    
    Specified by:
    
    notEqual in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    inequality predicate
  - equal
```
public Predicate equal(Expression<?> x,
              Object y)
```
    Create a predicate for testing the arguments for equality.
    
    Specified by:
    
    equal in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - object
    
    Returns:
    equality predicate
  - notEqual
```
public Predicate notEqual(Expression<?> x,
                 Object y)
```
    Create a predicate for testing the arguments for inequality.
    
    Specified by:
    
    notEqual in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - object
    
    Returns:
    inequality predicate
  - greaterThan
```
public <Y extends Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
                                                      Expression<? extends Y> y)
```
    Create a predicate for testing whether the first argument is greater than the second.
    
    Specified by:
    
    greaterThan in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    greater-than predicate
  - lessThan
```
public <Y extends Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
                                                   Expression<? extends Y> y)
```
    Create a predicate for testing whether the first argument is less than the second.
    
    Specified by:
    
    lessThan in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    less-than predicate
  - greaterThanOrEqualTo
```
public <Y extends Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                               Expression<? extends Y> y)
```
    Create a predicate for testing whether the first argument is greater than or equal to the second.
    
    Specified by:
    
    greaterThanOrEqualTo in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    greater-than-or-equal predicate
  - lessThanOrEqualTo
```
public <Y extends Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                            Expression<? extends Y> y)
```
    Create a predicate for testing whether the first argument is less than or equal to the second.
    
    Specified by:
    
    lessThanOrEqualTo in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    less-than-or-equal predicate
  - greaterThan
```
public <Y extends Comparable<? super Y>> Predicate greaterThan(Expression<? extends Y> x,
                                                      Y y)
```
    Create a predicate for testing whether the first argument is greater than the second.
    
    Specified by:
    
    greaterThan in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    greater-than predicate
  - lessThan
```
public <Y extends Comparable<? super Y>> Predicate lessThan(Expression<? extends Y> x,
                                                   Y y)
```
    Create a predicate for testing whether the first argument is less than the second.
    
    Specified by:
    
    lessThan in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    less-than predicate
  - greaterThanOrEqualTo
```
public <Y extends Comparable<? super Y>> Predicate greaterThanOrEqualTo(Expression<? extends Y> x,
                                                               Y y)
```
    Create a predicate for testing whether the first argument is greater than or equal to the second.
    
    Specified by:
    
    greaterThanOrEqualTo in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    greater-than-or-equal predicate
  - lessThanOrEqualTo
```
public <Y extends Comparable<? super Y>> Predicate lessThanOrEqualTo(Expression<? extends Y> x,
                                                            Y y)
```
    Create a predicate for testing whether the first argument is less than or equal to the second.
    
    Specified by:
    
    lessThanOrEqualTo in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    less-than-or-equal predicate
  - gt
```
public Predicate gt(Expression<? extends Number> x,
           Expression<? extends Number> y)
```
    Create a predicate for testing whether the first argument is greater than the second.
    
    Specified by:
    
    gt in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    greater-than predicate
  - lt
```
public Predicate lt(Expression<? extends Number> x,
           Expression<? extends Number> y)
```
    Create a predicate for testing whether the first argument is less than the second.
    
    Specified by:
    
    lt in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    less-than predicate
  - ge
```
public Predicate ge(Expression<? extends Number> x,
           Expression<? extends Number> y)
```
    Create a predicate for testing whether the first argument is greater than or equal to the second.
    
    Specified by:
    
    ge in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    greater-than-or-equal predicate
  - le
```
public Predicate le(Expression<? extends Number> x,
           Expression<? extends Number> y)
```
    Create a predicate for testing whether the first argument is less than or equal to the second.
    
    Specified by:
    
    le in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - expression
    
    Returns:
    less-than-or-equal predicate
  - gt
```
public Predicate gt(Expression<? extends Number> x,
           Number y)
```
    Create a predicate for testing whether the first argument is greater than the second.
    
    Specified by:
    
    gt in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    greater-than predicate
  - lt
```
public Predicate lt(Expression<? extends Number> x,
           Number y)
```
    Create a predicate for testing whether the first argument is less than the second.
    
    Specified by:
    
    lt in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    less-than predicate
  - ge
```
public Predicate ge(Expression<? extends Number> x,
           Number y)
```
    Create a predicate for testing whether the first argument is greater than or equal to the second.
    
    Specified by:
    
    ge in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    greater-than-or-equal predicate
  - le
```
public Predicate le(Expression<? extends Number> x,
           Number y)
```
    Create a predicate for testing whether the first argument is less than or equal to the second.
    
    Specified by:
    
    le in interface CriteriaBuilder
    
    Parameters:
    x - expression
    y - value
    
    Returns:
    less-than-or-equal predicate
  - between
```
public <Y extends Comparable<? super Y>> Predicate between(Expression<? extends Y> expression,
                                                  Y lowerBound,
                                                  Y upperBound)
```
    Create a predicate for testing whether the first argument is between the second and third arguments in value.
    
    Specified by:
    
    between in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    lowerBound - value
    upperBound - value
    
    Returns:
    between predicate
  - between
```
public <Y extends Comparable<? super Y>> Predicate between(Expression<? extends Y> expression,
                                                  Expression<? extends Y> lowerBound,
                                                  Expression<? extends Y> upperBound)
```
    Create a predicate for testing whether the first argument is between the second and third arguments in value.
    
    Specified by:
    
    between in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    lowerBound - expression
    upperBound - expression
    
    Returns:
    between predicate
  - in
```
public <T> CriteriaBuilder.In<T> in(Expression<? extends T> expression)
```
    Create predicate to test whether given expression is contained in a list of values.
    
    Specified by:
    
    in in interface CriteriaBuilder
    
    Parameters:
    expression - to be tested against list of values
    
    Returns:
    in predicate
  - in
```
public <T> CriteriaBuilder.In<T> in(Expression<? extends T> expression,
                           Expression<? extends T>... values)
```
  - in
```
public <T> CriteriaBuilder.In<T> in(Expression<? extends T> expression,
                           T... values)
```
  - in
```
public <T> CriteriaBuilder.In<T> in(Expression<? extends T> expression,
                           Collection<T> values)
```
  - like
```
public Predicate like(Expression<String> matchExpression,
             Expression<String> pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    
    Returns:
    like predicate
  - like
```
public Predicate like(Expression<String> matchExpression,
             Expression<String> pattern,
             Expression<Character> escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    escapeCharacter - escape character expression
    
    Returns:
    like predicate
  - like
```
public Predicate like(Expression<String> matchExpression,
             Expression<String> pattern,
             char escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    escapeCharacter - escape character
    
    Returns:
    like predicate
  - like
```
public Predicate like(Expression<String> matchExpression,
             String pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    
    Returns:
    like predicate
  - like
```
public Predicate like(Expression<String> matchExpression,
             String pattern,
             Expression<Character> escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    escapeCharacter - escape character expression
    
    Returns:
    like predicate
  - like
```
public Predicate like(Expression<String> matchExpression,
             String pattern,
             char escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression satisfies the given pattern.
    
    Specified by:
    
    like in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    escapeCharacter - escape character
    
    Returns:
    like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                Expression<String> pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    
    Returns:
    not-like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                Expression<String> pattern,
                Expression<Character> escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    escapeCharacter - escape character expression
    
    Returns:
    not-like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                Expression<String> pattern,
                char escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string expression
    escapeCharacter - escape character
    
    Returns:
    not-like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                String pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    
    Returns:
    not-like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                String pattern,
                Expression<Character> escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    escapeCharacter - escape character expression
    
    Returns:
    not-like predicate
  - notLike
```
public Predicate notLike(Expression<String> matchExpression,
                String pattern,
                char escapeCharacter)
```
    Description copied from interface: CriteriaBuilder
    
    Create a predicate for testing whether the expression does not satisfy the given pattern.
    
    Specified by:
    
    notLike in interface CriteriaBuilder
    
    Parameters:
    matchExpression - string expression
    pattern - string
    escapeCharacter - escape character
    
    Returns:
    not-like predicate
  - parameter
```
public <T> ParameterExpression<T> parameter(Class<T> paramClass)
```
    Create a parameter expression.
    
    Specified by:
    
    parameter in interface CriteriaBuilder
    
    Parameters:
    paramClass - parameter class
    
    Returns:
    parameter expression
  - parameter
```
public <T> ParameterExpression<T> parameter(Class<T> paramClass,
                                   String name)
```
    Create a parameter expression with the given name.
    
    Specified by:
    
    parameter in interface CriteriaBuilder
    
    Parameters:
    paramClass - parameter class
    name - name that can be used to refer to the parameter
    
    Returns:
    parameter expression
  - literal
```
public <T> Expression<T> literal(T value)
```
    Create an expression for a literal.
    
    Specified by:
    
    literal in interface CriteriaBuilder
    
    Parameters:
    value - value represented by the expression
    
    Returns:
    expression literal
  - nullLiteral
```
public <T> Expression<T> nullLiteral(Class<T> resultClass)
```
    Create an expression for a null literal with the given type.
    
    Specified by:
    
    nullLiteral in interface CriteriaBuilder
    
    Parameters:
    resultClass - type of the null literal
    
    Returns:
    null expression literal
  - avg
```
public <N extends Number> Expression<Double> avg(Expression<N> x)
```
    Create an aggregate expression applying the avg operation.
    
    Specified by:
    
    avg in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to avg operation
    
    Returns:
    avg expression
  - sum
```
public <N extends Number> Expression<N> sum(Expression<N> x)
```
    Create an aggregate expression applying the sum operation.
    
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to sum operation
    
    Returns:
    sum expression
  - sumAsLong
```
public Expression<Long> sumAsLong(Expression<Integer> x)
```
    Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.
    
    Specified by:
    
    sumAsLong in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to sum operation
    
    Returns:
    sum expression
  - sumAsDouble
```
public Expression<Double> sumAsDouble(Expression<Float> x)
```
    Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.
    
    Specified by:
    
    sumAsDouble in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to sum operation
    
    Returns:
    sum expression
  - max
```
public <N extends Number> Expression<N> max(Expression<N> x)
```
    Create an aggregate expression applying the numerical max operation.
    
    Specified by:
    
    max in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to max operation
    
    Returns:
    max expression
  - min
```
public <N extends Number> Expression<N> min(Expression<N> x)
```
    Create an aggregate expression applying the numerical min operation.
    
    Specified by:
    
    min in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to min operation
    
    Returns:
    min expression
  - greatest
```
public <X extends Comparable<? super X>> Expression<X> greatest(Expression<X> x)
```
    Create an aggregate expression for finding the greatest of the values (strings, dates, etc).
    
    Specified by:
    
    greatest in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to greatest operation
    
    Returns:
    greatest expression
  - least
```
public <X extends Comparable<? super X>> Expression<X> least(Expression<X> x)
```
    Create an aggregate expression for finding the least of the values (strings, dates, etc).
    
    Specified by:
    
    least in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to least operation
    
    Returns:
    least expression
  - count
```
public Expression<Long> count(Expression<?> x)
```
    Create an aggregate expression applying the count operation.
    
    Specified by:
    
    count in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to count operation
    
    Returns:
    count expression
  - countDistinct
```
public Expression<Long> countDistinct(Expression<?> x)
```
    Create an aggregate expression applying the count distinct operation.
    
    Specified by:
    
    countDistinct in interface CriteriaBuilder
    
    Parameters:
    x - expression representing input value to count distinct operation
    
    Returns:
    count distinct expression
  - function
```
public <T> Expression<T> function(String name,
                         Class<T> returnType,
                         Expression<?>... arguments)
```
    Create an expression for the execution of a database function.
    
    Specified by:
    
    function in interface CriteriaBuilder
    
    Parameters:
    name - function name
    returnType - expected result type
    arguments - function arguments
    
    Returns:
    expression
  - function
```
public <T> Expression<T> function(String name,
                         Class<T> returnType)
```
    Create a reference to a function taking no params.
    
    Parameters:
    name - The function name.
    returnType - The return type.
    
    Returns:
    The function expression
  - abs
```
public <N extends Number> Expression<N> abs(Expression<N> expression)
```
    Create an expression that returns the absolute value of its argument.
    
    Specified by:
    
    abs in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    
    Returns:
    absolute value
  - sqrt
```
public Expression<Double> sqrt(Expression<? extends Number> expression)
```
    Create an expression that returns the square root of its argument.
    
    Specified by:
    
    sqrt in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    
    Returns:
    square root
  - currentDate
```
public Expression<Date> currentDate()
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to return current date.
    
    Specified by:
    
    currentDate in interface CriteriaBuilder
    
    Returns:
    expression for current date
  - currentTimestamp
```
public Expression<Timestamp> currentTimestamp()
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to return current timestamp.
    
    Specified by:
    
    currentTimestamp in interface CriteriaBuilder
    
    Returns:
    expression for current timestamp
  - currentTime
```
public Expression<Time> currentTime()
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to return current time.
    
    Specified by:
    
    currentTime in interface CriteriaBuilder
    
    Returns:
    expression for current time
  - substring
```
public Expression<String> substring(Expression<String> value,
                           Expression<Integer> start)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string. First position is 1.
    
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    start - start position expression
    
    Returns:
    expression corresponding to substring extraction
  - substring
```
public Expression<String> substring(Expression<String> value,
                           int start)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression for substring extraction. Extracts a substring starting at the specified position through to end of the string. First position is 1.
    
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    start - start position
    
    Returns:
    expression corresponding to substring extraction
  - substring
```
public Expression<String> substring(Expression<String> value,
                           Expression<Integer> start,
                           Expression<Integer> length)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression for substring extraction. Extracts a substring of given length starting at the specified position. First position is 1.
    
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    start - start position expression
    length - length expression
    
    Returns:
    expression corresponding to substring extraction
  - substring
```
public Expression<String> substring(Expression<String> value,
                           int start,
                           int length)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression for substring extraction. Extracts a substring of given length starting at the specified position. First position is 1.
    
    Specified by:
    
    substring in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    start - start position
    length - length
    
    Returns:
    expression corresponding to substring extraction
  - trim
```
public Expression<String> trim(Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim blanks from both ends of a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - trim
```
public Expression<String> trim(CriteriaBuilder.Trimspec trimspec,
                      Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim blanks from a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimspec - trim specification
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - trim
```
public Expression<String> trim(Expression<Character> trimCharacter,
                      Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim character from both ends of a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimCharacter - expression for character to be trimmed
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - trim
```
public Expression<String> trim(CriteriaBuilder.Trimspec trimspec,
                      Expression<Character> trimCharacter,
                      Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim character from a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimspec - trim specification
    trimCharacter - expression for character to be trimmed
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - trim
```
public Expression<String> trim(char trimCharacter,
                      Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim character from both ends of a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimCharacter - character to be trimmed
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - trim
```
public Expression<String> trim(CriteriaBuilder.Trimspec trimspec,
                      char trimCharacter,
                      Expression<String> trimSource)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to trim character from a string.
    
    Specified by:
    
    trim in interface CriteriaBuilder
    
    Parameters:
    trimspec - trim specification
    trimCharacter - character to be trimmed
    trimSource - expression for string to trim
    
    Returns:
    trim expression
  - lower
```
public Expression<String> lower(Expression<String> value)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression for converting a string to lowercase.
    
    Specified by:
    
    lower in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    
    Returns:
    expression to convert to lowercase
  - upper
```
public Expression<String> upper(Expression<String> value)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression for converting a string to uppercase.
    
    Specified by:
    
    upper in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    
    Returns:
    expression to convert to uppercase
  - length
```
public Expression<Integer> length(Expression<String> value)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to return length of a string.
    
    Specified by:
    
    length in interface CriteriaBuilder
    
    Parameters:
    value - string expression
    
    Returns:
    length expression
  - locate
```
public Expression<Integer> locate(Expression<String> string,
                         Expression<String> pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
    
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Parameters:
    string - expression for string to be searched
    pattern - expression for string to be located
    
    Returns:
    expression corresponding to position
  - locate
```
public Expression<Integer> locate(Expression<String> string,
                         Expression<String> pattern,
                         Expression<Integer> start)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
    
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Parameters:
    string - expression for string to be searched
    pattern - expression for string to be located
    start - expression for position at which to start search
    
    Returns:
    expression corresponding to position
  - locate
```
public Expression<Integer> locate(Expression<String> string,
                         String pattern)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
    
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Parameters:
    string - expression for string to be searched
    pattern - string to be located
    
    Returns:
    expression corresponding to position
  - locate
```
public Expression<Integer> locate(Expression<String> string,
                         String pattern,
                         int start)
```
    Description copied from interface: CriteriaBuilder
    
    Create expression to locate the position of one string within another, returning position of first character if found. The first position in a string is denoted by 1. If the string to be located is not found, 0 is returned.
    
    Specified by:
    
    locate in interface CriteriaBuilder
    
    Parameters:
    string - expression for string to be searched
    pattern - string to be located
    start - position at which to start search
    
    Returns:
    expression corresponding to position
  - neg
```
public <N extends Number> Expression<N> neg(Expression<N> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the arithmetic negation of its argument.
    
    Specified by:
    
    neg in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    
    Returns:
    arithmetic negation
  - sum
```
public <N extends Number> Expression<N> sum(Expression<? extends N> expression1,
                                   Expression<? extends N> expression2)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the sum of its arguments.
    
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Parameters:
    expression1 - expression
    expression2 - expression
    
    Returns:
    sum
  - prod
```
public <N extends Number> Expression<N> prod(Expression<? extends N> expression1,
                                    Expression<? extends N> expression2)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the product of its arguments.
    
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Parameters:
    expression1 - expression
    expression2 - expression
    
    Returns:
    product
  - diff
```
public <N extends Number> Expression<N> diff(Expression<? extends N> expression1,
                                    Expression<? extends N> expression2)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the difference between its arguments.
    
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Parameters:
    expression1 - expression
    expression2 - expression
    
    Returns:
    difference
  - sum
```
public <N extends Number> Expression<N> sum(Expression<? extends N> expression,
                                   N n)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the sum of its arguments.
    
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    n - value
    
    Returns:
    sum
  - prod
```
public <N extends Number> Expression<N> prod(Expression<? extends N> expression,
                                    N n)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the product of its arguments.
    
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    n - value
    
    Returns:
    product
  - diff
```
public <N extends Number> Expression<N> diff(Expression<? extends N> expression,
                                    N n)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the difference between its arguments.
    
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    n - value
    
    Returns:
    difference
  - sum
```
public <N extends Number> Expression<N> sum(N n,
                                   Expression<? extends N> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the sum of its arguments.
    
    Specified by:
    
    sum in interface CriteriaBuilder
    
    Parameters:
    n - value
    expression - expression
    
    Returns:
    sum
  - prod
```
public <N extends Number> Expression<N> prod(N n,
                                    Expression<? extends N> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the product of its arguments.
    
    Specified by:
    
    prod in interface CriteriaBuilder
    
    Parameters:
    n - value
    expression - expression
    
    Returns:
    product
  - diff
```
public <N extends Number> Expression<N> diff(N n,
                                    Expression<? extends N> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the difference between its arguments.
    
    Specified by:
    
    diff in interface CriteriaBuilder
    
    Parameters:
    n - value
    expression - expression
    
    Returns:
    difference
  - quot
```
public Expression<Number> quot(Expression<? extends Number> expression1,
                      Expression<? extends Number> expression2)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the quotient of its arguments.
    
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Parameters:
    expression1 - expression
    expression2 - expression
    
    Returns:
    quotient
  - quot
```
public Expression<Number> quot(Expression<? extends Number> expression,
                      Number number)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the quotient of its arguments.
    
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    number - value
    
    Returns:
    quotient
  - quot
```
public Expression<Number> quot(Number number,
                      Expression<? extends Number> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the quotient of its arguments.
    
    Specified by:
    
    quot in interface CriteriaBuilder
    
    Parameters:
    number - value
    expression - expression
    
    Returns:
    quotient
  - mod
```
public Expression<Integer> mod(Expression<Integer> expression1,
                      Expression<Integer> expression2)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the modulus of its arguments.
    
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Parameters:
    expression1 - expression
    expression2 - expression
    
    Returns:
    modulus
  - mod
```
public Expression<Integer> mod(Expression<Integer> expression,
                      Integer integer)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the modulus of its arguments.
    
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Parameters:
    expression - expression
    integer - value
    
    Returns:
    modulus
  - mod
```
public Expression<Integer> mod(Integer integer,
                      Expression<Integer> expression)
```
    Description copied from interface: CriteriaBuilder
    
    Create an expression that returns the modulus of its arguments.
    
    Specified by:
    
    mod in interface CriteriaBuilder
    
    Parameters:
    integer - value
    expression - expression
    
    Returns:
    modulus
  - toLong
```
public ExpressionImplementor<Long> toLong(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toLong in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<Long>
  - toInteger
```
public ExpressionImplementor<Integer> toInteger(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toInteger in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<Integer>
  - toFloat
```
public ExpressionImplementor<Float> toFloat(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toFloat in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<Float>
  - toDouble
```
public ExpressionImplementor<Double> toDouble(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toDouble in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<Double>
  - toBigDecimal
```
public ExpressionImplementor<BigDecimal> toBigDecimal(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toBigDecimal in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<BigDecimal>
  - toBigInteger
```
public ExpressionImplementor<BigInteger> toBigInteger(Expression<? extends Number> expression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toBigInteger in interface CriteriaBuilder
    
    Parameters:
    expression - numeric expression
    
    Returns:
    Expression<BigInteger>
  - toString
```
public ExpressionImplementor<String> toString(Expression<Character> characterExpression)
```
    Typecast. Returns same expression object.
    
    Specified by:
    
    toString in interface CriteriaBuilder
    
    Parameters:
    characterExpression - expression
    
    Returns:
    Expression<String>
  - exists
```
public Predicate exists(Subquery<?> subquery)
```
    Create a predicate testing the existence of a subquery result.
    
    Specified by:
    
    exists in interface CriteriaBuilder
    
    Parameters:
    subquery - subquery whose result is to be tested
    
    Returns:
    exists predicate
  - all
```
public <Y> Expression<Y> all(Subquery<Y> subquery)
```
    Create an all expression over the subquery results.
    
    Specified by:
    
    all in interface CriteriaBuilder
    
    Parameters:
    subquery - subquery
    
    Returns:
    all expression
  - some
```
public <Y> Expression<Y> some(Subquery<Y> subquery)
```
    Create a some expression over the subquery results. This expression is equivalent to an any expression.
    
    Specified by:
    
    some in interface CriteriaBuilder
    
    Parameters:
    subquery - subquery
    
    Returns:
    some expression
  - any
```
public <Y> Expression<Y> any(Subquery<Y> subquery)
```
    Create an any expression over the subquery results. This expression is equivalent to a some expression.
    
    Specified by:
    
    any in interface CriteriaBuilder
    
    Parameters:
    subquery - subquery
    
    Returns:
    any expression
  - coalesce
```
public <Y> Expression<Y> coalesce(Expression<? extends Y> exp1,
                         Expression<? extends Y> exp2)
```
    Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
    
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Parameters:
    exp1 - expression
    exp2 - expression
    
    Returns:
    coalesce expression
  - coalesce
```
public <Y> Expression<Y> coalesce(Class<Y> type,
                         Expression<? extends Y> exp1,
                         Expression<? extends Y> exp2)
```
  - coalesce
```
public <Y> Expression<Y> coalesce(Expression<? extends Y> exp1,
                         Y exp2)
```
    Create an expression that returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.
    
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Parameters:
    exp1 - expression
    exp2 - value
    
    Returns:
    coalesce expression
  - coalesce
```
public <Y> Expression<Y> coalesce(Class<Y> type,
                         Expression<? extends Y> exp1,
                         Y exp2)
```
  - coalesce
```
public <T> CriteriaBuilder.Coalesce<T> coalesce()
```
    Create a coalesce expression.
    
    Specified by:
    
    coalesce in interface CriteriaBuilder
    
    Returns:
    coalesce expression
  - coalesce
```
public <T> CriteriaBuilder.Coalesce<T> coalesce(Class<T> type)
```
  - concat
```
public Expression<String> concat(Expression<String> string1,
                        Expression<String> string2)
```
    Create an expression for string concatenation.
    
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Parameters:
    string1 - string expression
    string2 - string expression
    
    Returns:
    expression corresponding to concatenation
  - concat
```
public Expression<String> concat(Expression<String> string1,
                        String string2)
```
    Create an expression for string concatenation.
    
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Parameters:
    string1 - string expression
    string2 - string
    
    Returns:
    expression corresponding to concatenation
  - concat
```
public Expression<String> concat(String string1,
                        Expression<String> string2)
```
    Create an expression for string concatenation.
    
    Specified by:
    
    concat in interface CriteriaBuilder
    
    Parameters:
    string1 - string
    string2 - string expression
    
    Returns:
    expression corresponding to concatenation
  - nullif
```
public <Y> Expression<Y> nullif(Expression<Y> exp1,
                       Expression<?> exp2)
```
    Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
    
    Specified by:
    
    nullif in interface CriteriaBuilder
    
    Parameters:
    exp1 - expression
    exp2 - expression
    
    Returns:
    nullif expression
  - nullif
```
public <Y> Expression<Y> nullif(Class<Y> type,
                       Expression<Y> exp1,
                       Expression<?> exp2)
```
  - nullif
```
public <Y> Expression<Y> nullif(Expression<Y> exp1,
                       Y exp2)
```
    Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not.
    
    Specified by:
    
    nullif in interface CriteriaBuilder
    
    Parameters:
    exp1 - expression
    exp2 - value
    
    Returns:
    nullif expression
  - nullif
```
public <Y> Expression<Y> nullif(Class<Y> type,
                       Expression<Y> exp1,
                       Y exp2)
```
  - selectCase
```
public <C,R> CriteriaBuilder.SimpleCase<C,R> selectCase(Expression<? extends C> expression)
```
    Create a simple case expression.
    
    Specified by:
    
    selectCase in interface CriteriaBuilder
    
    Parameters:
    expression - to be tested against the case conditions
    
    Returns:
    simple case expression
  - selectCase
```
public <C,R> CriteriaBuilder.SimpleCase<C,R> selectCase(Class<R> type,
                                               Expression<? extends C> expression)
```
  - selectCase
```
public <R> CriteriaBuilder.Case<R> selectCase()
```
    Create a general case expression.
    
    Specified by:
    
    selectCase in interface CriteriaBuilder
    
    Returns:
    general case expression
  - selectCase
```
public <R> CriteriaBuilder.Case<R> selectCase(Class<R> type)
```
  - size
```
public <C extends Collection<?>> Expression<Integer> size(C c)
```
    Create an expression that tests the size of a collection.
    
    Specified by:
    
    size in interface CriteriaBuilder
    
    Parameters:
    c - collection
    
    Returns:
    size expression
  - size
```
public <C extends Collection<?>> Expression<Integer> size(Expression<C> exp)
```
    Create an expression that tests the size of a collection.
    
    Specified by:
    
    size in interface CriteriaBuilder
    
    Parameters:
    exp - expression
    
    Returns:
    size expression
  - values
```
public <V,M extends Map<?,V>> Expression<Collection<V>> values(M map)
```
    Create an expression that returns the values of a map.
    
    Specified by:
    
    values in interface CriteriaBuilder
    
    Parameters:
    map - map
    
    Returns:
    collection expression
  - keys
```
public <K,M extends Map<K,?>> Expression<Set<K>> keys(M map)
```
    Create an expression that returns the keys of a map.
    
    Specified by:
    
    keys in interface CriteriaBuilder
    
    Parameters:
    map - map
    
    Returns:
    set expression
  - isEmpty
```
public <C extends Collection<?>> Predicate isEmpty(Expression<C> collectionExpression)
```
    Create a predicate that tests whether a collection is empty.
    
    Specified by:
    
    isEmpty in interface CriteriaBuilder
    
    Parameters:
    collectionExpression - expression
    
    Returns:
    is-empty predicate
  - isNotEmpty
```
public <C extends Collection<?>> Predicate isNotEmpty(Expression<C> collectionExpression)
```
    Create a predicate that tests whether a collection is not empty.
    
    Specified by:
    
    isNotEmpty in interface CriteriaBuilder
    
    Parameters:
    collectionExpression - expression
    
    Returns:
    is-not-empty predicate
  - isMember
```
public <E,C extends Collection<E>> Predicate isMember(E e,
                                             Expression<C> collectionExpression)
```
    Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false.
    
    Specified by:
    
    isMember in interface CriteriaBuilder
    
    Parameters:
    e - element
    collectionExpression - expression
    
    Returns:
    is-member predicate
  - isNotMember
```
public <E,C extends Collection<E>> Predicate isNotMember(E e,
                                                Expression<C> cExpression)
```
    Create a predicate that tests whether an element is not a member of a collection. If the collection is empty, the predicate will be true.
    
    Specified by:
    
    isNotMember in interface CriteriaBuilder
    
    Parameters:
    e - element
    cExpression - expression
    
    Returns:
    is-not-member predicate
  - isMember
```
public <E,C extends Collection<E>> Predicate isMember(Expression<E> elementExpression,
                                             Expression<C> collectionExpression)
```
    Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false.
    
    Specified by:
    
    isMember in interface CriteriaBuilder
    
    Parameters:
    elementExpression - element expression
    collectionExpression - expression
    
    Returns:
    is-member predicate
  - isNotMember
```
public <E,C extends Collection<E>> Predicate isNotMember(Expression<E> eExpression,
                                                Expression<C> cExpression)
```
    Create a predicate that tests whether an element is not a member of a collection. If the collection is empty, the predicate will be true.
    
    Specified by:
    
    isNotMember in interface CriteriaBuilder
    
    Parameters:
    eExpression - element expression
    cExpression - expression
    
    Returns:
    is-not-member predicate

Class CriteriaBuilderImpl

Nested Class Summary

Nested classes/interfaces inherited from interface javax.persistence.criteria.CriteriaBuilder

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

CriteriaBuilderImpl

Method Detail

getEntityManagerFactory

createQuery

createQuery

createTupleQuery

tuple

tuple

array

array

array

construct

construct

asc

desc

wrap

not

and

or

and

or

conjunction

disjunction

isTrue

isFalse

isNull

isNotNull

equal

notEqual

equal

notEqual

greaterThan

lessThan

greaterThanOrEqualTo

lessThanOrEqualTo

greaterThan

lessThan

greaterThanOrEqualTo

lessThanOrEqualTo

gt

lt

ge

le

gt

lt

ge

le

between

between

in

in

in

in

like

like

like

like

like

like

notLike

notLike

notLike

notLike

notLike

notLike

parameter

parameter

literal

nullLiteral

avg

sum

sumAsLong

sumAsDouble