I could use some help with creating a report. I have the report setup to work on a single "built-in" file, but I want the code to point to the Selected files area in the report generator. Any help is appreciated as I don't know SQL.
@[RevisionDataOfSelectedFiles]
§Name [RevisionData of the selected files]
§Company [SolidWorks]
§Description
[This query will list the revision data of the selected files.]
§Version [1.0]
§Arguments
[
]
§Sql
[
SELECT TOP (1) Documents.DocumentID , Documents.Filename, Documents.LatestRevisionNo AS 'LatestVersion', UserRevs.RevNr AS 'RevisionVersion', UserRevs.Comment AS 'Revision'
FROM Documents INNER JOIN
UserRevs ON Documents.DocumentID = UserRevs.DocumentID
WHERE (Documents.Filename LIKE '%9200-004141%')
ORDER BY UserRevs.RevNr DESC
]
SolidworksSolidworks Pdm enterprise Pdm