[CAMEL-10023] camel-mongodb - Consider sortBy header when performing findOneByQuery operation

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 2.17.1
• Fix Version/s: 2.17.2
• Component/s: camel-mongodb
• Patch Info: Patch Available
• Estimated Complexity: Novice
• Flags: Patch
• External issue URL: https://github.com/apache/camel/pull/1016
• Assignee: Claus Ibsen
• Reporter: Kris Boutilier
• Created: 07/Jun/16 00:05
• Updated: 09/Jun/16 18:01
• Resolved: 08/Jun/16 12:33

Description

There is a often a requirement to fetch the min/max record from Mongo based on a particular field. Typically the operation is performed using syntax similar to:

db.collection.find().sort({_id: -1}).limit(1)

or

db.collection.findOne({$query:{},$orderby:{_id:-1}})

As implemented the findOneByQuery operation currently ignores the sortBy header. This trivial patch passes sortBy to the sort parameter of findOne(), if set.

Helpfully, if the projection parameter is null findOne() returns all fields, so the state of fieldFilter is not checked before passing when the sortBy header has been set.

Issue Links

• links to: GitHub Pull Request #1016