Spring CrudRepository findByInventoryIds List Long inventoryIdList - equivalent to IN clause

Question

In Spring CrudRepository  do we have support for  IN clause  for a field  ie something similar to the following     findByInventoryIds List lt Long gt  inventoryIdList     If such support is not available  what elegant options can be considered  Firing queries for each id may not be optimal

User · Accepted Answer

findByInventoryIdIn List lt Long gt  inventoryIdList  should do the trick   The HTTP request parameter format would be like so   Yes  id 1 2 3 No   id 1 amp id 2 amp 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

User · Answer

For any method in a Spring CrudRepository you should be able to specify the  Query yourself   Something like this should work     Query   select o from MyObject o where inventoryId in  ids    List lt MyObject gt  findByInventoryIds  Param  ids   List lt Long gt  inventoryIdList

User · Answer

Yes  that is supported   Check the documentation provided here for the supported keywords inside method names   You can just define the method in the repository interface without using the  Query annotation and writing your custom query  In your case it would be as followed   List lt Inventory gt  findByIdIn List lt Long gt  ids     I assume that you have the Inventory entity and the InventoryRepository interface  The code in your case should look like this   The Entity   Entity public class Inventory implements Serializable      private static final long serialVersionUID   1L     private Long id        other fields      getters setters      The Repository   Repository  Transactional public interface InventoryRepository extends PagingAndSortingRepository lt Inventory  Long gt       List lt Inventory gt  findByIdIn List lt Long gt  ids

User · Answer

you can use the keyword  In  and pass the List argument  e g   findByInventoryIdIn  List lt AttributeHistory gt  findByValueIn List lt String gt  values

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

Examples related to java

Examples related to spring

Examples related to jpa

Examples related to spring-data

Examples related to spring-data-jpa