Skip to main content
J
JO_993058514-Alexandrite
14-Alexandrite
May 2, 2025
Solved

Grid not showing all rows returned for Thingworx 9.6

  • May 2, 2025
  • 1 reply
  • 423 views

I have verified that the service is returning 24 rows of data, but when viewing the mashup, only 4 rows display. Oddly enough, even in the mashup designer, inside the grid widget, it shows all of the data coming in correctly. Has this problem been seen before? I even tried creating a new mashup and new grid and re-binding everything. It is the same result. Clearly, the Chrome dev tools network tab shows 24 rows being returned, but only the last 4 are displayed in the grid for some reason.

Best answer by JO_9930585

The issue is the property IDFieldName is defaulted to "id" and I have a column named "id". This seems to override any primary key on the datashape, and thus it was only displaying 1 row for every id that exists. Interestingly it shows in composer just fine. The solution is to remove the "id" from this property.

JO_9930585_0-1746455121601.png

JO_9930585_1-1746455153063.png

 

1 reply

J
JO_993058514-AlexandriteAuthorAnswer
14-Alexandrite
May 5, 2025

The issue is the property IDFieldName is defaulted to "id" and I have a column named "id". This seems to override any primary key on the datashape, and thus it was only displaying 1 row for every id that exists. Interestingly it shows in composer just fine. The solution is to remove the "id" from this property.

JO_9930585_0-1746455121601.png

JO_9930585_1-1746455153063.png

 

    Terms & ConditionsCookie settingsAccessibility statement