Will try this query on this list as the main Koha list drew a blank ... Are there any issues related to deleting patrons that one should be aware of? I'm thinking particular of the "usual" circulation and & statistical reports that libraries run for annual reports, etc. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH
On 4 Apr 2011 07:45, "Cab Vinton" <bibliwho@gmail.com> wrote:
Will try this query on this list as the main Koha list drew a blank ...
Are there any issues related to deleting patrons that one should be aware
of?
I'm thinking particular of the "usual" circulation and & statistical reports that libraries run for annual reports, etc.
Yep just the usual you can't report on what doesn't exist issues. Chris
Thank you,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
On 4 Apr 2011 07:45, "Cab Vinton" <bibliwho@gmail.com> wrote:
Will try this query on this list as the main Koha list drew a blank ...
Are there any issues related to deleting patrons that one should be aware
of?
I'm thinking particular of the "usual" circulation and & statistical reports that libraries run for annual reports, etc.
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. Chris
Thank you,
Cab Vinton, Director Sanbornton Public Library Sanbornton, NH _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
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.
On 4 April 2011 08:28, Cab Vinton <bibliwho@gmail.com> wrote:
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
Nope, that would work just fine, as no join to borrowers.
(Hmm ... in looking at this, maybe it needs to be revised to take into account deleted items?)
Well the left join with items, will mean you will get null rows so one of your groups will be null (grouping by items.itype). If you want to know the actual itemtypes then yeah, you will need to do a union of items and deleteditems and join to that Chris
participants (2)
-
Cab Vinton -
Chris Cormack