70 | Comparison in JPQL and Criteria API); // Equal (=) Predicate eq1 = cb.equal(name, nameParam); Predicate eq2 = cb.equal(name, "India"); Predicate eq3 = cb.equal(area, areaParam); Predicate eq4 = cb.equal(area, 1000000); // Not Equal (<>) Predicate ne1 = cb.notEqual(name, nameParam); Predicate ne2 = cb |
56 | javax.persistence.criteria.CriteriaBuilder selections, expressions, predicates, orderings. Note that Predicate is used instead of Expression in ... : subquery - subquery Returns: all expression Since: JPA 2.0 Predicate and( Predicate... restrictions) Create a conjunction of the given restriction predicates. Create a conjunction of the given |
54 | Logical Operators in JPQL and Criteria API part of its JDO support. Criteria Query Logical Operators Boolean Expressions and Predicates Boolean expressions ... = country.get("isInOECD"); Predicate is a special sub interface of Expression<Boolean ... : Predicate isLarge = cb.gt(country.get("area"), 1000000); AND / OR Expressions The CriteriaBuilder |
36 | Collections in JPQL and Criteria Queries.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 |
34 | WHERE clause (JPQL / Criteria API) 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 ... to iterate directly on Country objects that satisfy the WHERE predicate. For entity classes |
26 | javax.persistence.criteria.Subquery to the list do not affect the query. Returns: the list of grouping expressions 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 the predicate that corresponds |
26 | javax.persistence.criteria.CriteriaBuilder.In>, Predicate, Selection<Boolean>, TupleElement<Boolean> Interface used to build in predicates. Since: JPA ... conjuncts or disjuncts of the predicate. 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 |
25 | Strings in JPQL and Criteria Queries> param = cb.parameter(String.class); // str [NOT] LIKE pattern Predicate l1 = cb.like(path, param); Predicate l2 = cb.like(path, "a%"); Predicate l3 = cb.notLike(path, param); Predicate |
19 | javax.persistence.criteria.Expression, ParameterExpression, Path, PluralJoin, Predicate, Root, SetJoin, Subquery Type for query expressions ... Predicate in(Object... values) Create a predicate to test whether the expression is a member of the argument list. Create a predicate to test whether the expression is a member of the argument list |
19 | javax.persistence.criteria.SetJoin if no parent. Returns: parent Since: JPA 2.0 Predicate in(Object... values) Create a predicate to test whether the expression is a member of the argument list. Create a predicate to test ... : predicate testing for membership Since: JPA 2.0 Predicate in(Collection<?> values) Create |
