[Koha] Report help

[BWS Johnson]

Salvete!

>SELECT
>CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),8,2)
>      WHEN '19' THEN 'XX'
>      WHEN '20' THEN 'XXI'
>      WHEN '18' THEN 'XVIII'
>      WHEN '17' THEN 'XVII'
>      ElSE 'OLDER' END
>   AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m
>GROUP BY bibtype
>
>I made this report based on two reports from the library by Nicole C.
>Engard.
>



    Should prolly be

>      WHEN '19' THEN 'X1X'
>      WHEN '20' THEN 'XX'
>      WHEN '18' THEN 'XVIII'
>      WHEN '17' THEN 'XVII'



    yeah?

Cheers,
Brooke