[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