Filter by property

python django orm
schneck picture schneck · Jul 30, 2009 · Viewed 53.6k times · Source

Is it possible to filter a Django queryset by model property?

i have a method in my model:

@property
def myproperty(self):
    [..]

and now i want to filter by this property like:

MyModel.objects.filter(myproperty=[..])

is this somehow possible?

Answer

Glenn Maynard picture Glenn Maynard · Jul 30, 2009

Nope. Django filters operate at the database level, generating SQL. To filter based on Python properties, you have to load the object into Python to evaluate the property--and at that point, you've already done all the work to load it.

Related questions

How to store a dictionary on a Django Model?

I need to store some data in a Django model. These data are not equal to all instances of the model. At first I thought about subclassing the model, but I’m trying to keep the application flexible. If I …

Read More
How to TRUNCATE TABLE using Django's ORM?

To empty a database table, I use this SQL Query: TRUNCATE TABLE `books` How to I truncate a table using Django's models and ORM? I've tried this, but it doesn't work: Book.objects.truncate()

Read More
How to make an Inner Join in django?

I want to show in an Html the name of the city, state, and country of a publication. But they are in different tables. Here is my models.py class country(models.Model): country_name = models.CharField(max_length=200, null=…

Read More