Django queryset get exact manytomany lookup [duplicate]

by

One approach is to use chain of filters:

node_query = Node.objects.all()
pk_list = [10, 6, 3]

for pk in pk_list:
    node_query = node_query.filter(tags=pk)

Now node_query will match node, that has at least three tags with pk 10, 6, 3. To exact matching of three tags:

UPDATE:
Thanks to @janos and @Adrián López, the correct answer is:

from django.db.models import Count

pk_list = [10, 6, 3]
node_query = Node.objects.annotate(count=Count('tags')).filter(count=len(pk_list))

for pk in pk_list:
    node_query = node_query.filter(tags__pk=pk)

More Related Contents:

  1. Why does django’s prefetch_related() only work with all() and not filter()?
  2. Select DISTINCT individual columns in django?
  3. Django: implementing JOIN using Django ORM?
  4. Django: ManyToMany filter matching on ALL items in a list
  5. How do I do an OR filter in a Django query?
  6. Django Aggregation: Summation of Multiplication of two fields
  7. Issue with ManyToMany Relationships not updating immediately after save
  8. How to filter empty or NULL names in a QuerySet?
  9. How to view corresponding SQL query of the Django ORM’s queryset?
  10. Custom QuerySet and Manager without breaking DRY?
  11. _set in Django for a queryset
  12. Raw SQL queries in Django views
  13. How to limit queryset/the records to view in Django admin site?
  14. django-orm case-insensitive order by
  15. Django – filtering on foreign key properties
  16. How to create a Django queryset filter comparing two date fields in the same model
  17. How to perform OR condition in django queryset?
  18. How to query Case-insensitive data in Django ORM?
  19. Django Queryset with filtering on reverse foreign key
  20. Default image for ImageField in Django’s ORM
  21. How to dynamically provide lookup field name in Django query? [duplicate]
  22. Django lazy QuerySet and pagination
  23. Django ORM: Group by and Max
  24. Django query datetime for objects older than 5 hours
  25. Django, query filtering from model method
  26. Django: Does prefetch_related() follow reverse relationship lookup?
  27. django most efficient way to count same field values in a query
  28. Django Order By Date, but have “None” at end?
  29. Django: __in query lookup doesn’t maintain the order in queryset
  30. how to write a query to get find value in a json field in django

Leave a Comment