I am using Spring JPA To check if record exists for name and join date:
boolean existsByNameAndJoinDate(String name, LocalDate joinDate);
This works fine but I need to check another property now which is of LocalDateTime
. The new field is creation date in db and has a time element but when it is queried it should be just queried with the date element excluding time, so I am trying to amend the above to this
boolean existsByNameAndJoinDateAndCreationDate(String name, LocalDate joinDate, LocalDate creationDate);
How can I get this to work if anyway whether with native or not?