AnsweredAssumed Answered

List from SQL Database that looks at all configurations / sheets

Question asked by Iftach Priel on Dec 23, 2014
Latest reply on Dec 24, 2014 by Iftach Priel

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

Outcomes