0 Replies Latest reply on Feb 14, 2017 6:25 AM by Jeremy Ferguson

    SQL build a view that organizes information

    Jeremy Ferguson

      Hello

      I am trying to build a view that organizes information about each document (file) to give me one record for each document with things like, document ID, title, revision (not version) current work flow state and so on.

      The attached code works until I start pulling values from the “VariableValue”, table when I start getting multiple rows.

      I look forward to any help I can get