Get all object from Django ForeignKey Field -


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