We have constituent attributes in our system where the value is selected from a drop-down menu. I would like to inactivate several old value options that should no longer be used. The values options are stored in T_KWCODED_VALUES, and the documentation for this table says that "Values for unused attributes can be inactivated or deleted." But we don't seem to have a box for inactivating in this table.
Right now we have renamed the attributes so that it obvious they shouldn't be used. But I'm wondering if I'm missing a better option. Has anyone else developed a solution for this?
-Michael Wilcox, Science Museum of Minnesota
Michael, you should be able to delete rows from T_KWCODED_VALUES system table.
Sabina
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Michael WilcoxSent: Wednesday, June 12, 2013 8:03 AMTo: Sabina SpilkinSubject: [Tessitura Technical Forum] Inactivate attribute values for T_KWCODED_VALUES?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Sabina, thanks for the reply. I believe that deleting the row would erase the data from any constituent accounts that hold that information. I would like to retain the information for future use, but just not use these values again into the future.
-Michael
Hi Michael
You can delete values from T_KWCODED_VALUES without losing the historical record.
Unusually for one of these tables, TX_CUST_KEYWORD stores the value itself, rather than a code or id with a link to the value, so the lookup is not referenced after the value has been entered.
I presume it was done that way so that you can use other sources for attribute lookup values, not just T_KWCODED_VALUES - including offering values calculated from other data on the fly, where the values can be indeterminate, and can also have non-lookup attributes - ie free-text , numerical, and date values.
If you want whole attributes to disappear from view, but remain in the data, probably the easiest thing to do is control-group them away from all ordinary users. We have a special control group called "deleted data" which makes things only visible to administrators - I think a lot of sites have something similar (possibly with a more logical name).
Ken
Ah, then Sabina and Ken, I stand corrected! I will test the delete procedure in our sandbox environment. And thanks also for mentioning the "deleted data" control group; I'll point it out to our Tessitura user group.
Best,
Michael