JPA Criteria builder IN clause query

Question

How to write criteria builder api query for below given JPQL query? I am using JPA 2.2.

SELECT *  FROM Employee e WHERE e.Parent IN ('John','Raj') ORDER BY e.Parent 

Answer 1

This criteria set-up should do the trick:

CriteriaBuilder cb = entityManager.getCriteriaBuilder(); CriteriaQuery<Employee> q = cb.createQuery(Employee.class);   Root<Employee> root = q.from(Employee.class); q.select(root);  List<String> parentList = Arrays.asList(new String[]{"John", "Raj"});  Expression<String> parentExpression = root.get(Employee_.Parent); Predicate parentPredicate = parentExpression.in(parentList); q.where(parentPredicate); q.orderBy(cb.asc(root.get(Employee_.Parent));  q.getResultList(); 

I have used the overloaded CriteriaQuery.where method here which accepts a Predicate.. an in predicate in this case.