gistfile1.txt

> db.inventory.insert(
...     {
...      item: "ABC1",
...      details: [{
...          model: "14Q3",
...          manufacturer: "XYZ Company"
...      }, 
...      {
...          model: "14Q4",
...          manufacturer: "ABC Company"
...      }],
...      stock: [ { size: "S", qty: 25 }, { size: "M", qty: 50 } ],
...      category: "clothing"
...     }
... )
WriteResult({ "nInserted" : 1 })
> 
> db.inventory.aggregate( [ { $unwind : "$stock" } ] );
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : [ { "model" : "14Q3", "manufacturer" : "XYZ Company" }, { "model" : "14Q4", "manufacturer" : "ABC Company" } ], "stock" : { "size" : "S", "qty" : 25 }, "category" : "clothing" }
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : [ { "model" : "14Q3", "manufacturer" : "XYZ Company" }, { "model" : "14Q4", "manufacturer" : "ABC Company" } ], "stock" : { "size" : "M", "qty" : 50 }, "category" : "clothing" }
> 
> 
> db.inventory.aggregate( [ { $unwind : "$details"}, { $unwind : "$stock" } ] );
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : { "model" : "14Q3", "manufacturer" : "XYZ Company" }, "stock" : { "size" : "S", "qty" : 25 }, "category" : "clothing" }
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : { "model" : "14Q3", "manufacturer" : "XYZ Company" }, "stock" : { "size" : "M", "qty" : 50 }, "category" : "clothing" }
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : { "model" : "14Q4", "manufacturer" : "ABC Company" }, "stock" : { "size" : "S", "qty" : 25 }, "category" : "clothing" }
{ "_id" : ObjectId("56040fcf3bcf6e956317c191"), "item" : "ABC1", "details" : { "model" : "14Q4", "manufacturer" : "ABC Company" }, "stock" : { "size" : "M", "qty" : 50 }, "category" : "clothing" }