About restriction

manual

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 ...

 
api-jpa

javax.persistence.criteria.CriteriaQuery

The CriteriaQuery interface defines functionality that is specific to top-level queries.(Interface of JPA)

 
api-jpa

javax.persistence.criteria.Subquery

The Subquery interface defines functionality that is specific to subqueries.(Interface of JPA)

 
api-jpa

where(restriction)

Modify the query to restrict the query result according to the specified boolean expression.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

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)

 
api-jpa

javax.persistence.criteria.Predicate

The type of a simple or compound predicate: a conjunction or disjunction of restrictions.(Interface of JPA)

 
api-jpa

not(restriction)

Create a negation of the given restriction.(Method of javax.persistence.criteria.CriteriaBuilder)

 
api-jpa

having(restriction)

Specify a restriction over the groups of the query.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

having(restrictions)

Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates.(Method of javax.persistence.criteria.CriteriaQuery)

 
manual

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 ...