On 2019-04-29 6:44 a.m., Njideaka Tobechukwu wrote:
Hi All,
Please, I am trying to create a report of my KOHA database to list books
published within 2016-2019, in a tabular form having just the book title,
author, and date of publication. However, I do not know how to go about
creating this report.
SELECT b.title, b.author, b.copyrightdate
FROM biblio b
WHERE b.copyrightdate BETWEEN '2016' AND '2019';
Note: this simplistically relies on "copyrightdate" 260$c, which Koha
defines as "publication or copyright date from the MARC record".
Best -- Paul
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
