Using BQL query to extract data from a G3 station

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.

Product Line

TAC I/A Series

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. This document 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).