在django过滤器中如何做小于等于等于？ [英] how to do less than or equal to and greater than equal to in django filter?

问题描述

在django过滤器中怎么做小于等于大于等于？像，我想在django视图中获取周围的价值：- 10< = val< = 50 。

为此，我在sql中使用了一些查询这：-

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;

我在django视图中尝试过类似的操作：-

I tried something like this in django view :-

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

但是我得到了不同的值。在sql中，我有65，在django中，我有29。sql答案是正确的。请帮助我在Django视图中进行比较。

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.

推荐答案

为什么不使用_range函数？

Why don't you use the _range function?

filter（gender ='MALE'，age__range =（10，50））

请参见此处：
https://docs.djangoproject.com/zh-CN/1.7/ ref / models / querysets /＃range

编辑新链接：
> https://docs.djangoproject.com/en/3.0/ref/models/querysets/#range

这篇关于在django过滤器中如何做小于等于等于？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！