Skip to main content
June 2, 2022
Solved

Action Button to delete an item from de Record, but not from the DataBase

  • June 2, 2022
  • 4 replies
  • 0 views

Is it posible to configure the action button "Delete Item" so it just deletes that item from the Record, but not from de Database? Do I do that from the process model?

Thank you!

Best answer by gopalk2865

HI, In your table you can have a  column called "IsActive" and once user clicks on delete then just make it as false. 

4 replies

gopalk2865
Participating Frequently
June 2, 2022

HI, In your table you can have a  column called "IsActive" and once user clicks on delete then just make it as false. 

stefanhelzle0001
Brainy
June 2, 2022

I do not understand you question. The record is just a representation of the data in the database.

konduruc733182
June 3, 2022

All the data that is being displayed in your record is representation of your data present in the database. Any action you perform on the record data will definitely have effect on the DB. Updating and Deleting actions are something to that we use only to make changes in the database. Instead you can try to hide the data from the record using filters.

christineh465186
June 3, 2022

Create your record with a default filter to filter out the records that have been soft deleted (some DB column indicating deletion)

https://docs.appian.com/suite/help/22.2/records-filter-source-data.html#default-filters