Internal Website Search

). The CriteriaBuilder interface provides three factory methods for building  CompoundSelection instances - array , tuple and construct . CriteriaBuilder's array The following JPQL query: SELECT c.name, c ... ]); } CriteriaBuilder's tuple The Tuple interface can be used as a clean alternative to Object[] : CriteriaQuery q

: CriteriaBuilder cb = em. getCriteriaBuilder (); CriteriaQuery q = cb. createQuery (Country.class); Root c = q. from (Country.class); q. select (c); The CriteriaBuilder interface serves as the main ... An equivalent query can be built using the JPA criteria API as follows: CriteriaBuilder cb = em

to 0 . Date and Time in Criteria Queries The CriteriaBuilder interface provides three factory methods ... and time parts are also available in criteria queries by using the generic CriteriaBuilder 's function

"), 1000000); AND / OR Expressions The CriteriaBuilder interface provides factory methods ... (); The CriteriaBuilder 's not method creates a Predicate by negating a specified boolean

interface for using the criteria API is the CriteriaBuilder interface: A CriteriaBuilder instance

. Criteria Query Literals The CriteriaBuilder interface provides two factory methods for building literal ... ); or by a special CriteriaBuilder 's method, nullLiteral , that returns a typed expression

JPA Interface CriteriaBuilder Used to construct criteria queries, compound selections, expressions ... Criteria API Queries article explains how to use CriteriaBuilder . Public Methods Expression abs ... - expression x - value y - value Return: between predicate Since: JPA 2.0 CriteriaBuilder .Coalesce coalesce

. CriteriaBuilder $Trimspec Used to specify how strings are trimmed. Since: JPA 2.0 Enum Constants BOTH Trim ... trailing end. Since: JPA 2.0 Public Static Enum Methods: CriteriaBuilder $Trimspec[] values () Returns ... may be used to iterate over the constants as follows: for ( CriteriaBuilder $Trimspec c : CriteriaBuilder

by applying the Predicate.not() method or the CriteriaBuilder .not() method. Return: boolean ... .0 CriteriaBuilder .In value ( Expression  value) Add to list of values to be tested against. Parameters: value - expression Return: in predicate Since: JPA 2.0 CriteriaBuilder .In value (T 

expression. Parameters: result - "else" result Return: expression Since: JPA 2.0 CriteriaBuilder ... case expression Since: JPA 2.0 CriteriaBuilder .SimpleCase when (C condition, R result

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression trim (    CriteriaBuilder .Trimspec ts,    char t,     Expression  x ) Create expression to trim character from a string. Parameters: ts - trim specification t - character

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression trim (    CriteriaBuilder .Trimspec ts,     Expression  t,     Expression  x ) Create expression to trim character from a string. Parameters: ts - trim specification t

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression trim (    CriteriaBuilder .Trimspec ts,     Expression  x ) Create expression to trim blanks from a string. Parameters: ts - trim specification x - expression for string to trim Return: trim expression Since: JPA 2.0

: result - "else" result Return: expression Since: JPA 2.0 CriteriaBuilder .Case when ( Expression   ... Since: JPA 2.0 CriteriaBuilder .Case when ( Expression  condition, R result) Add

: Expression Since: JPA 2.0 CriteriaBuilder .Coalesce value ( Expression  value) Add an argument ... CriteriaBuilder .Coalesce value (T value) Add an argument to the coalesce expression. Parameters

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaBuilder .Case selectCase () Create a general case expression. Return: general case expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaBuilder .SimpleCase selectCase (    Expression  expression ) Create a simple case expression. Parameters: expression - to be tested against the case conditions Return: simple case expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaBuilder .Coalesce coalesce () Create a coalesce expression. Return: coalesce expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaBuilder .In in (    Expression  expression ) Create predicate to test whether given expression is contained in a list of values. Parameters: expression - to be tested against list of values Return: in predicate Since: JPA 2.0

JPA Enum Constant in javax.persistence.criteria. CriteriaBuilder $Trimspec TRAILING Trim from trailing end. Since: JPA 2.0

JPA Enum Constant in javax.persistence.criteria. CriteriaBuilder $Trimspec BOTH Trim from both ends. Since: JPA 2.0

JPA Enum Constant in javax.persistence.criteria. CriteriaBuilder $Trimspec LEADING Trim from leading end. Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression diff (    Expression  x,    N y ) Create an expression that returns the difference between its arguments. Parameters: x - expression y - value Return: difference Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression diff (    Expression  x,     Expression  y ) Create an expression that returns the difference between its arguments. Parameters: x - expression y - expression Return: difference Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression prod (    Expression  x,    N y ) Create an expression that returns the product of its arguments. Parameters: x - expression y - value Return: product Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression prod (   N x,     Expression  y ) Create an expression that returns the product of its arguments. Parameters: x - value y - expression Return: product Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression prod (    Expression  x,     Expression  y ) Create an expression that returns the product of its arguments. Parameters: x - expression y - expression Return: product Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression quot (   Number x,     Expression  y ) Create an expression that returns the quotient of its arguments. Parameters: x - value y - expression Return: quotient Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression quot (    Expression  x,     Expression  y ) Create an expression that returns the quotient of its arguments. Parameters: x - expression y - expression Return: quotient Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression quot (    Expression  x,    Number y ) Create an expression that returns the quotient of its arguments. Parameters: x - expression y - value Return: quotient Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression diff (   N x,     Expression  y ) Create an expression that returns the difference between its arguments. Parameters: x - value y - expression Return: difference Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate le (    Expression  x,    Number y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - value Return: less-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate le (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - expression Return: less-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lt (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - expression Return: less-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lt (    Expression  x,    Number y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - value Return: less-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate ge (    Expression  x,    Number y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - value Return: greater-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sum (   N x,     Expression  y ) Create an expression that returns the sum of its arguments. Parameters: x - value y - expression Return: sum Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sum (    Expression  x,    N y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - value Return: sum Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression abs (    Expression  x ) Create an expression that returns the absolute value of its argument. Parameters: x - expression Return: absolute value Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sum (    Expression  x,     Expression  y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - expression Return: sum Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression neg (    Expression  x ) Create an expression that returns the arithmetic negation of its argument. Parameters: x - expression Return: arithmetic negation Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lessThanOrEqualTo (    Expression  x,    Y y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - value Return: less-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lessThanOrEqualTo (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - expression Return: less-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lessThan (    Expression  x,    Y y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - value Return: less-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate greaterThanOrEqualTo (    Expression  x,    Y y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - value Return: greater-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate lessThan (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - expression Return: less-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate ge (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - expression Return: greater-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate gt (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is greater than the second. Parameters: x - expression y - expression Return: greater-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate gt (    Expression  x,    Number y ) Create a predicate for testing whether the first argument is greater than the second. Parameters: x - expression y - value Return: greater-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate between (    Expression  v,    Y x,    Y y ) Create a predicate for testing whether the first argument is between the second and third arguments in value. Parameters: v