[Solved] how to do less than or equal to and greater than equal to in django filter?

How to do less than or equal to and greater than equal to in django filter? Like , I want to get value around :- 10<=val<=50 in django view.
For this I used some query in sql like this :-

select count(*) from table_name where gender='MALE' and age<=50 and age>=10;

I tried something like this in django view :-

tablename.objects.filter(Q(gender="MALE"),Q(age__lte=50) & Q(age__gte=10)).count()

But I got different values. In sql I got 65 and in django I got 29. sql answer is correct. Please help me to do comparison in django view.

Solution #1:

Why don’t you use the _range function?

filter(gender="MALE", age__range=(10, 50))

See here:
https://docs.djangoproject.com/en/1.7/ref/models/querysets/#range

Edit for new link:
https://docs.djangoproject.com/en/3.0/ref/models/querysets/#range

Respondent: mikeb

Solution #2:

If you really want to use >= and <= yo could write:

Modelname.objects.filter(gender='MALE', age__gte = 10, age__lte = 50).count()
Respondent: doru

The answers/resolutions are collected from stackoverflow, are licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0 .

Leave a Reply

Your email address will not be published.