query on jpa repository 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: findbyname in jpa

List<User> findByBirthDateAfter(ZonedDateTime birthDate);List<User> findByBirthDateBefore(ZonedDateTime birthDate);

Example 3: findbyname in jpa

List<User> findByNameOrBirthDate(String name, ZonedDateTime birthDate);List<User> findByNameOrBirthDateAndActive(String name, ZonedDateTime birthDate, Boolean active);