/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 vote353 views1 answer
Django table view sort filter
Python Django
0 vote360 views1 answer
Django url patterns static
Python Django
0 vote390 views1 answer
Django update field after save
Python Django
0 vote357 views1 answer
Django allauth Reverse for 'password_reset_confirm' not found. 'password_reset_confirm' is not a valid view function or pattern name.
Python Django
0 vote386 views1 answer
Start a django project
Python Django
0 vote368 views1 answer
How to run django server outside world
Python Django
0 vote343 views1 answer
Django model registration
Python Django
2 votes324 views1 answer
Django.core.exceptions.improperlyconfigured: wsgi application 'backend.wsgi.application' could not be loaded; error importing module.
Python Django
0 vote373 views1 answer
Two input string sum in django
Python Django
6 votes352 views3 answers
Django models filter
Python Django