[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.
Why don’t you use the _range function?
filter(gender="MALE", age__range=(10, 50))
Edit for new link:
If you really want to use
<= yo could write:
Modelname.objects.filter(gender='MALE', age__gte = 10, age__lte = 50).count()