Question
1
Replies
2184
Views
Ernst & Young LLP
Posted: September 25, 2017
Last activity: September 25, 2017
Closed
Exposing a Column
When I expose a column at a later stage and I open a particular work object and perform a Obj-Save through an activity Or a Column Population Job to get the old data from BLOB to the new column.
When the data is moved from BLOB to the newly exposed column, is it completely moved from BLOB or Is it just a copy from BLOB to newly exposed column?
Hi Prateek, After you make schema changes that expose a property as a database table column, and populate it: Property, whose values were previously stored only in the Storage Stream (BLOB) column, can populate the newly exposed column. The property values going forward will be stored directly into the column as long as it remains mapped to that column (mapped external or via Index).
Sidenote: You can update rows in a database table by using the Column Populator utility. You can also rebuild database indexes and Index- instances defined by Declare Index rules for the newly populated column as part of the same operation.