how to find unique values from array of object in mongoDB

Question

i have following bson data in mongoDB

{name : "c1"
   arr : [
  {
     partyName : "p1",
     poNumber : "789",
  },
  {
     partyName : "p1",
     poNumber : "700",
  },
  {
     partyName : "p3",
     poNumber : "889",
  }
 ]
},

{name : "c2"
   arr : [
  {
     partyName : "p1",
     poNumber : "789",
  },
  {
     partyName : "p2",
     poNumber : "700",
  },
  {
     partyName : "p3",
     poNumber : "889",
  }
 ]
}

i want all unique values of partyName of name: "c1" object like [p1,p3]. i tried this

const unique = await User.distinct({name :"c1","createPurchaseOrder.partyName"})

(note :- User is my schema name ) but it gives error, i tried to search on web but cant find solution please help me with this

nimrod serok · Accepted Answer · 2022-09-10 14:27:37Z

1

One option is using $reduce:

db.collection.aggregate([
  {$match: {name: "c1"}},
  {$project: {
      res: {
        $reduce: {
          input: "$arr",
          initialValue: [],
          in: {$setUnion: ["$$value", ["$$this.partyName"]]}
        }
      }
    }
  }
])

See how it works on the playground example

answered Sep 10, 2022 at 14:27

nimrod serok

16.1k2 gold badges15 silver badges36 bronze badges

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

Comments

Takis · Accepted Answer · 2022-09-10 16:53:33Z

Query1

match for the document with name=c1
path to take the array with the partyName and union with the empty array to remove the duplicates
union => order can be lost in patyNames

Playmongo

aggregate(
[{"$match": {"name": {"$eq": "c1"}}},
 {"$project": 
   {"_id": 0, "parties-unique": {"$setUnion": ["$arr.partyName", []]}}}])

Query2

the above is fast and simple but loses the order of the names
if you want to keep the original order, you can use this instead
reduce and add on array only if element doesn't already exists

Playmongo

aggregate(
[{"$match": {"name": {"$eq": "c1"}}},
 {"$set": 
   {"parties-unique": 
     {"$reduce": 
       {"input": "$arr.partyName",
        "initialValue": [],
        "in": 
         {"$cond": 
           [{"$in": ["$$this", "$$value"]}, "$$value",
             {"$concatArrays": ["$$value", ["$$this"]]}]}}}}}])

Collectives™ on Stack Overflow

how to find unique values from array of object in mongoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related