AnsweredAssumed Answered

Database view one row per document

Question asked by Jeremy Ferguson on Aug 21, 2020
Latest reply on Aug 26, 2020 by Wayne Matus

I would like to build a SQL View looking at a PDM vault where each document in the vault is represented as one row. Each row showing the most up to date information for that document or what I would see if I went to the document did a “Get Latest Version”. The problem I have is that I always end up with multiple rows for each document. 

Outcomes