/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

8 votes369 views2 answers
What does class meta do in django
Python Django
1 vote381 views1 answer
Django foreign key error Cannot assign must be a instance
Python Django
2 votes332 views1 answer
Postgres django settings
Python Django
0 vote352 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python Django
0 vote347 views1 answer
Django table view sort filter
Python Django
0 vote372 views2 answers
Django render template
Python Django
3 votes344 views1 answer
Csrf token exempt django
Python Django
0 vote351 views1 answer
How to store a int value in django sessions
Python Django
2 votes328 views2 answers
How to check django rest framework version
Python Django
0 vote383 views1 answer
Django data from many to many field in template
Python Django