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