none
[MDS] use business rule to set 2 attribute as composite and must be unique on one entity

    Question

  • Hi All,

    As title, I have an entity which include 3 attributes (COMPANY, TEAM, COUNT) as below,

    ------------------------------------------------------

    COMPANY TEAM COUNT
    APPLE HR 100
    APPLE CS 50
    APPLE OM 200
    IBM HR 90
    IBM CS 40


    ------------------------------------------------------

    And I know business rule can set action for unique check, but what I want is to check COMPANY+TEAM should be unique, not just one attribute check.

    Please advise if any solution, thanks in advanced.

    BR,

    Jackie


    • Edited by Jackie_tw Thursday, July 11, 2013 9:22 AM
    Thursday, July 11, 2013 9:20 AM

Answers

  • Hello,

      You can definitely set this up. I attached a screenshot of a hypothetical scenario where AppGroup and AppId must be unique in combination. For my example, as a condition I chose to check business rule whenever there is a change on either of the fields (OR). You may omit the condition altogether if you like. Action is "must be unique" and in action properties there is an option to make an attribute unique in combination with another attribute (or multiple attributes).

    HTH,

    Alex


    Tuesday, July 23, 2013 2:33 PM