As discussed during the July 2024 Cataloging Zoom forum, if you go to delete authority records, you’ll be prompted with a pop-up if the authority is present in any other record sets or has any See or See Also links.
To find other record sets an authority might belong to:
Create a record set with the authority records you’d like to delete. Note the RECORD SET ID
Adjust the following SQL to use this record set id:
SELECT recordsetid
FROM polaris.polaris.AuthorityRecordSets
WHERE authorityrecordid IN (
SELECT authorityrecordid
FROM polaris.polaris.AuthorityRecordSets
WHERE recordsetid = PUTRECORDSETIDHERE
)
AND recordsetid <> PUTRECORDSETIDHERE
Open a Record Set Find Tool and switch to SQL search mode.
Paste in the SQL above and select Search
The other record sets that contain the authority records from the first step will be shown.
CONFIRM THOSE OTHER RECORD SETS ARE NOT NEEDED
Delete the unneeded RECORD SETS. This REMOVES THE ENTIRE RECORD SET. It doesn’t simply remove one record from the record set.
Now the authority records will only be in the one remaining record set that you are using to delete them from. You should get fewer pop ups when you go to delete the authority records.
I deleted AND purged all the superfluous record sets and still got a TON of pop-ups that these authority records are in 1-2 other record sets. Can there be other record sets that I don’t see in my search?
Good catch @carl.ratz ! That makes me really sad though
I can’t think of a good non-direct SQL way to account for these. A long term solution would be removing that permission and bulk changing the owner on the current record sets, but again that would require direct SQL access. Do others have any thoughts?