Can not save the changed values on the Advance Grid feature

[DEV,YIDE,yoshi]

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,

[Velkumar]

Hi @DEV,YIDE,yoshi 

Could you please post your Mashup Binding screenshot

/VR

[DEV,YIDE,yoshi]

Hi, Velkumar

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

Regards,

[Velkumar]

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.

I have also attached sample entities for your reference.

/VR

[DEV,YIDE,yoshi]

Thanks, your information, but  I could not find out "EditedData" in the widget context menu as below;

Something wrong? 

And an  attached file "UpdateGridSample" is not imported by error message "Entity import failed" at "Application Log".

Regards;

PS; the current version: Thingworx 9.2.0

[Velkumar]

Hi @DEV,YIDE,yoshi 

Please find entities developed in Thingworx 9.2

No that is completely fine. You can pass EditedTable to AddOrUpdateDataTableEntries service

/VR

[DEV,YIDE,yoshi]

Hi, Velkumar,

Thank you for your advice.

I changed the "EnableEditButtons TRUE" from "isEditable" to clear the edit operation.

please check the following the binding screenshot.

The operation and results as follows;

(1) Click "Edit" button, "Add", "Save" and "Cancel" buttons are appeared at the same location.

(2) Add a row data like "A", "1", "c"

(3) Click "Save" button.

(4) The added row is cleared, also no data in INFOTABLE in DATA TABLE thing.

(5) But it looks like work well at the screen log like below.

(6) This is correct or something wrong? Or I need add the create new service for "Edit Completed " event?

by the way, I am tring to import your file.(Sorry it takes time to understand!)

[DEV,YIDE,yoshi]

binding screen shot as follows;

PS; same as previous replied.

[Velkumar]

Hi @DEV,YIDE,yoshi 

It should be "EditCellCompleted' not 'EditCompleted'

/VR

[DEV,YIDE,yoshi]

Hi, Velkumar

(1) changed the property "IsEditable TRUE" from EditEnableBottton TRUE".

(1)  changed to "EditCellCompleted" from "EditCompleted"".

(2) changed the cell value from "1" to "1111".

(3) check  Infortable value of DataTable.

(4) it is not changed.

Regards,

[Velkumar]

Hi @DEV,YIDE,yoshi 

If possible could you please share your entities

/VR

[DEV,YIDE,yoshi]

Hi, Velkumar

Please check the attached 3 files.

regards,

[Velkumar · Accepted solution]

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

[DEV,YIDE,yoshi]

Hi, Velkumar

Thank you so much for your advice and your time to give me.

Now Really, I understood INFOTABLE and DATATABLE are completely different.

So I change the service from "getProperties" to "getDataTableEntries" to show data.

Now I can change and see the chaged  values after reread Web browser

 button.

May I ask a completely different question as bellow?

(1) I delete the all Infotable Property in gridDataTable in my sample Entity.

(2) Still I can see the all of records, that's not strange because now I reffer the Datatable not property.

So, my question is "How to initialize(reset) the related DataTable"

if you have a time, please show me how to resolve it.

Best Regards,

[Velkumar]

Hi @DEV,YIDE,yoshi 

You can use PurgeDataTableEntries Service to completely clean / reset DataTable. 

Please refer this link for DataTable Services - https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/DataTables/DataTableServices.html

/VR

[DEV,YIDE,yoshi]

Hi, Velkmar

Thank you so much for your suggestion.

Everything cleared about my problem.

Thank you Again!

Regards,