高级查询,高级搜索,django做法
model.py
class A(models.Model):
a = models.CharField()
b = models.CharField()
c = models.CharField()
产生3个输入框,当用户不全输入时也可以查询。
views.py
from django.db.model.query_utils import Q
def aaa(request):
a = request.POST.get('a', None)
b = request.POST.get("b", None)
c = request.POST.get('c', None)
f = Q()
if a:
f = f & Q(('a', a.strip()))
if b:
f = f & Q(('b', a.strip()))
if c:
f = f & Q(('c', a.strip()))
result = A.objects.filter(f)