On Saturday 06 May 2006 12:55, Brian Elliott wrote:
> Is it possible to order a query by a ManyToManyField? For example,
> in the models below, I'd like to select all Entries and order by the
> Author's name. Something to the effect of Entry.objects.all
> ().order_by('authors__name')?
>
> Thanks,
> Brian
>
> class Author(models.Model):
> name = models.CharField(maxlength=50)
> email = models.URLField()
>
> class Entry(models.Model):
> headline = models.CharField(maxlength=255)
> body_text = models.TextField()
> pub_date = models.DateTimeField()
> authors = models.ManyToManyField(Author)
I can't see how this would work -- an entry can have many authors, so
which one do you order by?
The test of whether it can be included as a feature in the Django ORM is
whether you can do it in SQL, and do it in a generic way.
Luke
--
"It is a truth universally acknowledged, that a single man in
possession of a good fortune, must be in want of a wife." (Jane Austen)
Luke Plant || L.Plant.98 (at) cantab.net || http://lukeplant.me.uk/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
