Question

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****

Comments

Keep up to date on this post and subscribe to comments

January 16, 2019 - 3:34pm

The data is still maintained in the blob.

January 24, 2019 - 8:17am
Response to CarissaW_GCS

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

January 24, 2019 - 8:30am

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.

January 24, 2019 - 9:24am
Response to CarissaW_GCS

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.

January 24, 2019 - 9:35am

Correct, it is just one property on the Clipboard and in Tracer. Here is information on the column populator.

https://community.pega.com/sites/default/files/help_v81/procomhelpmain.htm#engine/database/tools/eng-cp-column-populator-con.htm

October 14, 2019 - 10:57am
Response to CarissaW_GCS

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?