how to write jpa query with in clause code example
Example 1: spring boot jpa in clause
@Query( "select o from MyObject o where inventoryId in :ids" )
List<MyObject> findByInventoryIds(@Param("ids") List<Long> inventoryIdList);
Example 2: java repository sql find not in list
@Query("FROM entity AS e WHERE e.id NOT IN ?1")
List<ObjectName> findByNotId(List<Long> ids);