/Python/Django/And condition with or in django

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

Similar codes

4 votes360 views1 answer
Django is null
Python Django
13 votes374 views6 answers
Django orm
Python Django
0 vote319 views1 answer
How to add condition if null value in django orm
Python Django
0 vote370 views1 answer
Creating base models django
Python Django
0 vote403 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
2 votes337 views1 answer
Django filter multiple fields
Python Django
0 vote351 views1 answer
Django strptime
Python Django
0 vote333 views1 answer
Python django model range validation
Python Django
1 vote345 views2 answers
Get user ip address django
Python Django
0 vote306 views3 answers
Django custom authentication
Python Django