Skip to main content
12-Amethyst
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.

12-Amethyst
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

19-Tanzanite
Jan 29, 2024 5:21 AM UTC

Hi @GABRYEL25770 

 

Could you please post your mashup bindings ?

 

/VR

Translate
12-Amethyst
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.

Translate
19-Tanzanite
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

Translate
10-Marble
Jan 29, 2024 5:52 AM UTC

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

Translate
12-Amethyst
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.

Translate
10-Marble
Feb 1, 2024 12:24 PM UTC

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

Translate
GABRYEL2577012-AmethystAuthorAnswer
12-Amethyst
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.

Translate