Hi 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 775-327-8338 -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Iming Chan Sent: Monday, July 18, 2016 11:38 PM To: koha@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 ----- Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: iming@translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Managing-new-authority-headings-tp5896094.... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha