Question

4
Replies
320
Views
Paulo Brito (PauloB18)
Sunlife Financial

Sunlife Financial
CA
PauloB18 Member since 2019 4 posts
Sunlife Financial
Posted: December 11, 2019
Last activity: February 4, 2020
Posted: 11 Dec 2019 16:12 EST
Last activity: 4 Feb 2020 8:44 EST
Closed

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.