How to $match two lists using MongoDB aggregation

Question

I have collection as: col1

{"_id":"5c3ea35651166f3refsfd5",
"environment": "production",
"application": ['cloud', 'android', 'finance']},

{"_id":"5c3ea35651166f3refsfd6",
"environment": "production",
"application": ['banking', 'network', 'finance']}

I want to project the data only if the application/s in collection matches with the application in the list of ['cloud', 'database', 'booking']. In this case, I should be able to get only first document as it has 'cloud' in both document as well as in list.

I need to use aggregation. But I am not getting correct direction..

Ashh · Accepted Answer · 2019-01-17 05:29:48Z

1

You can use $in query operator

col1.aggregate([
  { '$match': { 'application': { '$in': ['cloud', 'database', 'booking'] }}},
  { '$project': { 'environment': 1, 'application':1 }}
])

answered Jan 17, 2019 at 5:29

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

3 Comments

gd1 Over a year ago

But the values in list changes according to user, so I should not use fixed list.

Ashh Over a year ago

You can dynamically put the lst array.

gd1 Over a year ago

Oh! my bad. Thank you.

Collectives™ on Stack Overflow

How to $match two lists using MongoDB aggregation

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related