Last activity: 4 Oct 2018 11:08 EDT
Grid default sorting on a column
In repeat grid, is there an option to sort a column when data is populated. Also, I want to show the sort symbol to be displayed on the column header.
I am populating the grid with pxResults from RDB-List from external data source.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
COGNIZANT TECHNOLOGY SOLUTIONS
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 [email protected] 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.
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.
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.
Can you provide more details? how are you populating data?
If you are using pagelist, please check the clipboard to ensure data is available.
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.
@UnmeshK2 is this issue resolved for you , what would be the fix for this.
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.
Can you please give snapshot where can i use this function. I have similar requirement to change the default sorting in a repeating grid. And this repeating grid is getting loaded with a data page
After RDB retrieval can you try sorting the results in an activity using sort method?