how to get values in mongodb using find

Question

I have this data in my database.

"_id" : ObjectId("5c1b34d11aa970061a76aa68"),
        "city" : "Delhi"

I tried to get city like this.

 db.myCollection.find({_id:ObjectId("5c1b34d11a970061a76aa68")},{_id:0,city:1})

I am getting output { "city" : "Delhi" } like this. but i need only Delhi without quotes and "city". Is it possible.

Refer : stackoverflow.com/questions/23676205/…

Jitendra Khatri
– Jitendra Khatri

2018-12-21 06:39:44 +00:00
Commented Dec 21, 2018 at 6:39 — Jitendra Khatri
– Jitendra Khatri, Commented Dec 21, 2018 at 6:39

Saurabh Mistry · Accepted Answer · 2018-12-21 11:01:33Z

1

Use toArray() and map()

db.myCollection
    .find({_id:ObjectId("5c1b34d11a970061a76aa68")},{ _id:0, city:1 })
    .toArray()
    .map(function(result){ return result.city;})

edited Dec 21, 2018 at 11:01

answered Dec 21, 2018 at 6:43

Saurabh Mistry

13.8k5 gold badges60 silver badges78 bronze badges

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

Comments

Kuldeep Mishra · Accepted Answer · 2018-12-21 06:40:46Z

0

db.myCollection.find({_id:ObjectId("5c1b34d11a970061a76aa68")},function(err,result){
 res.render('yourviewpath', {
        response: result
    });

});
in view you can access like tbis as i am using ejs <%=response.result.city=>

it will print only city

edited Dec 21, 2018 at 6:40

answered Dec 21, 2018 at 6:33

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

1 Comment

PRUDHVI RAJ Over a year ago

I don't want to print. I need to take that result to frontend.

Collectives™ on Stack Overflow

how to get values in mongodb using find

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related