MongoDB/Mongoose query to filter all the value in an array based on their presence in a collection

Question

I have an array lets say [1,2,3] and a collection called 'Numbers' and it has a field called 'value'. I need to retain all the values in the array which are present against the 'value' field in any document in the collection.

Example,

Test array - [1,2,3]
Numbers collection - [{value: 1}, {value: 3}]
Result should be - [1,3]

Result is that way because '2' was not present against 'value' field in any documents within 'Numbers' collection.

How do i do this?

I have not written the code for this logic as i dont know how to do it!! Thats why i have given what my test array is and sample collection is and what my output should be! — user3807940
– user3807940, Commented Apr 20, 2017 at 18:57

s7vr · Accepted Answer · 2017-04-20 18:57:54Z

1

You can try below distinct query with projection and query filter.

db.Numbers.distinct( "value", { "value": { $in: [1,2,3] } } )

answered Apr 20, 2017 at 18:57

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

1 Comment

user3807940 Over a year ago

Thank you!! It works cool. If incase the 'value' is an ObjectID in a separate collection and if i need to do the same logic , how would i do that?

Collectives™ on Stack Overflow

MongoDB/Mongoose query to filter all the value in an array based on their presence in a collection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related