Impact on modifying deployed table data.

Question

We have deployed a table to higher environment and used in required objects to perform operations, we want t o add 2 columns to it . How can we achieve this , also will there be any impact on the objects as its already in higher environments .

Stefan Helzle · Accepted Answer

Only adding a field does not impact any object using this table. But, as long as the other objects are not updated, they will not populate the new fields.

Harsha Sharma · Answer

You can make the changes but the things to keep in mind to scale efficiently is Active process instances will not have those 2 new fields. So ensure if any precedent rule of that process model should not reference those fields directly. Have default values setup in case the field can't be indexed for such cases. 
 Any rule or process you are modifying referencing these new columns, keep in mind not all instances will have those fields so don't use dot operators, user property() functions to reference those to avoid the ' cannot index field error ' in production

Shubham Aware · Answer

Adding new columns to an existing production database table has no impact on objects currently using that table - all existing processes, interfaces, and reports continue working normally since they only reference their original columns. The new columns will remain empty until you explicitly update objects to populate them. 
 To handle this safely, make the new columns nullable, update your record type, and deploy through standard(Dev-Test-Prod) environments. You can then gradually update objects to use the new columns as needed - this is low-risk since you&rsquo;re adding, not modifying existing structure.​​​​​​​​​​​​​​​​

Impact on modifying deployed table data.

Top Replies