Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
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
Is it possible to post sample entities here?
I created three entities to reproduce this issue;
You can see the issues with the sorting when clicking on the sort buttons in the column.
Date won't sort at all, which generates the console error on client side and the number and integer will restart sorting after every undefined row.
This is a known issue and fixed in TWX 9.2.11, 9.3.7 and 9.4.0