Mongodb - match all items in array of strings field

Question

I am trying match documents where all items in field colors included in query list provided.

   {id: 1, colors: ["red"] },
   {id: 2, colors: ["blue", "red"] },
   {id: 3, colors: ["red", "blue", "green" ] },
   {id: 4, colors: ["black", "blue", "green" ] },

if the query [red] it should match items 1 if query [red, blue] it should match 1,2 if query [blue, green, red] it should match 1,2,3

all items in colors field should be in the query list

How can I do it in Mongodb

Takis · Accepted Answer · 2022-09-17 21:29:02Z

1

Query

i think you want colors to be subset of the query

Playmongo

aggregate(
[{"$match": {"$expr": {"$setIsSubset": ["$colors", ["red", "blue"]]}}}])

answered Sep 17, 2022 at 21:29

Takis

8,7552 gold badges17 silver badges28 bronze badges

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

4 Comments

Emad Jumaah Over a year ago

Thanks for your replay, This solves the second half of my implementation for subscription/notification. user can subscribe for tags on post, every subscription is a list of strings like so [ ["cityName", "flat", "rent"], ["cityName", "car", "sale", "honda"], ["car", "sale"], [ "electronics", "tv", "sale"] ] with your answer the server can send notification on new post if the list of tags in post match any of subscription arrays for the user now how can I fetch the list of posts base on subscription arrays of the user, so user can see all related posts on his feeds. Thanks

Takis Over a year ago

i am confused a bit, i think it will be easier to create another question, with the new data, what query should do, and the expected output

Emad Jumaah Over a year ago

stackoverflow.com/q/73759299/9487632

Emad Jumaah Over a year ago

can you please tell about this solution if it is efficient ? stackoverflow.com/q/73759299/9487632

Collectives™ on Stack Overflow

Mongodb - match all items in array of strings field

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related