[Koha] Help with report - again!

[Church, Beverly]

Hi Lisa,

Try the "copyrightdate" column in the "biblio" table.

 Bev

* * * *
Beverly Church
LibLime Project Manager

phone: 1-301-654-8088 ext. 292
email: bchurch at liblime.com
skype: beverlychurch


2011/6/2 Peel Lisa <lisa.peel at ritz.edu>

>  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:lrea at nekls.org]
> *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: *lisa.peel at ritz.edu <hortense.hofer at ritz.edu>*
>
> http://www.ritz.edu - http://www.culinaryarts.ch
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> 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
> lrea at nekls.org
>
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/7d1ba13d/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4862 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/7d1ba13d/attachment.jpeg