Как добавить несколько условий И ИЛИ в построитель критериев с помощью спецификации Spring JPA ⇐ JAVA

[Гость]

I am using toPredicate() method of org.springframework.data.jpa.domain.Specification and want to add two list of AND OR predicates but only or conditions are working.

static class RtoReportsSpecification { public static Specification applyFilter(ReportFilter reportFilter, String userId) { return new Specification() { private static final long serialVersionUID = 1L; @Override public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) { List andPredicates = new ArrayList(); andPredicates.add(criteriaBuilder.equal(root.get("field1"), reportFilter.getField1())); andPredicates.add(criteriaBuilder.equal(root.get("geography"), reportFilter.getGeography())); andPredicates.add(criteriaBuilder.equal(root.get("deptName"), reportFilter.getDeptName())); criteriaBuilder.and(andPredicates.toArray(new Predicate[andPredicates.size()])); List orPredicates = new ArrayList(); orPredicates.add(criteriaBuilder.or(criteriaBuilder.equal(root.get("email1"), userId))); orPredicates.add(criteriaBuilder.or(criteriaBuilder.equal(root.get(email2), userId))); orPredicates.add(criteriaBuilder.equal(root.get("email3"), userId)); orPredicates.add(criteriaBuilder.equal(root.get("email4"), userId)); criteriaBuilder.or(orPredicates.toArray(new Predicate[orPredicates.size()])); query.orderBy(criteriaBuilder.asc(root.get("empName"))); return criteriaBuilder.or(orPredicates.toArray(new Predicate[orPredicates.size()])); } }; } } public List findRtoReportsData(ReportFilter reportFilter, String userId) { return rtoReportsRepo.findAll(RtoReportsSpecification.applyFilter(reportFilter, userId)); } But only or conditions are applied not and conditions.


Источник: https://stackoverflow.com/questions/781 ... ng-jpa-spe