AnsweredAssumed Answered

SQL table that identifies file name and location in archives

Question asked by Walter Bednarz on Feb 4, 2014
Latest reply on Feb 5, 2014 by Walter Bednarz

Is there a way to identify where a file is and what it is named in the archives via sql tables?  I am trying to create a SQL query that list documents with their vault path, archive name, and archive location. This is what I have so far.

 

 

SELECT Documents.Filename, Projects.Path

FROM Documents JOIN

DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID JOIN

Projects ON Projects.ProjectID = DocumentsInProjects.ProjectID

WHERE Documents.Deleted = 0

ORDER BY Documents.Filename

Outcomes