MongoDB query with an ‘or’ condition

by

Just thought I’d update in-case anyone stumbles across this page in the future. As of 1.5.3, mongo now supports a real $or operator: http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-%24or

Your query of “(expires >= Now()) OR (expires IS NULL)” can now be rendered as:

{$or: [{expires: {$gte: new Date()}}, {expires: null}]}

More Related Contents:

  1. Find document with array that contains a specific value
  2. Update field in exact element array in MongoDB
  3. How to change the type of a field?
  4. Mongodb sort inner array
  5. MongoDB logging all queries
  6. Return only matched sub-document elements within a nested array
  7. Querying internal array size in MongoDB
  8. How to delete N numbers of documents in mongodb
  9. Unhandled promise rejection: Error: URL malformed, cannot be parsed
  10. mongo group query how to keep fields
  11. Auto compact the deleted space in mongodb?
  12. Find duplicate records in MongoDB
  13. $unwind empty array
  14. How to return Mongoose results from the find method?
  15. How do I start Mongo DB from Windows?
  16. Find all duplicate documents in a MongoDB collection by a key field
  17. How to ignore nulls while unmarshalling a MongoDB document?
  18. How to use mongoimport to import CSV files?
  19. Build a reactive publication with additional fields in each document
  20. Mongodb query specific month|year not date
  21. Remove Duplicates from MongoDB
  22. Spring data MongoDb: MappingMongoConverter remove _class
  23. How to toggle a boolean field in one document with atomic operation?
  24. How to delete documents by query efficiently in mongo?
  25. Sum in nested document MongoDB
  26. Update embedded object inside array inside array in MongoDB
  27. Modify and replay MongoDB oplog
  28. Creating custom Object ID in MongoDB
  29. Sort nested array of objects
  30. How to create a Mongo Docker Image with default collections and data?

Leave a Comment