Hello,
I would like to programatically validate that content staging between two environments was successful. What Im looking for is some sort of "hash" (http://en.wikipedia.org/wiki/Hash_function) of an individual piece of CMS content (Document, Object, etc) which represents that content at a specific point in time.
What I would
like to do (pseudo code):
# in env1
select distinct DocumentGUID,hash from dbo.CMS_Document where DocumentId in
(select TaskDocumentId from dbo.Staging_Task);
# perform content staging from env to env2 via CMS Desk
# in env2
foreach myDocumentGUID,myhash:
select hash from dbo.CMS_Document where DocumentGUID = myDocumentGUID
if hash != myhash
# myDocumentGUID did not sync correctly
fi
Im considering using DocumentModifiedWhen which will tell me that a change has been made, but it doesnt confirm that the change was correct.
Thanks