Starting workflow on delete action
I am updating another table in the database whenever an attribute value is changed (insert, update, delete) in the master data table.
To perform this action, I have created a business rule (with event as "has changed") and it triggers a workflow to perform the table update. Sadly, the business rule is not triggered whenever a value is deleted in the master data table. Therefore
the other table in the database is inconsitent.
Can you please provide me a way on how to modify the business rule and trigger the workflow whenever a record is deleted in MDS.
Thanks in advance!
The "has changed" only apply to attribute update. Currently, there is no way to trigger the business rule for soft or hard delete member.
To sync the MDS table to another table, the best option is expose the MDS entity to subscription view and use SQL merge to merge it into another table.