Leigh, I believe that inactivated thesaurus xrefs can be searched under advanced query. You need to specify the Inactive terms node for searching.

Of course, if you simply wanted to purge all inactivated thesaurus xrefs from TMS, that can be managed through a SQL script as well - which would save you a lot of time and effort.

~Chad

On Thu, Nov 12, 2015 at 2:09 PM, Leigh Gleason <[log in to unmask]> wrote:
Hi All, 

We are working on a massive thesaurus cleanup that was half done when we converted to TMS -- we're now trying to move toward finishing it.  We're still running TMS 2012, and are hosted.  I realize that Thesaurus Manager gets better in TMS 2014, and perhaps I should be tabling this project until we upgrade -- but until then, I'm stuck on a problem I can't figure out how to fix and am hoping you might know how. 

In the Objects module's Attributes field, we apparently made "Inactive" but did not delete some terms that are clearly wrong (typos, for example).  When I try to delete the entry from Thesaurus Manager, it won't let me because it is ThesXref'ed to object records as an inactive term. 

The problem is that I don't know what object records have these inactive terms.  Advanced search does not find inactive terms, and the particular case I'm working on has over a thousand records tied to the correct thesaurus term with the right spelling, so that would be a lot to slog through in hopes to spotting the greyed out inactive term.

Is there a way in TMS 2012 to see what record uses this inactive term, short of the long slog? Is this something more easily fixed in 2014?

With thanks,


Leigh


--

Leigh Gleason
Curator of Collections
UCR/California Museum of Photography
3824 Main Street
Riverside, CA 92521

web: www.cmp.ucr.edu
email: [log in to unmask]
tel: 951-827-5303
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.