AnsweredAssumed Answered

Non existing configurations filter

Question asked by Damir Galic on Mar 26, 2020

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]

Outcomes