/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

15 votes306 views6 answers
Django install
Python Django
11 votes280 views3 answers
Django q filter
Python Django
1 vote247 views1 answer
Django pass data between views
Python Django
0 vote307 views2 answers
Django rest framework foreign key relation giving error in serializer
Python Django
-1 vote302 views2 answers
Django connection cursor
Python Django
3 votes350 views1 answer
Django session expire time
Python Django
0 vote232 views1 answer
Django set boolean field value in view
Python Django
1 vote323 views1 answer
Django add to cart
Python Django
2 votes353 views2 answers
Django template array index
Python Django
4 votes283 views2 answers
Django how to delete a db field
Python Django