Object Packages are a great way to collect together disparate artifact records, for whatever reason the package creator decides. By the same token, Status Flags are a great way to identify artifact records with special attributes, or that require special attention. A great time saver would be if you could mass assign a status flag to the contents of an object package. You can, with this little SQL script…
(more…)Category: SQL Scripting
-
Get Location Authority Statistics
The Usage Report feature is a great way to keep track of what authority terms have or haven’t been used within TMS. The problem is that the Usage Report feature sometimes isn’t extensive enough – in this case covering the Location Authority. I designed this SQL query to help.
(more…)