Combine two OR-queries with AND in Mongoose

by

It’s probably easiest to create your query object directly as:

  Test.find({
      $and: [
          { $or: [{a: 1}, {b: 1}] },
          { $or: [{c: 1}, {d: 1}] }
      ]
  }, function (err, results) {
      ...
  }

But you can also use the Query#and helper that’s available in recent 3.x Mongoose releases:

  Test.find()
      .and([
          { $or: [{a: 1}, {b: 1}] },
          { $or: [{c: 1}, {d: 1}] }
      ])
      .exec(function (err, results) {
          ...
      });

More Related Contents:

  1. Push items into mongo array via mongoose
  2. E11000 duplicate key error index in mongodb mongoose
  3. Mongoose: findOneAndUpdate doesn’t return updated document
  4. Mongoose populate vs object nesting
  5. Stop Mongoose from creating _id property for sub-document array items
  6. Why does mongoose always add an s to the end of my collection name
  7. mongodb/mongoose findMany – find all documents with IDs listed in array
  8. MongoDB/Mongoose querying at a specific date?
  9. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  10. Making mongoose.js queries run synchronously
  11. add created_at and updated_at fields to mongoose schemas
  12. How to populate a sub-document in mongoose after creating it?
  13. mongoose custom validation using 2 fields
  14. Mongoose (mongodb) batch insert?
  15. (node:3341) DeprecationWarning: Mongoose: mpromise
  16. Mongoose update without callback
  17. How to fix ‘Error: querySrv EREFUSED’ when connecting to MongoDB Atlas?
  18. How to define object in array in Mongoose schema correctly with 2d geo index
  19. Difference between MongoDB and Mongoose
  20. How can I generate an ObjectId with mongoose?
  21. How to get all count of mongoose model?
  22. Mongoose: CastError: Cast to ObjectId failed for value “[object Object]” at path “_id”
  23. Model.find() returns empty in mongoose [duplicate]
  24. Mongoose – caused by :: 11000 E11000 duplicate key error index?
  25. log all queries that mongoose fire in the application
  26. Which SchemaType in Mongoose is Best for Timestamp?
  27. Mongoose: ObjectId Comparisons fail inconsistently
  28. Mongoose multiple connections
  29. set field as empty for mongo object using mongoose
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment