Spring findBy with unordered array

Question

I'm using Spring MVC, and have a Conversation entity with the property participants. This is a List of userId Strings who are involved in a particular Conversation. I am trying to retrieve all Conversations whose participants are equal to some List of userIds from a MongoRepository. How do I do this?

I have tried the following:

Conversation findByParticipantsEquals(List<String> participantId);

However the order of participantIds is kind of random so it doesn't necessarily work.

Vasu · Accepted Answer · 2017-03-31 15:32:56Z

1

You can actually use $in operator as shown below:

@Query(value = "{ 'participantId': { $in: ?0 } }")
public List<Conversation> findByParticipantsEquals(List<String> participantIds);

answered Mar 31, 2017 at 15:32

Vasu

22.6k11 gold badges54 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring findBy with unordered array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related