Posted: 18 Oct 2016 9:39 EDT Last activity: 19 Oct 2016 8:30 EDT
How to convert a list view with a customised getContent activity into Report Definition
I have few list views with customized getContent activities which I need to convert into Report Definition for upgrading from 7.1.7 to 7.2.1. These type of list views with customized getContent activity cannot be converted to RD using the wizard. How can I convert the list views and implement the logic of the customized getContent activity in the Report Definition?
***Updated by moderator: Lochan to update Categories***
I think wizard will not be able to handle it. You will need to do it manually and leverage SQL functions which can be added to report definition to generate similar SQL's which the customized getContent activity was generating.
Thanks Kalinga! But how can we customize the SQL generated by the RD as it is done from the OOTB Final activity pxRetrieveReportData. Also, in the customized getContent activity, we are doing some Page-Copy and Property-Set which we need to handle as well.
Probably the question to ask is, why was the customization needed as part of the List View getContent activity? If the customization is very specific to the application, is list view the right place to do it since you are talking about page-copy and property-set. Also, is the generated SQL by list view not functionally correct or is not performant enough that you had to customize? If yes, did you try checking what report definition generates?
It depends on the complexity of the SQL in your custom getContent. Even in the custom getContent, if you were simply referencing ContBuilder APIs, then it should still be feasible easily for conversion. But if the SQL was handwritten, based on the complexity of the SQL, adopting it to report definition might vary. There is no easy way out here.
In this regard, do we have any extension point in pxRetrieveReportData where we can add the customized-application-specific-getcontent-activity. Since the activity "pxRetrieveReportData" itself is final, we can't incorportate the custom-data-retrievals in RD.