get the previous version of the particular record

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

I have a requirement, where i need to get the previous version of the particular record. I am importing data via Excel and data entities, the record imported is updating the existing records, I want to compare both the values (Previous and newly updated).

Please tell me, if there is any way to find that.

Thanks,

A.K.

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: get the previous version of the particular record

The previous version is not stored anywhere. If you want to compare, you should enable Database logging for the underlying table, for all the fields you wish to monitor. But please remember that database logging causes a performance price, and can consume a lot of database space, so you should not use it for transactional tables.
Verified answer

Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

RE: get the previous version of the particular record

If you don't have a copy, then the old version simply doesn't exist anymore and therefore you can't use it for any comparison.

Or do you mean that you want to compare data before actually updating the record (comparing data in a staging table with the actual entity data)?