Using Advanced Grid to delete a datatable row

[jbaute]

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.

[slangley]

Hi @jbaute.

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

Regards.

--Sharon

[jbaute]

@slangley 

Thingworx Software Version8.5.4-b222

[slangley]

Hi @jbaute.

Can you please provide your recreation steps, mashup, and supporting entities?  We need to test it and validate, and possibly open a new case with R&D.

Regards.

--Sharon

[jbaute]

Thanks @slangley 

Attached is a simple test project. The mashup I'm using to test is the jmb_Activites2_mu

[slangley · Accepted solution]

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

[slangley]

Hi @jbaute.

ThingWorx 9.0 has just released.  ThingWorx 8.5.7 is targeted for release on July 21.

Regards.

--Sharon

[slangley]

Hi @jbaute.

ThingWorx 8.5.7 was recently released.

For the benefit of others on the community, please mark the appropriate response on this thread as the Accepted Solution.

Regards.

--Sharon