Is there an easy way how to run DELETE FROM Xy or better TRUNCATE TABLE Xy in the workflow step? I need to delete all records from the table Xy before creating new records.
If you don`t care about data audit log, you can create a stored procedure in which you can execute any SQL statements you want.
Then you call it by running a DataService.ExecuteProcedure method.
1 Like