[Koha] Help with report - again!

[Peel Lisa]

Hi Beverley and Nora

Thank you, now have the list I need.

Thanks again

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/>



From: Church, Beverly [mailto:bchurch at liblime.com]
Sent: 02 June 2011 16:24
To: Peel Lisa
Cc: Liz Rea; koha at lists.katipo.co.nz
Subject: Re: [Koha] Help with report - again!

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<mailto:bchurch at liblime.com>
skype: beverlychurch

2011/6/2 Peel Lisa <lisa.peel at ritz.edu<mailto: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<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<mailto:hortense.hofer at ritz.edu>
http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto: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<mailto:lrea at nekls.org>

[cid:image003.jpg at 01CC2144.B13E61D0]


_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto: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/49d912ce/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: image002.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/49d912ce/attachment-0002.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 4862 bytes
Desc: image003.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/49d912ce/attachment-0003.jpg