String queryString ="SELECT s FROM " + ReachDeclarationImpl.class.getName()
+ " rd INNER JOIN rd.supplier s"
+ " WHERE rd in (SELECT distinct rd3 FROM " + ReachDeclarationImpl.class.getName() + " rd3 INNER JOIN rd3.legalEntities le1 INNER JOIN le1.users u1 WHERE u1 is not null and u1 = :user) OR rd in ( SELECT distinct rd2 FROM " + EntityDeclarationImpl.class.getName()
+ " ned INNER JOIN ned.reachDeclaration rd2 INNER JOIN ned.legalEntity le2 INNER JOIN le2.users u2"
+ " WHERE (u2 is not null and u2 = :user)) "
+ " order by upper(s.supplierName) asc"; |