[Table] Multi-sort feature enhancements

[davidicus]

What package is this for?

• React
• Angular

Summary

These are copied from comment thread from this PR. There are many good suggestions to enhance the usability of this feature. The PAL design team will be taking a look at the existing spec and will take these features into consideration in their finalized spec.

• If existing sorts exist, and I click the triple dot on a column that is not already sorted then it should add a new row and set that selected column in the dropdown.
• Perhaps if I clicked a table column that is NOT sorted it might remove all other sorts, although I expect that customers would likely expect that action to just add another sorted column automatically.

[davidicus]

@dianatran18 FYI. These are some comments regarding enhancements to multi-sort that we should consider when design looks at this pattern.

[JordanWSmith15]

Relates to #2399

[kevinsperrine]

@davidicus @dianatran18 These two additions were brought up by Sean in the original review. How should we handle these?

If existing sorts exist, and I click the triple dot on a column that is not already sorted then it should add a new row and set that selected column in the dropdown.

This one seems feasible. It could also happen if no sort exists, because the first sort option could be set to which-ever column they clicked the three-dot menu and chose multi-sort from.

Perhaps if I clicked a table column that is NOT sorted it might remove all other sorts, although I expect that customers would likely expect that action to just add another sorted column automatically.

Personally, I would expect clicking sort on a column that does not have multi-sort would sort by that column and clear the sorting on other columns.