Answers for "jpa in select"

spring boot jpa in clause

@Query( "select o from MyObject o where inventoryId in :ids" )
List<MyObject> findByInventoryIds(@Param("ids") List<Long> inventoryIdList);

Posted by: Guest on May-29-2020

java repository sql find not in list

@Query("FROM entity AS e WHERE e.id NOT IN ?1")
    List<ObjectName> findByNotId(List<Long> ids);

Posted by: Guest on June-17-2020

Code answers related to "jpa in select"