Django ManyToMany filter()

by

Just restating what Tomasz said.

There are many examples of FOO__in=... style filters in the many-to-many and many-to-one tests. Here is syntax for your specific problem:

users_in_1zone = User.objects.filter(zones__id=<id1>)
# same thing but using in
users_in_1zone = User.objects.filter(zones__in=[<id1>])

# filtering on a few zones, by id
users_in_zones = User.objects.filter(zones__in=[<id1>, <id2>, <id3>])
# and by zone object (object gets converted to pk under the covers)
users_in_zones = User.objects.filter(zones__in=[zone1, zone2, zone3])

The double underscore (__) syntax is used all over the place when working with querysets.

More Related Contents:

  1. When saving, how can you check if a field has changed?
  2. Django: How can I protect against concurrent modification of database entries
  3. How to express a One-To-Many relationship in Django?
  4. Get model’s fields in Django
  5. Can django’s auth_user.username be varchar(75)? How could that be done?
  6. Override default queryset in Django admin
  7. Setting the selected value on a Django forms.ChoiceField
  8. Custom QuerySet and Manager without breaking DRY?
  9. Django: Query using contains each value in a list
  10. How can I have two foreign keys to the same model in Django?
  11. How do you serialize a model instance in Django?
  12. Django migrate –fake and –fake-initial explained
  13. How to make email field unique in model User from contrib.auth in Django
  14. Why does django’s prefetch_related() only work with all() and not filter()?
  15. Select DISTINCT individual columns in django?
  16. Django ModelForm override widget
  17. Django – how to specify a database for a model?
  18. “Post Image data using POSTMAN”
  19. How to add data into ManyToMany field?
  20. Raw SQL queries in Django views
  21. Django model: delete() not triggered
  22. Django – filtering on foreign key properties
  23. Django unique_together with nullable ForeignKey
  24. Django Order By Date, but have “None” at end?
  25. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  26. Password field in Django model
  27. Creating Partial Indexes with Django 1.7
  28. Django: dynamic database file
  29. conversion of datetime Field to string in django queryset.values_list()
  30. Django Rest framework, how to include ‘__all__’ fields and a related field in ModelSerializer ?

Leave a Comment