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
-~----------~----~----~----~------~----~------~--~---
