/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 vote265 views1 answer
Add to manytomany key django stackoverflow
Python Django
0 vote279 views1 answer
Reverse relationship in django for one to one field for usage in Django rest serializer
Python Django
0 vote305 views1 answer
Add row in db django
Python Django
1 vote261 views2 answers
Django class based views
Python Django
0 vote287 views1 answer
Django versatileimagefield
Python Django
0 vote269 views1 answer
Django on_delete rules
Python Django
9 votes271 views2 answers
Django import Q
Python Django
1 vote254 views2 answers
How to 404 custom page not found in django
Python Django
0 vote314 views3 answers
User serializer in django rest framework
Python Django
0 vote320 views1 answer
Django get current user in form
Python Django