Eui: [EuiDataGrid] Allow sorting on hidden columns?

[myasonik]

Right now, DataGrid does not allow sorting on hidden columns as during intial development we were trying to keep both the component and the UX fairly lean.

Right now, I'm working on a proof of concept on integrating DataGrid into Discover and I found myself seeing this capability as a nice feature-add. I can very easily imagine users wanting to sort by, let's say, order_id, but not actually care what the value is just that they're in order.

Adding to that, there's kind of a way to do this in Discover today but it's very limited and kind of obscure. You can hide the Time column in Discover through Advanced Settings but the table is still sorted by Time. You just have limited control on this all and it's obfuscated through Advanced Settings.

Because of how clear and simple (imo) the DataGrid toolbar is, I think we could support this feature pretty easily and enable folks to further customize their tables.

CC @chandlerprall @snide

[myasonik]

@AlonaNadler Do you recall if this has ever been an actual feature request or is this just my own assumptions on how people might like to use it?

[AlonaNadler]

I haven't heard of this request. The only feature I can think of it being useful is maybe timestamp where you want the docs to be chronological without the need to see the timestamp, this is a niche

[github-actions[bot]]

👋 Hey there. This issue hasn't had any activity for 180 days. We'll automatically close it if that trend continues for another week. If you feel this issue is still valid and needs attention please let us know with a comment.

[myasonik]

@kertal @chandlerprall I don't know if this is still a valid/worthwhile request...

[kertal]

for me it's more a Discover issue that we can clean up once we get rid of the legacy table

[myasonik]

Going to close this then and let someone reopen if it's needed