Data Store Entities Smart to Truncate Table

Question

Hello, 
 We are using Data Store Entities Smart to delete all data from a table. Problem is that id have to be provided of what have to be deleted. And if the number of thoose id's is bigger the services does not work. Is there a way to delete all the records inside table ? Or to delete them by other identification which is not the primary key. For example delete all records which have column name "status" = 2. 
 
 This way we will achieve the deletion of big portions of data. Or the other option is truncate table if it is available ?

Chitra Sharma · Accepted Answer

You can do it by creating a stored procedure that include query to be executed and run that stored procedure from Appian wherever required. This way you will have no limitation on input value length and you can provide multiple input to filter in procedure like status=2 etc.

Data Store Entities Smart to Truncate Table

Top Replies