Hi,
I've an entity named Affaire that contains a many to many relation to Commune
This Commune have a many to one relation to District
So I'm trying to get all the Affaire that have affaire.communes.district.libelleFr like = '%Sari%'
I create criteria like this way
Code:
Criteria criteria = session.createCriteria(Affaire.class);
Criteria manyToMany = criteria.createCriteria("communes");
if (district.getLibelleFr()!= null && district.getLibelleFr().length() > 0) {
Criteria districtCriteria= manyToMany.createCriteria("district");
System.out.println("Create district criteria for libelleFr " + district.getLibelleFr());
districtCriteria.add(Expression.like("libelleFr", "%" + district.getLibelleFr() + "%"));
}
but once executing my list is empty
any idea on the cause ?
thanks in advance
Login
FAQ
Search
