Skip to main content
6-Contributor
Oct 6, 2023 3:20 AM UTC
Solved

Can not save the changed values on the Advance Grid feature

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,

 

 

VelkumarAnswer
19-Tanzanite
Oct 12, 2023 5:49 AM UTC

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

15 replies

19-Tanzanite
Oct 9, 2023 6:08 AM UTC

Hi @DEV,YIDE,yoshi 

 

Could you please post your Mashup Binding screenshot

 

/VR

Translate
6-Contributor
Oct 10, 2023 1:01 AM UTC

Hi, Velkumar

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

DEVYIDEyoshi_0-1696899627644.png

Regards,

 

 

Translate
19-Tanzanite
Oct 10, 2023 6:27 AM UTC

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

 

Translate