custom sortingFn problem
How can I implement custom sorting logic where:
Numbers are sorted numerically.
Empty strings are placed at the end.
For example:
// asc [6,'',2,'',4] => [2,4,6,'','']
// desc [6,'',2,'',4] => [6,4,2,'','']
// false [6,'',2,'',4] => [6,'',2,'',4]
const sortStatusFn: SortingFn<Order> = (rowA, rowB, _columnId) => {
// not working
const statusA = rowA.original.status;
const statusB = rowB.original.status;
if (statusA !== '' && statusB !== '') {
return statusA > statusB ? 1 : -1;
}
if (statusA === '') return 1;
if (statusB === '') return -1;
return 0;
};
However, within the function, I seem unable to determine whether the current sorting mode is 'asc', 'desc', or 'no sorting'.
Code:
https://stackblitz.com/edit/vitejs-vite-f47e9f?file=src%2FTestTable.tsx
Numbers are sorted numerically.
Empty strings are placed at the end.
For example:
// asc [6,'',2,'',4] => [2,4,6,'','']
// desc [6,'',2,'',4] => [6,4,2,'','']
// false [6,'',2,'',4] => [6,'',2,'',4]
const sortStatusFn: SortingFn<Order> = (rowA, rowB, _columnId) => {
// not working
const statusA = rowA.original.status;
const statusB = rowB.original.status;
if (statusA !== '' && statusB !== '') {
return statusA > statusB ? 1 : -1;
}
if (statusA === '') return 1;
if (statusB === '') return -1;
return 0;
};
However, within the function, I seem unable to determine whether the current sorting mode is 'asc', 'desc', or 'no sorting'.
Code:
https://stackblitz.com/edit/vitejs-vite-f47e9f?file=src%2FTestTable.tsx
