I have come up with a rough query to solve this. It could be optimized further to present a few bits in a more clear way:
inner join Vault.dbo.Documents
on Vault.dbo.VariableValue.DocumentID = Vault.dbo.Documents.DocumentID
where vault.dbo.variablevalue.VariableID like 'variablewhichisduplicate' and Vault.dbo.VariableValue.ValueCache like 'duplicatevariablevalue'
Note that 'vault' is the name of the file vault.
I just tumbled upon the same problem, but I'm not able to transform your query to a .crp file to use the report generator tool. Corey Vantilborg would you mind sharing your code with me?
Hello, I would recommend searching the Knowledge Base - try solution S-033897 or S-063649. Regards, Joy
Thanks Joy, S-033897 worked perfectly fine for me!