/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 vote211 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django
0 vote224 views1 answer
Random word generator django
Python Django
0 vote186 views1 answer
Get list of users django
Python Django
1 vote196 views1 answer
Check if the user is logged in django decorator
Python Django
0 vote163 views2 answers
Deploy django with nginx and gunicorn
Python Django
0 vote206 views1 answer
Form rendering options in django
Python Django
0 vote213 views1 answer
Django today date in template
Python Django
3 votes218 views1 answer
Django user group check
Python Django
0 vote218 views1 answer
How to insert value in admin panel in django
Python Django
0 vote190 views1 answer
Sending email in django
Python Django