NodeJS and MongoDB FindAndModify() need remove or update

The .findAndModify() method in the node native driver implementation is different from the mongo shell implementation. To do an update as above you do:

collection.findAndModify(   { "_id": "auto" },   { "$inc": { "bill": 1 } },   function(err,doc) {     // work here   });

Oddly somewhat to remove you specify in options so the same would "remove" the matched document:

collection.findAndModify(   { "_id": "auto" },   { "$inc": { "bill": 1 } },   { "remove": true },   function(err,doc) {     // work here   });

The main difference being you do not name the "key" sections for the actions.

http://mongodb.github.io/node-mongodb-native/2.0/api/Collection.html#findAndModify

This above document specifies that the second parameter is the sort order for choosing which document to use if multiple ones match the query. Only giving two parameters will result in the "need remove or update" error message.

collection('MyCollection').findAndModify(    { _id: "auto" },    [],    { $inc: { "bill": 1 } },    { upsert: true, new: true },    function(err,doc) {       // work here    });

Hi I have followed this and it worked perfectly.db.collection('test').findAndModify(  {hello: 'world'}, // query  [['_id','asc']],  // sort order  {$set: {hi: 'there'}}, // replacement, replaces only the field "hi"  {}, // options  function(err, object) {      if (err){          console.warn(err.message);  // returns error if no matching object found      }else{          console.dir(object);      }  });});