Do we need to use exposed properties in RDB methods or will it read from BLOB as well?

General
, , ,
1

Do we need to use exposed properties in RDB methods or will it read from BLOB as well?

2

@TanyaS58

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.

3

@SohamM95 so we do need to use exposed columns in case of RDB methods thats what i can conclude from your detailed explaination?

4

@TanyaS58

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

5

@TanyaS58

Yes

6

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