I'm not able to use anything over Django 1.0.2. Does SUM work for this version, I'm getting the error:
Could not import #####.views. Error was: cannot import name Sum Is there another way around this? Thanks for your time and energy guys, d On Jul 21, 12:22 am, Andrew Fong <fongand...@gmail.com> wrote: > The relevant documentation btw: > > http://docs.djangoproject.com/en/dev/topics/db/aggregation/http://docs.djangoproject.com/en/dev/topics/db/queries/#lookups-that-... > > On Jul 20, 10:18 am, Andrew Fong <fongand...@gmail.com> wrote: > > > > > Assuming your models are like this: > > > class Book(models.Model): > > name = models.CharField(max_length=128) > > > class User(models.Model): > > is_staff = models.BooleanField(default=False) > > > class Rating(models.Model): > > user = models.ForeignKey(User) > > score = models.IntegerField(default=3) > > book = models.ForeignKey(Book) > > > Try this: > > > from django.db.models import Sum > > Book.objects.filter(rating__user__is_staff=True).annotate(score=Sum > > ('rating__score')).order_by('-score')[0:10] > > > -- Andrew > > > On Jul 20, 9:22 am, The Danny Bos <danny...@gmail.com> wrote: > > > > Hey there, > > > > I'm looking at getting a Top 10 of all Books on a site, but only where > > > rated by users of a certain Group. > > > Here's what I've got so far: > > > > book = Book.objects.all() > > > > Somewhat impressive, hey? > > > > - So, my tables/models are Book, Rating, User. > > > - I save all ratings in Rating like so "rating | user | book" > > > - I'd just like the Top 10 as rated by users in the group "Staff". > > > > Hope that helps, > > > I'm really stuck on how to get this moving. > > > > d --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
