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 ... - expression x - value y - value Return: between predicate Since: JPA 2.0 CriteriaBuilder .Coalesce coalesce

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

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

. 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

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

. 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 

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 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 .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 .Case selectCase () Create a general case expression. Return: general case 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

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,     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

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,    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 CriteriaQuery createQuery () Create a CriteriaQuery object. Return: criteria query object Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaQuery createQuery (   Class  resultClass ) Create a CriteriaQuery object with the specified result type. Parameters: resultClass - type of the query result Return: criteria query object Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaQuery createTupleQuery () Create a CriteriaQuery object that returns a tuple of objects as its result. Return: criteria query object Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaUpdate createCriteriaUpdate (   Class  targetEntity ) Create a CriteriaUpdate query object to perform a bulk update operation. Parameters: targetEntity - target type for update operation Return: the query object Since: JPA 2.1

JPA Method in javax.persistence.criteria. CriteriaBuilder CriteriaDelete createCriteriaDelete (   Class  targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Return: the query object Since: JPA 2.1

JPA Method in javax.persistence.criteria. CriteriaBuilder CompoundSelection construct (   Class  resultClass,     Selection ... selections ) Create a selection item corresponding to a constructor. This method is used to specify a constructor that will be applied

JPA Method in javax.persistence.criteria. CriteriaBuilder CompoundSelection tuple (    Selection ... selections ) Create a tuple-valued selection item. Parameters: selections - selection items Return: tuple-valued compound selection Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder CompoundSelection array (    Selection ... selections ) Create an array-valued selection item. Parameters: selections - selection items Return: array-valued compound selection Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Order asc (    Expression  x ) Create an ordering by the ascending value of the expression. Parameters: x - expression used to define the ordering Return: ascending ordering corresponding to the expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Order desc (    Expression  x ) Create an ordering by the descending value of the expression. Parameters: x - expression used to define the ordering Return: descending ordering corresponding to the expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression avg (    Expression  x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Return: avg expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sum (    Expression  x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sumAsLong (    Expression  x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression sumAsDouble (    Expression  x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression max (    Expression  x ) Create an aggregate expression applying the numerical max operation. Parameters: x - expression representing input value to max operation Return: max expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression min (    Expression  x ) Create an aggregate expression applying the numerical min operation. Parameters: x - expression representing input value to min operation Return: min expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression greatest (    Expression  x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation Return: greatest expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression least (    Expression  x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Return: least expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression count (    Expression  x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Return: count expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression countDistinct (    Expression  x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Return: count distinct expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate exists (    Subquery  subquery ) Create a predicate testing the existence of a subquery result. Parameters: subquery - subquery whose result is to be tested Return: exists predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression all (    Subquery  subquery ) Create an all expression over the subquery results. Parameters: subquery - subquery Return: all expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression some (    Subquery  subquery ) Create a some expression over the subquery results. This expression is equivalent to an any expression. Parameters: subquery - subquery Return: some expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Expression any (    Subquery  subquery ) Create an any expression over the subquery results. This expression is equivalent to a some expression. Parameters: subquery - subquery Return: any expression Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate and (    Expression  x,     Expression  y ) Create a conjunction of the given boolean expressions. Parameters: x - boolean expression y - boolean expression Return: and predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate and (   Predicate... restrictions ) Create a conjunction of the given restriction predicates. A conjunction of zero predicates is true. Parameters: restrictions - zero or more restriction predicates Return: and predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate or (    Expression  x,     Expression  y ) Create a disjunction of the given boolean expressions. Parameters: x - boolean expression y - boolean expression Return: or predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate or (   Predicate... restrictions ) Create a disjunction of the given restriction predicates. A disjunction of zero predicates is false. Parameters: restrictions - zero or more restriction predicates Return: or predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate not (    Expression  restriction ) Create a negation of the given restriction. Parameters: restriction - restriction expression Return: not predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate conjunction () Create a conjunction (with zero conjuncts). A conjunction with zero conjuncts is true. Return: and predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. CriteriaBuilder Predicate disjunction () Create a disjunction (with zero disjuncts). A disjunction with zero disjuncts is false. Return: or predicate Since: JPA 2.0