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