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’, publicationyear as 'Pub Year’, b.title as 'Title’, b.author as 'Author’, i.dateaccessioned as "Added”, bi.itemtype as 'Type' FROM biblioitems bi LEFT JOIN biblio b USING (biblionumber) LEFT JOIN items i ON (bi.biblioitemnumber = i.itemnumber) WHERE bi.itemtype IN ('EBOOK','AUDIOBOOK') Alternatively, your where statement could be: WHERE bi.isbn IS NOT NULL AND i.barcode IS NULL Happy reporting! Best, Marti Fuerst Systems Librarian Huntsville-Madison County Public Library 915 Monroe St, Huntsville, AL 35801 http://hmcpl.org/ — mfuerst@hmcpl.org
On Mar 19, 2018, at 1:55 AM, Katrin Fischer <katrin.fischer.83@web.de> wrote:
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 need a report that will generate a list (with titles) of all ebooks in my catalog. This means barcode would be null but ISBN would NOT be null. It's the ISBN part that I'm having trouble with in my attempts to build an SQL report. If you can help, I'd appreciate it. I did not find any ebook reports at all in the Koha reports library. Weird?
Thanks! Amy
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha