https://docs.appian.com/suite/help/23.1/Delete_from_Data_Store_Entities_Smart_Service.html#:~:text=The%20Delete%20from%20Data%20Store%20Entities%20Smart%20Service%20lets%20you,node%20input%20of%20type%20EntityDataIdentifiers.
Hello,
we using Delete From Data Store Entities smart service to delete a nested entities up to 2 levels with cascade All option
Data seems to be deleted fine from main entity as well as nested entities , but record types seems to be not synced.
If I use queryRecord - I'm still seeing deleted data from cascaded record , but if I use query dataStore entity deleted record not returning as expected .
Appian documentation says automatic sync is supported on on nested CDT's until 1000 rows, my tables have less than 1000 rows in total - any thoughts ? ..
Discussion posts and replies are publicly visible
Hi there, I believe that your record needs to get synced, after deletion of the data from the database.There are two ways you can sync the record, one is to manually sync the record using the sync option inside the record type, and the other one is using the smart service "sync record" in the process model just after "delete from the datastore entity" smart service.
The original poster mentioned that they have used the "Delete From Data Store Entities smart service" which is also mentioned in the screenshot you have attached.
Thank you for pointing out the mistake. It's corrected now, SIR!
Thank you both for the reply, manual sync is not a option for us. I have 2 levels deep nested CDTs, Does Sync Records smart service support nested Records ?
AFAIK it should work for nested records. In the sync record smart service, it requires an identifier of the record to sync the data, so just pass the correct identifier for the records. Also, one smart service syncs a single record's data so if you want to sync multiple records then add smart services accordingly.Please go through the below link for more informationdocs.appian.com/.../Sync_Records_Smart_Service.html