In some use cases it is required not to physically delete the row from database but instead update a FLAG e.g delete_FLAG = 'Y' to hide rows from user. So, if you are not familiar with the framework then you might take a long route to do the task which could easily be done by declarative steps.
In this post we will do the following.
- We will add history columns in entities.
- We will have a view criteria to display only DELETE_FLAG = 'N' rows.
- On deletion in detail table we will delete logically.
- We will update the History columns of Master entity as modified by and modified_date.
Download the sample code
More info in this video