Excerpts from David Sale's message of 2020-07-31 19:12:13 +:
> However, adding "b.isbn" to the SELECT list (as with "b.title", "b.author",
> etc.) breaks the report and renders it non-functional.
You might find this page useful, since it does provide some isbn examples:
https://wiki.koha-com
The ISBN is in the biblioitems table. Change b.isbn to bi.isbn and add
LEFT JOIN biblionitems bi USING (biblionumber) before the line that
starts with WHERE.
On 7/31/20 2:12 PM, David Sale wrote:
Hello,
Our library is engaged in a weeding project that requires a SQL report for Koha
to be cu
Hello,
Our library is engaged in a weeding project that requires a SQL report for Koha
to be customized.
The report we are attempting to customize was written by ByWater Solutions, and
it generates a list of items "not seen" in X years, by branch and shelf
location.
The existing report is wri
3 matches
Mail list logo