Very confused... problem using 'annotate' in Django

django sorting annotate
Daniel Waltrip picture Daniel Waltrip · Aug 2, 2009 · Viewed 9.7k times · Source

So I have two models, a Ranking model and a UserRanking model. The app centers on people taking a list of items and ranking them (ex: "Best Movies of 2008"). The Ranking model is the overall aggregate ranked list, which is calculated from all the different UserRankings that people create for that list. So for each Ranking, there are a bunch of different UserRankings, exactly one for each user that gave his/her opinion by submitting their ranked version of the list. The UserRanking model has a ForeignKey field named 'ranking' which points towards the Ranking model.

Anyways, I am trying to gather the popular Rankings. My first step is to get the Rankings with most UserRankings associated to them using this line of code:

popular = Ranking.objects.all().annotate(num_user_rankings=Count('userranking')).order_by('num_user_rankings')[:50]

However, Django gives me a NameError and says: "global name 'Count' is not defined". It doesn't complain about annotate (which is only available in the Django Development version), so that means the Django Development is working right? 'Count' is clearly described in the Django docs as one of several Aggregate functions that can used as arg for annotate. This makes absolutely no sense.

In fact, I just tested it, and I was able to get my page to display using annotate with no paramaters, and it didn't give me any errors (obviously I removed the order_by as well). So annotate does work for sure!

Answer

Meredith L. Patterson picture Meredith L. Patterson · Aug 2, 2009

Did you import Count from django.db.models?

from django.db.models import Count

Related questions

django order_by query set, ascending and descending

How can I order by descending my query set in django by date? Reserved.objects.all().filter(client=client_id).order_by('check_in') I just want to filter from descending all the Reserved by check_in date.

Read More
django - convert a list back to a queryset

I have a handful of records that I would like to sort based on a computed value. Got the answer over here... like so: sorted(Profile.objects.all(), key=lambda p: p.reputation) on a Profile class like this: class …

Read More
Django admin: how to sort by one of the custom list_display fields that has no database field

# admin.py class CustomerAdmin(admin.ModelAdmin): list_display = ('foo', 'number_of_orders') # models.py class Order(models.Model): bar = models.CharField[...] customer = models.ForeignKey(Customer) class Customer(models.Model): foo = models.CharField[...] def number_of_orders(self): return u'%s' % …

Read More