Select entire document after using select: false

[NathanAP]

Do you want to request a feature or report a bug?

Question / feature

What is the current behavior?

Currently, if we use select: false in a schema, we need to do Model.findOne({ _id }).select("+field_a") to get its value.

What is the expected behavior?

We could have an option to select the entire document, ignoring the select: false, it would not require us to do something like Model.findOne({ _id }).select("+field_b +field_c +field_d +field_e ... +field_n"). I feel this is necessary for some situations, but I couldn't figure a proper way to achieve this. I couldn't find anywhere an answer to this and I did not get an answer in stack overflow. Any idea is welcome!

What are the versions of Node.js, Mongoose and MongoDB you are using? Note that "latest" is not a version.

node v16.14.0
mongoose v6.2.4
mongodb v5.0.6

[Uzlopak]

If you use select false, then you basically say: hey I don't want to expose this attribute by a simple findOne or find by accident because of reasons like security.

So why are you using select false?

[IslandRhythms]

ditto ^

[NathanAP]

Thats totally the case, I'm using it to hide attributes that I won't use in the response!

Lets say I'm not interested in send a list of created orders by users to my endpoint response, but I need to use the list for something else (comparison, searching, etc). To archieve that, I'll need to use .select("+orders") every time I seek for an user to do it. If I have more "hidden" attributes, I'll need to add a +anotherAttribute for every other attribute I need. A simple option that brings the entire document could be more simple while coding.

Its not really a big deal, but I missed this option the week with a model I have.

[indraraj26]

In this case you can drop the field with select("-dropfield") instead of select:false on schema level.

[Uzlopak]

I would actually prefer to always select with an object and not with a string.

Anyhow
If you want you can even create a second model with the same schema, but which has no select:false set. Like userPublicModel and userInternalModel. In one you have a schema where you hide e.g. password and one were you expose everything.

[NathanAP]

Nice! I don't want to cause trouble or make this a big deal, just wondering if there was a good option to do it without needing to add a string everywhere. I'll think about another object or a const string with a method to get all fields available. Thanks.

[sami-lab]

Actually I also need this feature for selecting All fields for Admin side so instead of writing all select:false fields manually Is there any better way you found?

[NathanAP]

No ):

I ended up adding everything in a single string when I needed...

[1finedev]

a little unfortunate that mongoose does not have this.

Every api surely has an admin side which needs to fetch all fields in the db. having to chain .select(insert 20 fields here) is just a pain

[NathanAP]

Thanks guys for this feature <3