https://community.ptc.com/t5/ThingWorx-Developers/Grid-not-showing-all-rows-returned-for-Thingworx-9-6/m-p/1013760#M69680 <P>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.</P> Fri, 02 May 2025 20:16:29 GMT JustinOberle1 2025-05-02T20:16:29Z https://community.ptc.com/t5/ThingWorx-Developers/Grid-not-showing-all-rows-returned-for-Thingworx-9-6/m-p/1013760#M69680 <P>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.</P> Fri, 02 May 2025 20:16:29 GMT https://community.ptc.com/t5/ThingWorx-Developers/Grid-not-showing-all-rows-returned-for-Thingworx-9-6/m-p/1013760#M69680 JustinOberle1 2025-05-02T20:16:29Z https://community.ptc.com/t5/ThingWorx-Developers/Grid-not-showing-all-rows-returned-for-Thingworx-9-6/m-p/1013975#M69686 <P>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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JO_9930585_0-1746455121601.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/122524i8EF6EA524326E188/image-size/medium?v=v2&amp;px=400" role="button" title="JO_9930585_0-1746455121601.png" alt="JO_9930585_0-1746455121601.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JO_9930585_1-1746455153063.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/122525i1E835DE393712E08/image-size/medium?v=v2&amp;px=400" role="button" title="JO_9930585_1-1746455153063.png" alt="JO_9930585_1-1746455153063.png" /></span></P><P>&nbsp;</P> Mon, 05 May 2025 14:26:19 GMT https://community.ptc.com/t5/ThingWorx-Developers/Grid-not-showing-all-rows-returned-for-Thingworx-9-6/m-p/1013975#M69686 JustinOberle1 2025-05-05T14:26:19Z