Skip to main content
Known Participant
October 27, 2022
Question

delete data store entity

  • October 27, 2022
  • 4 replies
  • 5 views

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
October 27, 2022

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
October 27, 2022

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
October 27, 2022

okay can you please share the screenshot