Skip to main content
Jan 28, 2024 9:09 PM UTC
Solved

Thingworx Data Table Query is not working after Insert

I created a Data Table that is populating a grid, but when I insert an especific item in the Data Table the grid doesn't show it, despite the item have been created in the Data Table. After I reload the page the item is finally shown,  and now I can create the items normally, and they gonna be shown in the page normally after the The Service Invoke Complete os the service insert.

I don't know why the first insert don't query in the page.

Jan 31, 2024 1:35 PM UTC

I solved the problema by create an expression with this command (TW.location.reload), and after all insert this expression is invoked reloading the page automatically. It wasn't visually strange and solved my probleme of not displaying all data in the grid. I just turned off the box "ShowDataLoading" of grid properties to not show the reload icon all the time.

9 replies

Jan 29, 2024 5:21 AM UTC

Hi @GABRYEL25770 

 

Could you please post your mashup bindings ?

 

/VR

Jan 29, 2024 12:43 PM UTC

GABRYEL25770_0-1706532024521.png

GABRYEL25770_1-1706532045981.png

I created other service to query just to test something, but the result is the same. Note that I am binding the output in a Grid and a TreeGridAdvanced, and in the TreeGridAdvanced worked fine. Looks like a bug in the Grid.

Jan 30, 2024 4:43 AM UTC

Hi @GABRYEL25770 

 

Mashup Bindings looks good.

 

Could you please check if the query service is executed after Insert Service in the browser developer tool?

 

Also please share the Data Table Processing Subsystem stats

Velkumar_0-1706589715456.png

 

/VR

Jan 29, 2024 5:52 AM UTC

Bind service invoke complete event of insert to getGridData service, and check all other bindings are correct.

Jan 29, 2024 12:46 PM UTC

Think I did it right, I posted some photos of my bidings in Velkumar's Reply, but I think is a Grid bug because the services worked fine in a TreeGridAdvanced.

Feb 1, 2024 12:24 PM UTC

Yes, your binding was correct, you may also try toggling CookiePersistence property, sometimes it does help.

GABRYEL25770AuthorAnswer
Jan 31, 2024 1:35 PM UTC

I solved the problema by create an expression with this command (TW.location.reload), and after all insert this expression is invoked reloading the page automatically. It wasn't visually strange and solved my probleme of not displaying all data in the grid. I just turned off the box "ShowDataLoading" of grid properties to not show the reload icon all the time.