Description
This block is used to import data from history or alarm databases. It refers to a Selection that queries database. The query can be:
-
SlotPathOrd: history:/Active_Demo_Analytics/Main_Meter_Elec_Floor1
-
BQL: history:|bql:select * where id like '*Meter*'
Once the histories/alarm records are selected, they will be stored in the strategy in the chosen artifact.
Implementation
-
Drag and drop a selection from the palette (Selection Folder) in the BtibService (OrdSelection or MultiOrdSelection)
-
Set the query in "ord" property
-
Let the boolean "isActive" to false
-
Drag and drop a selection from the palette (Source Folder) in the strategy
-
Link the action "execute" to the topic "executed" of the previous block
Properties
-
Selection: the selection from the BtibService, applied on history or alarm database
Artifacts
-
Tables: contains one table for each history selected. For trend records history, table will be composed by 3 columns: timestamp, status and value.
Summary
