I use biblio.copyrightdate in SQL This is a modifed Super Weeder from the blog. It's great in a downloadable Excel report!
SELECT CONCAT( '<a href=\"/cgi-bin/koha/cataloguing/additem.pl?biblionumber=',biblio.biblionumber, '\">',items.barcode,'</a>' ) AS 'Barcode',items.barcode,items.itemcallnumber,biblio.title,biblio.author,biblio.copyrightdate AS 'Copyright',items.dateaccessioned AS 'Accessioned',items.itype,items.issues,items.itemnumber,items.renewals,(IFNULL(items.issues,0)+IFNULL(items.renewals,0)) AS Total_Circ,items.datelastborrowed,items.itemlost,items.onloan,items.damaged,items.itemnotes,items.holdingbranch FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.holdingbranch='FARMINGTON' ORDER BY items.itemcallnumber Use these parameters in the WHERE (in red) conneced with AND items.holdingbranch='FARMINGTON' items.itemcallnumber LIKE 'FAST %' items.itype='BOOK' items.ccode='ADULT' Hal Bright Farmington Libraies ________________________________ From: [email protected] [[email protected]] on behalf of Peel Lisa [[email protected]] Sent: Thursday, June 02, 2011 9:45 AM To: '[email protected]' Subject: [Koha] Help with report - again! Hello I need to create a list which will give me details of all the items at one library including the year of publication. Have tried adding publication year to the guided search but no data appears in the column. Apologies for making such a basic request but I have been asked for the report to be done urgently! Any help appreciated Regards Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: [email protected]<mailto:[email protected]> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
<<inline: image001.jpg>>
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
