Hi,
I apologize for the lousy title, but I really didn't know how to summarize
the problem I'm facing. I have the following model:
class MessierMarathon(models.Model):
messier_number = models.IntegerField()
image = models.ForeignKey(Image)
nominations = models.IntegerField(default = 0)
nominators = models.ManyToManyField(User, null=True)
def __unicode__(self):
return 'M %i' % self.messier_number
class Meta:
unique_together = ('messier_number', 'image')
ordering = ('messier_number', 'nominations')
A typical content for this model would be:
Image A: 5 nominations for messier_number 1
Image B: 4 nominations for messier_number 1
Image C: 6 nominations for messier_number 2
...and so on.
I would like to formulate a query that returns me one image for each
messier_number, picking the one with the most nominations. So, in the
previous example, the query would return images A and C. The image B would
not be returned because image A has more nominations for messier_number 1.
The images returned must be sorted by messier_number, and of course may
repeat. (An image might contain more that one Messier object, and get
highest nomination counts for both).
Can anybody please help with this?
Thanks in advance,
Salvatore.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/django-users/-/GB-T19nk21cJ.
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.
