mongodb distinct query values

Question

I have the following mongodb documents:

{
  "_id": "", 
  "name": "example1", 
  "colors": [
     {
         "id": 1000000,
         "properties": [
             {
                 "id": "1000",
                 "name": "",
                 "value": "green"
             },
             {
                 "id": "2000",
                 "name": "",
                 "value": "circle"
             }
         ]
     } ]
}
{
 "_id": "", 
  "name": "example2", 
  "colors": [
     {
         "id": 1000000,
         "properties": [
             {
                 "id": "1000",
                 "name": "",
                 "value": "red"
             },
             {
                 "id": "4000",
                 "name": "",
                 "value": "box"
             }
         ]
     } ]
}

I would like to get distinct queries on the value field in the array where id=1000

db.getCollection('product').distinct('colors.properties.value', {'colors.properties.id':{'$eq': 1000}})

but it returns all values in the array.

The expected Result would be:

["green", "red"]

stackoverflow.com/questions/46716560/…

Manvir
– Manvir

2020-11-08 00:11:24 +00:00
Commented Nov 8, 2020 at 0:11 — Manvir
– Manvir, Commented Nov 8, 2020 at 0:11

varman · Accepted Answer · 2020-11-08 03:27:04Z

1

There are a lot of way to do.

$match eliminates unwanted data
$unwind de-structure the array
$addToSet in $group gives the distinct data

The mongo script :

db.collection.aggregate([
  {
    $match: {
      "colors.properties.id": "1000"
    }
  },
  {
    "$unwind": "$colors"
  },
  {
    "$unwind": "$colors.properties"
  },
  {
    $match: {
      "colors.properties.id": "1000"
    }
  },
  {
    $group: {
      _id: null,
      distinctData: {
        $addToSet: "$colors.properties.value"
      }
    }
  }
])

Working Mongo playground

answered Nov 8, 2020 at 3:27

varman

8,9326 gold badges25 silver badges56 bronze badges

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

1 Comment

István Döbrentei Over a year ago

Thank you very much. I am a beginner in MongoDB and your answer helps me a lot.

Collectives™ on Stack Overflow

mongodb distinct query values

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