cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Using Advanced Grid to delete a datatable row

jbaute
4-Participant

Using Advanced Grid to delete a datatable row

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.

1 ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:jbaute)

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

View solution in original post

7 REPLIES 7
slangley
23-Emerald II
(To:jbaute)

Hi @jbaute.

 

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

 

Regards.

 

--Sharon

jbaute
4-Participant
(To:slangley)

@slangley 

8.5.4-b222

slangley
23-Emerald II
(To:jbaute)

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
4-Participant
(To:slangley)

Thanks @slangley 

 

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

slangley
23-Emerald II
(To:jbaute)

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
23-Emerald II
(To:slangley)

Hi @jbaute.

 

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

 

Regards.

 

--Sharon

slangley
23-Emerald II
(To: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

Top Tags