[Koha] ebook report

[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 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
>
>
>