Just remove the productItemJoin
and use the productItemFetch
instead.
CriteriaBuilder builder = em.getCriteriaBuilder();
CriteriaQuery<Ereturn> criteria = builder.createQuery( Ereturn.class );
Root<Ereturn> er = criteria.from(Ereturn.class);
Fetch<Ereturn, ProductItem> productItemFetch = er.fetch("productItems", JoinType.LEFT);
List<Predicate> predicates = new ArrayList<>();
predicates.add(builder.equal( productItemFetch.get( "status" ), "RECEIVED"));
criteria.where(
builder.and(predicates.toArray(new Predicate[predicates.size()]))
);
List<Ereturn> ers = em.createQuery( criteria )
.getResultList();