CODEWITHSUNDEEP
node.jsmongodbangularjsmongoose
Pmpha
Pmpha

Reputation: 25

find multiple documents by the same objectID

I have a documents with the following structure:

the model:

var relationID = Schema({
    _id: {type: Schema.Types.ObjectId}
});

    var schemaName = Schema({   
    relations:[relationID],   
    meta: {},    
    modificationDate: {type: Date, "default": Date.now}});

doc 1:

doc:  { 
_id: 52cdb245f5116f8567000004

relations: 
   [{ 
      _id: 52cd9930a22c865a44000006
   }]
}

doc 2:

doc:  { 
    _id: 52d01bf303aaa8f473000005

    relations: 
       [{ 
          _id: 52cd9930a22c865a44000006
       }]
}

Both docs have the same relations id. I want to select them with:

exports.detail = function (req, res) {
    var condition, fields, options;
    condition = {relationsID: { $in: [ "52cd9930a22c865a44000006"]  } }

        fields = {},
        options = {'createdAt': -1};

    transactions
        .find(condition, fields)
        .exec(function (err, doc){
            var retObj = {
                meta: {"action": "list",'timestamp': new Date()},
                doc: doc[0],
                err: err
            };
            return res.send(retObj);
        })
}

it doesn't work. How can i select both docs?

Thanks!

Upvotes: 0

Views: 142

Answers (1)

Peter Lyons
Peter Lyons

Reputation: 145994

All you need is:

var condition = {'relations._id': '52cd9930a22c865a44000006'};

Mongodb will interpret that intuitively for an array of objects. You do not need the $in operator. Mongodb knows when it finds a document where .relations is an array, to look through the array for a subdocument with the matching ._id.

Upvotes: 1

Related Questions