Skip to Content
avatar image
Former Member


HI all,

In assignments dialog box - Fields - i can see a option called ''Original''.

it shows the same fields of the table.

i tried the following expression.

-my table has 2 fields name and test(to write the result of my assignment)

-two records

-name has spg code , mc

IF(IS_NULL([Original].Name),"no value", "has value")

once i executed this expression, the result was - 'no value'

But my Name field has 2 records in it.

B/W i executed this expression again by selecting fileds->name instead of fileds-> original -> name

and it showed me the right output ; 'has value'

can anyone let me know what is the actual use of ''Original'' option!!!!

can you explain with the above example!!



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2010 at 12:07 PM

    Hello Eva,

    Concept of Original comes into play when you are using checkin/checkout on records.

    Checkout action will create two copies of same record.

    Original record will remain as it is; and it will be blocked for modification.

    New copy of the same record will be available for modification.

    Checkin action will write all the modifications made on copy record back to original record.

    'Original' option in assignment tab provide access to original record values.

    For example: 'Original' option can be used for detecting change in any particular field.

    IF(Original.Name = Name,"no change", "changed")

    Checkin/checkout is very good feature of MDM when used with MDM workflows.

    Please refer DataManager guide for further explanation of checkin/checkout operation.



    Add comment
    10|10000 characters needed characters exceeded