Skip to main content
6-Contributor
October 6, 2023
Solved

Can not save the changed values on the Advance Grid feature

  • October 6, 2023
  • 1 reply
  • 10702 views

I cannot change the value of INFOTABLE during the Advance Grid feature of Thingworx 9.2.0.

 

The operation as follows;

1 create  a DataShape for INFOTABLE.

2 create a ThingShape includes INFOTABLE  properties defined by the created DataShape.

3 Create Thing and set default values in INFOTABLE properties.

4 Create a Mashup with Advance Grid Widget as follows.

  (1) Bind INFOTABLE to Data of Advance Grid Wiget by getProperties service.

 (2) set all columns to be editable on the setting grid column of Advance Grid Widget context menu.

 (3) check EnableEditButtons in Property tab of Advance Grid Widget,

5 show created widjet.

6 click the edit button.

7 change values of cells.

8 click the save button.

9 Chaned values are displyed on the grid, at this point, looks so good!

10  click edit button again.

11  cells are not changed.(same as default values)

Please show me something wrong.

Regards,

 

 

Best answer by Velkumar

Hi @DEV,YIDE,yoshi 

 

I can see the values are updating in DataTable. 

 

So here is the flow :

1. On Mashup open, Data loads from Property InfoTable

2. On Grid once value are updated. Data getting stored in DataTable

3. On Reload on Mashup, it will display Property InfoTable value only. Because you are updating DataTable not Property

 

I have added one more grid to compare DataTable Data and Grid Data. PFA

 

/VR

1 reply

19-Tanzanite
October 9, 2023

Hi @DEV,YIDE,yoshi 

 

Could you please post your Mashup Binding screenshot

 

/VR

6-Contributor
October 10, 2023

Hi, Velkumar

Sorry for the late reply. The screenshot is as follows.

DEVYIDEyoshi_0-1696899627644.png

Regards,

 

 

19-Tanzanite
October 10, 2023

Hi @DEV,YIDE,yoshi 

 

Based on the EditCellCompleted event from the grid I'm able to update values in DataTable. Please check trigger event for "AddOrUpdateDataTableEntries" service in your Mashup.

 

Velkumar_0-1696919108138.png

 

I have also attached sample entities for your reference.

 

/VR