How to extract data if array contains required data

[shubham_udata]

I have documents like this:

_id:shubham
hobbies [2 elements]
  [0] {2 fields}
 Type : Drawing
 Members: 1
  [1] {2 fields}
 Type : Cricket
 Members: 11

 _id:anant
hobbies [2 elements]
  [0] {2 fields}
 Type : Drawing
 Members: 1

  _id:nipoon
hobbies [2 elements]
  [0] {2 fields}
 Type : Drawing
 Members: 1
  [1] {2 fields}
 Type : Cricket
 Members: 11

I want to extract data which as both Drawing and Cricket as hobbies and eliminate if not having both.

In above case I want all data of _id: shubham and _id: nipoon and eliminate _id: anant.

[steevej (Steeve Juneau)]

Could you please provide your sample data as well formed JSON documents?

This way we can just cut-n-paste the documents directly in our installation. This will help us help you faster.

[MaBeuLux88 (Maxime Beugnet)]

I think I have a simpler version with the $all array operator:

> db.col.find({hobbies: {$all: ["Cricket", "Drawing"]}})
{ "_id" : "shubham", "hobbies" : [ "Drawing", "Cricket" ], "members" : 11 }

Cheers,
Maxime.