Re: [Koha] Report help

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