View | Details | Raw Unified | Return to bug 17535
Collapse All | Expand All

(-)a/C4/Reports/Guided.pm (-1 / +1 lines)
Lines 632-637 sub get_saved_reports_base_query { Link Here
632
SELECT s.*, $area_name_sql_snippet, av_g.lib AS groupname, av_sg.lib AS subgroupname,
632
SELECT s.*, $area_name_sql_snippet, av_g.lib AS groupname, av_sg.lib AS subgroupname,
633
b.firstname AS borrowerfirstname, b.surname AS borrowersurname
633
b.firstname AS borrowerfirstname, b.surname AS borrowersurname
634
FROM saved_sql s
634
FROM saved_sql s
635
LEFT JOIN saved_reports r ON r.report_id = s.id
635
LEFT OUTER JOIN authorised_values av_g ON (av_g.category = 'REPORT_GROUP' AND av_g.authorised_value = s.report_group)
636
LEFT OUTER JOIN authorised_values av_g ON (av_g.category = 'REPORT_GROUP' AND av_g.authorised_value = s.report_group)
636
LEFT OUTER JOIN authorised_values av_sg ON (av_sg.category = 'REPORT_SUBGROUP' AND av_sg.lib_opac = s.report_group AND av_sg.authorised_value = s.report_subgroup)
637
LEFT OUTER JOIN authorised_values av_sg ON (av_sg.category = 'REPORT_SUBGROUP' AND av_sg.lib_opac = s.report_group AND av_sg.authorised_value = s.report_subgroup)
637
LEFT OUTER JOIN borrowers b USING (borrowernumber)
638
LEFT OUTER JOIN borrowers b USING (borrowernumber)
638
- 

Return to bug 17535