mongodb – Find document with closest integer value

by

Interesting problem. I don’t know if you can do it in a single query, but you can do it in two:

var x = 1; // given integer
closestBelow = db.test.find({ratio: {$lte: x}}).sort({ratio: -1}).limit(1);
closestAbove = db.test.find({ratio: {$gt: x}}).sort({ratio: 1}).limit(1);

Then you just check which of the two docs has the ratio closest to the target integer.

MongoDB 3.2 Update

The 3.2 release adds support for the $abs absolute value aggregation operator which now allows this to be done in a single aggregate query:

var x = 1;
db.test.aggregate([
    // Project a diff field that's the absolute difference along with the original doc.
    {$project: {diff: {$abs: {$subtract: [x, '$ratio']}}, doc: '$$ROOT'}},
    // Order the docs by diff
    {$sort: {diff: 1}},
    // Take the first one
    {$limit: 1}
])

More Related Contents:

  1. Find objects between two dates MongoDB
  2. How to update the _id of one MongoDB Document?
  3. How to remove a field completely from a MongoDB document?
  4. How to Model a “likes” voting system with MongoDB
  5. Understanding MongoDB BSON Document size limit
  6. MongoDB – admin user not authorized
  7. How can I run MongoDB as a Windows service?
  8. Overflow sort stage buffered data usage exceeds internal limit
  9. Slow pagination over tons of records in mongodb
  10. MongoDB – paging
  11. MongoDB query with an ‘or’ condition
  12. mongo.exe not installed in Version 6.0.0
  13. multiple instances of Mongo DB on same server
  14. How can I share MongoDB collections between Meteor apps?
  15. MongoDb shuts down with Code 100 [closed]
  16. Mongodb Query To select records having a given key
  17. MongoDB – What about Decimal type of value?
  18. MongoDB $or query
  19. Is shortening MongoDB property names worthwhile?
  20. Can mongodb be used as an embedded database?
  21. convert iso date to timestamp in mongo query
  22. Using $slice operator to get last element of array
  23. Simple HTTP/TCP health check for MongoDB
  24. How to organise a many to many relationship in MongoDB
  25. Map-Reduce performance in MongoDb 2.2, 2.4, and 2.6
  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