From bf2472b1ec9bbdbbb30bf5d2457c4b7862cfd6ad Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Mon, 19 Nov 2018 15:01:15 +0100 Subject: [PATCH] Include has_slides data in sessionlist as well Not just in the schedule. --- postgresqleu/confreg/views.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/postgresqleu/confreg/views.py b/postgresqleu/confreg/views.py index d4678f2..d8ab310 100644 --- a/postgresqleu/confreg/views.py +++ b/postgresqleu/confreg/views.py @@ -1058,7 +1058,10 @@ def sessionlist(request, confname): if not conference.testers.filter(pk=request.user.id): return render_conference_response(request, conference, 'sessions', 'confreg/sessionsclosed.html') - sessions = ConferenceSession.objects.filter(conference=conference).filter(cross_schedule=False).filter(status=1).order_by('track__sortkey', 'track', 'title') + sessions = ConferenceSession.objects.filter(conference=conference).extra(select={ + 'has_slides': 'EXISTS (SELECT 1 FROM confreg_conferencesessionslides WHERE session_id=confreg_conferencesession.id)', + }).filter(cross_schedule=False).filter(status=1).order_by('track__sortkey', 'track', 'title') + return render_conference_response(request, conference, 'sessions', 'confreg/sessionlist.html', { 'sessions': sessions, }) -- 2.39.5