/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

1 vote213 views1 answer
Django sites framework
Python Django
8 votes219 views6 answers
Django filters
Python Django
3 votes257 views1 answer
Django user group check
Python Django
0 vote218 views1 answer
Django today date in template
Python Django
0 vote251 views2 answers
Django models get all
Python Django
2 votes229 views3 answers
Django login required decorator
Python Django
0 vote217 views1 answer
Celery beat command for django celery beat
Python Django
3 votes225 views2 answers
Django rest framework simple jwt
Python Django
0 vote242 views1 answer
Django model custom field
Python Django
0 vote228 views1 answer
Iniciar servidor en Django
Python Django