On 2/8/08, coldpizza <[EMAIL PROTECTED]> wrote: > Given that I have a Book model with a ManyToManyField called authors > how do I get all the books for a particular author? Each book may have > more than one author, so I cannot filter the books using the standard > methods.
You'll want to more closely read the documentation on related object lookups: http://www.djangoproject.com/documentation/db-api/#related-objects. The short version, though, is this: Given a author ID, to find all the books by that author you'd use:: Book.objects.filter(authors__pk=author_id) Or, given a particular author object:: author.book_set.all() (Where did "book_set" come from? It's automatically created on the "other side" of the many-to-many relation you created from Book to Author. You can change the name of that relation attribute using the "related_name" option to ManyToManyField). Jacob PS: Also see Chapter 5 of the Django Book (http://djangobook.com/en/1.0/chapter05/); it's got examples pretty similar to what you're doing. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
