[Koha] Managing new authority headings

Hillyard, Cecil 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.
Cecil Hillyard
Washoe County Library
Technical Services

-----Original Message-----
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

Dear all,

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 ...

Kind regards,


Iming Chan
Translib Information Service
Melbourne, Australia

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 mailing list