AF Linked Table timestamp

Discussion created by tgreen on Apr 2, 2014
Latest reply on Jul 7, 2014 by Gregor





In AF, we have various Linked Tables


We have no issue creating template attributes to reference the data of the linked tables


What I would like to set up is the 'Timestamp' showing in the Attributes of an Element to be the timestamp of that record




Table structure is something like this




DeviceName, Timestamp,  Value1, Value2, Value3, ect


Attribute Template values are set to this:






SELECT Value1 FROM [Table] WHERE [DeviceName] = '%Element%' and Timestamp <= #%Time%# ORDER BY Timestamp desc




Result is the correct value, but the Timestamp is '1/1/1970 12:00:00 AM' for all of them.  I want these to show essentially the 'Timestamp' of it's record found in the Linked Table




Any ideas?