Question
Iffco-Tokio General Insurance Company Ltd
IN
Last activity: 14 Jul 2020 11:36 EDT
Fetch Mutile records from db
I have 3 list of records in a Blob for Single policy.
I am fetching records from DB so i have to write
PR_READ_FROM_STREAM('.Policy.CoInsuranceList(1).InsurerName',pzinskey, pzpvstream)
PR_READ_FROM_STREAM('.Policy.CoInsuranceList(2).InsurerName',pzinskey, pzpvstream)
PR_READ_FROM_STREAM('.Policy.CoInsuranceList(3).InsurerName',pzinskey, pzpvstream)
There can be more than 3 records but i want all records in my query. Is there any that dont have to write this for all the records.
Coforge DPA
GB
Hi
First of all why do you want to retrieve from BLOB? Cant you expose them if they are used extensively. Exposing these columns is the ideal way and would be easy for you to retrieve through Report definition.
Regards
Bhavya
Maantic Inc
US
Pega Version 7.4 Report definition able to read values from BLOB. use report definition to get values.
If the fields are used for frequent reporting, as Bhavya suggested expose the columns and use it in report defintion.