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

user_5552812 0
Viewed 66422

I am trying to migrate the application. I am working on from Hibernate to Spring Data Jpa.

Though spring data jpa offers simple methods for query building, I am stuck up in creating query method that uses both And and Or operator.

MethodName - findByPlan_PlanTypeInAndSetupStepIsNullOrStepupStepIs(...)

When it converts into the query, the first two expressions are combined and it executes as [(exp1 and exp2) or (exp3)].

whereas required is ](exp1) and (exp2 or exp3)].

Can anyone please let me know if this is achievable through Spring data jpa?

spring-data spring-data-jpa java
4 Answers

Use something like

findByFirstElementAndCriteriaOrSecondElementAndCriteria

is like (first & condition) OR ( second & condition) --> condition & ( first or second)

user_65941740
Related