Dear Caroline,
Great it works. May I know where I can find a list of dictionary or fields for the SQL? Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: [email protected] | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ] 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk *From:* Caroline Cyr La Rose [mailto:[email protected]] *Sent:* Sunday, 20 January 2019 3:49 AM *To:* koha list <[email protected]>; Peter Lau < [email protected]> *Subject:* Re: [Koha] Course Reserve information from customized report Hi Peter, Try this SELECT courses.course_number AS "Course code", courses.course_name AS "Course", CONCAT(borrowers.surname, ', ', borrowers.firstname, ' (', borrowers.cardnumber, ')') AS "Course teacher", biblio.title AS "Title", biblio.author AS "Author", biblioitems.isbn AS "ISBN", items.itype AS "Item type", items.itemcallnumber AS "Item callnumber", items.barcode AS "Item barcode" FROM course_items LEFT JOIN items USING (itemnumber) LEFT JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN course_reserves USING (ci_id) LEFT JOIN courses USING (course_id) LEFT JOIN course_instructors USING (course_id) LEFT JOIN borrowers USING (borrowernumber) Adapted from https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_course_reserve_items -- Caroline Cyr La Rose, M.L.I.S Librarian | Product Manager, inLibro Le 19 janvier 2019 à 01:19:40, Peter Lau ([email protected]) a écrit: I would like to draw a list of all items cataloged under Course Reserve including the Course Code, Course teacher (if input), Bib title, Bib author, ISBN etc. I don't know how to draw them easily from the report function. Thanks and regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: [email protected] <[email protected]> | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
