[jira] [Created] (CAMEL-10019) Consider sortBy header when performing findOneByQuery operation

["Kris Boutilier (JIRA)" <ji...@apache.org>]

Kris Boutilier created CAMEL-10019:
--------------------------------------

             Summary: Consider sortBy header when performing findOneByQuery operation
                 Key: CAMEL-10019
                 URL: https://issues.apache.org/jira/browse/CAMEL-10019
             Project: Camel
          Issue Type: New Feature
          Components: camel-mongodb
    Affects Versions: 2.17.1
            Reporter: Kris Boutilier


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)