My model structure is like this:
class Group(models.Model):
u_id = models.ForeignKey(User)
group_name = models.CharField(max_length=50,unique=True)
def __str__(self): # __unicode__ on Python 2
return self.group_name + " " + self.org_nam
class Members(models.Model):
group_id = models.ForeignKey(Group)
name = models.CharField(max_length=60)
def __str__(self): # __unicode__ on Python 2
return self.name + " " + self.gender
class Ratings(models.Model):
member_id = models.ForeignKey(Members)
question = models.ForeignKey(Questions)
rating =
models.DecimalField(max_digits=20,decimal_places=2,null=True,blank=True)
class GroupQn(models.Model):
group_id = models.ForeignKey(Group)
qn_id = models.ForeignKey(Questions)
*I want calculate maximum rating member for each question of a particular
group:*
*What I have tried:*
def top_ratings(group_id):
group = get_object_or_404(Group, pk=group_id)
members = Members.objects.filter(group_id=group)
questionset = GroupQn.objects.filter(group_id=group)
top_rated_list = []
for i in questionset:
max_rating =
Ratings.objects.filter(question=i.qn_id,member_id=members).aggregate(Max('rating'))['rating__max']
top_rated_list = Ratings.objects.get(rating = max_rating)
return top_rated_list
*i am getting an error:*
*"*MultipleObjectsReturned at /group/2 get() returned more than one Ratings
-- it returned 2! Request Method: GET Request URL: 127.0.0.1:8000/group/2
Django
Version: 1.7.5 Exception Type: MultipleObjectsReturned Exception Value:
get() returned more than one Ratings -- it returned 2! – *"*
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/c8da7f1c-4f43-4d06-8ca2-a6b37c2a0776%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
