MongoDB Ignoring Filter

Question

Either I'm missing something or is this a possible Node.js driver issue?

const users = await User.find({ 'test.test': { $gt: 0 } }).lean();

None of my User documents contain the test object, therefore none should meet this filter's criteria. However, instead of returning no documents, it's returning all of my user documents. According to the documentation, it should only ever return all of the documents in a collection if no/empty filters are passed?

Edit: I said ignoring filter as it only seems to occur when applying nested filters on undefined properties. For instance, if I add more filter conditions that a few documents meet they'll apply *correctly. Example: User.find({ username: { $exists: true }, 'test.test': { $gt: 0 } }) returns only the user documents where username exists, however they still don't have the test object.

cooldogyum · Accepted Answer · 2022-01-07 22:44:38Z

1

The issue was resolved by setting the Mongoose Schema strictQuery option to false.

https://mongoosejs.com/docs/guide.html#strictQuery

answered Jan 7, 2022 at 22:44

cooldogyum

728 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Ignoring Filter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related