projection not working with find query

Question

Hello I'd like to exclude some fields by query,. Im using nodejs

public async getDoc() {
        return new Promise((resolve, reject) => {
            this.database.collection('users').find({email: "value3"}, {password: 0}).toArray((err, result) => {
                if(err) {
                    reject(err)
                }
                resolve(result);
            });
        })
    }

but in the result set I keep getting password field..

Use a projection document docs.mongodb.com/manual/tutorial/… — Joshua Benz
– Joshua Benz, Commented Aug 7, 2018 at 17:53

Ashh · Accepted Answer · 2019-04-13 17:57:20Z

13

Projection doesn't work with the new nodejs mongodb driver... Instead you will have to use .project() cursor method here

this.database.collection('users')
  .find({ "email": "value3" })
  .project({ "password": 0 })
  .toArray();

edited Apr 13, 2019 at 17:57

answered Aug 7, 2018 at 18:00

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

3 Comments

Dat Tran Over a year ago

Project is the right way to use. But It's not true that projection options doesn't work. It's just because the code of the author doesn't pass the right arguments for the otions.

Ashh Over a year ago

query failed: Unsupported projection option: projection: { password: 1.0 } please test and then comment

Dat Tran Over a year ago

please check your version of mongodb. projection is only available on version > 3. use fields instead if your mongodb version < 3.

Syed Kashan Ali · Accepted Answer · 2018-08-07 18:04:27Z

1

Use fields object as 2nd parameter in find method with all fields in that object which you want to get exluding password.

Do it like this:

find({email: "value3"}, {fields: {all_other_fields...: 1}})

You can also try {fields: {password: 0}} as well but I haven't tried it myself that's why I'm not sure that it'll work.

answered Aug 7, 2018 at 18:04

Syed Kashan Ali

6634 silver badges8 bronze badges

1 Comment

Dat Tran Over a year ago

for version >3. fields is deprecated. You should you projection instead.

Collectives™ on Stack Overflow

projection not working with find query

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related