["python","django","django-models","django-views","reverse-foreign-key"]
Django reverse lookup of foreign keys

I have a venue, this venue has many events happening there. My models look like this: class Venue(models.Model): title = models.CharField(max_length=200) date_published = models.DateTimeField('published date',default=datetime.now, blank=True) venue_latitude = models.CharField(max_length=200) venue_longitude = models.CharField(max_length=200) venue_address = models.CharField(max_length=200) venue_city = models.CharField(max_length=200) venue_state = models.CharField(max_length=200) venue_country = models.CharField(max_length=200) description = models.TextField() def __unicode__(self): return u'%s' % (self.title) class Event(models.Model): title = models.CharField(max_length=200) date_published = models.DateTimeField('published date',default=datetime.now, blank=True) date_start = models.DateTimeField('start date') date_end = models.DateTimeField('end date') def __unicode__(self): return self.title description = models.TextField() price = models.IntegerField(null=True, blank=True) venue = models.ForeignKey(Venue) I'd like to display all the events that are happening at a certain venue. How can I do that? My current view looks like: def detail(request, venue_id): venue = get_object_or_404(Venue, pk=venue_id) return render(request, 'venue-detail.html', {'venue': venue})
You can use events = venue.event_set to go the other way. Note that venue.event_set is a manager object, like Event.objects, so you can call .all, .filter, .exclude and similar on it to get a queryset. See the Django documentation