Sort Editable Grid By Column Values

Question

Creating sortable columns in a read-only grid seems very straightforward, but I cannot figure out how to do this in an editable grid. I am trying to do this for a numeric decimal column, but would also like the grid to be sortable by multiple columns. Please let me know any suggestions or resources.

Drew Johnson · Answer

The sorting configuration for editable grid rows is not configured as a parameter from within a!gridLayout() itself. Sort the data outside of the grid component and then loop over the sorted items in the "rows" parameter of the editable grid. For example, if the data you want to sort is coming from a query, use the pagingInfo parameter of the query to sort the data appropriately before it is passed into the grid.

Mike Schmitt · Answer

You should be able to just run that query by itself and verify whether it comes out ordered the way you want.

Mike Schmitt · Answer

This is possible to do via workarounds like Drew mentions, but there's a reason the editable grid isn't inherently sortable by column - when the data within is actually editable, then trying to change the sort (while pending edits are in place, etc) is just a nightmare. Therefore I strongly recommend against this. If you need sorting, use read-only. If you need editable, then sort the data at the start in a manner that will be suitable until editing is completed.

Sort Editable Grid By Column Values

Top Replies