Preview | SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
WBWalter Bednarz04/02/2014
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