/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 vote357 views1 answer
Abstract user in django
Python Django
0 vote333 views1 answer
Django set random password
Python Django
1 vote335 views1 answer
Django sites framework
Python Django
0 vote381 views1 answer
Django import Response
Python Django
0 vote338 views1 answer
Set defualt to none django
Python Django
1 vote382 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
0 vote354 views1 answer
Bulk upload with dictionary or list in django moels
Python Django
-2 votes370 views2 answers
Where to import reverse_lazy in django
Python Django
0 vote360 views1 answer
Python Django How To Bulk Update
Python Django
0 vote346 views1 answer
User passes test django
Python Django