Description

The BqlSize calculates the size of an ord query result. This makes it easy to create a number of summaries in the form of slots.


Implementation

  • Drag and drop the BqlSize component into the station.
  • Enter the request into the query slot.
  • Switch the Enabled slot to true.



Properties

  • LogExt: Allows the configuration of logs sending. See Logs for more information.
  • Status: The component can be in three states, {ok} by default, {fault} if it encounters an error, and {disabled} if the property enabled is false.
  • FaultCause: The description of the error if the component enters a {fault} state.
  • Enabled: Enables / disables the component. If the component is disabled, it cannot run.
  • ExecuteTime: Time period between two executions of the component. Note that the resolution of a BQL query can take a little time, it is advisable to adapt these times to the load of your station.
  • ExecuteQuery: Base query executed by the component.
  • OptimizedQuery: The execution query optimized by the Optimize action. This query is used as priority, if not empty, rather than that of the ExecuteQuery slot.
  • Size: Size of the query result.


Advanced configuration properties

  • ExecuteOnStart: Sets whether the initialization query should be executed when the component is started.
  • ExecuteOnClone: Allows the initialization query to be launched when copying a BqlSize.
  • OptimizeOnStart: Allows you to define whether the execution query should be optimized when the component starts.
  • OptimizeOnClone: Allows optimization of the execution query when the component is cloned.


Actions

  • Execute: Start the execution of the BqlSize manually.
  • Optimize: Runs the execution query optimization. If the execution query is performed on a base larger than the results, the base (scheme part) is automatically reduced as far as possible to the results base. The intention is to obtain faster component execution. The optimized query is saved in the OptimizedQuery slot.


Topic

  • Executed: Topic that fires when component execution is complete (this can potentially trigger third-party logic a posteriori)