mongodb query array of elemnts in a field

Question

I have array of _id's like

arr=["xxxx","yyyyy",zzzz"]

NOw I want to return all the docs of these ids from a collection like

coll.find({_id:{$in:{arr}})//must return xxx.yyy.zzz docs

this is returning all fields from collection, How to do this?

these are my docs

  {_id:"xxx",
         bvalue:"val",
         cval:"val"
    }
     {_id:"yyy",
         bvalue:"val",
         cval:"val"
    }
     {_id:"zzz",
         bvalue:"val",
         cval:"val"
    }

I need a query which returns all documents with id's in array In my array I have id's xxx,yyy,zzz so I want all these docs to return

Re-phrase the question and give an example.

vmr
– vmr

2014-09-30 09:33:51 +00:00
Commented Sep 30, 2014 at 9:33 — vmr
– vmr, Commented Sep 30, 2014 at 9:33
Please add your doc structure

mallik
– mallik

2014-09-30 10:09:08 +00:00
Commented Sep 30, 2014 at 10:09 — mallik
– mallik, Commented Sep 30, 2014 at 10:09

wdberkeley · Accepted Answer · 2014-09-30 15:01:47Z

2

The query is doing exactly what it is supposed to - returning the documents that match your query criteria. If you just want the _id's back, use projection:

db.coll.find({ "_id" : { "$in" : arr }, { "_id" : 1 })

answered Sep 30, 2014 at 15:01

wdberkeley

11.7k1 gold badge30 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

mongodb query array of elemnts in a field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related