In table with editable grid ,on column heading we have filter .On applying filter it shows filtered rows ,but when we click on "Clear filter" it should show all the records ,but nothing is happening it displays filtered records only.
@SudhirC4 can you tell us what Pega version you are using?
The issue may be due to the grid control that you have - if you can provide screenshots of the data source used, and details of what the Tracer shows we may be able to comment more.
Also take a look at a possible option for you in this post.
This is how the grids work:
In a Grid control, select the Optimized Code checkbox.
Select the Personalize table checkbox.
Select the 'Save personalization automatically' checkbox.
Filter the table runtime on any column.
Sort the records on any column
Clear the filter
Perform a Refresh list action.
Explanation: for optimized grid : we support personalization filtering for multiple view grid only, Not for implicit grid (for which "save personalisation automatically" is not enabled) so if that is your configuration, then the current behaviour is expected because : step 1 - apply filter => grid state is not saved step 2 - sort the column => grid state saved (where sort & filter are applied) step 3 - clear filter => grid state is not saved step 4 - refresh section => persisted grid state is shown which is the state after step 2.