how to deactivate variable set

[amrutakulkarni]

Can we deactivate variable set?

[top_tanti]

You may not want to delete the variable set as it would also delete the variables within. If I remember correctly, this means any preexisting records utilizing those variables would lose information (variables would disappear). Deactivating the variables within the variable set would allow a user to restrict further use of the variable set without impacting existing records.

[Kalaiarasan Pus]

I don't think the variables would get deleted but think variable set reference will get blanked out from related variables .

[top_tanti]

I stand corrected. I assumed there would be a cascade delete when deleting the variable set which is not the case. The variables will remain with no data loss.

[odijk]

Out of the box this is not possible.

As mentioned by others, there is a significant risk in loosing data when you delete the variable set: only do that if it was never used.

To really deactivate is:

* Remove the variable set from all the items it is linked to

* Add an attribute "u_active" to the variable set table

* Create a before query business rule that only allows the admin to see the variable sets that are inactive. (or something similar)

  > alternative is to use a Read-ACL, but they people will see the "number of rows restricted by..." message.

This way the variable set will no longer be available, but the underlying questions are still valid for the items that made use of them.

[Kalaiarasan Pus]

Have you guys tested about data loss? I do not think variables gets deleted from instance when variable set is deleted. If that is the case, there should be no data loss.

PS: I am not suggesting to delete variableset but just saying it is one of the options.