166 | Criteria Query Selection and ResultsThe JPA Criteria API interfaces in this group are used for setting the SELECT and ORDER BY clauses ... clause in a criteria query is represented by Selection: Because Selection is a super interface of Expression, any criteria expression can be used as the SELECT clause content. Multiple selection |
163 | Chapter 4 - JPA Queries (JPQL / Criteria) well as how to use the JPA Criteria API, which provides an alternative way for building queries in JPA, based on JPQL. The first section describes the API that JPA provides for using dynamic and static ... (and a criteria query) is explained by describing the main clauses of JPQL queries (SELECT, FROM, WHERE, GROUP |
157 | JPA Query Expressions (JPQL / Criteria)Query expressions are the foundations on which JPQL and criteria queries are built. Every query ... of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists |
156 | JPA Query Structure (JPQL / Criteria) on how to set criteria query clauses are provided as follows: Criteria SELECT (select, distinct, multiselect, array, tuple, construct). Criteria FROM (from, join, fetch). Criteria WHERE (where). Criteria GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc). |
156 | Criteria Query From ElementsThe interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query ... are represented in criteria queries by descendant interfaces of the From interface: Range variables ... and its descendant interfaces: See the FROM in Criteria Queries section for more details and examples. Join |
152 | Strings in JPQL and Criteria Queries operator). Criteria Query String Expressions JPQL string operators and functions (which are described above) are available also as JPA criteria query expressions. The CriteriaBuilder interface provides ... and when applicable simple Java objects as well as criteria expressions. |
152 | Numbers in JPQL and Criteria Queries of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described above) are available also as JPA criteria query ... two operands. At least one operand must be a criteria numeric expression. The other operand |
150 | Date and Time in JPQL and Criteria Queries in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date ... when the query is run. Functions for extracting date and time parts are also available in criteria queries |
150 | Collections in JPQL and Criteria Queries of collection, so in ObjectDB these operators are treated as synonyms. Criteria Query Collection ... criteria query expressions. The CriteriaBuilder interface provides factory methods for building |
147 | Criteria Query ExpressionsThe following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples. |
