0 Replies Latest reply on Oct 24, 2013 4:09 AM by Jeremy Ferguson

    Getting data from the “Variable Value” table

    Jeremy Ferguson

      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? 

       

      thanks