Re: [Koha] ebook report

2018-03-19 Thread Martha Fuerst
I cobbled together something quickly by Frankensteining some of our other digital resources reports. We use a different item type for ebooks and downloadable audio, so if you do the same, that would be a way to aggregate them. SELECT bi.biblioitemnumber as 'Item Number’, bi.isbn as 'ISBN’, publ

Re: [Koha] ebook report

2018-03-18 Thread Katrin Fischer
Hi Amy, can you share what you have so far? I haven't tested, but you could try something like: WHERE biblioitems.isbn is NOT NULL and biblioitems.isbn != "" Hope this helps, Katrin On 16.03.2018 21:32, Amy Schuler wrote: Hello, does anyone have an ebook report they are willing to share? I