Grid widget sorting issues

[jvandijk@lely]

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

[Sathishkumar_C]

Is it possible to post sample entities here?

[jvandijk@lely]

I created three entities to reproduce this issue;

• a mashup with just a Grid widget and every column is sortable,
• a datashape containing columns for a date, number, integer and string,
• and a thing with a service called GetInfotable which returns an infotable with some random data and three rows with undefined cells.

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.

[TonyZhang]

Hi jvandijk@lely 

This is a known issue and fixed in TWX 9.2.11, 9.3.7 and 9.4.0

https://www.ptc.com/en/support/article/CS380956