AnsweredAssumed Answered

AF External Table Refresh Period

Question asked by VijayaBhaskar on Jun 8, 2017
Latest reply on Jun 14, 2017 by rdavin

Hi All,

We have created a AF External table which queries the AF Hierarchy of that AF database and gets the results of all the attributes. This table data is again used in the other AF Elements for more calculations. I have set the cache interval of this AF External table as 10 minutes.

 

Here my question is - Is this External Table updates automatically after 10 mins with the new data ?

 

The source attributes updates at every 5 minutes as per the analysis scheduled.

 

Below id the Query we are using to update the External Table

 

SELECT ElementPath "ElementPath", LIST(Element,',') "ActorList" ,LIST((CAST(V AS string)),',') "TotalLossValues" 

FROM (

    SELECT eh.Path "ElementPath", e.name "Element", s.Value "V"

    FROM [AF_DATABASE].[Asset].[Element] e

     INNER JOIN [AF_DATABASE].[Asset].[ElementHierarchy] eh ON eh.ElementID = e.ID

     INNER JOIN [AF_DATABASE].[Asset].[Elementattribute] ea ON ea.ElementID = e.ID

     INNER JOIN [AF_DATABASE].[Data].[Snapshot] s ON ea.id = s.ElementAttributeID

     WHERE ea.name = 'Loss'

     ORDER BY s.value ASC

) AllRelations

GROUP BY ElementPath

 

Regards

Vijay

Outcomes