tgreen

AF Linked Table timestamp

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

Hi,

 

 

 

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:

 

 

 

Value1

 

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?

Outcomes