I am very new to Mongo engine and currently I have mongo query filter that is working in mongo shell but I wanted to achieve the same in Mongoengine , can you please help me
Mongo Shell Query
{name:{$nin:[/ja/,/ra/]}}
but same is not working with Mongoengine
namelist = NameRecord.objects(name__nin=['/ja/','/ra/'])
Thanks in advance
First of all I would like to thank @tom-slabbaert for pointing me the what was wrong , as he pointed the issue was with regex of python and finally with his input I am able to find the solution, in fact all credits goes to him just I am adding answer so it will be helpful any others in future
namelist = NameRecord.objects(name__nin=[re.compile(r"ja"), re.compile(r"ra")])
In the Mongo shell you're using javascript regex syntax, /string/ is a regex and not a string. unlike in python where youse using these values are strings.
All you need to do is convert them to the python regex equivalent:
namelist = NameRecord.objects(name__nin=[r"ja", r"ra"])
