Allow DateTime columns to be sorted in chronological order
Currently in the Table and Asset Comparison Table symbol, data in columns can be sorted in numerical or alphabetical order.
For columns with timestamp format (e.g. DD/MM/YYYY), allow sorting of time stamps by the DateTime properly.
Menotti Aristone commented
The Asset Comparison table is currently just performing an alpha numeric sort as mentioned in our documentation so it actually doesn't work for all attribute values storing timestamps regardless of locale.
Since this is just really a numeric sort in this case it may appear as though attributes storing En-US timestamps are correct but that is just because in En-US months are represented first and there are not many multi-digit months. When sorting between days of the same month though this can still be mishandled as it sorts each digit individually so 17 can be sorted above 3 for example.
We would need some additional handling to account for sorting of timestamps so I though it would be best to add that as an enhancement request.
Hee Joo commented
Small correction to this enhancement request. Sorting also doesn't work even for English US timestamps.
John, yes I've discussed this with our PI Vision team. Since this feature is not supported, we decided that this is more suitable for enhancement request.
This seems more like a bug than a feature enhancement. Have you contacted support about this issue?