/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 vote143 views1 answer
Listing of django model types
Python Django
0 vote136 views1 answer
How to order randomly in django orm
Python Django
6 votes129 views2 answers
Kill port django
Python Django
5 votes127 views2 answers
Get_object_or_404 django
Python Django
0 vote142 views1 answer
Adding extra fields to user model django
Python Django
1 vote132 views2 answers
Django in conda
Python Django
0 vote128 views1 answer
For loop in django template css
Python Django
2 votes202 views3 answers
No such table django
Python Django
1 vote200 views1 answer
Create django group
Python Django
1 vote141 views1 answer
Check if queryset is empty django template
Python Django