/Python/Django/Django filter and condition

Django filter and condition

And condition with or in django

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 account

Source: stackoverflow.com

Django filter and condition

from django.db.models import Q
criterion1 = Q(question__contains="software")
criterion2 = Q(question__contains="java")
q = Question.objects.filter(criterion1 & criterion2)

Source: stackoverflow.com

Similar codes

0 vote250 views2 answers
Blog in django
Python Django
4 votes166 views2 answers
Check installed django version
Python Django
0 vote234 views1 answer
Django filter values with e and operator
Python Django
0 vote300 views1 answer
Relative path django
Python Django
0 vote257 views1 answer
Django voice lib
Python Django
5 votes274 views3 answers
Render to response django
Python Django
9 votes237 views2 answers
Django app
Python Django
0 vote232 views1 answer
Django collectstatic with auto yes
Python Django
0 vote258 views1 answer
Django auto increment field
Python Django
0 vote230 views1 answer
Filter outside queryset in list django
Python Django