mapping data with mongo query using custom key

Asked Sep 05 '16 at 13:48

Active Sep 05 '16 at 15:42

Viewed 108 times

I have two collections - orders, feedbacks

Both have a key reference_no which does the mapping between them. I need to something like sql join between these two collections.

Before mongo I was doing it in plain javascript using map after getting data from two collections individually. But this breaks when I have to apply filter on one table.

Is there any way I can do it using mongo?

mongo version on production: 3.0.7

possible solution : I add reference of orders -> _id to feedbacks, but its not possible to do it now.

edited Sep 05 '16 at 15:42

asked Sep 05 '16 at 13:48

nirvair

4,001
10
51
85

You can use $lookup on Mongo version 3.2. Refer this link https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/ – notionquest Sep 05 '16 at 15:35
I am using 3.0.7. Is there any other way out? In mongoose? – nirvair Sep 05 '16 at 15:42
Lots of options here: https://stackoverflow.com/questions/2350495/how-do-i-perform-the-sql-join-equivalent-in-mongodb – JohnnyHK Sep 05 '16 at 17:11

mapping data with mongo query using custom key

0 Answers0

Linked