/Python/Django/Django filter multiple fields

Django filter multiple fields

# Will return rows with 1 or 6 in colA and 'yourValue' in colB
YourModel.objects.filter(colA__in=[1,8],colB='yourValue')

# Will return rows with 1 or 6 in colA OR
# potentially different rows with 'yourValue' in colB
YourModel.objects.filter(colA__in=[1,8]).filter(colB='yourValue')

Similar codes

0 vote291 views1 answer
Django allauth Reverse for 'password_reset_confirm' not found. 'password_reset_confirm' is not a valid view function or pattern name.
Python Django
0 vote265 views1 answer
Django MESSAGE_TAGS
Python Django
0 vote330 views1 answer
Back button django template
Python Django
23 votes344 views2 answers
Django rest
Python Django
4 votes296 views3 answers
No such table: django_session
Python Django
0 vote246 views1 answer
Add data to foreign key table django
Python Django
0 vote282 views2 answers
Django model remove duplicates
Python Django
0 vote295 views1 answer
Validationerror django params
Python Django
0 vote272 views2 answers
Django edit object foreign key id
Python Django
2 votes347 views2 answers
Django queryset is in list
Python Django