defaultSorted cannot sort more than one column

[ebfg]

Describe the bug
Only the first column of the defaultSorted array is considered. I see #717 was closed, but neither the documentation nor the linked example contains two columns in defaultSorted.

codesandbox
https://codesandbox.io/embed/react-bootstrap-table-next-basic-example-69nq0

Note that the second sort column is on price descending, so the row with id 2 should be displayed first.

In general, the expected behavior here is that the table is first sorted by name, and then for items with the same name, they should be ordered by price in descending.

Happy to provide more examples as needed.

[AllenFang]

@ebfg the reason I give defaultSorted as an array is I was considering the flexibility for multi sort. but so far I still don't have time to implement multisort which mean, sort can be only applied on single column.

I will consider to implement multi sort but it's low priority for me. anyway, PR is also welcome. thanks

[ebfg]

#1088

[jonrandahl]

While this may not be the preferred answer, you can also sort your data before it's sent to the table component?
data.sort((a, b) => (a.col1 > b.col1 ? 1 : a.col1 === b.col1 ? (a.col2 > b.col2 ? 1 : -1) : -1));

If it helps anyone else... :)

[jdhankins]

I have had success by concatenating object key values together into a single hidden field, then using that field as the defaultSorted object. It's kind of a hack, but works in some instances.