[OPEN-ILS-GENERAL] circulation report

[Knuutinen Päivi]

Thank you Chris! This was very helpful, I can do it now.

Päivi Knuutinen
kirjastovirkailija
Joensuun seutukirjasto
050 441 2247
paivi.knuutinen at jns.fi

________________________________________
Lähettäjä: open-ils-general-bounces at list.georgialibraries.org [open-ils-general-bounces at list.georgialibraries.org] käyttäjän Sharp, Chris [csharp at georgialibraries.org] puolesta
Lähetetty: 10. syyskuuta 2013 23:03
Vastaanottaja: Evergreen Discussion Group
Aihe: Re: [OPEN-ILS-GENERAL] circulation report

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/