/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

23 votes513 views3 answers
Pip install django rest framework
Python Django
1 vote341 views2 answers
Join two querysets django
Python Django
0 vote386 views1 answer
Query first 5 element in django
Python Django
0 vote404 views1 answer
Activate inherit function django
Python Django
2 votes391 views2 answers
Or operator django
Python Django
0 vote376 views1 answer
Django rotatingfilehandler
Python Django
1 vote378 views2 answers
.save() in django
Python Django
0 vote381 views1 answer
App is not a registered namespace django
Python Django
0 vote372 views1 answer
Django-filter field name greater than
Python Django
1 vote407 views2 answers
How to access cookies in django
Python Django