Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause

by

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.

More Related Contents:

  1. setMaxResults for Spring-Data-JPA annotation?
  2. Using generics in Spring Data JPA repositories
  3. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  4. Handling soft-deletes with Spring JPA
  5. Spring-Data FETCH JOIN with Paging is not working
  6. Why use returned instance after save() on Spring Data JPA Repository?
  7. How to use @Transactional with Spring Data?
  8. Spring Data JPA: query ManyToMany
  9. Spring Data JPA find by embedded object property
  10. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  11. Spring Data + JPA with multiple datasources but only one set of Repositories
  12. How to properly use findBySomeOtherId not findById in Spring data jpa?
  13. Dynamic spring data jpa repository query with arbitrary AND clauses
  14. What is this spring.jpa.open-in-view=true property in Spring Boot?
  15. Spring Data JPA – ZonedDateTime format for json serialization
  16. How does the FetchMode work in Spring Data JPA
  17. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  18. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  19. Implementing custom methods of Spring Data repository and exposing them through REST
  20. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  21. JPA: update only specific fields
  22. Spring JpaRepository – Detach and Attach entity
  23. Use abstract super class as parameter for Spring data repository
  24. Are you supposed to have one repository per table in JPA?
  25. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  26. Delete Not Working with JpaRepository
  27. How to store @Query sql in external file for CrudRepository?
  28. Missing CrudRepository#findOne method
  29. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment