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

.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 jakarta.persistence.criteria. Predicate boolean isNegated () Whether the predicate has been created from another predicate by applying () or by calling CriteriaBuilder.not . Return: boolean indicating if the predicate is a negated predicate Since: JPA 2.0

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

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 jakarta.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 jakarta.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 (List  restrictions) Create a conjunction of the given

; 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

or whether they must be retained Return: the modified subquery. Since: JPA 2.0 Predicate equalTo ( Expression  value) Create a predicate to test whether the expression is equal to the argument. Parameters: value - expression to be tested against Return: predicate testing for equality Inherited

Predicate equalTo ( Expression  value) Create a predicate to test whether the expression is equal to the argument. Parameters: value - expression to be tested against Return: predicate testing for equality Since: JPA 3.2 Predicate equalTo (Object value) Create a predicate to test

from: Expression Since: JPA 3.2 Predicate equalTo ( Expression  value) Create a predicate to test ... against Return: predicate testing for equality Inherited from: Expression Since: JPA 3.2 Predicate equalTo (Object value) Create a predicate to test whether the expression is equal to the argument

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

Since: JPA 2.0 Predicate getGroupRestriction () Return the predicate that corresponds to the restriction(s ... predicate Since: JPA 2.0 Set getParameters () Return the parameters of the query. Returns empty set ... Inherited from: CommonAbstractCriteria Since: JPA 2.1 Predicate getRestriction () Return

. Return: 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

. Return: the query parameters Inherited from: CommonAbstractCriteria 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

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

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 ... Since: JPA 2.1 CriteriaUpdate where ( Predicate ... restrictions) Modify the update query

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 Predicate and (   List  restrictions ) Create a conjunction of the given restriction predicates . A conjunction of zero predicates is true. Parameters: restrictions - a list of zero or more restriction predicates Return: and predicate Since: JPA 3.2

Since: JPA 2.0 Predicate getOn () Return the predicate that corresponds to the ON restriction(s) on the join, or null if no ON condition has been specified. Return: the ON restriction predicate ... join object Since: JPA 2.1 Join on ( Predicate ... restrictions) Modify the join to restrict

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

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

; Predicate ... restrictions ) Modify the query to restrict the query result according to the conjunction of the specified restriction predicates . Replaces the previously added restriction(s), if any ... - zero or more restriction predicates Return: the modified query Since: JPA 2.0

; Predicate ... restrictions ) Modify the DELETE query to restrict the target of the deletion according to the conjunction of the specified restriction predicates . Replaces the previously added ... removed. Parameters: restrictions - zero or more restriction predicates Return: the modified delete query Since: JPA 2.1

JPA Method in jakarta.persistence.criteria.Expression Predicate equalTo (    Expression  value ) Create a predicate to test whether the expression is equal to the argument. Parameters: value - expression to be tested against Return: predicate testing for equality Since: JPA 3.2

JPA Method in jakarta.persistence.criteria.Expression Predicate notEqualTo (   Object value ) Create a predicate to test whether the expression is unequal to the argument. Parameters: value - value to be tested against Return: predicate testing for inequality Since: JPA 3.2

JPA Method in jakarta.persistence.criteria.Expression Predicate notEqualTo (    Expression  value ) Create a predicate to test whether the expression is unequal to the argument. Parameters: value - expression to be tested against Return: predicate testing for inequality Since: JPA 3.2

JPA Method in jakarta.persistence.criteria.Expression Predicate equalTo (   Object value ) Create a predicate to test whether the expression is equal to the argument. Parameters: value - value to be tested against Return: predicate testing for equality Since: JPA 3.2

JPA Method in jakarta.persistence.criteria.Subquery Subquery having (    Predicate ... of the specified restriction predicates . Replaces the previously added having restriction(s), if any ... - zero or more restriction predicates Return: the modified subquery 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 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 jakarta.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 jakarta.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 jakarta.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