Issue
Using BQL query to extract data from a G3 station
How to display data from the BMS system on their custom / third party application.
Environment
I/A Series G3
Cause
A requirement to display data from the BMS system on their custom application.
Resolution
You can query for data using a BQL (Baja Query Language) query. The Baja Query Language (BQL) is an SQL-like query language that provides a mechanism for identifying various sets of data. It provides an ad hoc way to search for data based on some criteria.
3rd party applications which is capable of running a web query can be used to query data from a G3 station. One such application is Microsoft Excel. The Niagara BQL Query Examples PDF provides several examples of BQL queries as well as an example of using Excel web query. Most data in a station can be queried including point values etc.
For detailed description of BQL usage, refer to the Niagara Help in Workbench ( as shown below).
