Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
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
Author
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.