Niagara BQL Query Examples PDF

[mroche1]

In the Niagara BQL Query Examples document, get examples of how to use BQL query to extract data from a G3 station. Learn about how to display data from the BMS system on a custom / third-party application. An example of using Excel web query is included.

Product Line

TAC IA Series

Table of Contents

Niagara BQL Query Examples – 1

Using Where Statements – 1

Like Operators – 2

Period Modifiers – 2

Delta Values – 2

Rollup Values – 2

Space Character Handling in Web (Excel) Queries – 3

Sample Excel Web Query – 3

Excerpts

“This query returns data from the OaTemp history in two columns. The first column contains the timestamp and the second column contains the value. The syntax "as 'time stamp'" and "as 'temperature'" configures the text to be displayed at the top of each column. This is useful when the name of the property is not intuitive, such as 'toString'.” – Page 1

“At times it is necessary to evaluate the collected values to determine minimum, maximum, average, and the sum of values. This can be accomplished through program objects by performing bql queries and then cursor through the BI Table results to perform the math functions. Alternatively, there is a special function of the bql query which does this; it is the same functionality that is provided in the history chart interface for data rollups.” – Page 2

“The return could be limited by using 'select timestamp,value' if the trend flags and status are not required. Because the refresh options were selected, this data table will refresh automatically every 15 minutes while the spreadsheet is open.” – Page 6