How to do many-to-many Django query to find book with 2 given authors?

by

Not intuitive at first but the answer is right in front of us.

Book.objects.filter(author__id=1).filter(author__id=2)

If you want an exact match, you could potentially further filter this result by those items that only have exactly 2 authors.

Book.objects.annotate(count=Count('author')).filter(author__id=1)\
                .filter(author__id=13).filter(count=2)

If you want exact matches dynamically, how about something like this?:

def get_exact_match(model_class, m2m_field, ids):
    query = model_class.objects.annotate(count=Count(m2m_field))\
                .filter(count=len(ids))
    for _id in ids:
        query = query.filter(**{m2m_field: _id})
    return query

matches = get_exact_match(MyModel, 'my_m2m_field', [1, 2, 3, 4])

# matches is still an unevaluated queryset, so you could run more filters
# without hitting the database.

More Related Contents:

  1. What is related_name used for?
  2. Django filter queryset __in for *every* item in list
  3. How do I access the child classes of an object in django without knowing the name of the child class?
  4. How can I filter a date of a DateTimeField in Django?
  5. How can I filter a Django query with a list of values?
  6. Getting the SQL from a Django QuerySet [duplicate]
  7. How do I do a not equal in Django queryset filtering?
  8. Django Query That Get Most Recent Objects From Different Categories
  9. How do I get the object if it exists, or None if it does not exist in Django?
  10. Django orm get latest for each group
  11. django – convert a list back to a queryset [duplicate]
  12. Django values_list vs values
  13. many-to-many in list display django
  14. Django Many-to-Many (m2m) Relation to same model
  15. How to combine multiple querysets in Django?
  16. “_set” in a queryset object in Django
  17. Count number of records by date in Django
  18. aggregate() vs annotate() in Django
  19. Count() vs len() on a Django QuerySet
  20. How to perform OR condition in django queryset?
  21. Simple Subquery with OuterRef
  22. QuerySet, Object has no attribute id – Django
  23. Django custom annotation function
  24. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  25. Get the latest record with filter in Django
  26. django filter on the basis of text length
  27. Generic many-to-many relationships
  28. Django filter JSONField list of dicts
  29. How to annotate Count with a condition in a Django queryset
  30. Can a dictionary be passed to django models on create?

Leave a Comment