Require sorting in every column in editable grid.

Question

I am already know populating data through Rule expression with sort in one column. 
 My requirement is to sort every column in editable grid. 
 Is there any way to do the same.

Mike Schmitt · Answer

Sorting on columns is only supported (directly) in the Read-Only grid component. In general, having columns dynamically sortable in an Editable Grid is not a very good idea, as it can cause stuff to get shuffled around in a way that will be very hard to debug and support. What is your use case?

Dave Lewis · Answer

Make all the gridLayoutHeaderCell labels null, or empty string "". Then create an extra rowLayout and recreate all of your headerCell labels as rich texts. A new richTextDisplayField for each column. Now, you can not only have much tighter controls on the display of your headers (it won't look exactly the same, and maybe that's better). You'll ALSO have the ability to add dynamic links and icons! You can use that to change the sort of the pagingInfo of the datasubset you use to build the grid. Make sure it's a rule input or a refresh variable and you should be set. If you want to, you can even attach up arrow and down arrow icons to the end of your rich text ersatz header. 
 That's going to put you through a lot of work to reimplement the same functionality you had on a Paging Grid, but it's doable.