[jira] [Updated] (CAMEL-10019) camel-mongodb - Consider sortBy header when performing findOneByQuery operation

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

     [ https://issues.apache.org/jira/browse/CAMEL-10019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kris Boutilier updated CAMEL-10019:
-----------------------------------
    Summary: camel-mongodb - Consider sortBy header when performing findOneByQuery operation  (was: Consider sortBy header when performing findOneByQuery operation)

> camel-mongodb - 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
>            Priority: Trivial
>
> 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)