Allow deselecting a sorted column in EuiTable

[cjcenizal]

Per elastic/kibana#14687 (comment), we want the ability to display rows inside of a table in the order in which the API provided them.

In terms of UX, I think we can accomplish this by allowing the user to click on a column to cycle through sorting on that column, sorting on that column reversed, and then deselecting it to use the default order of the items.

[nreese]

@cjcenizal Here is how we have implemented deselecting sort in the dashboard app with EuiBasicTable. It would be really nice to have native support so we don't have to duplicate this logic everywhere.

https://github.com/elastic/kibana/blob/master/src/core_plugins/kibana/public/dashboard/listing/dashboard_listing.js#L146

  onTableChange = ({ page, sort = {} }) => {
    const {
      index: pageIndex,
      size: pageSize,
    } = page;

    let {
      field: sortField,
      direction: sortDirection,
    } = sort;

    // 3rd sorting state that is not captured by sort - native order (no sort)
    // when switching from desc to asc for the same field - use native order
    if (this.state.sortField === sortField
      && this.state.sortDirection === 'desc'
      && sortDirection === 'asc') {
      sortField = null;
      sortDirection = null;
    }

    this.setState({
      page: pageIndex,
      perPage: pageSize,
      sortField,
      sortDirection,
    });
  }

[chandlerprall]

@snide @cchaos do other table implementations have a common UX pattern for deselecting the sort column?

[thompsongl]

Just noticed this issue.
Fairly certain #1591 added the requested functionality and would be available >=9.0.0

[snide]

Yep. Let's close it out. Feel free to open if that is not the case.