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 .
Discussion posts and replies are publicly visible
I do not understand what your actual question is. Please explain your ask in more detail.
- I want to add new columns to a DB table which is already deployed to Production and being used in different places of our Application . If we alter the table and redeploy .How the objects which are already consuming it in production will affect .And how to handle it .
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.
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
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’re adding, not modifying existing structure.
Thanks you