[Koha] Report Help

Nicole Engard nengard at gmail.com
Sat Jul 2 01:33:42 NZST 2011


Hi all,

I wrote this report to get all subject headings in a Koha system that
start with key phrases:

SELECT lcsh
FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code>="a"]')
AS lcsh FROM biblioitems)
AS subjects
WHERE lcsh
LIKE "College%"
OR lcsh LIKE "Seminary%"
GROUP BY lcsh


What's happening is if there is more than one 610 on a bib record it's
showing them both on one line.  I tried using DISTINCT, but that's
didn't do the trick, so I'm up for ideas.

Nicole


More information about the Koha mailing list