/Python/Django/Django filter and condition

Django filter and condition

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

Django filter and condition

from django.db.models import Q
criterion1 = Q(question__contains="software")
criterion2 = Q(question__contains="java")
q = Question.objects.filter(criterion1 & criterion2)

Source: stackoverflow.com

Similar codes

0 vote244 views1 answer
How to get data from multiple tables in django
Python Django
0 vote220 views1 answer
How to instal django cities
Python Django
1 vote220 views1 answer
Run django app locally
Python Django
0 vote218 views1 answer
Django from
Python Django
1 vote273 views1 answer
Permanent redirect django
Python Django
2 votes278 views3 answers
Get absolute url django
Python Django
0 vote225 views3 answers
Django add user to group
Python Django
0 vote218 views1 answer
Change date format on django templates
Python Django
0 vote233 views1 answer
Django rest framework not getting form
Python Django
2 votes365 views1 answer
Django empty queryset
Python Django