MongoDb Java Async: Combine Filter and Sort for FindOneAndUpdate

Question

Suppose I want to run query like this

.find(Filters.exists("a", false))
            .sort(Sorts.orderBy(Sorts.descending("b"),Sorts.ascending("c")))

But with findOneAndUpdate operation.

.findOneAndUpate(bson???, Updates.combine(Updates.set("b", 1), Updates.set("c", 2)), callback)

How do I create correct bson parameter, combining both filter and sort?

s7vr · Accepted Answer · 2017-03-07 11:41:21Z

1

You can't combine filter with sort.

FindOneAndUpdate takes three parameters. Pass the first parameter as filter and third parameter is FindOneAndUpdateOptions which takes the sort.

Something like

findOneAndUpdate(filter,update,
                         new FindOneAndUpdateOptions().sort(sort));

answered Mar 7, 2017 at 11:41

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1