Hi, we are using CR XI and our audit table holds old and new values that has been changed, deleted and added. We need to show which data has been changed/deleted/added under each heading. The data is stored as a long string and it looks something like this:
<Value label="OpeningDate"><OldValue /><NewValue>15/11/2010</NewValue><Value label="Cert Number"><OldValue>44369</OldValue><NewValue /><Value label="Country"><OldValue>UK</OldValue><NewValue />
The heading will always be after <Value label= and if there is no existing or new value, there will be a space in <OldValue /> or <NewValue />.
We would like to show the above example as:
OpeningDate
From: (Not set)
To: 15/11/2010
Cert Number
From: 44369
To: (Not set)
Country
From: UK
To: (Not set)
Any advise on how can we achieve this please ?
Thank you.
<Value label="OpeningDate"><OldValue /><NewValue>15/11/2010</NewValue><Value label="Cert Number"><OldValue>44369</OldValue><NewValue /><Value label="Country"><OldValue>UK</OldValue><NewValue />
The heading will always be after <Value label= and if there is no existing or new value, there will be a space in <OldValue /> or <NewValue />.
We would like to show the above example as:
OpeningDate
From: (Not set)
To: 15/11/2010
Cert Number
From: 44369
To: (Not set)
Country
From: UK
To: (Not set)
Any advise on how can we achieve this please ?
Thank you.