Home / Questions / 466827
Accepted
David Rod
Asked: 2022-07-06 01:11:06 +0800 CST 2022-07-06 01:11:06 +0800 CST

JPA Query Key value with IN

  • 772

I have this query where I have to pass a list and say if it exists. The question is for the use of IN in the bus, does it have to go in front or behind? If it is behind, why?

boolean existsByUserAndBusInAndCar(String User, List<String> bus, Car car);
spring-boot

1 Answers

  1. Best Answer

    The best thing in these cases is to check the documentation of the syntax for creating queries with spring-data, I add the link to the documentation:

    https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.query-creation

    As you can see from the example findByAgeIn(Collection<Age> ages)the clause INis placed after the field.

    • 3