Grid widget sorting issues
ThingWorx 9.3.4
Hello there,
We experience some issues with sorting columns in the Grid widget. Our grid displays data correctly and, in certain rows, some cells intentionally contain no values.
Because of the "undefined" values in the cells, the grid won't sort - e.g. date columns - or partly sort - e.g. number columns -.
When we try to sort on a date column containing "undefined" values, the error given on the client side is the following:

Columns with a number that also have some cells with "undefined" values start sorting some numbers, then shows an undefined value and the sorting restart with the following rows starting from a lowest value again.
What we expect is that "undefined" values are part of the sorting, so asc starts with empty values and desc puts empty values at the end.
Kind regards

