Creating a report for serials
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. Regards 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@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
Lisa, My list of claims is showing me the branch code. What version of Koha are you using? Nicole 2011/3/15 Peel Lisa <lisa.peel@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.
Regards
Lisa
[image: 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@ritz.edu <hortense.hofer@ritz.edu>*
http://www.ritz.edu - http://www.culinaryarts.ch
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Nicole Still on 3.00 I am afraid ! Lisa From: Nicole Engard [mailto:nengard@gmail.com] Sent: 15 March 2011 20:11 To: Peel Lisa Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Creating a report for serials Lisa, My list of claims is showing me the branch code. What version of Koha are you using? Nicole 2011/3/15 Peel Lisa <lisa.peel@ritz.edu<mailto:lisa.peel@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. Regards 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<tel:%2B41%2024%20482%2082%2082> Fax: +41 24 482 82 80<tel:%2B41%2024%20482%2082%2080> E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@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@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
The latest release is 3.2.5 and 3.2.6 is due in less than 10 days, you might want to consider upgrading :) Nicole On Tue, Mar 15, 2011 at 3:21 PM, Peel Lisa <lisa.peel@ritz.edu> wrote:
Hi Nicole
Still on 3.00 I am afraid !
Lisa
*From:* Nicole Engard [mailto:nengard@gmail.com] *Sent:* 15 March 2011 20:11 *To:* Peel Lisa *Cc:* koha@lists.katipo.co.nz *Subject:* Re: [Koha] Creating a report for serials
Lisa,
My list of claims is showing me the branch code. What version of Koha are you using?
Nicole
2011/3/15 Peel Lisa <lisa.peel@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.
Regards
Lisa
[image: Description: Description: Description: CR_logo_POS_COULEUR b]
* *
* *
*LISA PEEL, PGDip, MA.*
Librarian
César Ritz Colleges Switzerland
1897 Le Bouveret - Switzerland
Tel: <%2B41%2024%20482%2082%2082>+41 24 482 82 82 Fax: <%2B41%2024%20482%2082%2080>+41 24 482 82 80
E-mail: *lisa.peel@ritz.edu <hortense.hofer@ritz.edu>*
http://www.ritz.edu - http://www.culinaryarts.ch
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Nicole Engard -
Peel Lisa