locked
How to run a business rule on member delete? RRS feed

  • Question

  • Hello,

    I currently built a workflow process that gets triggered on any data change on my entity member. When I delete a member no business rule gets executed. Anyone have any idea how to enforce business rules to run pre delete?

    or how to invoke a workflow on delete?

    Thank you!

    Iris

    Thursday, June 5, 2014 12:03 AM

Answers

All replies

  • You can use INSTEAD OF triggers to perform BEFORE trigger action. 

    more info:

    INSTEAD OF DELETE Triggers  BOL

    INSTEAD OF Triggers SQLMAG

    sample:

    Delete records within Instead Of Delete trigger


    sqldevelop.wordpress.com

    Thursday, June 5, 2014 4:56 AM
  • Hi Saeid,

    Thank you for your quick response. I have a few questions regarding MDS interaction with custom created triggers

    With MDS, wouldn't I need to put this trigger on every EN table? and if so when I make dynamic changes (via the UI) to the entity definition wouldn't the trigger that I just added mess up the default MDS capabilities of dropping the table and recreating it? and if it is successful in droping my table, how will can I auto generate the trigger?

    Thanks again!

    Iris


    Iris Abramovitz

    Thursday, June 5, 2014 3:09 PM