Re: [Koha] Course Reserve information from customized report

2019-01-20 Thread Peter Lau
upta [mailto:indr...@gmail.com] Sent: Monday, 21 January 2019 9:33 AM To: Peter Lau Cc: koha list Subject: Re: [Koha] Course Reserve information from customized report Hi Peter, Koha's database schema is documented here version wise - http://schema.koha-community.org/ hope this helps Indranil

Re: [Koha] Course Reserve information from customized report

2019-01-20 Thread Indranil Das Gupta
re We Grow Our Future | *www.yccece.edu.hk > > > > *From:* Caroline Cyr La Rose [mailto:caroline.cyr-la-r...@inlibro.com] > *Sent:* Sunday, 20 January 2019 3:49 AM > *To:* koha list ; Peter Lau < > peter@yccece.edu.hk> > *Subject:* Re: [Koha] Course Reserve infor

Re: [Koha] Course Reserve information from customized report

2019-01-20 Thread Peter Lau
list ; Peter Lau < peter@yccece.edu.hk> *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.surn

Re: [Koha] Course Reserve information from customized report

2019-01-19 Thread 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",

[Koha] Course Reserve information from customized report

2019-01-18 Thread Peter Lau
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: