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
