Question
HCL
SG
Last activity: 19 Feb 2017 22:58 EST
Optimizing inherited property
We have a requirement to optimize a property which is inherited from parent class.
Scenario:
We have created a page property in our work class, and the page definition is Org-FW-DivFW-Data-ABC. We have property "propOne" in Org-FW-DivFW-Data. Since this property "propOne" is inherited it is not shown in App explorer of work class. We have a requirement to optimize this property since it is being used in report definition.
Issue:
Since this property is not shown in App explorer, we are not able to optimize this property. If we open the property directly and try to optimize it, we are not able to see the work class in the 'Optimized for classes' list in the Property Optimization tool. If we could have seen the inherited property also in the app explorer, we could have optimized the property without any issues.
Accepted Solution
IN
Could you try external mapping to the property and adding it as a column in the database.
You can also go through the below link for more details.
https://collaborate.pega.com/question/how-optimize-parent-class-property-sub-class-table
Pegasystems Inc.
US
Hi Bharath,
You can try with the pzOptimizeAProperty Activity inorder to optimize your property as shown in attachment.
Regards,
Mahesh
Pegasystems Inc.
US
Hi Bharath,
I had checked the availability of the activity pzOptimizeAProperty in the Pega 7.1.7 as shown in attachment.
Regards,
Mahesh
HCL
SG
Hi Mahesh,
We tried to optimize inherited property using pzOptimizeAProperty Activity, it failed with error.
Error:
Fail: Unable to generate ALTER statement(s): Type Not Supported for property: .CorporateAction.PaymentDate : code: <none> SQLState: <none> Message: <none>
Please find attached the screenshot for input values for pzOptimizeAProperty activity.
CorporateAction is a page of type Org-FW-DivFW-Data-ABC in work class. And .PaymentDate is a property inherited from Org-FW-DivFW-Data.
Please let me know how I could optimize these kind of inherited properties.
Pegasystems Inc.
US
Hi Bharat,
Could you enable the Debug for DB queries in the tracer setting and provide the tracer file of the use case for our further investigation, also share the full stack trace of the error from the log file.
Thanks
Mahesh
Pegasystems Inc.
US
Hi Bharat,
I had cross checked with our product specialists and came to know that this kind of requirement is not supported by Pega it seems.
Regards
Mahesh
Pegasystems Inc.
US
Hi Bharat,
Even though you do the changes at the database level, we are not sure about the engine code how it will act on those changes. Moreover this kind of requirement is not supported by Pega as per the information from product specialists due to some side effects.
Regards
Mahesh
Accepted Solution
IN
Could you try external mapping to the property and adding it as a column in the database.
You can also go through the below link for more details.
https://collaborate.pega.com/question/how-optimize-parent-class-property-sub-class-table