[OPEN-ILS-GENERAL] circulation report

[Rogan Hamby]

Chris's in staff client approach is probably better, especially if you want
to run it regularly and email the results.

Just for the sake for over answering a question however, here is one way to
do it in SQL.  I provide the disclaimer that I am not a SQL guru so someone
else can probably tell you a better way to do it.

select substring(rec.value from 36 for 3), count(circ.id)
from action.circulation circ
join asset.copy copy on copy.id = circ.target_copy
join asset.call_number call on call.id = copy.call_number
join metabib.real_full_rec rec on rec.record = call.record
where date(circ.xact_start) >= '2013-01-01'
and date(circ.xact_start) <= '2013-01-30'
and rec.tag = '008'
group by 1
;



On Tue, Sep 10, 2013 at 4:03 PM, Sharp, Chris
<csharp at georgialibraries.org>wrote:

> Pasi and Päivi,
>
> The MARC fixed-field "Lang" code is available via this path in the reports
> UI:
>
> Choose "Item" source.
> Item -> Call Number/Volume -> Bib Record -> Fixed Field Entry -> Lang ->
> Language Code
>
> There's also:
>
> Item -> Call Number/Volume -> Bib Record -> Fixed Field Entry -> Lang ->
> Language
>
> which should be the text description of the Language too.
>
> I hope that's helpful!
>
> Chris
>
> ----- Original Message -----
> > From: "Kallinen Pasi" <Pasi.Kallinen at pttk.fi>
> > To: "Evergreen Discussion Group" <
> open-ils-general at list.georgialibraries.org>
> > Sent: Tuesday, September 10, 2013 1:54:32 PM
> > Subject: Re: [OPEN-ILS-GENERAL] circulation report
> >
> >
> >
> > If this really isn't possible via the reports UI, we can do it via
> > SQL, sure.
> >
> >
> >
> >
> >
> >
> > --
> >
> > Ystävällisin terveisin
> >
> > Pasi Kallinen
> > ICT-asiantuntija
> >
> > p. 0400-139747
> > pasi.kallinen at pttk.fi
> > Länsikatu 15
> > 80110 Joensuu
> >
> > Pohjois-Karjalan Tietotekniikkakeskus Oy - www.pttk.fi
> >
> >
> > From: open-ils-general-bounces at list.georgialibraries.org
> > [open-ils-general-bounces at list.georgialibraries.org] on behalf of
> > Rogan Hamby [rogan.hamby at yclibrary.net]
> > Sent: Tuesday, September 10, 2013 17:12
> > To: Evergreen Discussion Group
> > Subject: Re: [OPEN-ILS-GENERAL] circulation report
> >
> >
> >
> >
> > Do you have access to run SQL reports or are you limited to using the
> > staff client reporter?
> >
> >
> >
> > On Tue, Sep 10, 2013 at 7:25 AM, Knuutinen Päivi <
> > paivi.knuutinen at jns.fi > wrote:
> >
> >
> >
> >
> >
> >
> >
> > I need to have a circulation report of books written in different
> > languages (e.g. Finnish, Swedish, English etc.). It is easy to have
> > report of all books using Circulation source. I may only specify one
> > source per template and I can't find any option to select the
> > language of the item. How can I do a report to count circulation of
> > books of different languages?
> >
> >
> > Päivi Knuutinen
> > Finland
> >
> >
> >
> >
> > --
> >
> >
> >
> > Rogan Hamby, MLS, CCNP, MIA
> > Managers Headquarters Library and Reference Services,
> > York County Library System
> >
> >
> > "You can never get a cup of tea large enough or a book long enough to
> > suit me."
> > -- C.S. Lewis
>
> --
> Chris Sharp
> PINES System Administrator
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
>



-- 

Rogan Hamby, MLS, CCNP, MIA
Managers Headquarters Library and Reference Services,
York County Library System

"You can never get a cup of tea large enough or a book long enough to suit
me."
-- C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130910/3ee44301/attachment-0001.htm>