Skip to main content
1-Visitor
September 13, 2022
Question

How to save the edited grid data in the table of database?

  • September 13, 2022
  • 1 reply
  • 2898 views

Hi,

 

I have done the following binding, but still the edited data is not saving in the data base, the binding I have given in the below picture.

 

could you provide some solution?

 

Thanks in advance

1 reply

16-Pearl
September 13, 2022

You need to pass EditedTable to your Table_Update service. The table will contain the modified data which you need to do with what you need:

 

nmutter_0-1663103068783.png

Most likely you also just want to call the Table_Update service on EditCompleted event (not on all events you have configured in the screenshot).

 

Also see:

AdvancedGridsProperties.html "EditCompleted" and "EditedTable"

 

Hope that helps!

Priyatosh1-VisitorAuthor
1-Visitor
September 14, 2022

HI @nmutter ,

 

Thanks for the reply.

 

I was trying to bind as you said and after binding the grid is not editable.

 

I have attached the binding picture here, kindly go through it and provide me a solution.

 

Thanks in advance

16-Pearl
September 15, 2022

I dont see that "EditedTable" is bound and passed to the Table_Update service of yours. Maybe this post will help https://community.ptc.com/t5/ThingWorx-Developers/Editing-an-grid/m-p/514615/highlight/true#M11105 .