/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 vote392 views5 answers
Django-tool-bar
Python Django
12 votes284 views5 answers
Django-cors-headers
Python Django
0 vote232 views1 answer
Python django model range validation
Python Django
0 vote263 views1 answer
Django form is onvalid
Python Django
1 vote237 views1 answer
Iterate over dictionary django
Python Django
2 votes232 views2 answers
Or operator django
Python Django
0 vote198 views1 answer
Django rest framework multiple user registration
Python Django
0 vote270 views1 answer
Django.com
Python Django
0 vote243 views1 answer
What is *args and **kwargs in django
Python Django
1 vote242 views1 answer
Db_index django
Python Django