Question
2
Replies
12165
Views
Tata Consultancy Services Limited
Tata Consultancy Services Limited
GB
Tata Consultancy Services Limited
Posted: February 10, 2016
Last activity: March 16, 2016
Last activity: 16 Mar 2016 15:15 EDT
Closed
Solved
Query Blob column (pr_read_from_stream)
Hello All,
Is there any way to query the blob column and get the property value.
I am using the below query. It is working for the property which are directly on the pyWorkPage.
Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE
But I want to know the property resides inside one of the pages under pyWorkPage.
I tried the below syntaxes and none of them are working..
"Page\Property"
"Page/Property"
"/Page/Property"
"\Page\property"
Kindly advice.
Thanks,
Guhan!
Accepted Solution
Posted: 5 years ago
PEGA
Pegasystems Inc.
IN
could we try ...
- pr_read_from_stream ('.PageName.PropertyName', pzInsKey, pzPVStream) PropertyName from TableName ;
Posted: 5 years ago
Tata Consultancy Services Limited
Tata Consultancy Services Limited
GB
Dear Phani,
Thanks a lot for your reply.
It works ...
Regards,
Guhan