ObjectDB Database 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 ... the JPA criteria API as follows: CriteriaBuilder cb = em. getCriteriaBuilder (); CriteriaQuery q

JPA Interface CriteriaBuilder Used to construct criteria queries, compound selections, expressions ... Criteria API Queries article explains how to use CriteriaBuilder . Public Methods Expression abs ... to its argument. Parameters: x - expression Return: ceiling Since: JPA 2.0 CriteriaBuilder .Coalesce

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

. 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 jakarta.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 jakarta.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 jakarta.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 jakarta.persistence.criteria. CriteriaBuilder CriteriaBuilder .Case selectCase () Create a general case expression. Return: general case expression Since: JPA 2.0

JPA Method in jakarta.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 jakarta.persistence.criteria. CriteriaBuilder CriteriaBuilder .Coalesce coalesce () Create a coalesce expression. Return: coalesce expression Since: JPA 2.0

JPA Method in jakarta.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 Method in jakarta.persistence.criteria. CriteriaBuilder Expression concat (   List  expressions ) Create an expression for string concatenation. If the given list of expressions is empty, returns an expression equivalent to literal("") . Parameters: expressions - string

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 jakarta.persistence.criteria. CriteriaBuilder Predicate or (   List  restrictions ) Create a disjunction of the given restriction predicates. A disjunction of zero predicates is false. Parameters: restrictions - a list of zero or more restriction predicates Return: or predicate Since: JPA 3.2

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression right (    Expression  x,    int len ) Create an expression for the rightmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the rightmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression left (    Expression  x,    int len ) Create an expression for the leftmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the leftmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression right (    Expression  x,     Expression  len ) Create an expression for the rightmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the rightmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression left (    Expression  x,     Expression  len ) Create an expression for the leftmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the leftmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression replace (    Expression  x,    String substring,     Expression  replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression replace (    Expression  x,     Expression  substring,     Expression  replacement ) Create an expression replacing every occurrence of a substring within a string

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression replace (    Expression  x,    String substring,    String replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression replace (    Expression  x,     Expression  substring,    String replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression sign (    Expression  x ) Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, -1 if its argument is negative, or 0 if its argument is exactly zero. Parameters: x - expression Return: sign Since: JPA 2.0

JPA Method in jakarta.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 jakarta.persistence.criteria. CriteriaBuilder Expression ceiling (    Expression  x ) Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument. Parameters: x - expression Return: ceiling Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. CriteriaBuilder Expression floor (    Expression  x ) Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument. Parameters: x - expression Return: floor Since: JPA 2.0

JPA Method in jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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