BqlToComponents

Description

The BqlToComponents allows you to transform the result of query (a table) to components and slots. One line of the table is represented as a component and each cell is a a slot in the component.

This is pretty useful when you want to use it in a view or in a logic.

Implementation

• Add a BqlToComponents in your stations

• Define your query

• Define the number of components using the action SetComponentCount It corresponds to the number of rows you are going to have from the query result. 💡  You can use in the query TOP x to restrict the number of results.

• Define the number of slots per component using the action SetSlotCount. It corresponds to the number of columns you are going to have from the query result.

• Define the Execute Time

Properties

• Status: Status of the component

• FaultCause: Displays the error when the component did not run successfully

• Enabled: Whether to activate the automatic resolution of the query or not

• ExecuteTime: The period where the component will resolve the query and update the slots.

• ExecuteQuery: Bql query to resolve and to transform the result into slots. It can be on the slot, history or alarm space.
  💡  The query can begin with "station:|slot:" for a search of the whole station or "slot:" for a relative search

Action

• Execute: To force the execution. It will resolve the query and transform the result into slots

• Clean: To clean the components and slots

• SetComponentCount: To set the number of rows you want to transform into components

• SetSlotCount: To set the number of columns you want to transform into slots