About restriction
WHERE clause (JPQL / Criteria API)
Explains how to use the WHERE clause in a JPQL query.... methods for setting the WHERE clause. Single Restriction The first where where(restriction) CriteriaQuery's method Modify the query to restrict ...
javax.persistence.criteria.Subquery
The Subquery interface defines functionality that is specific to subqueries.(Interface of JPA)
javax.persistence.criteria.CriteriaQuery
The CriteriaQuery interface defines functionality that is specific to top-level queries.(Interface of JPA)
where(restriction)
Modify the query to restrict the query result according to the specified boolean expression.(Method of javax.persistence.criteria.CriteriaQuery)
where(restrictions)
Modify the query to restrict the query result according to the conjunction of the specified restriction predicates.(Method of javax.persistence.criteria.CriteriaQuery)
javax.persistence.criteria.Predicate
The type of a simple or compound predicate: a conjunction or disjunction of restrictions.(Interface of JPA)
not(restriction)
Create a negation of the given restriction.(Method of javax.persistence.criteria.CriteriaBuilder)
having(restriction)
Specify a restriction over the groups of the query.(Method of javax.persistence.criteria.CriteriaQuery)
having(restrictions)
Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates.(Method of javax.persistence.criteria.CriteriaQuery)
Comparison in JPQL and Criteria API
Explains how comparison operators can be used in JPQL queries, including in comparing null values. Most JPQL queries use at least one comparison operator in their WHERE clause. This page covers the following topics: Comparison Operators Comparing NULL values IS [NOT] NULL Comp ...
