Margie Roginski wrote:
Say I have a Reader model that has a foreign key to a Book
class Reader(models.Model):
book = models.ForeignKey(Book)
Now say I want to find all books and order them by the number of
readers. Is that possible, ie something like this?
Book.objects.all().order_by(reader_set__count)
This syntax doesn't work, however. Is this possible?
Margie
I can't give you specific code but I think that you want is under the
Aggregation section of the documentation. Specifically I think you want
to apply the Count object on the Book reader set. You were almost there. :)
http://docs.djangoproject.com/en/dev/topics/db/aggregation/#topics-db-aggregation
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
