Mongo query to find documents where any of the field's elements match any of the query param elements

Question

I've scoured the docs and google. Maybe I just need help formulating the question.

I have a field that stores an array of values. We'll call it "tags" for simplicity. I want to be able to search for all documents that match ANY of the multiple tags I search on. Put another way, I want to find all records that are tagged with at least one (not necessarily all) of these tags. Here's an example.

Documents :

{name: "My Thing 1", tags: ["cool", "important", "anothertag"]},
{name: "My Thing 2", tags: ["cool"]},
{name: "My Thing 3", tags: ["cool", "important"]}
{name: "My Thing 4", tags: ["important", "anothertag"]}
{name: "My Thing 5", tags: []}
{name: "My Thing 6", tags: ["anothertag"]}

Query: ["important", "cool"]

Result: documents 1-4 (not 5-6)

Does this answer your question? [MongoDB select where in array of \_id?](https://stackoverflow.com/questions/7713363/mongodb-select-where-in-array-of-id) — whoami - fakeFaceTrueSoul, Feb 17 '20 at 17:28
You need to use `$in` operator as suggested in above link, It should help you out of this issue. — whoami - fakeFaceTrueSoul, Feb 17 '20 at 17:28
I don't think that's it since the field I'm querying against is itself an array, unlike the _id field in that example. — Taylor Vance, Feb 17 '20 at 17:30
If should work, Can you please try it first & let us know, FYI I've tested samething & it's working !! — whoami - fakeFaceTrueSoul, Feb 17 '20 at 17:34
@whoami Well SOB it worked. I must have written my test query wrong because I thought I'd tried $in before posting. Thanks for the info and patience! — Taylor Vance, Feb 17 '20 at 18:08

score 0 · Accepted Answer · answered Feb 17 '20 at 18:10

0

See comment by whoami. $in does the trick.

answered Feb 17 '20 at 18:10

Taylor Vance

706
1
8
22

Mongo query to find documents where any of the field's elements match any of the query param elements

1 Answers1