On Tue, Mar 10, 2009 at 11:35 AM, Chris McCormick <ch...@mccormick.cx>wrote:
>
> Hi,
>
> I want to do something like:
>
> Thing.objects.all().order_by("otherthing__count")
>
> So there's a many-to-many between Thing and Otherthing, and I want to get a
> list of Things in the order of most-otherthings joined - is there some
> easy,
> Djangoish way to do it, or should I create a new field in Thing which holds
> the
> number of Otherthings it's joined to?
>
> Chris.
>
> -------------------
> http://mccormick.cx
>
> >
>
This is possible with aggregation support in the Django development
version/1.1 alpha and it looks like:
Thing.objects.annotate(num_other=Count('other_thing')).order_by('num_other')
Alex
--
"I disapprove of what you say, but I will defend to the death your right to
say it." --Voltaire
"The people's good is the highest law."--Cicero
--~--~---------~--~----~------------~-------~--~----~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
