Datagrid: Custom Sorting for DataGrid with Date and Icon

[infor-mahesh]

Is your feature request related to a problem or use case? Please describe.

The current implementation of the DataGrid doesn't includes cells that display both a date and an icon sorting. The default sorting mechanism is set to sort by date, but the sorting results are inaccurate, likely due to the presence of the icon alongside the date. This affects the usability and accuracy of the data presentation in the DataGrid.

Describe the solution you'd like

I require the implementation of a custom sorting mechanism that accurately sorts the DataGrid by date while ignoring the icons.

Additional context

[tmcconechy]

@infor-mahesh we might need an example for this to get it right. Is the data really date format (ISO String ect?) How did you implement the column?

[infor-mahesh]

Hi @tmcconechy ,

If we use formatter: Soho.Formatters.Date in the data grid, we only get the date value. However, our requirement is to display both the date and an icon. To achieve this, we created a custom method that appends the date and icon, and then adds it to the data grid.

The problem we are facing is that, since this is appended and not using the default formatters, we are encountering issues with sorting. Therefore, we need a formatter that can handle both the date and icon so that sorting functions correctly without any issues.

Thank you.

[tmcconechy]

@infor-mahesh i sort of get it but it would help if you can provide a basic example (even if it doesnt work yet). So we know what data ect to expect