Re: [Koha] Creating a Report to List Books published with a Date Range

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