Business Rules - preventing values from being NULL RRS feed

  • Question

  • Hi all,

    I want to create a business rule to prevent a certain field from having NULL values and raise an error or restore previous value in that case.

    I have tried the rule "is required", which really prompts a validation error when NULL values are inserted. But although the entity isn't validated, the value in the field remains NULL.

    For example: I have a model called "Company", entity called "Contract" and an attribute called "Category". Assume row ID #3 has "Category = High". When I apply the business rule "Category is required" on "Contract" entity and then delete the Category value of row ID #3, there is a validation error but Category value of row ID #3 remains NULL which is no good.

    Is there a way to restore previous value or throw an error to the user in case NULL value is inserted? I want to completely prevent values from being NULL, even if the entity has not been validated.

    Thanks in advance,


    Sunday, September 4, 2016 7:29 AM


  • Hi Ron,

    Business rule validation doesn't prevent edits , it flags the member as invalid. I have tested the scenario you mentioned. Unfortunately, it is not supported by MDS Business rules now, we will track the requirement and will consider it in our future plan .

    Please let me know if you have any other questions related to this scenario .



    Tuesday, September 13, 2016 3:45 AM