/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 vote146 views1 answer
Purpose of migration folder in django
Python Django
1 vote141 views1 answer
Django proper capitalization case jinja
Python Django
1 vote128 views1 answer
Django model query add annotation field to show duplicate count
Python Django
4 votes177 views2 answers
Authentication views django
Python Django
0 vote80 views1 answer
Cant use foreign key in list_display django
Python Django
1 vote130 views1 answer
Module "django.contrib.auth.hashers" does not define a "BcryptPasswordHasher" attribute/class
Python Django
6 votes95 views2 answers
Get_or_create django
Python Django
0 vote140 views1 answer
Django pointfield value format for fixtures
Python Django
0 vote145 views1 answer
Pdfs in django
Python Django
0 vote140 views1 answer
Django datepicker mindate and maxdate
Python Django