/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

0 vote419 views1 answer
Test if instance in queryset django
Python Django
0 vote407 views1 answer
Django-mathfilters
Python Django
0 vote389 views1 answer
Django raw without sql injection
Python Django
4 votes406 views1 answer
Django slug int url mapping
Python Django
0 vote393 views1 answer
Import sqlite to mysql django
Python Django
2 votes384 views1 answer
Django and react url conflict
Python Django
0 vote421 views1 answer
Django database connection isn't set to UTC postgresql
Python Django
3 votes297 views2 answers
Django favicon
Python Django
0 vote371 views1 answer
Django not saving images forms
Python Django
0 vote400 views1 answer
Fix the debug_mode = false django
Python Django