Table Viewer - Support sorting columns

[snlwih]

Is your feature request related to a problem? Please describe.
When viewing the contents of a table, I want to be able to quickly sort records in one or more columns.

Describe the solution you'd like
Provide an option in the Table Viewer to specify which columns should be sorted

Environment
SAS version: SAS 9 and SAS Viya

[scottdover]

I've take a look at how we may handle this, and I believe it to be possible with AG Grid Community edition. Here are the changes I foresee:

• Update columnDefs to have attribute sortable: true. This will allow you to sort one or more columns
• Add the onSortChanged callback to our AG Grid instance. Within that function, we're able to call event.api.getColumns()
  • Each column has a sort attribute that we can use to contruct a query for the backend to give us new results

[scottdover]

This has been merged into main and will ship with 1.18.0