Skip to main content
sarathkumr268295
Known Participant
Mar 16, 2026 12:42 PM UTC
Question

Delete Data from multiple record types

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.

8 replies

revathis772076
Participating Frequently
Mar 16, 2026 3:27 PM UTC

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

sarathkumr268295
Known Participant
Mar 17, 2026 4:25 AM UTC

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
Brainy
Mar 16, 2026 3:32 PM UTC

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

sarathkumr268295
Known Participant
Mar 17, 2026 4:34 AM UTC

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
Brainy
Mar 17, 2026 5:05 AM UTC

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

शुभम्
sarathkumr268295
Known Participant
Mar 17, 2026 5:32 AM UTC

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

shubhama926776
Brainy
Mar 17, 2026 5:35 AM UTC

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.

शुभम्