Skip to main content
5-Regular Member
November 9, 2023
Solved

Grid widget sorting issues

  • November 9, 2023
  • 1 reply
  • 2304 views

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:

jvandijklely_0-1699540677490.png

 

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

 

Best answer by 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

1 reply

17-Peridot
November 10, 2023

Is it possible to post sample entities here?

5-Regular Member
November 10, 2023

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.

TonyZhang16-PearlAnswer
16-Pearl
December 29, 2023

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