Describe the bug
i need to transform the data to show to the user.
Eg from YYYY-MM-DD to DD/MM/YYYY,
from usd 10.99 to usd 10,99.
Anyway, to order i need to use de original data ( a date or decimal number), to filter i need to use the transformed data or both.
dont exist a property in the row with columnId to return the transformed data (row.original, row.getValue and row.renderValue just return the original data).
i tried to pass the transformed data thru accessorFn: row => formatDate(row.field), but with this approach, i lose the original data in order function, and ordering with transformatted data gives me a wrong ordenation.
how to solve this problem?
Your minimal, reproducible example
https://codesandbox.io/s/nice-ishizaka-s2n6mw?file=/src/App.tsx
Steps to reproduce
create a row
{
header: "name",
accessorKey: "nameKey",
cell: ({getValue}) => formatDate(getValue())
},
// this option i lose the formatted data to filter
or
{
header: "name",
id: 'nameKey',
accessorFn: row => formatDate(row.date),
},
// this option i lose the original data to order
const formatDate = (date: string | Date, format?: string) => {
// console.log("date", date)
format = format || 'dd/MM/yyyy';
return dateFormat(toDate(date), format);
};
Expected behavior
order by original data and filter by transformed data
How often does this bug happen?
Every time
Screenshots or Videos
No response
Platform
all Operating System and Browsers
react-table version
8.9.3
TypeScript version
5.2.2
Additional context
No response
Terms & Code of Conduct
Describe the bug
i need to transform the data to show to the user.
Eg from YYYY-MM-DD to DD/MM/YYYY,
from usd 10.99 to usd 10,99.
Anyway, to order i need to use de original data ( a date or decimal number), to filter i need to use the transformed data or both.
dont exist a property in the row with columnId to return the transformed data (row.original, row.getValue and row.renderValue just return the original data).
i tried to pass the transformed data thru accessorFn: row => formatDate(row.field), but with this approach, i lose the original data in order function, and ordering with transformatted data gives me a wrong ordenation.
how to solve this problem?
Your minimal, reproducible example
https://codesandbox.io/s/nice-ishizaka-s2n6mw?file=/src/App.tsx
Steps to reproduce
create a row
{
header: "name",
accessorKey: "nameKey",
cell: ({getValue}) => formatDate(getValue())
},
// this option i lose the formatted data to filter
or
{
header: "name",
id: 'nameKey',
accessorFn: row => formatDate(row.date),
},
// this option i lose the original data to order
const formatDate = (date: string | Date, format?: string) => {
// console.log("date", date)
format = format || 'dd/MM/yyyy';
return dateFormat(toDate(date), format);
};
Expected behavior
order by original data and filter by transformed data
How often does this bug happen?
Every time
Screenshots or Videos
No response
Platform
all Operating System and Browsers
react-table version
8.9.3
TypeScript version
5.2.2
Additional context
No response
Terms & Code of Conduct