[Koha] Course Reserve information from customized report

[Caroline Cyr La Rose]

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 (peter.lau at yccece.edu.hk) 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: peter.lau at yccece.edu.hk
<library at yccece.edu.hk> | 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
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha