Hi, Happy New Year 2022.
> Here's a sample problem: finding subject headings whose ind 2 = "4".
> WHERE ExtractValue(metadata,
'//datafield[@tag="650"]/@ind2="2"') = "4"
I'd say it should be :
WHERE ExtractValue(metadata,
'count(//datafield[@tag="650"][@ind2="4"])') > 0
Do not use //datafield[@tag="650"]/@ind2 because if there are several
650 values will be contatenated so not equal to 4.
My reference is :
https://www.w3schools.com/xml/xpath_syntax.asp
Best regards,
Le 05/01/2022 à 16:35, Charles Kelley a écrit :
Hi, all!
Happy New Year, everyone!
I know how to compile a report when a subfield has particular value. Is
there a way to compile a report when ind 1 or ind 2 has a particular value?
Here's a sample problem: finding subject headings whose ind 2 = "4".
The SQL SELECT statement might look something like
SELECT
biblioitems.biblionumber AS 'Bib. Record No.',
ExtractValue(metadata, '//datafield[@tag="245"]/subfield[@code="a"]') AS
'Main Title', ExtractValue(metadata,'//datafield[@tag="650"]/subfield[@ind2
="1"]') AS 'Topical Subject'
FROM biblioitems
JOIN biblio_metadata ON (biblioitems.biblionumber =
biblio_metadata.biblionumber)
WHERE ExtractValue(metadata, '//datafield[@tag="650"]/@ind2="2"') = "4"
I've looked in the Koha wiki, but I have not successfully found hints,
instructions, sample reports, etc.
Can anyone suggest an alternative? Maybe MarcEdit will be easier than
SQL.
Many thanks!
--
Fridolin SOMERS <[email protected]>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
