How to query as the count of hitting element in a list on a field which is a list in Mongodb using Python?

Question

Given the following documents in the ariticle collection:

{ _id: 1, words: [ "Apple", "IT", "Company", "IOS" ] }

{ _id: 2, words: [ "Google", "Android", "Search Engine","Company" ] }

Now, I wanna to query on the words field to get the documents that hit a specified number of elements in the list ["Company","Apple","IT","Google","Iphone","Smartisan"]. For example, I wanna to get the documents that hits any of 3 in the list above on field words.

How to write the query statements in pymongo, or does pymongo support query like this?

score 1 · Answer 1 · edited May 23 '17 at 12:20

1

You can use the $size operator to select arrays of a certain size.

db.article.find({ "words" : { "$size" : 3 } })

Obviously, replace db and article with the variables identifying your database and collection.

How to query as the count of hitting element in a list on a field which is a list in Mongodb using Python?

1 Answers1