Django filter query on with property fields automatically calculated
No, you can't perform lookup based on model methods or properties. Django ORM does not allow that.
Queries are compiled to SQL to be sent and processed at the database level whereas properties are Python code and the database knows nothing about them. That's the reason why the Django filter only allows us to use database fields.
Can do this:
Order.objects.filter(created=..) # valid as 'created' is a model field
Cannot do this:
Order.objects.filter(expires=..) # INVALID as 'expires' is a model property
You can instead use list comprehensions to get the desired result.
[obj for obj in Order.objects.all() if obj.expire in days]
The above will give me the list of Order
objects having expire
value in the days
list.
I dont think you can use a property in the field lookups as the doc says The field specified in a lookup has to be the name of a model field
https://docs.djangoproject.com/en/1.8/topics/db/queries/#field-lookups