/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 vote131 views1 answer
Server error 500 heroku django
Python Django
1 vote138 views1 answer
How to send json in django response
Python Django
1 vote121 views1 answer
Require http method django view
Python Django
0 vote144 views1 answer
Get context data django
Python Django
1 vote129 views1 answer
Django httpresponseredirect
Python Django
0 vote144 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python Django
0 vote143 views2 answers
Avoid bad request django
Python Django
-1 vote131 views1 answer
Django queryset count
Python Django
0 vote187 views1 answer
Shared a local host django
Python Django
12 votes146 views5 answers
Django-cors-headers
Python Django