Close popover
Paulo Brito (PauloB18)
Sunlife Financial

Sunlife Financial
PauloB18 Member since 2019 4 posts
Sunlife Financial
Posted: December 11, 2019
Last activity: February 4, 2020

Querying Pega82 database

Hi there,

I have a question that may have been asked before however I am not able to locate any answer here yet.

We would like to write a query to combine data from these two tables:

. PegaRules.pr4_rule_property and

. PegaRULES.pr4_fieldvalue.

Basically we are implementing a list/report to display data from pr4_rule_property table and include pyFieldvalue, pyLocalizedValue from PegaRULES.pr4_fieldvalue table.

Unfortunately this is not as simple as joining the tables.

Could someone please send a sample of how to build this query?

Thank you,

Paulo Brito

***Edited by Moderator Marissa to update platform capability tags****

Reporting Data Integration