How to add js used in ListView to Report Definition
Hi,
My project is on Pega 6.2 SP2 based on Pega CPM framework, I am facing troubles with a list view.
The newly designed code uses a join of 3 tables in the listview, the 3rd of which is an index table. However as the index table doesnt have a specific service item entry, the list view doesnt load when we open an item from the worklist which has that specific service item in it.
I am planning to get rid of the Index table in this listview, and create a Report Definition instead(as in a report, we can use properties inside the blob as well and need not expose them).
Now my only worry is replicating the onclick behaviour of the listview. We have used a js file in the listview where we have configured behaviours such as single click, double click and onloa function.
As far as I know, I cant add that JS file in the report I am making.
One thing I have in mind is to create a repeating grid, use the report I am making as its source and then configuring single click, double click and onload on the grid but that would require design level changes and the UI might change resulting in bad customer reviews.
Can anybody please help me with it?
Accepted Solution
Pegasystems
IN
>> I am planning to get rid of the Index table in this listview, and create a Report Definition instead(as in a report, we can use properties inside the blob as well and need not expose them).
This is not recommended. Access to the BLOB columns in report definition will lead to severe performance degradation when compared to optimized columns.
Please read this carefully before going ahead with your change - https://docs-previous.pega.com/when-use-and-when-not-use-unoptimized-properties-reports
Pegasystems Inc.
IN
Hi Rajiv Nistala,
Thanks for your reply. What can I do in my scenario in that case?
One thing I thought of was to keep using the list view, expose the properties I am using from the Index table in the work table, and use declare expressions to copy the properties to the work class ones.
Should I go ahead with this? Please let me know if you can think of any other way which I can use to get my task done?
This is a production issue and I need to act on it as quickly as possible.
Pegasystems
IN
This looks relevant - https://pdn.pega.com/forums/user-interface/singledouble-click-report-definition
I am not a UI expert. I just wanted to highlight the performance implications of directly using BLOB columns in reports.
Updated: 14 Apr 2016 7:38 EDT
Pegasystems Inc.
IN
Thanks for your reply.
This post about report is the same approach I have mentioned in the post. Thanks.
I was aware of the performance implications of directly using the BLOB but wanted to give that a try and check how much of a performance impact are we getting. But after reading the first article you posted, will probably refrain from using it.
Pegasystems Inc.
IN
Hi,
My original query is still not answered.
I had a listview which I am trying to convert to a report definition. Now I need to configure single and double click functions which I had configured through a js file in the list view. How can we achieve that in Report definition. Please help.
I have figured out where to call scripts on single click and double click but dont where to keep the js script. Can you please help?