How to Show Report from a Page List coming from a data page
I have a requirement, where I am fetching live data from a different system through Connect REST via a Data page; hence I am able to store them in a clipboard page list property and show them in a repeat grid layout in the UI. But now I need to show charts based on those data.
Is there a way to show charts without storing these page list values in a pega databse?
Basically I want to show charts based on data page page list response values sourced from a Connect REST.
***Updated by moderator: Lochan to add Categories***
We can achieve this requirement by an activity configured either on post-processing of data page invocation or once the data is available on the clipboard as a page list.
In the activity, call Page-Copy method to copy content from Page-List in another page list of the different class with same hierarchy. Then, obj-save can be called to save the content in the mapped table.
Once the data is available, you can configure a report definition with required columns.
Hope it helps you or gives you an idea to achieve your requirement, if it does kindly notify.
Thanks for your response; but in your approach also you are asking me to save the values into a Pega DB table either through obj save or some oother appproach. That can be done, I understand; but I want to show live values coming from the REST service in a particular case.
Suppose for a Case1, today 3 sets of values are coming from the service. As per your approach I am mapping these 3 sets of values for Case 1 in a particular Pega Data table. Now after 2 days the same service returns 2 sets of values for that particular Case1. In that scenario, as per your approach it would still show the 3 sets of values previously stored in the table. I want to show live values from the REST service (directly from the clipborard pagelist properties without actually mapping in the Pega data table) and also want to reduce the overhead of saving the values in Pega db -- is it possible / feasible? If so, how?
I understand your problem, my approach suggested was a tweak by utilising existing OOTB functionalities.
Have you tried flushing the data page content by using "Reload once per interaction" It will make the application to invoke the data page content every time. But challenges here is, we have to map the data to pagelist property and subsequently saving it in Pega data table and then running a report definition to get the chart. And it's obviously an overhead.
Though any time, we can take a feedback/enhancement request to include the functionality to have chart option for data pages as well. And it's subject to product owner's review. Please let us know if you want an enhancement request raised.