MongoDb query condition on comparing 2 fields

by

You can use a $where. Just be aware it will be fairly slow (has to execute Javascript code on every record) so combine with indexed queries if you can.

db.T.find( { $where: function() { return this.Grade1 > this.Grade2 } } );

or more compact:

db.T.find( { $where : "this.Grade1 > this.Grade2" } );

UPD for mongodb v.3.6+

you can use $expr as described in recent answer

More Related Contents:

  1. MEAN app vs. Mongo service local in Angular2
  2. Find objects between two dates MongoDB
  3. Get names of all keys in the collection
  4. How to filter array in subdocument with MongoDB [duplicate]
  5. How to select a single field for all documents in a MongoDB collection?
  6. mongodb group values by multiple fields
  7. Conditional $sum in MongoDB
  8. mongoDB/mongoose: unique if not null
  9. arrayFilters in mongodb
  10. MongoDB password with “@” in it
  11. MongoDB: How to query for records where field is null or not set?
  12. exclude fields in $lookup aggregation
  13. Mongo how to $lookup with DBRef
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. How do you query for “is not null” in Mongo?
  16. MongoDB: exception in initAndListen: 20 Attempted to create a lock file on a read-only directory: /data/db, terminating
  17. MongoDB ‘unable to find index for $geoNear query’
  18. MongoDB sort documents by array elements
  19. MongoDB won’t start after server crash
  20. MongoDB Text Search AND multiple search words
  21. How does sorting with an index work in MongoDB?
  22. How to use dot in field name?
  23. How to get multiple document using array of MongoDb id?
  24. Docker: change folder where to store docker volumes
  25. How to organise a many to many relationship in MongoDB
  26. Unique IDs with mongodb
  27. Cannot import mongodb
  28. MongoDB count() versus countDocuments()
  29. mongodb : Increasing max connections in mongodb
  30. Create filter aggregation in spring

Leave a Comment