How to clean up RTC attributes
We have an issue where we have many attributes that are no longer used, or have been converted and in doing so created more attributes that are named similar to the originals. Needless to say this has created a bit of user confusion, but it has also impacted JRS were it's made some attributes totally unusable.
What would we need to do to go into the database and modify the attribute IDs?
What would we need to do in addition to make sure RTC still functions without issue afterwards?
Is it possible to actually remove them without impacting the existing references and links to them?
One answer
I am not aware that you can delete custom attributes at the moment. I think there are enhancement requests for that.
What I have used so far, and suggested to others, is to change the Attribute Display name to something like "zzzz_deprecated OldName".
This tell users in Queries and reporting to stay away from that stuff and sorts it to the end.
Comments
I have tried deleting the custom attributes by id on the XML. You must delete everything on the xml with that id : permissions, presentations, custom attribute definition and custom attribute on workitem.
I succeded but I used not in a production environment, I extracted the template and delete some custom attributes on the template and then create a new PA.