/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 vote192 views1 answer
Slug in redirect django
Python Django
2 votes220 views1 answer
Pass in queryset as filter django
Python Django
4 votes205 views3 answers
No such table: django_session
Python Django
1 vote220 views3 answers
Value list in django
Python Django
0 vote198 views2 answers
How to JOIN three tables with Django ORM
Python Django
0 vote196 views1 answer
Django querset group by sum
Python Django
0 vote205 views1 answer
How to customize simplejwt error response message in django restframework
Python Django
-1 vote218 views2 answers
How to url encode using python django
Python Django
0 vote198 views1 answer
How to save multiple choices in django site:stackoverflow.com
Python Django
0 vote208 views1 answer
Setting up a django prostgress project
Python Django