[Koha] New SQL Report - Patron without image

Cab Vinton bibliwho at gmail.com
Tue Jun 11 05:23:02 NZST 2013


Patron without image
Developer: Md. Zahid Hossain Shoeb, Independent University, Bangladesh (IUB)
Module: Patrons
Purpose: To list the patrons whose images have not been uploaded.

SELECT cardnumber, surname, firstname
FROM borrowers
WHERE cardnumber
NOT IN (SELECT cardnumber FROM patronimage)


More information about the Koha mailing list