Question : and condition with or in django
Answered by : oldfashioned-opossum-tr6cvj1snkzw
Just adding this for multiple filters attaching to Q object, if someone might be looking to it. If a Q object is provided, it must precede the definition of any keyword arguments. Otherwise its an invalid query. You should be careful when doing it.
an example would be
from django.db.models import Q
User.objects.filter(Q(income__gte=5000) | Q(income__isnull=True),category='income')
Here the OR condition and a filter with category of income is taken into accountSource : https://stackoverflow.com/questions/6567831/how-to-perform-or-condition-in-django-queryset | Last Update : Sun, 20 Dec 20
Question : and condition with or in django
Answered by : poised-plover-c6x5difxlwz1
from django.db.models import Q
User.objects.filter(Q(income__gte=5000) | Q(income__isnull=True))Source : https://coders911.org/questions/6567831/How-to-perform-OR-condition-in-django-queryset | Last Update : Mon, 11 Apr 22
