SELECT TOP (1000) [VariableID]
,[DocumentID]
,[ProjectID]
,[RevisionNo]
,[ConfigurationID]
,[ValueText]
,[ValueInt]
,[ValueFloat]
,[ValueDate]
,[ValueCache]
,[IsLongText]
FROM [EPDM].[dbo].[VariableValue]
where documentid = 7208
order by configurationid
This is apparently showing also deleted - non existing configurations. How can I filter out only existing configurations?
edit:
I assume I must match [DocumentRevisionConfiguration].[RevisionNo]
SolidworksSolidworks Pdm/enterprise Pdm