pymongo- How can I have distinct values for a field along with other query parameters


I am using pymongo and want to have distinct values for a field such that I can also pass other query parameters. For example, I have entries like:

   id = "my_id1"
   tags: [tag1, tag2, tag3],
   category: "movie",
   id = "my_id2"
   tags: [tag3, tag6, tag9],
   category: "tv",
   id = "my_id3"
   tags: [tag2, tag6, tag8],
   category: "movie",

So I want to have all distinct tags under movie category. Can anyone please guide how can I achive this using pymongo. In mongo javascript shell, I issued db.mycoll.distinct('tags', {category: "movie"}) and it worked just fine. But when I do the same in pymongo it raises error. I guess it is not supported in pymongo. Any idea though how can such a task be achieved.

10/14/2012 6:29:08 AM

Accepted Answer

You have to make the distinct call on the cursor returned from a find instead of on the collection:

tags = db.mycoll.find({"category": "movie"}).distinct("tags")
12/3/2015 2:05:28 PM

pymongo (since v1.1.1) supports collection.distinct('key')

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow