Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

2
Replies
85
Views
HimanshuG3500 Member since 2020 1 post
Iffco-Tokio General Insurance Company Ltd
Posted: Jul 14, 2020
Last activity: Jul 14, 2020
Closed

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.

To see attachments, please log in.
Pega Platform 7.4
System Administration
Financial Services
Business Architect
Pega Academy

Posted: 4 years ago

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

To see attachments, please log in.
Posted: 4 years ago

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice