How to get result in JSONObject form from MongoDb using NodeJS

Question

I am trying to fetch Distinct data from MongoDb using NodeJs.I am getting data in JSONArray form as I am not getting key from MongoDb.

Below is my code:

const coll = client.db("mydb").collection("ItemsAddedByAdmin");
coll.distinct("product_name",(function(err,docs){                     
   res.send({"product_name":docs});
}));

Below is my OUTPUT

{
"product_name": [
    "Biology",
    "Chemistry",
    "Crown",
    "Crown Junior",
    "Long Book",
    "Long Book A4",
    "Physics",
    "Sketch Book",
    "Universal"
  ]
}

and when I am trying below code I am getting no values.

const coll = client.db("mydb").collection("ItemsAddedByAdmin");
coll.distinct("product_name",(function(err,docs){
   let output = docs.map(r => ({'product_name':docs.product_name}));
   res.send(output);                        
}));

OUTPUT

[
{},
{},
{},
{},
{},
{},
{},
{},
{}
]

I want values in key value pair like given below:

[
 {
   "product_name":Book
 },
 {
   "product_name":Pencil
 }  
]

Someone please let me know how can I get desired result any help would be appreciated.

THANKS

Ankit Chaudhary · Accepted Answer · 2020-01-29 12:38:04Z

1

Just a small change and it should start working:

const coll = client.db("mydb").collection("ItemsAddedByAdmin");
coll.distinct("product_name",(function(err,docs){

      let output = docs.map(r => ({'product_name':r})); // r contains the item of array at respective index
      res.send(output);       

}));

edited Jan 29, 2020 at 12:38

answered Jan 29, 2020 at 12:33

Ankit Chaudhary

4,1092 gold badges15 silver badges25 bronze badges

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

Comments

Prakash Karena · Accepted Answer · 2020-01-29 12:34:41Z

1

Need to use only r in your map function

 let output = docs.map( r => ({'product_name': r}));

answered Jan 29, 2020 at 12:34

Prakash Karena

2,6031 gold badge9 silver badges18 bronze badges

Comments

double-beep · Accepted Answer · 2020-01-29 17:45:33Z

0

db.getCollection('coll').find({},{product_name:1,_id:0})

edited Jan 29, 2020 at 17:45

double-beep

5,67019 gold badges43 silver badges50 bronze badges

answered Jan 29, 2020 at 12:33

vicky

4152 silver badges10 bronze badges

1 Comment

Digvijay Singh Thakur Over a year ago

This will return same values available in database and not distinct.

Collectives™ on Stack Overflow

How to get result in JSONObject form from MongoDb using NodeJS

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related