Getting unique values within two arrays in one document in MongoDB

Question

I have the following document:

{
  userId: 1234,
  contacts: ['a', 'b', 'c', 'd'],
  conversations: ['a', 'b', 'e'],
}

I want to get distinct value from the contacts and conversations array. So for this case, the output should be: a, b, c, d, e

turivishal · Accepted Answer · 2020-07-20 06:57:59Z

2

Use $setUnion operator to aggregate values from two arrays:

db.test.aggregate([
    {
        $project: {
            userId: 1, 
            values: {
                $setUnion: [
                    '$contacts',
                    '$conversations'
                ]
            }
        }
    }
])

Result:

{ "userId" : 1234, "values" : [ "a", "b", "c", "d", "e" ] }

UPDATE: For MongoDB 2.4 you can map each document on client side. Define unique function for array. And then simply map each document

db.test.find().map(function(doc) {
   return { 
      userId : doc.userId, 
      values : doc.contacts.concat(doc.conversations).unique()
   };
})

Note: if there is several documents with same userId you can group them on server side.

edited Jul 20, 2020 at 6:57

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

answered Dec 18, 2014 at 10:42

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

1 Comment

fardeem Over a year ago

setUnion seems to be new in 2.6. I'm using 2.4. Any other way?

Collectives™ on Stack Overflow

Getting unique values within two arrays in one document in MongoDB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related