AnsweredAssumed Answered

Getting data from the “Variable Value” table

Question asked by Jeremy Ferguson on Oct 24, 2013

Hi I am new at reporting so I am looking for guidance on the best way to approach this problem.


I have a SQL statement that fines all the document belonging to a project and the workflow state that they are on, this gives me a results set of document IDs and Current state IDs.


I now need to look in the “Variable Value” table for things like document number, title, revision and so on my problem is I do not know the best way to get the data from the “Variable Value” in a format that is usable that is row by document?