ObjectDB Database Search

part of its JDO support. Criteria Query Logical Operators Boolean Expressions and Predicates Boolean ... . get ("isInUN"); Path isInEU = country. get ("isInEU"); Path isInOECD = country. get ("isInOECD"); Predicate ... whose type is boolean - such as comparison operators: Predicate isLarge = cb. gt (country. get ("area

"); Expression param = cb. parameter (String.class); // collection IS [NOT] EMPTY Predicate e1 = cb. isEmpty (languages); Predicate e2 = cb. isNotEmpty (languages); // element [NOT] MEMBER OF collection Predicate m1 = cb. isMember (param, languages); Predicate m2 = cb. isMember ("English", languages

= :min AND x ) Predicate gt1 = cb. greaterThan (name, nameParam); Predicate gt2 = cb. greaterThan (name, "India"); Predicate gt3 = cb. gt (area, areaParam); Predicate gt4 = cb. gt (area, 1000000);     // Greater Than or Equal (=) Predicate ge1 = cb

JPA Interface Predicate Super Interfaces: Expression , Selection , TupleElement The type of a simple or compound predicate : a conjunction or disjunction of restrictions. A simple predicate ... and Criteria API article explains how to use Predicate . Public Methods List getExpressions () Return

the WHERE predicate , defines which objects to accept. Only Country objects for which the predicate expression evaluates to TRUE are passed to the SELECT clause and then collected as query results. WHERE Predicate ... that index to iterate directly on Country objects that satisfy the WHERE predicate . For entity classes

JPA Method in javax.persistence.criteria. Predicate boolean isNegated () Whether the predicate has been created from another predicate by applying the Predicate .not() method or the CriteriaBuilder.not() method. Return: boolean indicating if the predicate is a negated predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. Predicate Predicate .BooleanOperator getOperator () Return the boolean operator for the predicate . If the predicate is simple, this is AND . Return: boolean operator for the predicate Since: JPA 2.0

.criteria. Predicate $BooleanOperator Since: JPA 2.0 Enum Constants AND Since: JPA 2.0 OR Since: JPA 2.0 Public Static Enum Methods: Predicate .BooleanOperator[] values () Returns an array containing ... over the constants as follows: for ( Predicate .BooleanOperator c : Predicate .BooleanOperator.values

JPA Method in javax.persistence.criteria. Predicate List getExpressions () Return the top-level conjuncts or disjuncts of the predicate . Returns empty list if there are no top-level conjuncts or disjuncts of the predicate . Modifications to the list do not affect the query. Return: list of boolean expressions forming the predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria. Predicate Predicate not () Create a negation of the predicate . Return: negated predicate Since: JPA 2.0

JPA Enum Constant in javax.persistence.criteria. Predicate $BooleanOperator AND Since: JPA 2.0

JPA Enum Constant in javax.persistence.criteria. Predicate $BooleanOperator OR Since: JPA 2.0

Predicate l1 = cb. like (path, param); Predicate l2 = cb. like (path, "a%"); Predicate l3 = cb. notLike (path, param); Predicate l4 = cb. notLike (path, "a%"); // additional methods take also an escape

, predicates , orderings. Note that Predicate is used instead of Expression in this API in order ... Since: JPA 2.0 Predicate and ( Expression  x,  Expression  y) Create a conjunction ... : and predicate Since: JPA 2.0 Predicate and ( Predicate ... restrictions) Create a conjunction

; Country . Predicate p = cb. notEqual (e. type (), cb. literal (Country.class)); In the above example

; Expression argument and the other having form takes a variable number of Predicate  arguments

Predicate getGroupRestriction () Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Return: having clause predicate ... Subquery having ( Predicate ... restrictions) Specify restrictions over the groups

JPA Interface In Super Interfaces: Expression , Predicate , Selection , TupleElement Interface used to build in predicates . Since: JPA 2.0 Public Methods Expression getExpression () Return ... () Return the top-level conjuncts or disjuncts of the predicate . Returns empty list

of the expression Return: new expression of the given type Inherited from: Expression Since: JPA 2.0 Predicate in (Collection  values) Create a predicate to test whether the expression is a member of the collection. Parameters: values - collection of values to be tested against Return: predicate testing

Predicate in (Collection  values) Create a predicate to test whether the expression is a member of the collection. Parameters: values - collection of values to be tested against Return: predicate testing for membership Since: JPA 2.0 Predicate in ( Expression ... values) Create a predicate

Inherited from: Parameter Since: JPA 2.0 Predicate in (Collection  values) Create a predicate ... to be tested against Return: predicate testing for membership Inherited from: Expression Since: JPA 2.0 Predicate in ( Expression ... values) Create a predicate to test whether the expression

Since: JPA 2.0 Predicate getGroupRestriction () Return the predicate that corresponds to the restriction ... predicate Since: JPA 2.0 Predicate getRestriction () Return the predicate that corresponds ... predicate Inherited from: CommonAbstractCriteria Since: JPA 2.1 Class getResultType () Return the result

: the list of grouping expressions Inherited from: AbstractQuery Since: JPA 2.0 Predicate getGroupRestriction () Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Return: having clause predicate Inherited from

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

corresponding to the given entity Since: JPA 2.1 Predicate getRestriction () Return the predicate ... . Return: where clause predicate Inherited from: CommonAbstractCriteria Since: JPA 2.1 Root getRoot ... where ( Predicate ... restrictions) Modify the delete query to restrict the target of the deletion

Return: query root corresponding to the given entity Since: JPA 2.1 Predicate getRestriction () Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified. Return: where clause predicate Inherited from: CommonAbstractCriteria Since: JPA 2.1

made from this type Inherited from: From Since: JPA 2.0 Predicate getOn () Return the predicate ... : the ON restriction predicate Since: JPA 2.1 From getParent () Return the parent of the join ... Return: the modified join object Since: JPA 2.1 Join on ( Predicate ... restrictions) Modify the join

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isMember (    Expression  elem,     Expression  collection ) Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isMember (   E elem,     Expression  collection ) Create a predicate that tests whether an element is a member of a collection. If the collection is empty, the predicate will be false. Parameters

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isNotMember (    Expression  elem,     Expression  collection ) Create a predicate that tests whether an element is not a member of a collection. If the collection is empty, the predicate

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isNotMember (   E elem,     Expression  collection ) 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

JPA Method in javax.persistence.criteria.AbstractQuery AbstractQuery where (    Predicate ... of the specified restriction predicates . Replaces the previously added restriction(s), if any ... : restrictions - zero or more restriction predicates Return: the modified query Since: JPA 2.0

; Predicate ... restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates . Replaces the previously having added restriction(s ... . Parameters: restrictions - zero or more restriction predicates Return: the modified query Since: JPA 2.0

JPA Method in javax.persistence.criteria.AbstractQuery Predicate getGroupRestriction () Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Return: having clause predicate Since: JPA 2.0

of the update or delete. Since: JPA 2.1 Public Methods Predicate getRestriction () Return the predicate ... . Return: where clause predicate Since: JPA 2.1 Subquery subquery (Class  type) Create

JPA Method in javax.persistence.criteria.CommonAbstractCriteria Predicate getRestriction () Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified. Return: where clause predicate Since: JPA 2.1

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 Predicate isTrue (    Expression  x ) Create a predicate testing for a true value. Parameters: x - expression to be tested Return: predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isFalse (    Expression  x ) Create a predicate testing for a false value. Parameters: x - expression to be tested Return: predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isNull (    Expression  x ) Create a predicate to test whether the expression is null. Parameters: x - expression Return: is-null predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate isNotNull (    Expression  x ) Create a predicate to test whether the expression is not null. Parameters: x - expression Return: is-not-null predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate equal (    Expression  x,     Expression  y ) Create a predicate for testing the arguments for equality. Parameters: x - expression y - expression Return: equality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate equal (    Expression  x,    Object y ) Create a predicate for testing the arguments for equality. Parameters: x - expression y - object Return: equality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate notEqual (    Expression  x,     Expression  y ) Create a predicate for testing the arguments for inequality. Parameters: x - expression y - expression Return: inequality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate notEqual (    Expression  x,    Object y ) Create a predicate for testing the arguments for inequality. Parameters: x - expression y - object Return: inequality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate greaterThan (    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 greaterThan (    Expression  x,    Y 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 greaterThanOrEqualTo (    Expression  x,     Expression  y ) Create a predicate for testing ... - expression Return: greater-than-or-equal 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