Do we need to use exposed properties in RDB methods or will it read from BLOB as well?
Do we need to use exposed properties in RDB methods or will it read from BLOB as well?
Accepted Solution
Updated: 15 Jun 2024 7:28 EDT
Maantic Inc
IN
RDB- methods use Connect-SQL to fetch data from the database, they rely on the query provided by the developer and have no context of falling back to pzPVStream if the column name mentioned in the query is actually not a column in the table. Note that to support fallback, it would result in explicit parsing of the query itself (which in itself might be quite complicated depending on the use case). With Obj- methods or List View / Report Definitions, since developers specifically refer to properties (and not write the actual SQL query), at execution time, the Pega platform can validate the existence of an explicit column for it or not. Based on this, it can generate an appropriate query of either opening the entire BLOB or use UDFs.
Rulesstack Private Limited
IN
Yes, you need to use exposed properties in RDB methods for efficient data retrieval. RDB methods do not read from the BLOB directly.
Thanks
Ajay kumar
Tata Consultancy Services
IN
Hi @TanyaS58
Your RDB SQL query can't interpret Pega Blob as it is obfuscated in Pega's proprietary manner and so that you should be you expose a property, then only it will work in RDB (in RD, it will work even if you don't expose a property).
Pega Blob has to be read / written thru Pega tool.
I hope this will help you.
Thanks,
Ashok