Add an automated way to delete unused authority records
Bug #1792732 reported by
Jane Sandberg
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
Having a bunch of unused authority records in Evergreen can really slow down users who are trying to work with authorities. Koha includes a script to run to remove authorities that are not linked to any bib records. It would be nice if Evergreen included something similar: http://
tags: |
added: cat-authority removed: authority |
To post a comment you must log in.
Thinking about this a bit more, I guess a simple way to do that would be to just issue the following SQL:
`UPDATE authority. record_ entry SET deleted=TRUE WHERE NOT deleted AND id NOT IN (SELECT DISTINCT authority FROM authority. bib_linking) `
And then refine that SQL based on specific needs.