/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 vote150 views1 answer
Register template tag django
Python Django
9 votes159 views2 answers
Django delete instance
Python Django
2 votes165 views1 answer
Django queryset get all distinct
Python Django
1 vote172 views2 answers
No changes detected in app django
Python Django
0 vote163 views1 answer
Django filter values with e and operator
Python Django
0 vote185 views2 answers
MultiValueDictKeyError django
Python Django
1 vote167 views2 answers
Django class based views
Python Django
1 vote171 views1 answer
Django filter after annotate
Python Django
1 vote177 views1 answer
Django link home page
Python Django
0 vote159 views1 answer
Django queryset all objects
Python Django