Ways to include BLOB properties in Reports - PostgreSQL
Hi All,
I am using Pega 7.1.8 with PostgreSQL DB. My requirement is to include blob properties mapped to pr_other table in reports. On analysis, i found optimization won't work for properites mapped to pr_other table. And then i found another solution is UDFs. But the problem with UDFs usage in production environment is performance issue. So i need your suggestions to find out other alternates.
Thanks and Regards
Jahnavi
Pegasystems Inc.
IN
Can you try with column population utility to expose the blob properties into external columns and then create report on it.
Amazon
IN
Hi Rajendra,
Could you please share more information about the column population utility, i don't know about this.
Amazon
IN
Hi Rajendra,
I found information about column population tool which is an alternative for optimization. https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
But i want to have seperate columns for the properties that are mapped to data.pr_other table. So from the above article, i am not clear whether this tool works for pr_other table or not.
Pegasystems Inc.
IN
Using blob properties at the same time expecting performance improvement is not possible.
If there is a need for the property to be used in report better expose it and then use it instead of refering blob.
Amazon
IN
Hi Santanu,
But the problem with exposing the column is, the properties are mapped to pr_other table. So i am unable to use this option.
Pegasystems Inc.
IN
Hi,
Discussion in below link may help you.
Accepted Solution
Updated: 9 Apr 2018 6:36 EDT
Amazon
IN
Hi All,
Thanks for all your responses. I am going with Index option to include unexposed properties in the reports.
Regards,
Jahnavi