Spring CrudRepository findByInventoryIds(List<Long> inventoryIdList) - equivalent to IN clause

java spring jpa spring-data spring-data-jpa
Espresso picture Espresso · Sep 24, 2013 · Viewed 199.2k times · Source

In Spring CrudRepository, do we have support for "IN clause" for a field? ie something similar to the following? 

 findByInventoryIds(List<Long> inventoryIdList)

If such support is not available, what elegant options can be considered? Firing queries for each id may not be optimal.

Answer

Oliver Drotbohm picture Oliver Drotbohm · Sep 25, 2013

findByInventoryIdIn(List<Long> inventoryIdList) should do the trick.

The HTTP request parameter format would be like so:

Yes ?id=1,2,3
No  ?id=1&id=2&id=3

The complete list of JPA repository keywords can be found in the current documentation listing. It shows that IsIn is equivalent – if you prefer the verb for readability – and that JPA also supports NotIn and IsNotIn.

Related questions

What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?

What is the difference between CrudRepository and JpaRepository interfaces in Spring Data JPA? When I see the examples on the web, I see them there used kind of interchangeably. What is the difference between them? Why would you want to …

Read More
setMaxResults for Spring-Data-JPA annotation?

I am trying to incorporate Spring-Data-JPA into my project. One thing that confuses me is how do I achieve setMaxResults(n) by annotation ? for example, my code: public interface UserRepository extends CrudRepository<User , Long> { @Query(value="From User …

Read More
How to beautifully update a JPA entity in Spring Data?

So I have looked at various tutorials about JPA with Spring Data and this has been done different on many occasions and I am no quite sure what the correct approach is. Assume there is the follwing entity: package stackoverflowTest.…

Read More