Skip to main content
1-Visitor
March 20, 2020
Solved

Using Advanced Grid to delete a datatable row

  • March 20, 2020
  • 1 reply
  • 3142 views

I have a simple datatable thing that I am populating and editing successfully with the advanced grid. I am not able to get the widget to delete rows. The datatable does have a primary key. Can someone please tell me how to get this working? I am on v8.5 sp4, and I have seen other threads that say this was a bug that has been fixed in this version. ( cc @slangley )

 

I have tried binding

selected rows ->DeleteDataTableEntry
selected rows -> DeleteDataTableEntries

deleted table ->DeleteDataTableEntry

deleted table-> DeleteDataTableEntries

 

None of those seem to work. 

 

Thanks in advance.

Best answer by slangley

Hi @jbaute.

 

Another internal case was opened for this issue.  The fix versions are 9.0, targeted for June, and 8.5.7, targeted for July.

 

For workarounds:

 

  1. Try adding the column name ID to get the delete functionality to work
  2. Use the DeleteDataTableEntryByKey service available in the datatable thing.  You'll need to add a button or some other mechanism for triggering the event.

Regards.

 

--Sharon

1 reply

Community Manager
March 20, 2020

Hi @jbaute.

 

This issue was addressed in ThingWorx 8.5.4.  Which version are you running?

 

Regards.

 

--Sharon

jbaute1-VisitorAuthor
1-Visitor
March 20, 2020

@slangley 

8.5.4-b222

slangleyCommunity ManagerAnswer
Community Manager
April 9, 2020

Hi @jbaute.

 

Another internal case was opened for this issue.  The fix versions are 9.0, targeted for June, and 8.5.7, targeted for July.

 

For workarounds:

 

  1. Try adding the column name ID to get the delete functionality to work
  2. Use the DeleteDataTableEntryByKey service available in the datatable thing.  You'll need to add a button or some other mechanism for triggering the event.

Regards.

 

--Sharon