Usage of "$nin" in pymongo script

Question

I am running a python script to retrieve data from a mongo collection. I would like to use the "$nin" operator to retrieve all the fields from the collection except for the ones whose "UserID" is not like "xyz.com". Below is my script, I am running into a syntax error using the script. Could you please let me know how the "$nin" should be represented in pymongo ?

for data in db.userauthorization.find({'UserID':{"$nin":{[/'xyz.com'/]}}}):
    print data

Thanks in advance!

The syntax error is not in the $nin, it's in the use of slashes around the regex. — Daniel Roseman, Jun 14 '16 at 19:44
Right, as such, this is basically a dupe of https://stackoverflow.com/questions/3483318/performing-regex-queries-with-pymongo — JohnnyHK, Jun 14 '16 at 20:08

score 0 · Answer 1 · answered Nov 04 '19 at 11:56

0

Try without "/" for data in db.userauthorization.find({'UserID':{"$nin":{['xyz.com']}}}): print data

answered Nov 04 '19 at 11:56

Pierre

21
3

Usage of "$nin" in pymongo script

1 Answers1