Discussion

Add new columns to pr4_rule_vw in 7.1.8

We are using custom rule type in our project extensively. We have report definition running on Data-Rule-Summary (table pr4_rule_vw ). Now we are trying to add additional column to pr4_rule_vw table. Before 7.1.8 , pr4_rule_vw table are controlled by database triggers. After 7.1.8 , looks like pega engine handles data population to pr4_rule_vw table.

We creted 2 property :- one under Rule- and one under Data-Rule-Summary and created corresponding database column in pr4_rule and pr4_rule_vw. When we create the new custom rule, pr4_rule table gets populated whereas the pr4_rule_view table didnt get populated. Is there any steps

Do we need to follow any steps apart from above whenever we need to add additional columns to pr4_rule_vw table (since it is handle by pega engine after 7.1.8 upgrade)?

Thanks,

Nagarajan Kadhiresan

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
February 2, 2016 - 9:03am

You no need to perform any steps. Pega 7 will take care all custom rule types after upgrade.

February 18, 2016 - 5:13pm

pr4_rule_vw has the metadata of the rules and columns which are most common between the rules. 

Why do you want to have the rule type specific properties in the pr4_rule_vw table?

You can modify the report to read the data from the custom rule type specific / mapped table.