Question
Inovar
IN
Last activity: 14 Aug 2024 2:21 EDT
Extracting Entire blob using UDF functions
Hi ,
Is there any way to extract entire blob using udf functions or sql queries, instead of querying each field like below ?.
(select pegadata.pr_read_from_stream('.ProjectDescription', pzInsKey, pzPVStream) AS descr from pegadata.pc_jms_pm_work where pyid='P-3890')
***Edited by Moderator Rupashree to add Capability tags***
Tata Consultancy Services
IN
Hi @azmathullashaik,
You can remove the where clause and then execute so that will get ProjectDescription for All WO's.
and We will get scalar property values directly from Blob. We can't extract entire BLOB and We can't get Entire BLOB Data (One Object BLOB contain many Properties).
@KenshoTsuchihashi Do you have any thoughts on this ? Please do let us know.
select pegadata.pr_read_from_stream('ProjectDescription',pzInsKey,pzpvstream) AS descr from pegadata.pc_jms_pm_work
I hope this will hep you.
Thanks,
Ashok
Pegasystems Inc.
IN
@azmathullashaik Do you need all the fields in the blob in sql? otherwise, you can try using the lookup data page for the required class. It should fetch all the fields in the blob.
Tata Consultancy Services
IN
Hi @kammv
Thanks you for the response,
Can I have the SQL query for Read BLOB Data, It should be show the All Properties Data After Executing the Query in Pega Query Runner.
E.g: pyID:W-123
After Executing the Query, It should be show the All the properties data from the BLOB, Including Non Exposed Properties, OOTB Properties Data and Etc..
Thanks,
Ashok