Filter twice based on input from first filter's output in MongoDB

Question

Given a collection like below, when input is "Ross", I want all records whose zipcode matches with Ross.

Input is not zipcode but name.

[
  {
    name : "Ross",
    zipcode : "12345" 
  },
  {
    name : "joey",
    zipcode : "12345" 
  },
  {
    name : "chandler",
    zipcode : "22457" 
  },
  {
    name : "monica",
    zipcode : "22457" 
  },
  {
    name : "phoebe",
    zipcode : "32457" 
  },
  {
    name : "rachel",
    zipcode : "32457" 
  }
]

In this case, when I get "Ross" as input, the output should be

[
  {
    name : "Ross",
    zipcode : "12345" 
  },
  {
    name : "joey",
    zipcode : "12345" 
  }
]

I have tried looking into mongo-aggregation, but I did not come across a solution that meets my use-case.

Kindly point me in the right direction.

Wernfried Domscheit · Accepted Answer · 2022-12-14 07:28:03Z

1

You can try this one:

db.collection.aggregate([
   {
      $lookup: {
         from: "collection",
         localField: "zipcode",
         foreignField: "zipcode",
         as: "zipcodes"
      }
   },
   {
      $match: {
         $or: [
            { name: "Ross" },
            { "zipcodes.name": "Ross" },
         ]
      }
   },
   { $unset: "zipcodes" }
])

Mongo Playground

answered Dec 14, 2022 at 7:28

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

Filter twice based on input from first filter's output in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related