mongodb find query conditional return value

Question

I can do a find in mongodb like:

db.user.find({ "show": true}, { firstname: 1, lastname: 1, email:1 })

Now I'd like to be a little more specific to let people hide their email address. So what I'd like is to query if "show":true then get firstname:1, lastname:1 AND (email:1 iff show_email:true)

worst case I can take all the info and filter it out on the back end with a map function but I wondered if there was a nice query-able way??

JohnnyHK · Accepted Answer · 2014-02-02 17:01:27Z

1

The truthiness of the projection object's fields are all that matter, so you can just do it as:

db.user.find({ "show": true }, { firstname: 1, lastname: 1, email: show_email })

answered Feb 2, 2014 at 17:01

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Comments

Works On Mine · Accepted Answer · 2014-02-02 16:51:32Z

0

Since you didnt specify any driver specification, I am betting on this, the MongoShell

if(show_email){
   db.user.find({ "show": true}, { firstname: 1, lastname: 1, email:1 })
}
else{
   db.user.find({ "show": true}, { firstname: 1, lastname: 1})
}

answered Feb 2, 2014 at 16:51

Works On Mine

1,1311 gold badge8 silver badges20 bronze badges

Collectives™ on Stack Overflow

mongodb find query conditional return value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related