[Koha] Help with report - again!

[Hal Bright]

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: koha-bounces at lists.katipo.co.nz [koha-bounces at lists.katipo.co.nz] on behalf of Peel Lisa [lisa.peel at ritz.edu]
Sent: Thursday, June 02, 2011 9:45 AM
To: 'koha at lists.katipo.co.nz'
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: lisa.peel at ritz.edu<mailto:hortense.hofer at ritz.edu>
http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/a3c5713e/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: image001.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/a3c5713e/attachment-0001.jpg