AnsweredAssumed Answered

SQL build a view that organizes information

Question asked by Jeremy Ferguson on Feb 14, 2017

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

Attachments

Outcomes