I'm new to MongoDB. I've imported a json file into my MongoDB. The structure looks like the following:
What I'm trying to do is get all the data for player 0, player 1,.. etc but I don't know how my db.collection.find should look.
Asked
Active
Viewed 44 times
0
halfer
- 18,701
- 13
- 79
- 158
Joeri Boons
- 79
- 1
- 8
-
What do you really want to achieve? What should your query return? – Rudra Aug 23 '15 at 05:25
-
it should return the player[0] block – Joeri Boons Aug 23 '15 at 05:29
-
Possible dupe of http://stackoverflow.com/questions/3985214/retrieve-only-the-queried-element-in-an-object-array-in-mongodb-collection – JohnnyHK Aug 23 '15 at 05:44
-
use `$unwind` with `aggregation` framework. If you can provide a sample data set, I might try to write the exact query. – Rudra Aug 23 '15 at 05:47
-
well this is my json file: [link](http://pastebin.com/zycpLcwe) – Joeri Boons Aug 23 '15 at 05:55
1 Answers
2
Use db.collection.aggregate([{$unwind:"$match.players"}]). You cal also choose which field to project and which field to not. You can add that in the aggregation pipeline.
db.collection.aggregate([{$unwind:"$match.players"},
{$project:{_id:1, player:'$match.players'}}
]);
Rudra
- 1,590
- 15
- 26