[Koha] Report help

[Elaine Bradtke]

 I rewrote the report to make it user friendly to my colleagues who aren't
familiar with Roman numerals. . . little tweaks like this I can do. It's
the syntax and commands that I don't know how to use properly that's the
real problem.

SELECT
CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,2)
WHEN '15' THEN '16th'
WHEN '16' THEN '17th'
WHEN '17' THEN '18th'
WHEN '18' THEN '19th'
WHEN '19' THEN '20th'
WHEN '20' THEN '21st'
      ElSE 'Unknown' END
   AS Century, count(DISTINCT biblionumber) AS bibs FROM biblioitems m
GROUP BY century


On Tue, Jul 29, 2014 at 12:08 PM, BWS Johnson <abesottedphoenix at yahoo.com>
wrote:

> Salve!
>
>     Way late response since I can't check my personal email at work.
>
>
> >Ahrgh
> >not enough sleep last night
> >1900s=20th century. .
> >
>
>     Even if it's by Century, the initial ones had
>
>
> >>>>      WHEN '18' THEN 'XVIII'
> >>>>      WHEN '17' THEN 'XVII'
>
>     So either way, it's flubbed, since that ought be XIX and XVIII
> respectively.
>
>
> Cheers,
> Brooke
>
>


-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)