Skip to main content
Known Participant
Oct 27, 2022 5:33 AM UTC
Question

delete data store entity

Hi Can anyone help me to understand what is in below screenshot?


How can I delete the data in db in this case, I wanted to delete product table row and corresponding rows from Product quantity table which is having pId = Product table ID

Product table -  ID, pName

Product_Quantity_table - ID,pId(foreign Key),Quantity

4 replies

Participating Frequently
Oct 27, 2022 5:47 AM UTC

Hi, if we have the foreign key relationship and if we delete the parent row child rows will be deleted automatically please check this  https://docs.appian.com/suite/help/22.3/Delete_from_Data_Store_Entities_Smart_Service.html

Known Participant
Oct 27, 2022 6:17 AM UTC

I got it Thanks,

But I don't know how to configure delete data store entity, When i try to configure ,the configured item dissappears after saving

Participating Frequently
Oct 27, 2022 6:25 AM UTC

okay can you please share the screenshot