/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 vote338 views2 answers
Generate random password django
Python Django
0 vote327 views1 answer
Django model make the field caseinsensitive
Python Django
0 vote343 views1 answer
Form action in django
Python Django
0 vote347 views1 answer
Django not migrating
Python Django
1 vote344 views1 answer
Updating many to many field in django using pk
Python Django
0 vote332 views1 answer
Get ip address in django
Python Django
1 vote320 views1 answer
Correr servidor django
Python Django
0 vote328 views1 answer
Delete migrations django and start over deployment heroku
Python Django
1 vote327 views1 answer
Filter foreign fileds django_filters
Python Django
0 vote333 views2 answers
Allow x_frame_options django
Python Django