[Koha] Help with report - again!

[Liz Rea]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/277a94ff/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email_signature.jpeg
Type: image/jpeg
Size: 4862 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110602/277a94ff/attachment.jpeg