/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 vote168 views1 answer
Slug in redirect django
Python Django
0 vote238 views1 answer
Relative path django
Python Django
0 vote193 views1 answer
Validate delete inline formset django
Python Django
0 vote179 views3 answers
Django add user to group
Python Django
2 votes206 views2 answers
Django queryset is in list
Python Django
0 vote194 views1 answer
Get or create django
Python Django
0 vote180 views1 answer
Pass context data with templateview in django
Python Django
1 vote180 views1 answer
Cookies in django
Python Django
0 vote168 views1 answer
User passes test django
Python Django
0 vote194 views1 answer
Enumerate in django templte
Python Django