[Koha] Orphaned Authority Records: Finding Them and Deleting Them
Charles Kelley
cmkelleymls at gmail.com
Tue Aug 4 21:02:10 NZST 2020
Hello, all!
I have been trying to detect, isolate, and delete orphaned authority
headings, i.e., authority records to which no record is attached. I tried
adapting the duplicate authority record report from the SQL Reports
Library. I thought changing this one line would do the trick, but alas, it
did not.
HAVING count(authid) > 1
>
I changed it to
HAVING count(authid) < 1
> HAVING count(authid) = 1
> HAVING authid IS NULL OR authid = ''
Alas, an empty report. Is there something I can do to find and then
delete the orphaned authority records? Many of these orphaned authority
records are duplicates that I am painstakingly merging two at a time. If I
could get some help in speeding up the merge and deletion because going
through the records two at a time is terribly inefficient.
Many thanks for your help.
--
気を付けて。 /ki wo tukete/ = Take care.
-- Charles.
Charles Kelley, MLS
PSC 704 Box 1029
APO AP 96338
Charles Kelley
Tsukimino 1-Chome 5-2
Tsukimino Gaadenia #210
Yamato-shi, Kanagawa-ken
〒242-0002 JAPAN
+1-301-741-7122 [US cell]
+81-80-4356-2178 [JPN cell]
mnogojazyk at aol.com [h]
cmkelleymls at gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
Meeting Your Information Needs. Virtually.
More information about the Koha
mailing list