[Koha] Creating a report for serials

Peel Lisa lisa.peel at ritz.edu
Wed Mar 16 08:21:48 NZDT 2011

Hi Nicole

Still on 3.00 I am afraid !


From: Nicole Engard [mailto:nengard at gmail.com]
Sent: 15 March 2011 20:11
To: Peel Lisa
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Creating a report for serials


My list of claims is showing me the branch code. What version of Koha are you using?

2011/3/15 Peel Lisa <lisa.peel at ritz.edu<mailto:lisa.peel at ritz.edu>>
Hello all

We have had our serials  module live for about 6 months now so I thought it was about time I looked at the Claims – however, it does not tell me which library each subscription is for so it is difficult for me to know which missed/late serials to direct to which library.

Could someone perhaps provide me with the SQL to run a report which will give me the information which Claims gives me but also with the added information of Library (Claims currently gives me Supplier, Title, Issue Number, Status, and Since). I normally try and tweak one of the reports in the SQL Reports Library but I cannot find any for the Serials module.

Thanks in advance.



[Description: Description: Description: CR_logo_POS_COULEUR b]

César Ritz Colleges Switzerland
1897 Le Bouveret - Switzerland
Tel: +41 24 482 82 82<tel:%2B41%2024%20482%2082%2082> Fax: +41 24 482 82 80<tel:%2B41%2024%20482%2082%2080>
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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110315/df8e55bf/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4030 bytes
Desc: image001.jpg
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110315/df8e55bf/attachment.jpg 

More information about the Koha mailing list