JPA Interface

CriteriaQuery

Type Parameters:
<T> - the type of the defined result
Super Interfaces:
AbstractQuery<T>, CommonAbstractCriteria, CriteriaSelect<T>
The CriteriaQuery interface defines functionality that is specific to top-level queries.
Since:
JPA 2.0
The JPA Criteria API Queries article explains how to use CriteriaQuery.

Public Methods

CriteriaQuery<T> distinct(boolean distinct)
Specify whether duplicate query results are eliminated.
A true value will cause duplicates to be eliminated. A false value will cause duplicates to be retained. If distinct has not been specified, duplicate results must be retained. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
distinct - boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained
Return:
the modified query.
Since:
JPA 2.0
Root<X> from(Class<X> entityClass)
Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.
Parameters:
entityClass - the entity class
Return:
query root corresponding to the given entity
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
Root<X> from(EntityType<X> entity)
Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots.
Parameters:
entity - metamodel entity representing the entity of type X
Return:
query root corresponding to the given entity
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
List<Expression<?>> getGroupList()
Return a list of the grouping expressions.
Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query.
Return:
the list of grouping expressions
Inherited from:
AbstractQuery<T>
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:
AbstractQuery<T>
Since:
JPA 2.0
List<Order> getOrderList()
Return the ordering expressions in order of precedence.
Returns empty list if no ordering expressions have been specified. Modifications to the list do not affect the query.
Return:
the list of ordering expressions
Since:
JPA 2.0
Class<T> getResultType()
Return the result type of the query or subquery.
If a result type was specified as an argument to the createQuery or subquery method, that type is returned. If the query was created using the createTupleQuery method, the result type is Tuple. Otherwise, the result type is Object.
Return:
result type
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
Set<Root<?>> getRoots()
Return the query roots.
These are the roots that are defined for the CriteriaQuery or Subquery itself, including any subquery roots defined as a result of correlation. Returns an empty set if no roots have been defined. Modifications to the set do not affect the query.
Return:
the set of query roots
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
Selection<T> getSelection()
Return the selection of the query, or null if no selection has been set.
Return:
selection item
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
CriteriaQuery<T> groupBy(Expression<?>... grouping)
Specify the expressions that are used to form groups over the query results.
Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
grouping - zero or more grouping expressions
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> groupBy(List<Expression<?>> grouping)
Specify the expressions that are used to form groups over the query results.
Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
grouping - list of zero or more grouping expressions
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> having(Expression<Boolean> restriction)
Specify a restriction over the groups of the query.
Replaces the previous having restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restriction - a simple or compound boolean expression
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> having(List<Predicate> restrictions)
Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates.
Replaces the previously added having restriction(s), if any. If no restrictions are specified, any previously added restrictions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restrictions - a list of zero or more restriction predicates
Return:
the modified query
Since:
JPA 3.2
CriteriaQuery<T> having(Predicate... restrictions)
Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates.
Replaces the previously added having restriction(s), if any. If no restrictions are specified, any previously added restrictions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restrictions - zero or more restriction predicates
Return:
the modified query
Since:
JPA 2.0
boolean isDistinct()
Return whether duplicate query results must be eliminated or retained.
Return:
boolean indicating whether duplicate query results must be eliminated
Inherited from:
AbstractQuery<T>
Since:
JPA 2.0
CriteriaQuery<T> orderBy(List<Order> o)
Specify the ordering expressions that are used to order the query results.
Replaces the previous ordering expressions, if any. If no ordering expressions are specified, the previous ordering, if any, is simply removed, and results will be returned in no particular order. The order of the ordering expressions in the list determines the precedence, whereby the first element in the list has the highest precedence.
Parameters:
o - list of zero or more ordering expressions
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> orderBy(Order... o)
Specify the ordering expressions that are used to order the query results.
Replaces the previous ordering expressions, if any. If no ordering expressions are specified, the previous ordering, if any, is simply removed, and results will be returned in no particular order. The left-to-right sequence of the ordering expressions determines the precedence, whereby the leftmost has the highest precedence.
Parameters:
o - zero or more ordering expressions
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> select(Selection<?extendsT> selection)
Specify the item that is to be returned in the query result.
Replaces the previously specified selection(s), if any.

Note: Applications using the string-based API may need to specify the type of the select item when it results from a get or join operation and the query result type is specified.

For example: 

 CriteriaQuery<String> q = cb.createQuery(String.class);
 Root<Order> order = q.from(Order.class);
 q.select(order.get("shippingAddress").<String>get("state"));

 CriteriaQuery<Product> q2 = cb.createQuery(Product.class);
 q2.select(q2.from(Order.class)
             .join("items")
             .<Item, Product>join("product"));
Parameters:
selection - selection specifying the item that is to be returned in the query result
Return:
the modified query
Throws:
IllegalArgumentException - if the selection is a compound selection and more than one selection item has the same assigned alias
Since:
JPA 2.0
CriteriaQuery<T> where(Expression<Boolean> restriction)
Modify the query to restrict the query result according to the specified boolean expression.
Replaces the previously added restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restriction - a simple or compound boolean expression
Return:
the modified query
Since:
JPA 2.0
CriteriaQuery<T> where(List<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. If no restrictions are specified, any previously added restrictions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restrictions - a list of zero or more restriction predicates
Return:
the modified query
Since:
JPA 3.2
CriteriaQuery<T> where(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. If no restrictions are specified, any previously added restrictions are simply removed. This method only overrides the return type of the corresponding AbstractQuery method.
Parameters:
restrictions - zero or more restriction predicates
Return:
the modified query
Since:
JPA 2.0