21 | GROUP BY and HAVING clauses that use that currency: SELECT c.currency, SUM(c.population) FROM Country c WHERE 'Europe' MEMBER ... Country c WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ... language: SELECT SUM(c.population), AVG(c.population) FROM Country c WHERE 'English' MEMBER OF c |
14 | FROM clause (JPQL / Criteria API) WHERE c2 MEMBER OF c1.neighbors Multiple variables are equivalent to nested loops in a program ... , INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD, NEW |
14 | Logical Operators in JPQL and Criteria API instances) and return a new Predicate instance: Predicate p1 = cb.and(isInUN, isInEU); // Member of both UN and EU Predicate p2 = cb.or(isInOECD, isLarge); // Either OECD member or large |
14 | JPA Metamodel API reflection representation of the field (or property) type: Member member = attr.getJavaMember |
11 | javax.persistence.criteria.CriteriaBuilder) Create a predicate that tests whether an element is a member of a 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: elem - element collection - expression Returns: is-member predicate |
10 | ORDER BY clause (JPQL / Criteria API) WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ORDER BY c.currency The ORDER |
10 | ObjectDB Object Database Features & functions (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER |
10 | JPA Query Expressions (JPQL / Criteria)] MEMBER [OF] and the [NOT] LIKE operator. Logical operators: AND, OR, NOT. In addition, JPA queries |
8 | javax.persistence.criteria.From) 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. Parameters: values - values ... <?> values) Create a predicate to test whether the expression is a member of the collection. Create |
1 | [ODB1] Chapter 3 - Persistent Classes class), interface implementations, inner classes, etc. The class members (constructors, methods |
