locked
Model Domain attribute as NUMERIC datatype RRS feed

  • Question

  • I have an attribute which has a set of allowable integers as accepted values (domain values). I could model it using domain based entity but both Name and Code are Text data types by default and cant be changed. I think this is a limitation of MDS 2012 where we can achieve the results but with a workaround. Any suggestions?


    Thanks, Ashish Singh

    Sunday, December 29, 2013 1:45 PM

Answers

  • You could have another Numeric column in your Domain based Entity that is truly a number. 

    Name      Column   MyNumber

    'One'            '1'         1             (quotes to show its a string)

     

    Then you would have Business Rule Access to this Column from the main Entity.  (  when you expand the domain based entity in BRs you will see all fields inside of the child entity, in the example above you would see MyNumber)

    If used by BR then you are done.

    If you wanted to sort on this or filter just in UI , you could (ok I know not the best but) create another numeric column and set it to the value via Business Rule from the underlying Domain Based entity value.


    Friday, January 10, 2014 10:36 PM