11 Replies Latest reply on Feb 5, 2014 5:16 PM by Walter Bednarz

    SQL table that identifies file name and location in archives

    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