/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 vote202 views1 answer
How to add phone number to django user model
Python Django
1 vote226 views1 answer
No such table: django_session admin
Python Django
2 votes206 views1 answer
Django model current timestamp
Python Django
2 votes199 views1 answer
How do I mock an uploaded file in django?
Python Django
0 vote225 views2 answers
How to use django-filters with viewset
Python Django
0 vote201 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
23 votes234 views2 answers
Django rest
Python Django
0 vote239 views2 answers
Django template date format yyyy-mm-dd
Python Django
15 votes220 views4 answers
Django python install
Python Django
3 votes220 views1 answer
Business logic in django
Python Django