SelectionBlock

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