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

[Koha-devel] Help with SQL report

2009-11-30 Thread 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 out there who can help us? Ri