[Koha] ebook report

[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’,
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 at hmcpl.org

> On Mar 19, 2018, at 1:55 AM, Katrin Fischer <katrin.fischer.83 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha