Hi all,
I have this query that returns file names, file path and workflow state of files in the Vault that posted in this thread:
SELECT P.Path As 'Project Path', D.Filename AS 'File Name', S.Name AS 'Status Name'
FROM Projects AS P INNER JOIN
DocumentsInProjects AS DP ON P.ProjectID = DP.ProjectID INNER JOIN
Documents AS D ON DP.DocumentID = D.DocumentID INNER JOIN
Status AS S ON D.CurrentStatusID = S.StatusID
Where (S.Name LIKE '%') AND D.ObjectTypeID <> 0
Order By S.Name ASC
I was wondering if anyone could point me in the right direction to show specific variables like Revision, Description, etc..
I tried this:
select documents.Filename, status.Name, LatestRevisionNo
from documents
join status
on status.StatusId = documents.currentstatusid
But it doesn't return the Revision I expected
Any advice would be much appreciated!
SolidworksSolidworks Pdm/enterprise Pdm