Idea

1
Replies
26
Views
Abilash BLR (AbilashBLR)
BRT
Lead System Architect
BRT
IN
AbilashBLR Member since 2013 9 posts
BRT
Posted: 3 weeks 4 days ago
Last activity: 2 weeks ago
Posted: 21 May 2021 6:16 EDT
Last activity: 1 Jun 2021 4:56 EDT

Expose and populate column data from BLOB of table of large volume with sql UDF or column populator PEGA prpcutils

For much bigger application exposing a column is a challenge and options to try from PEGA UI as developer is not a good solution and need to try following options we have which will run on DB directly and can be much much faster.

Consolidating the articles i had gone through for the possible solutions to try for exposing column and populating data from BLOB

 

SQL UDF

https://www.pegaxchange.com/2018/02/18/read-pega-7-blob/

 

Column populator with prpcutils

https://community.pega.com/knowledgebase/articles/system-administration/84/populating-properties-using-direct-connection-database

https://community.pega.com/knowledgebase/articles/database-management/how-use-column-populator-utility-prpc-6x-pega-719

Pega Platform Reporting Support Case Created