Re: [Koha-devel] Deleting patrons

2011-04-03 Thread Chris Cormack
On 4 April 2011 08:28, Cab Vinton 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 JOI

Re: [Koha-devel] Deleting patrons

2011-04-03 Thread 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) WHER

Re: [Koha-devel] Deleting patrons

2011-04-03 Thread Chris Cormack
On 4 Apr 2011 07:45, "Cab Vinton" 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 r

Re: [Koha-devel] Deleting patrons

2011-04-03 Thread Chris Cormack
On 4 Apr 2011 07:45, "Cab Vinton" 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 r

[Koha-devel] Deleting patrons

2011-04-03 Thread Cab Vinton
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, D