Skip to main content
G
GABRYEL2577012-Amethyst
12-Amethyst
January 28, 2024
Solved

Thingworx Data Table Query is not working after Insert

  • January 28, 2024
  • 3 replies
  • 2803 views

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.

Best answer by GABRYEL25770

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.

3 replies

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
January 29, 2024

Hi @GABRYEL25770 

 

Could you please post your mashup bindings ?

 

/VR

G
GABRYEL2577012-AmethystAuthor
12-Amethyst
January 29, 2024

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.

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
January 30, 2024

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

    J
    j_akhtar10-Marble
    10-Marble
    January 29, 2024

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

    G
    GABRYEL2577012-AmethystAuthor
    12-Amethyst
    January 29, 2024

    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.

    J
    j_akhtar10-Marble
    10-Marble
    February 1, 2024

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

    G
    GABRYEL2577012-AmethystAuthorAnswer
    12-Amethyst
    January 31, 2024

    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.

    Terms & ConditionsCookie settingsAccessibility statement