JPA criteria API - Matching against a list in Spring Data JPA Specifications

Question

I'm want to create a specification that matches a group id of a user object against a list of ids. I was thinking about using isMember (like in the code) but the method won't take the list.

public static Specification<User> matchCompanyIdsList(final List<Long> groupIds){   return new Specification<User>() {     public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder builder){       final Path<Group> group = root.<Group> get("group");       return builder.isMember(company.<Long>get("id"), companyIds);     }   }; } 

If I'm off, the how would I do it otherwise?

Answer 1

Do you want to create a specification that matches all users that have group id, which are in the groupsIds list?

If so, you could use something like this (Which will use SQL IN clause):

public static Specification<User> matchCompanyIdsList(final List<Long> groupIds){     return new Specification<User>() {         public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder builder){             final Path<Group> group = root.<Group> get("group");             return group.in(groupIds);         }     }; }