Discussion
CGI
IN
Last activity: 27 Jul 2022 5:15 EDT
Important: Retain column filter on repeated grid after Refresh
We have a repeating grid, where we can filter on columns. We have a filtered data and opened the case to work on it.
Requirement: After closing the case, repeated grid {list/records} should be refreshed and filter should not be cleared.
I have gone through the below links, it does not solve our requirment.
Thanks in Advance!
Updated: 27 Apr 2022 16:38 EDT
Blue Rose Technologies GmbH
BE
Hi ,
As you can see in the links , it has been considered as the product enhancement request.If you would like to follow up on an enhancement request please contact your Account Executive.
Please see the below link for more information :
Thanks.
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
IN
Hi Rajasekhar,
As per the current design, we will not be able to retain the filtered records state on refresh. This is an enhancement and as Akshay suggested please contact your Account Executive for further details on the same.
Best Regards,
Mounika
Updated: 27 Apr 2022 16:38 EDT
Techmahindra
IN
Hi Rajasekhar,
Have you used the action item List->Refresh instead of refresh section. I believe this is the only work around being provided.
However even in the latest PRPC 7.2 version it behaves the same and I believe is not an issue but an expected behaviour. On refresh of the section always the behavior is to clear the filters or sorts in the grid.
As per FDBK-17427 it is still pending with project managment for them to decide in furture releases only considering it being a valid usecase.
Please check if you can refine your business usecase.
Regards,
Shanthini Charles
Wipro
IN
@Shanthini_Charles Hi Shanthini, I am also facing the same issue where in a grid, I am using checkbox for each row. When the checkbox is checked, I need to automatically check the checkbox in other rows as well based on some condition. I was doing refresh section on checkbox however, the filters getting removed when checkbox is checked or unchecked. I tried using refresh list, its working fine but the check box in other rows is not getting checked. When I manually refresh the entire section its working fine. How to resolve the issue?
Attaching screenshots
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Thanks for your detailed example.
Our requirement is:
We have a repeating grid to display my work list on dashboard, where we can filter on columns.
Step 1: Filter records in my work list, click on filter icon on column header.
Step 2: Open the case to work on it.
Step 3: Close the case after working, it will display my work list on dash board.
Requirement: After closing the case, when my work list is displayed on dash board, it should be Auto refreshed and filter should not be cleared.
Issue: my work list on dashboard is not auto refreshed, same case i.e. opened and worked by user is displayed, when user clicks the same case, it displays error on UI. Since case is moved from his work list.
Thanks for your detailed example.
Our requirement is:
We have a repeating grid to display my work list on dashboard, where we can filter on columns.
Step 1: Filter records in my work list, click on filter icon on column header.
Step 2: Open the case to work on it.
Step 3: Close the case after working, it will display my work list on dash board.
Requirement: After closing the case, when my work list is displayed on dash board, it should be Auto refreshed and filter should not be cleared.
Issue: my work list on dashboard is not auto refreshed, same case i.e. opened and worked by user is displayed, when user clicks the same case, it displays error on UI. Since case is moved from his work list.
|
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
IN
In the above attachment, I have used a button to refresh it.
Can you try using hover or onFocus on grid element to trigger the same action.
That will at lease refresh the grid wen you hover/gain focus of it and will get you rid of above error.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Thanks.
At grid level event, don't have Hover or onFocus event.
We are using Pega 7.1.7.
Client is expecting to refresh the my work list grid on close of case i.e. my work list is displayed on close of case.
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
IN
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
We do understand, it is expected behavior in Pega.
Could you please guide us about custom script or anything to fulfill business requirement to achieve UX.
Updated: 27 Apr 2022 16:38 EDT
Cognizant Technology Solutions
US
can be achevied by copying the parameter page on sort and page filtering to a temporary page (i.e in pypregridudpate activity except at the time of initial load which can be checked by temppage pageexists condition)and restoring it back again on click of refresh by copying the temporary page back to parameter page and running an activity called doGridAction will retain the filters and sorting.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Thanks...
Can someone help in details steps for below statement
"can be achevied by copying the parameter page on sort and page filtering to a temporary page (i.e in pypregridudpate activity except at the time of initial load which can be checked by temppage pageexists condition)and restoring it back again on click of refresh by copying the temporary page back to parameter page and running an activity called doGridAction will retain the filters and sorting."
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Can someone help in details steps for below statement
"can be achevied by copying the parameter page on sort and page filtering to a temporary page (i.e in pypregridudpate activity except at the time of initial load which can be checked by temppage pageexists condition)and restoring it back again on click of refresh by copying the temporary page back to parameter page and running an activity called doGridAction will retain the filters and sorting."
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Can someone help in details steps for below statement
"can be achevied by copying the parameter page on sort and page filtering to a temporary page (i.e in pypregridudpate activity except at the time of initial load which can be checked by temppage pageexists condition)and restoring it back again on click of refresh by copying the temporary page back to parameter page and running an activity called doGridAction will retain the filters and sorting."
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Can someone help in details steps for below statement
"can be achevied by copying the parameter page on sort and page filtering to a temporary page (i.e in pypregridudpate activity except at the time of initial load which can be checked by temppage pageexists condition)and restoring it back again on click of refresh by copying the temporary page back to parameter page and running an activity called doGridAction will retain the filters and sorting."
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
IN
Hello Rajasekhar,
When you use grid you use a mechanism to source the data. Let s say you are using a report defintion.
Now obviously, to fetch the data from backend, it forms a SQL query which internally go and fires at backend to retrieve the data.
When you apply filter, then the query gets modified with a where clause so that it gets only that set of data which you want.
What we meant by parameter page is the one where the where conditions get defined.
If you run tracer while applying filter, you can easily detect the page which holds that where clause.
Next, if you go to grid configuration, under the Operations tab- Advanced configuration, you will have an option to define Run activity before grid update
Use a custom activity there and use that filter parameter page to twig the loading behavior.
Note : This is just my assumption and i have not tried it in house. You can follow this and share the result here.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Thanks Santanu,
We tried below steps
- Page-copy of pyFilterCriteria to Temp Page in pyPreGridUpdate activity, Precondition param.gridAction=="FILTER"
- From button click, Calling Refresh this section and activity, which Page-copy from Temp Page to pyFilterCriteria and called pzdoGridAction.
It is not working. Need help.
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
IN
Hello
Have you passed the filter condition to your source via pre activity ?
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Could you please elaborate "passed the filter condition to your source via pre activity".
We tried below steps
- Page-copy of pyFilterCriteria to Temp Page in pyPreGridUpdate activity, Precondition param.gridAction=="FILTER"
- From button click, Calling Refresh this section and activity, which Page-copy from Temp Page to pyFilterCriteria and called pzdoGridAction.
Please share the steps details ASAP.
Thanks
Updated: 27 Apr 2022 16:38 EDT
EY
CA
Hi,
When you apply the filter on the grid, did you check the name. It is actually not the exact name pyFilterCriteria.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Thanks
Yes, it is suffix to pyFilterCriteria. It depends on how we populate the grid e.g. pyFilterCriteria_D_QueueItems_pxResults_QueueItemsAll_1
Please share the steps for solution.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution............
Please share steps also......
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Long pending query..............
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
Infosys
US
Just a thought if you can use "Refresh List" on Grid , instead of doing a "Section Refresh" . I didnt read through all of the posts but thought it might help !.
Thanks ,
Nis
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Long pending query..............
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
CGI
IN
Long pending query..............
In current design of Pega, it is not supported. Can someone share the work around solution ASAP............
Please share steps also......
Thanks in Advance.
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
US
Hi Rajasekhar
I am sorry, but unfortunately, there is no local change that could be offered.
If you'd like, you can request an enhancement request on your behalf and then explain to your account executive why this is important to your use case who can then speak to Pega product management. In any case, there is no guarantee that the enhancement would be worked upon on the same release as yours or offered in a time frame that you may want.
Bhuvana.
Updated: 27 Apr 2022 16:38 EDT
Pegasystems Inc.
US
Hello!
This is related to FDBK-17427 (as referenced in an above comment) and this post has been referenced in our enhancement system. Please take this feedack id and bring it to your Account Executive for next steps.
Thanks!