/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 vote234 views1 answer
Django force download file
Python Django
2 votes178 views1 answer
Urlpatterns += static(r'^static/(?P<path>.*)$', 'django.views.static.serve', {'document_root': settings.STATIC_ROOT})
Python Django
0 vote158 views1 answer
Django rotatingfilehandler
Python Django
0 vote165 views1 answer
Load local data to django
Python Django
0 vote150 views1 answer
Django sign up
Python Django
0 vote147 views1 answer
Django from
Python Django
0 vote141 views1 answer
Show all urls django extensions
Python Django
0 vote149 views1 answer
Django swagger settings https
Python Django
0 vote142 views1 answer
Django fixtures. To dump data
Python Django
2 votes162 views2 answers
Get query param in django
Python Django