Looking for service to delete DataTable entries with specific column matched values
Ex : delete ExampleDataTable where columnX ="some value"
Tried which is deleting all the records. This is expected.
When I try to use DeleteDataTableEntries from DataTable > Services , getting the message 'Must have a datashape defined to add rows...' . Created the DataTable on data shape only but still getting the message.
I was just testing a similar service that deletes DataTable entries based on the value of one or more collumns. In my scenario, I have a data table with a Username (primary key), email address and subscription date. When a user executes this service, he or she will be deleted from a subscription list. I used only two collumns out of three to delete the entry but I am sure it works only with the primary key.
I used the service
and my code looks something like this:
var values = Things["BlogSubscribersTable"].CreateValues();