We have a requirement to delete data from multiple records ie., almost 30+ records. Seems like we can pass data of only one record type at a time while trying to delete using delete records smart service which increases the number of process variables. Is there any optimized way of deleting data from these many number of records ?? We are trying to query each record individually since the number of records to delete at a time can be high more than 100 which is more than the number of related records that can be queried.
Discussion posts and replies are publicly visible
Use a database stored procedure for deleting multiple records. This is more efficient than deleting records individually from Appian.
Did you check the record relationship configuration? For one-to-many, you can allow deletion of child records per the parent record.
The reason why we didn't proceed with stored procedure is it will be difficult to debug which data has been deleted. So that's why we thought of doing it inside appian so that we can have the ids in the process variables.
Hi StefanIts not straight forward as it seems but will give it a try. The reason why we want to delete separately is so that we can track what all ids are being deleted for debugging purpose
Why can't you use Delete from Data Store Entities smart service?
Our application is fully made of records. We don't have any data store entities
You can still create a Datastore and Entities for this requirement for better performance. You don't need to use this in your process, but you can use it in this scenario to work dynamically and efficiently without the record delete limit.
Will check with the team. Thanks Shubham