Breaking News: Grepper is joining You.com. Read the official announcement!

mongodb distinct multiple fields

Yuwotmate answered on August 1, 2022 Popularity 8/10 Helpfulness 5/10

answer mongodb distinct multiple fields

mongodb distinct multiple fields

Comment

-- Question Extract Two distinct values multiple fields seperately

db.Unsold.aggregate([{ "$group": {_id: null,"category_distinct": { "$addToSet": "$category_name" },"brand_distinct": { "$addToSet":"$brand_name" }}},{
$project: {
_id:0
}}])

-- Output
[
  {
    category_distinct: [
      'Mountain Bikes', 
      'Electric Bikes', 
      'Children Bicycles',
      'Road Bikes'
    ],
    brand_distinct: [ 'Trek', 'Surly', 'Electra' ]
  }
]

-- Input if u want to see
-- Unsold Collection
[
  {
    _id: ObjectId("62e7bc832e2eb9db477de04f"),
    product_id: 'CHB267',
    brand_name: 'Trek',
    category_name: 'Children Bicycles'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de050"),
    product_id: 'MOB121',
    brand_name: 'Surly',
    category_name: 'Mountain Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de051"),
    product_id: 'ELB195',
    brand_name: 'Electra',
    category_name: 'Electric Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de052"),
    product_id: 'MOB1',
    brand_name: 'Trek',
    category_name: 'Mountain Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de053"),
    product_id: 'CHB291',
    brand_name: 'Electra',
    category_name: 'Children Bicycles'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de054"),
    product_id: 'RDB316',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de055"),
    product_id: 'RDB317',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de056"),
    product_id: 'RDB319',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de057"),
    product_id: 'CHB284',
    brand_name: 'Electra',
    category_name: 'Children Bicycles'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de058"),
    product_id: 'RDB318',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de059"),
    product_id: 'MOB125',
    brand_name: 'Trek',
    category_name: 'Mountain Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de05a"),
    product_id: 'RDB154',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de05b"),
    product_id: 'RDB321',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  },
  {
    _id: ObjectId("62e7bc832e2eb9db477de05c"),
    product_id: 'RDB320',
    brand_name: 'Trek',
    category_name: 'Road Bikes'
  }
]

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: distinct mongodb sql

Link to this answer
Share Copy Link

Contributed on Aug 01 2022

Yuwotmate

0 Answers Avg Quality 2/10

mongodb distinct multiple fields

Contents

More Related Answers

mongodb distinct multiple fields

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.