Question
TCS
IN
Last activity: 14 Oct 2019 10:57 EDT
Unexposed property's fate in BLOB after optimization
What happens to an unexposed property in a BLOB(pzpvStream) when it is exposed to a distinct database column using Property Optimization tool?Does the unexposed property is deleted from BLOB as it is converted to a separate database column through optimization?
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
The data is still maintained in the blob.
TCS
IN
Thanks for your reply.
Will there be a problem of using exposed property in where clause of Obj- Browse method which has a copy in BLOB?
As Obj methods work with blobs. Thus, what will happen in this situation
Pegasystems Inc.
US
Once you expose a column, you can run the column populator utility to make sure existing records are populated. From that point, the data in the exposed column and the data in the blob should be the same.
TCS
IN
Thanks for your reply.
What is column populator utility in Pega? How can I use it to verify that the data is populated and identical for both ?
Another parallel question: There will be only one property representing both in a Clipboard Page.Thus, we cant check it from Clipboard or Tracer.
Pegasystems Inc.
US
Correct, it is just one property on the Clipboard and in Tracer. Here is information on the column populator.
TCS
IN
Questions:-
1. Which wizard or landing page in designer studio help us to run the Column populator tool?
2. Suppose I had a property x in BLOB with value x=1. The single value property x is exposed as database column x and set as x=2.
Column populator is not run to make the values equal in BLOB and exposed column.
Now I am doing Obj-Open on the class mapped with this table.
What will be the value of x in the step page for this class in the clipboard? Will it have x=2 for column or x=1 for BLOB reference?