How do I filter query objects (DecimalFIeld) by value range in Django?

user_5308983 0
Viewed 484

I've a Django model with a DecimalField.

class SomeModel(models.Model):
    decimal_field = models.DecimalField()

I'd like to get all model instances which have a field value in the range of e.g. 5.0 and 10.0. I've read the Django docs section about queries but I did not find a solution. How do I have to write the query SomeModel.objects.filter(?) ?

django-models django
2 Answers

You should use the __gt __gte __lt __lte field lookups, corresponding to greater, than greater than or equal, less than, less than or equal, so the query you want to do should look like:

SomeModel.objects.filter(decimal_field__gte=lower_limit, decimal_field__lte=upper_limit)
user_125212020
user_9016410
Related