I have an Entity Class like this Entity Table name EMAIL class Email Id Column name Id Long id Column name EMAIL ID String emailId Column name PIN CODE String pincode How to write findBy method for the below query using crudrepository spring data jpa select email id name from email details where eamil id in mike gmail com ram gmail com and pin code in 633677 733877 I am expecting the spring data jpa method like the below but how to construct it List lt Email gt findBy List lt String gt emails List lt String gt pinCodes I want to get list of Emails in a single database hit

The following signature will do List lt Email gt findByEmailIdInAndPincodeIn List lt String gt emails List lt String gt pinCodes Spring Data JPA supports a large number of keywords to build a query IN and AND are among them

crudrepository findBy method signature with multiple in operators?

The Solution to crudrepository findBy method signature with multiple in operators? is

The following signature will do:

List<Email> findByEmailIdInAndPincodeIn(List<String> emails, List<String> pinCodes);

Spring Data JPA supports a large number of keywords to build a query. IN and AND are among them.

~ Answered on 2015-09-26 11:07:06

crudrepository findBy method signature with multiple in operators?

The Solution to crudrepository findBy method signature with multiple in operators? is

Most Viewed Questions: