Hi Lisa, Try the "copyrightdate" column in the "biblio" table.
Bev * * * * Beverly Church LibLime Project Manager phone: 1-301-654-8088 ext. 292 email: [email protected] skype: beverlychurch 2011/6/2 Peel Lisa <[email protected]> > 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] <[email protected]>* > > http://www.ritz.edu - 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] > > > > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > >
<<image001.jpg>>
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
