Question
Morgan Stanley
IN
Last activity: 28 Feb 2017 11:38 EST
How to optimize parent class property in sub class table
How do i optimize a parent class property which is visible in sub class through inheritance.
PS: Parent and Child classes point to different tables
Pegasystems
IN
Please refer to this help topic - https://community.pega.com/sites/default/files/help_v72/procomhelpmain.htm
Morgan Stanley
IN
Thanks Rajiv.
Would this utility populate the columns as well just as the optimization wizard does?
Pegasystems
IN
This only creates the column. You should use the column population utility to get the data populated.
Morgan Stanley
IN
We actually have a requirement to optimize around 6 properties in our implementation layer tables. There properties are coming from our horizontal layer class which points to a different table and that too none of the properties are marked as required in column inclusion.
Is there any way that i optimize all the properties and also populate all the columns?
Accepted Solution
Updated: 19 May 2016 9:34 EDT
Hi Avinash,
As discussed the parent table was mapped to default table pr_other and currently expose cols has limitation that the class should not be mapped to pr_other and should have dedicated table. Generally the best practice is to have dedicated table.
Also we have an EPIC (linked to the post above) that was coming up may be we can address this issue in that EPIC.Below are the two solutions that can be considered.
1) Create a same property in the child class with same as parent class. Optimize and delete the property from the child class. (Preferred approach).
2) Map the parent class to dedicated table.Optimize the property and drop the table.
Morgan Stanley
IN
The issue is that the Modify Schema wizard does not show up properties from the parent class as they are not marked as required in Column inclusion. And that too these properties are from our horizontal and hence locked.
Bank of Novascotia
CA
Check if this article is of any help.
https://community.pega.com/support/support-articles/top-level-property-not-populated-exposed-column
Basically, the solution mentioned is :
"To explicitly listing the newly optimized property on the external mapping tab of the class(es) it was optimized for."