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]
[email protected] [h]
[email protected] [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
Meeting Your Information Needs. Virtually.
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
