Read page type property from a blob using pr_read_from_stream UDF
I have a requirement to extract page type property for a work object from the blob stored in the database using pr_read_from_stream UDF or through any other method that can be used through a RDB methods from PEGA.
Please note that in my case since the assignment has been corrupted.Iam not able to use Obj methods for extracting the properties.
I am also able to get the values of the single properties (top level or within a page) with the query given below:-
Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE
But how can i get the whole page property?Pls suggest
**Updated by Moderator: Marissa. Removed user added Ask the Expert and #helpme group tags. Apologies for confusion, shouldn't have been an end-user option***
Since these values are help in a DecisionData, we are unable to "Optimize" the Properties to expose them. Since we can see the Object in the DB, I was wondering if it was possible to somehow reach the data.
The requirement is to extract proposition metadata to an open datamodel so that customer can create its own reports. Pega Marketing Interacton History is open i.e. it can be quired via plain SQL. However, same cannot be applied for proposition metadata. Therefore, customer wonders if decision datastore can be queired. Apparently, only way to read that data is to write a custom Activity in Pega or extract it to an open schema via BIX.