AnsweredAssumed Answered

Lists from SQL query on latest versions only??

Question asked by Ian MacPherson on Jun 1, 2011
Latest reply on Jul 23, 2018 by Brian Poelman

We have setup some lists that get the data directly from SQL, one example is for the variabel Vendor Name. However, it returns values from all versions of files. So if someone has corrected the spelling of a vendors name, thereby creating a new version the list returns both values.

 

Is there a way to program the SQL list so that it only returns the values from the latest version of files? (I'm brain dead when it comes to SQL!)

 

Here is thq SQL query we are using which is straight from the example in the Admin Guide.

 

Select distinct Vv.ValueCache
From VariableValue Vv
Where Vv.VariableID =  (    select variableid
            from variable
            where Variablename like 'Vendor Name') And
      Vv.ValueCache != ''
order by Vv.ValueCache ASC

Outcomes