I'm trying to set up a list for search cards that is derived from SQL database. The list should select distinct values of a specific variable ("CurRevECO" ).
It works, but it brings back only some of the values. looking into it, I noticed that it does'n't select values from the @ sheet (drawings).
Is there a way to select values from all configurations \ sheets?
Alternatively, is there a way to select values only from @ configuration?
this is the SQL code I'm using:
SELECT DISTINCT VariableValue.ValueCache
FROM Documents INNER JOIN
VariableValue ON Documents.DocumentID = VariableValue.DocumentID INNER JOIN
Variable ON VariableValue.VariableID = Variable.VariableID
WHERE (Variable.VariableName LIKE 'CurRevECO')
AND Documents.LatestRevisionNo = VariableValue.RevisionNo
Order by VariableValue.ValueCache DESC