Question2Replies27Views HimanshuG3500 Member since 2020 1 post Iffco-Tokio General Insurance Company Ltd Posted: 2 months agoLast activity: 2 months 1 week ago Fetch Mutile records from dbI 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. Pega Platform 7.4 System Administration Financial Services Business Architect Pega Academy ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 2 months agoBhavya_Incessant Incessant Technologies replied to HimanshuG3500HiFirst 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. RegardsBhavya Posted: 2 months agoJohnPaulRaja,C Cognizant replied to HimanshuG3500Pega 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.