[Koha] SQL Report Update

Cab Vinton bibliwho at gmail.com
Wed May 22 01:51:05 NZST 2013


* Report edited so that it now works :-)

Non Circulating Items
Developer: Nicole C. Engard, ByWater Solutions
Module: Circulation
Purpose: List items that have never circulated
Status: Complete

SELECT b.title, b.author, i.barcode, i.itemcallnumber
FROM items i
LEFT JOIN biblio b USING (biblionumber)
WHERE i.itemnumber NOT IN (SELECT itemnumber FROM issues WHERE
itemnumber IS NOT NULL)
              AND i.itemnumber NOT IN (SELECT itemnumber FROM
old_issues WHERE itemnumber IS NOT NULL)


More information about the Koha mailing list