Hi Lisa,
I think you should replace biblioitems.publicationyear with biblio.copyrightdate to get the date of publication. Nora ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: [email protected] AIM: noraatmls From: [email protected] [mailto:[email protected]] On Behalf Of Peel Lisa Sent: Thursday, June 02, 2011 10:10 AM To: 'Liz Rea' Cc: '[email protected]' Subject: Re: [Koha] Help with report - again! Hi Liz Thanks for the quick reply but there is still no data in the publication year column is this something we have done wrong when cataloguing? There is definitely data in the 260c field in the majority of our records. Regards Lisa From: Liz Rea [mailto:[email protected]] Sent: 02 June 2011 16:03 To: Peel Lisa Cc: koha list Subject: Re: [Koha] Help with report - again! On Jun 2, 2011, at 8:45 AM, Peel Lisa wrote: 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 <image001.jpg> 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/> _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc notes: Paste this into the reports "Create from SQL" section, and run from there. you'll want to put in your branch code for 'yourbranch' Set the limit to something above the maximum number of records you expect. Hope this helps! Liz Rea [email protected]
<<image001.jpg>>
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
