mongodb wrong when i try to findandmodify

Question

this is the structure in mongodb

{   code:'ACBD5588',
    email:'owner@mail.com',
    object{
        array_doc:[//many documents with this structure
        {
            code_doc:'ANCB7894',
            info_doc:'....',
            //etc
        }
        ],
        counting:45,
    }
}

im trying to delete a document inside an array, this document haas a unique code_array so in the array there are many documents with a unique code_array, i want to erase the document inside the array

db.collection('database').findAndModify(
        {
            'code':code,
            'email':email,
        },[],{$pull:{'object.array_doc':{'code_doc':code_doc}}},function(err,resultado)
        {

but the operation gives me this error

uncaught exception: findAndModifyFailed failed: { "errmsg" :
 "need remove or update", "ok" : 0 }

please provide a sample document that you expect this to succeed on - it's not clear from the post exactly what the schema is. — Asya Kamsky, Feb 27 '13 at 12:27
each document have an array of documents named 'object', and i have to pull and push documents inside — andrescabana86, Feb 27 '13 at 21:36
The document you listed is not legal JSON. Do you just have extra {} on some of the fields by mistake? Also, I don't see a field named code_array, but I do see code_doc - do you have a typo in your query? — Asya Kamsky, Feb 28 '13 at 00:02
yes sry my mistake, i edit the post... now is correct, what is the mean of"The document you listed is not legal JSON."... — andrescabana86, Feb 28 '13 at 01:34
This works fine if I run it as a mongoskin program. Are you running this in the shell or as a mongoskin program? — JohnnyHK, Feb 28 '13 at 02:14
Is mongoskin up to date? `npm ls mongoskin` should show 0.5.0. — JohnnyHK, Feb 28 '13 at 02:25
it's not syntactically legal. You had extra {}s and you don't have : between object and { - can you cut-n-paste what is actually in your program? Also make sure all the variables are set. — Asya Kamsky, Feb 28 '13 at 08:39

score 0 · Answer 1 · answered Jan 12 '15 at 07:57

Which version of MongoDB are you using? In the latest version MongoDB expects "update" or "remove" to be mentioned explicitly in the findAndModify command. Please use the following query instead.

db.collectionName.findAndModify({
  query : {
    'code':code,
    'email':email
  },
  update: {
     $pull : {'object.array_doc':{'code_doc':code_doc} }
  }
})

mongodb wrong when i try to findandmodify

1 Answers1