ds-blue-logo
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