i have 2 models, event , suggestedname. suggestedname has foreignkey relationship event integerfield called 'votes'. want top 5 suggestednames associated event.
my models:
class event(models.model): def __unicode__(self): return unicode(self.id) id = models.bigintegerfield(blank = 'true', primary_key='true') version = models.integerfield(default = 0) views = models.integerfield(default = 0) created = models.datetimefield(editable = false) modified = models.datetimefield() trained = models.booleanfield(default = false) type = models.smallintegerfield(default = 0) class suggestedname(models.model): def __unicode__(self): return self.name name = models.charfield(max_length=200, blank = 'true', null = 'true') votes = models.integerfield(default = 0) event = models.foreignkey(event) what have in view this:
e = event.objects.get(pk=event_id) suggestedn = e.suggestedname_set.order_by('votes')[:5].reverse() but i'm not getting results.
try:
e.suggestedname_set.order_by('-votes')[:5] or specify related name
class suggestedname(models.model): def __unicode__(self): return self.name name = models.charfield(max_length=200, blank = true, null = true) votes = models.integerfield(default = 0) event = models.foreignkey(event, related_name='suggestions') and then,
e.suggestions.order_by('-votes')[:5]
Comments
Post a Comment