/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 vote384 views1 answer
Django queryset group by sum
Python Django
3 votes386 views1 answer
Disable csrf for one url django
Python Django
3 votes376 views2 answers
Django postgres connection
Python Django
0 vote370 views1 answer
Access host database django docker
Python Django
0 vote368 views1 answer
Change date format on django templates
Python Django
1 vote363 views1 answer
Django foreign key field on delete do nothing
Python Django
0 vote383 views1 answer
Django save another class data while saving a class
Python Django
0 vote368 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python Django
0 vote418 views1 answer
How to pass primary key to url django
Python Django
0 vote369 views1 answer
Django email change sender name
Python Django