[Original]

[former_member283645]

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!!

Thanks

Eva

[Former Member · Accepted solution]

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.

Regards,

Shaailesh.

[former_member283645 · Accepted solution]

Thanks, Points awarded

Eva