Question

Delete Data from multiple record types

Forum|Forum|4 months ago
March 16, 2026
8 replies
0 views

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.

revathis772076

Use a database stored procedure for deleting multiple records. This is more efficient than deleting records individually from Appian.

sarathkumr268295Author

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.

stefanhelzle0001

Did you check the record relationship configuration? For one-to-many, you can allow deletion of child records per the parent record.

sarathkumr268295Author

Hi Stefan

Its 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

shubhama926776

Why can't you use Delete from Data Store Entities smart service?

sarathkumr268295Author

Our application is fully made of records. We don't have any data store entities

shubhama926776

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.

Sign up

Login with SSO

Login to the community

Login with SSO