Hi,

I need to extract the attributes of all versions for a documents. For example one documents has 5 versions so I want to get all the 5 versions of attributes.

I have used below SQL query to get all versions of attributes but its giving only specific attributes for each versions. Its not giving the output as mentioned in "Preview" tab.

"select d.FileName, v.VariableName, vv.ValueCache as [Value], dc.ConfigurationName,Cast(vv.RevisionNo as varchar(5)) + '/' + Cast(d.LatestRevisionNo as varchar(5)) as [Version],o.Description as [Type]

from VariableValue vv

inner join Variable v on vv.VariableID = v.VariableID

inner join Documents d on vv.DocumentID = d.DocumentID and d.LatestRevisionNo=vv.RevisionNo

inner join DocumentConfiguration dc on dc.ConfigurationID = vv.ConfigurationID

inner join ObjectType o on d.ObjectTypeID = o.ObjectTypeID

where d.Filename = '43136.SLDASM'and

dc.ConfigurationID=2 order by vv.RevisionNo"

Is there any changes in my query?

Please tell me any API is there to get all versions of attributes?

Thanks in Advance.