Hi pradeep,

Btw which version you are using..? In pega 7.1.6 there is operations tab where you can find check box of column sorting option.

Thanks N@gendra for the response. I am using Pega 7.1.7.

I am able to enable sorting on columns. But, I want one particular column to be sorted by default when the screen loads. Also, the sorting symbol which shows ascending/descending order should be visible on that column.

Basically, the above thing should happen without user intervention. Data should appear sorted to the user with sorting symbol visible on grid column.

Hi Pradeep,

The most efficient way is to have the Database Sort the Data for you before you even capture the Result Set in pxResults.  If you are using Embedded SQL in the RDB-List simply add an "Order By" clause to your Embedded DML Select Statement.

Regards,

Henry

Pega Academy

Hi ,

I am facing a problem on repeat grid that if I click on one of the column of the grid, my repeat grid (Data)disappers.

Kindly provide the solution if any.

Thanks.

Can you provide more details? how are you populating data?

If you are using pagelist, please check the clipboard to ensure data is available.

Hi Pradeep, 

yes i am using pagelist and I've my data in clipboard.

Actually on review screen it loads the data but when I click on one of the column it gets disappear.

and if refresh the page then it displays the grid with data.

I have a similar requirement to sort a particular column when the repeat grid is loaded. Its better to use the function @pxSortPageList(pagelist_name, column_name, ascending/descending) in the load data transform or in the pre activity of the screen.

HI,

After RDB retrieval can you try sorting the results in an activity using sort method?