[Koha-devel] Deleting patrons

[Cab Vinton]

Thanks, Chris.

So, correct to say that a report like the one below would not be
affected by patrons deleted via Koha?

Checkouts by Item Type
SELECT items.itype AS Collection, COUNT( statistics.itemnumber ) AS Count
FROM statistics
LEFT JOIN items ON (statistics.itemnumber = items.itemnumber)
WHERE date(statistics.datetime) between '2009-01-01' and '2009-12-31'
AND statistics.type IN ('issue','renew')
GROUP BY items.itype

(Hmm ... in looking at this, maybe it needs to be revised to take into
account deleted items?)

Cheers,

Cab Vinton, Director
Sanbornton Public Library
Sanbornton, NH


> And this time with an actual useful reply. If you delete them via Koha you
> will be fine. They end up in the deletedborrowers table which you can query
> over, using a join or union. If you delete them in the db, then that info is
> gone.
>
> Statistics will still be in the statistics table but you will no longer be
> able to find the borrower with your query to get things like categorycode
> etc.
>