Question
Virtusa
US
Last activity: 7 Aug 2019 7:27 EDT
Undo Property Optimizzation
Is there a way to undo property optimization , say we optimize a property and then we dont want that column is there any option to remove that column from the DB table ? (not by writing alter script) , any option in designer studio ??
Pegasystems Inc.
US
The property that you optimized records the classes that inherited that property at the time that you did the optimization.
The property that you optimized records the classes that inherited that property at the time that you did the optimization.
Deleting a column requires DBA privileges.
ALTER TABLE "table_name" DROP "column_name";
You said Designer Studio so assume this is Development and not Production.
Instead of worrying about deleting the column in your Development database, modify the Rule-Obj-Property rule that you optimized.
- Obj-Open the Property rule
- Propery-Remove pzOptimizedForClassList
- Obj-Save
- Commit
In Designer Studio, in the Advanced tab of the Property rule, do not say "Column inclusion required"
Create new instances where that Property is set.
Verify that the existing column is NOT populated would be tricky without direct DB access.
You could either ask a DBA to check for you, or define a Connect-SQL rule that does Browse.