/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

3 votes322 views1 answer
No module named 'django.core.urlresolvers'
Python Django
0 vote352 views1 answer
Login views django template passing
Python Django
-1 vote308 views2 answers
Django view
Python Django
19 votes374 views6 answers
Pip install django
Python Django
0 vote334 views1 answer
Proper pagination django template
Python Django
-2 votes287 views9 answers
Django
Python Django
-2 votes376 views1 answer
How to get data from django session
Python Django
1 vote309 views1 answer
Order by listview django
Python Django
0 vote331 views1 answer
Django many to many post update method via rest
Python Django
0 vote356 views1 answer
Django check if user is staff in template
Python Django