[Koha] Report help

Nicole Engard nengard at gmail.com
Wed Apr 15 03:05:35 NZST 2015

Hi all,

I'm working on this report and I want there to be a BR between each
distinct 650a - but for some reason it's not working. I worked on this
in channel for a while and you can see the log here:

Here's the report:

Select b.biblionumber, GROUP_CONCAT(DISTINCT ExtractValue(m.marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]') SEPARATOR ' BR ') AS
'Subject',i.itype AS 'IType'
FROM biblio b
LEFT JOIN biblioitems m using (biblionumber)
left join items i using (biblioitemnumber)
WHERE i.location in
and i.itype != 'JOURNAL' and ExtractValue(m.marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]') is not null and
ExtractValue(m.marcxml, '//datafield[@tag="650"]/subfield[@code="a"]')
!= ''
group by i.biblionumber
ORDER BY b.biblionumber

Thanks in advance!

More information about the Koha mailing list