Preview   |   SOLIDWORKS User Forum

 PDM SQL Query Issue
Guy Edkins   |  1 month ago
Open in Forum   

All you need is a 3DEXPERIENCE ID.

I have a SQL query (below) that returns the latest revision of parts and assemblies. It returns NULL for revisions for items that have been checked out in the released state and checked back (new version) thereby missing the actual rev of the file that indeed has a rev. How can I tweak the SQL call to capture the actual current rev with versions that appear after the stamped rev?

Declare @Aroba Int

You are not authorized to view this page No results found! Suggestions: Check spelling, try a different search, or browse topics below.