RevisionNo in the VariableValue table is how you find the latest version of a value that was entered on a data card as they can change from version to version. You also have to take into consideration which variable and configuration when reviewing the raw data. Below is a sample of a the Revision variable in different versions of a document.
Thanks for the quick reply.
The report shows a historic configuration of the file that had the duplicate value when the file was added to the vault. The configuration that the report refers to was deleted. So now there is no configuration under the given name in the oring-2-155 but the report still shows it? Why?
From my understanding, the report should show the current state of the desired variable, at the top most updated level.
Also, if I have different configurations with same unique value, will the setting the unique value in the vault will still work or will it give an error?