Question


stg IT LLP
US
Last activity: 16 Nov 2023 23:00 EST
PZPVStream Column
How to Expose data from PZPVStream Column?
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Evoke Technologies
US
@BalanagammalS16953192 Do Property Optimization...!


stg IT LLP
US
@AkshithReddyTThank you for your reply!
Can you expand this?
Updated: 6 Nov 2023 9:49 EST


Tata Consultancy Services
IN
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


stg IT LLP
US
@Bhumireddy Thank you !
Updated: 16 Nov 2023 8:37 EST


Tekclan Software Solutions
IN
If you optimize property in pega automatically population job will be created(Case will be created in System-Job-PropertyOptimization) this case will populate the column records for existing rows(case objects).
Thanks.


Truviq Systems
NL
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.