CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery();
Root<UserHD> z = cq.from(UserHD.class);
Join<UserHD, Role> j = z.join(UserHD_.role);
cq.where(cb.equal(j.get(Role_.name), RoleEnum.CUSTOMER));
cq.orderBy(cb.asc(z.get(UserHD_.name)));
cq.select(z);
List<UserHD> l = getEntityManager().createQuery(cq).getResultList();
return l;