Java Spring Boot : How to find all rows with multiple Ids like findAllByAge(ArrayList ageList)?

Question

I am having a table/entity User with fields like userId, name, age etc.

I know with Spring boot, in Repository, we can search for rows like

User findByUserId(Long userId)

Which may return User with the passed argument user id.

But I am looking for an option where I can pass a list in argument something like below.

List findAllByAge(ArrayList ageList)

Which may return all the users with passed ageList. Let me know if this is possible with this or I have to use native query? I know I can do this with native queries also but if it's possible with this then it would be great.

user_5558072 · Answer

You have to use In in the end of the name of your method:

List findAllByAgeIn(ArrayList ageList)
                       ^^

For more details refer to this: Supported keywords inside method names

Java Spring Boot : How to find all rows with multiple Ids like findAllByAge(ArrayList<Long> ageList)?

1 Answers