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 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
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
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",
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:
5 matches
Mail list logo