There were all kinds of problems with that edited report - here's the
one that worked:
SELECT branchcode, categorycode, COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <>
AND <> and branchcode = <>
GROUP BY branchcode, categorycode ORDER BY branchcode
Field names got a bit messed u
From: Jared Camins-Esakov [jcam...@cpbibliography.com]
Sent: Saturday, June 09, 2012 4:55 PM
To: James Ghiorzi
Cc: koha@lists.katipo.co.nz; neng...@bywatersolutions.com
Subject: Re: [Koha] Help with sql statement.
James,
I am trying to get the new patron report develop
This should work:
SELECT b.code,c.code,COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <>
AND <> and b.code = <>
GROUP BY c.code
On Sat, Jun 9, 2012 at 7:55 PM, Jared Camins-Esakov
wrote:
> James,
>
>
> I am trying to get the new patron report developed by Sharon Moreland, to
>>
James Ghiorzi
Data Management Coordinator
Martin Luther King Jr. Library
San Jose State University
From: Jared Camins-Esakov [jcam...@cpbibliography.com]
Sent: Saturday, June 09, 2012 4:55 PM
To: James Ghiorzi
Cc: koha@lists.katipo.co.nz; neng...@bywatersolutions.com
This should work:
SELECT b.code,c.code,COUNT(*)
FROM borrowers WHERE DATE(dateenrolled) between <>
AND <> and b.code = <>
GROUP BY c.code
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listi
James,
I am trying to get the new patron report developed by Sharon Moreland, to
> do a date range and have a location selection for San Benito County Free
> Library. I am sure I am doing something wrong, please advise as necessary,
>
> SQL:
>
> SELECT b.code,c.code,COUNT(*)
> FROM borrowers WHE
6 matches
Mail list logo
