Spring data jpa – How to combine multiple And and Or through method name

by

Agree with Oliver on long and unreadable method names, but nevertheless and for the sake of argument, you can achieve desired result by using the equivalency 

A /\ (B \/ C) <=> (A /\ B) \/ (A /\ C)
A and (B or C) <=> (A and B) or (A and C)

So in your case it should look something like this: 

findByPlan_PlanTypeInAndSetupStepIsNullOrPlan_PlanTypeInAndStepupStepIs(...)

More Related Contents:

  1. How to properly use findBySomeOtherId not findById in Spring data jpa?
  2. How to add custom method to Spring Data JPA
  3. Dynamic spring data jpa repository query with arbitrary AND clauses
  4. setMaxResults for Spring-Data-JPA annotation?
  5. Using generics in Spring Data JPA repositories
  6. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  7. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  8. Handling soft-deletes with Spring JPA
  9. How to maintain bi-directional relationships with Spring Data REST and JPA?
  10. Filtering database rows with spring-data-jpa and spring-mvc
  11. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  12. Spring data jpa- No bean named ‘entityManagerFactory’ is defined; Injection of autowired dependencies failed
  13. Spring-Data FETCH JOIN with Paging is not working
  14. Filtering data with Spring boot CrudRepository
  15. Why use returned instance after save() on Spring Data JPA Repository?
  16. How to use @Transactional with Spring Data?
  17. Are you supposed to have one repository per table in JPA?
  18. Delete Not Working with JpaRepository
  19. Spring Data JPA: query ManyToMany
  20. Spring Data JPA: Query by Example?
  21. How to store @Query sql in external file for CrudRepository?
  22. Spring Data – Multi-column searches
  23. Spring Data JPA find by embedded object property
  24. Missing CrudRepository#findOne method
  25. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  26. Best way of handling entities inheritance in Spring Data JPA
  27. Spring Data + JPA with multiple datasources but only one set of Repositories
  28. Spring Data JPA – Is it possible to sort on a calculated property?
  29. Implementing custom methods of Spring Data repository and exposing them through REST
  30. Use abstract super class as parameter for Spring data repository

Leave a Comment