About Criteria API

manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries. The JPA Criteria API provides an alternative way for defining JPA queries, which is mainly ... page covers the following topics: JPA Criteria API vs JPQL First JPA Criteria Query ...

 
manual

JPA Query Structure (JPQL / Criteria)

Explains the structure of a JPQL query, which consists of 6 clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.... the following pages: SELECT clause (JPQL / Criteria API) FROM clause (JPQL / Criteria API) WHERE clause (JPQL / ...

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... Reserved Identifiers FROM and JOIN in Criteria Queries Range Variables Range variables ... are all invalid variable names. FROM and JOIN in Criteria Queries FROM query identification variables are represented in ...

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - ... Queries Paths and Types in JPQL and Criteria API Numbers in JPQL and Criteria Queries Strings in JPQL and ...

 
manual

SELECT clause (JPQL / Criteria API)

Explains how to use the SELECT clause and projections in a JPA/JPQL query.... SELECT DISTINCT SELECT in Criteria Queries Projection of Path Expressions ... SELECT in Criteria Queries The criteria query API  provides several ways for setting the SELECT clause. Single ...

 
api-jpa

JPA Queries

Reference (JavaDoc) of all the JPA query types, including Query, TypedQuery, CriteriaBuilder, CriteriaQuery, Tuple, Root, Expression, Order, etc.... The JPA Query API section (in chapter 4 of the ObjectDB manual) provides detailed ... queries (e.g. "SELECT c FROM Country" ). Criteria Query API Building dynamic queries whose structure is only ... a valid complete JPQL query. JPA 2 introduced the JPA Criteria Query API , as a cleaner alternative that enables building a dynamic ...

 
manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... JPQL Expressions in WHERE WHERE in Criteria Queries How a WHERE Clause Works The ... especially dominant in the WHERE clause. WHERE in Criteria Queries The CriteriaQuery ... :p can be built by using the criteria query API as follows: CriteriaQuery ...

 
manual

ORDER BY clause (JPQL / Criteria API)

Explains how to use the ORDER BY clause in a JPA/JPQL query.... Grouping (GROUP BY) Order ORDER BY in Criteria Queries ORDER BY Expressions The ... the result order would be undefined. ORDER BY in Criteria Queries The CriteriaQuery ... DESC can be built using the criteria query API as follows: CriteriaQuery ...

 
api-jpa

Criteria Query Selection and Results

Reference (JavaDoc) of JPA query criteria result interfaces, including Selection, CompoundSelection, Order and Tuple. The JPA Criteria API interfaces in this group are in use for setting the SELECT and ORDER BY ... Elements The content of the SELECT clause in a criteria query is represented by Selection : ...

 
api-jpa

Criteria Query From Elements

Reference (JavaDoc) of JPA query criteria FROM clause interfaces, including From, Root, Join and Fetch. The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The FROM clause  in JPA queries (as in ...