[Koha] Help with report - again!

[Nora Blake]

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: nblake at masslibsystem.org
AIM: noraatmls 

 

From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Peel Lisa
Sent: Thursday, June 02, 2011 10:10 AM
To: 'Liz Rea'
Cc: 'koha at lists.katipo.co.nz'
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: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
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

 



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/818cb422/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/818cb422/attachment.jpeg