Modifying SQL Query for specific PDM Variables

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