[Koha] [Koha-devel] sql query / number of items

MJ Ray mjr at phonecoop.coop
Sat Jan 19 06:01:59 NZDT 2013


Samuel Desseaux <samuel.desseaux at ecp.fr>
> I need to write a sql query to count the number of 995 field in the 
> records which i 've imported.
> 
> An idea?

Firstly, this is a use query, not a development one, so should be
sent to koha at lists.katipo.co.nz and not koha-devel.

Secondly, it's probably quite similar to
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicate_bibs_using_the_001
but using 995 instead of 001 and count(...) somewhere.

Hope that helps,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op.
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/


More information about the Koha mailing list