Explanation of environment: I am running SharePoint 2010 SP1, December CU's. I have a list item which has a taxonomy column. As expected, if a term (e.g. “foo”) is deleted from the term store, users no longer see “foo” as an option for new items, but the term remains on previous items because “foo” is not deleted from the TaxonomyHiddenList by the Taxonomy Update Scheduler job.
Problem: This presents problems with search because if “foo” is deleted, we don’t want anyone to ever know “foo” existed anywhere on our site.
Desired Behavior: In addition to updating current items, I would like orphaned terms to be deleted from the TaxonomyHiddenList
Proposed Solution: Write a custom timer job to iterate through all terms and delete any orphaned items from the TaxonomyHiddenList
Question: Is this a viable solution? Am I missing something? Is there a more elegant way to handle this than manhandling the TaxonomyHiddenList?