Date display vs. sorting

[aeberhart]

The FAQ suggests to do date or currency formatting on a SQL level:

How can I format dates or currency in tables? This can be done on the database query level. If you're using PostgreSQL for instance, this query will format the "born" and "salary" columns accordingly (assuming their database type is date and int): select to_char(born, 'DD-MON-YYYY'), cast(salary as money) from employee.

This breaks table sorting because the type is "string" rather than "date"

[aeberhart]

There are a couple of options:

• provide a hint (much like how we do this for images, etc): https://dashjoin.github.io/platform/latest/developer-reference/#display
• introduce the concept of query metadata for expressions also
• introduce a global setting for how dates are to be formatted
• use DateField (https://marmelab.com/react-admin/DateField.html) based on dbType

[aeberhart]

Issues:

• support date, time and datetime inputs and display
• in JSONata expressions, support date, time and datetime
• support sorting of data that is displayed via helper objects