[Koha-bugs] [Bug 21603] New: Remove Group by clause in SearchCourses
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Oct 18 15:44:47 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21603
Bug ID: 21603
Summary: Remove Group by clause in SearchCourses
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Course reserves
Assignee: koha-bugs at lists.koha-community.org
Reporter: nick at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
I am not certain we can simply remove here, but the GROUP by seems to stem form
adding course instructors, though we fetch the instructors for each course
after this query
971 $query .= "
972 LEFT JOIN course_instructors ci
973 ON ( c.course_id = ci.course_id )
974 LEFT JOIN borrowers b
975 ON ( ci.borrowernumber = b.borrowernumber )
976 LEFT JOIN authorised_values av
977 ON ( c.department = av.authorised_value )
978 WHERE
979 ( av.category = 'DEPARTMENT' OR av.category = 'TERM' )
980 AND
981 (
982 department LIKE ? OR
983 course_number LIKE ? OR
984 section LIKE ? OR
985 course_name LIKE ? OR
986 term LIKE ? OR
987 public_note LIKE ? OR
988 CONCAT(surname,' ',firstname) LIKE ? OR
989 CONCAT(firstname,' ',surname) LIKE ? OR
990 lib LIKE ? OR
991 lib_opac LIKE ?
992 )
993 AND
994 c.enabled LIKE ?
995 GROUP BY c.course_id
996 ";
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list