1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| public List<CentreComptable> findBySociete() {
CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
CriteriaQuery cq = cb.createQuery();
Root<CentreComptable> from = cq.from(CentreComptable.class);
Join<CentreComptable, Societes> societes = from.join(CentreComptable_.societesfk);
CriteriaQuery<CentreComptable> select = cq.select(from);
//select.where(cb.equal(societes.get(Societes_.libelleCourt), "ELIT"));
TypedQuery<CentreComptable> typedQuery = getEntityManager().createQuery(select);
List<CentreComptable> resultList = typedQuery.getResultList();
return resultList;
} |
Partager