@BalanagammalS16953192 Do Property Optimization...!

Hi @BalanagammalS16953192,

You can't expose direclty data from the BLOB (pzPVStream), If want expose the data you can use Property Optimization. From the new case creation onwards it will store in Exposed colom.(Exposed coloms mostly used in Report Defination) and respesctive data will be stored in Exposed colom and BLOB (pzPVStream).

For the Old Cases, you can use below activity

Activity Name: RecreateIndexesForClass

Do Private Edit, then Step No: 2.2 (Obj-Open-By-Handle); Enable Lock and ReleaseOnCommit.   then  Save

Just pass the Class Name, then Run

Please refer below articles for optimize the property and Understanding Pega Blob

Optimize a property and How to optimize properties in production environment

Understanding Pega Blob and UDF

Thanks,

Ashok

@BalanagammalS16953192

Using the Application Explorer, expand the Data Model node and the Property list. Right-click a property name and click Optimize for reporting. Select the tables in which you want to create a dedicated database column for this property. You must select at least one table. If the property is embedded, specify the RuleSet and Version that is to contain the new Index- class, the properties in that class, and the Declare Index rule. Select whether to optimize the property now or later. If you select later, click the calendar icon to select a date within seven days of the current date to optimize the property. Click Next. Review the tables to which the property column will be added and the classes that will be mapped to each table. Click Next. Click Finish.