Re: [Koha-devel] Help with SQL report

2009-12-18 Thread Chris Cormack
2009/12/19 Adrea Lund : > Dear Chris, Paul and KOHA devel list, > > Thank you very much for your responses.  Our library is currently using KOHA > version 3.01.00.032., so if you could write a report like I described that > works with version 3.01.00.032, then we don't care right now if it works >

Re: [Koha-devel] Help with SQL report

2009-12-18 Thread Adrea Lund
ext11 - Original Message - From: "Chris Cormack" To: "Adrea Lund" Cc: Sent: Thursday, December 10, 2009 3:52 PM Subject: Re: [Koha-devel] Help with SQL report 2009/12/11 Adrea Lund : > Thank you for all the responses. I should have explained more clearly that &g

Re: [Koha-devel] Help with SQL report

2009-12-11 Thread Paul Poulain
Chris Cormack a écrit : > 2009/12/11 Adrea Lund : > >> I'll try to answer Chris Cormack's question and describe our ideal report - >> >> It would allow you to specify the following variables... >> 1) a specific call number range >> 2) a specific time frame - _ date to _ date >> 3) choose

Re: [Koha-devel] Help with SQL report

2009-12-10 Thread Chris Cormack
2009/12/11 Adrea Lund : > Thank you for all the responses.  I should have explained more clearly that > I know extremely little about mysql - so some of the comments I've gotten > from the lists I sent this to are going right over my head.  But I do > promise that once we have a working report(s),

Re: [Koha-devel] Help with SQL report

2009-11-30 Thread Chris Nighswonger
Hi Adrea, On Mon, Nov 30, 2009 at 4:38 PM, Chris Cormack wrote: > 2009/12/1 Adrea Lund : > > Dear KOHA Users, > > > > > > With the help of Beverly Church at Liblime > Also, be aware that if you are running LEK, some database fields have changed and this will make it difficult for the community t

Re: [Koha-devel] Help with SQL report

2009-11-30 Thread Nicole Engard
Also, if you have working reports remember to share them with your colleagues via the wiki: http://wiki.koha.org/doku.php?id=sql_library Thanks a bunch, Nicole C. Engard Documentation Manager (and designated nagger) On Mon, Nov 30, 2009 at 4:38 PM, Chris Cormack wrote: > 2009/12/1 Adrea Lund : >

Re: [Koha-devel] Help with SQL report

2009-11-30 Thread Chris Cormack
2009/12/1 Adrea Lund : > Dear KOHA Users, > > > With the help of Beverly Church at Liblime (Thank You Beverly!!), our > library is trying to get an SQL report that we can use for weeding our > collections.  We are getting closer to what we want, but we have gotten > stuck – are there any SQL gurus