[Koha-bugs] [Bug 25079] Show club enrollment question answers in staff client

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079

--- Comment #1 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
This report gets that data one might want. It's not a pretty or fun report:
SELECT borrowernumber, surname, firstname, club_id, clubs.name,
club_template_enrollment_fields.name, club_enrollment_fields.value
FROM club_enrollment_fields
LEFT JOIN club_enrollments on
(club_enrollment_fields.club_enrollment_id=club_enrollments.id)
LEFT JOIN borrowers using (borrowernumber)
LEFT JOIN clubs on (club_enrollments.club_id=clubs.id)
LEFT JOIN club_template_enrollment_fields on
(club_enrollment_fields.club_template_enrollment_field_id=club_template_enrollment_fields.id)
WHERE clubs.id=<<Club ID>> and club_enrollments.date_canceled is null

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.