How to use lookup operator icontains in raw query of django mongodb engine?

Question

I am using django-mongodb-engine

Here, I used MongoDBManager to use a raw query.

class NameInfo(models.Model)
   first_name = models.CharField(max_length=50)


class Abc(models.Model):
    name = EmbeddedModelField('NameInfo')
    objects = MongoDBManager()

Abc.objects.raw_query({'name.firstname.contains':'j'})

The last line is not working as expected. So, how can I use the contains lookup type on embedded fields?

If there is another workaround not using MongoDBManager that would also be acceptable.

score 0 · Accepted Answer · edited Jun 01 '18 at 22:38

0

In MongoDB terms this is a $regex operation, so you issue in "raw" like this:

Abc.objects.raw_query({ "name.firstname": { "$regex": "j" } })

Note that the objects returned are not the model objects from your class definitions but simply raw python objects.

edited Jun 01 '18 at 22:38

AnilRedshift

7,937
7
35
59

answered Jul 14 '15 at 10:50

Blakes Seven

49,422
14
129
135

Perfect Answer! The first query is working, second one is not, because i am using django-mongodb-engine, not mongoengine. – jatinkumar patel Jul 14 '15 at 10:58
@jatin Sorry I'll strip that. On autopilot as a mongoengine user myself. Should have read your tags. – Blakes Seven Jul 14 '15 at 11:00
Hey! We don't use semicolon in Python ;) – Paulo Fabrício Dec 05 '17 at 12:10

How to use lookup operator icontains in raw query of django mongodb engine?

1 Answers1