[Koha] Managing new authority headings
CHillyard at washoecounty.us
Wed Jul 20 03:13:13 NZST 2016
We have this report that looks for 'unauthorized' 650s in a time range.
SELECT biblionumber, itemtype, ExtractValue(marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml,
'//datafield[@tag="650"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(marcxml,
'//datafield[@tag="650"]/subfield[@code="9"]')) = 0 AND timestamp between <<Between (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> ORDER BY heading
It only shows subfield a.
Washoe County Library
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Iming Chan
Sent: Monday, July 18, 2016 11:38 PM
To: koha at lists.katipo.co.nz
Subject: [Koha] Managing new authority headings
Does anyone monitor new authority headings (all types) created? If so, how do you identify new headings created in a given time period? Custom reports??
At this moment, there is no easy way to identify those new headings. Going
through the entire list of authority headings is very labour intensive work.
I would like to manage this area a little more, after found quite a few duplicate, unused, and even invalid/outdated headings.
I would also like to see a more advanced method of global change of headings, for example:
$aHong Kong to $aHong Kong (China) [only those found in subfield $a], or $zHong Kong to $zChina $zHong Kong [only those found in subfield $z and split into multiple subfield $z], or $xPictorial works to $vPictorial works [only those found with subfield $x]
This will eliminate the need to change affected headings individually.
Looking forward to hear your comments ...
Translib Information Service
Phone: +61 3 9801 5097
Fax: +61 3 9801 4024
E-mail: iming at translib.com
View this message in context: http://koha.1045719.n5.nabble.com/Managing-new-authority-headings-tp5896094.html
Sent from the Koha-general mailing list archive at Nabble.com.
Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha