Niagara Sample BQL Queries

Niagara Sample BQL Queries

Alarm Queries
local:|fox:|station:|slot:/|bql:select name as 'Point Name',out as 'Point Status' from control:ControlPoint where status.alarm = 'true'
local:|fox:|station:|slot:/|bql:select * from alarm:AlarmSourceExt where alarmClass = 'defaultAlarmClass' and status.alarm = true
alarm:|bql:select timestamp,alarmData.sourceName,sourceState,ackState,ackRequired,alarmData.msgText,alarmClass where alarmData.sourceName like 'B1J*' and alarmClass like '*1*' order by timestamp desc
alarm:|bql:select timestamp,alarmData.sourceName,sourceState,ackState,ackRequired,alarmData.msgText,alarmClass where alarmData.sourceName like 'B1J*' and alarmClass like '*2*' order by timestamp desc
alarm:|bql:select *

History Queries
local:|fox:|history:/MyStation/ZoneTemp|bql:select timestamp, value where timestamp in bqltime.today
history:|bql:select *

Component Queries
local:|fox:|station:|slot:/VAV_Bldg_1|bql:select slotPath as 'Path', displayName as 'Display', out.value as 'Output Value' from control:NumericPoint where displayName like '*ZN_T*'
local:|fox:|station:|slot:/VAV_Bldg_1|bql:select slotPath as 'Path', displayName as 'Display', out.value as 'Output Value' from control:NumericPoint where displayName like '*ZN_T*' or displayName like '*STPT*'
local:|fox:|station:|slot:/Exercises|bql:select * where slotPath like '*TrafficLight1'

Http Queries - Must be using Basic Hx Profile
http://192.168.7.194/ord?station:|alarm:/|bql:select%20*
http://192.168.7.194/ord?station:|alarm:/|bql:select%20timestamp,%20source%20where%20source%20like%20%27*Temperature*%27
http://192.168.7.194/ord?station:|history:/SqlDemo|bql:select%20*
http://192.168.7.194/ord?station:|history:/SqlDemo/ZoneTemperature|bql:select%20*
http://192.168.7.194/ord?station:|history:/SqlDemo/ZoneTemperature|bql:select%20status,%20value%20where%20timestamp%20in%20bqltime.lastweek     (for this you can also use bqltime.lastmonth, bqltime.last7days, etc)
http://192.168.7.194/ord?station:|history:/SqlDemo/ZoneTemperature?period=timeRange;start=2016-04-05T00:00:00.000-00:00;end=2016-04-17T00:00:00.000-00:00|bql:select%20status,%20value,%20timestamp
http://192.168.7.194/ord?station:|history:/SqlDemo/AuditHistory|bql:select%20*
http://192.168.7.194/ord?station:|slot:/|bql:select%20name,out.value%20as%20%27Absolute%20Ord%27%20from%20control:NumericPoint

@goseese

I wonder if you have any experience or pointers for a query I am trying to figure out.

Given I have a Jace8000 and I can execute this query to see all points on the controller.

/ord?station:|slot:/Drivers/NrioNetwork|bql:select%20*%20from%20control:ControlPoint

Returns a lis something like this. I cut out a lot of content and some of the columns to shorten this up.

slot:/Drivers/NrioNetwork/IO$2dR$2d34/points/DigitalInputs/SysA1DoorSwitch Open {down,stale} slot:/Drivers/NrioNetwork/IO$2dR$2d34/points/DigitalInputs/SysA6DoorSwitch Open {down,stale} slot:/Drivers/NrioNetwork/IO$2dR$2d16$2d1/points/SysA1Temp 302.0 °F {down,stale} units=°F,precision=1,min=-inf,max=+inf slot:/Drivers/NrioNetwork/IO$2dR$2d16$2d1/points/SysA4TempA 302.0 °F {down,stale} units=°F,precision=1,min=-inf,max=+inf ... slot:/Drivers/NrioNetwork/IO$2dR$2d16$2d1/points/Comp$233_Med_Temp_Alarm slot:/Drivers/NrioNetwork/IO$2dR$2d16$2d1/points/SysA1Defrost Defrost Off {down,unackedAlarm} @ 16 slot:/Drivers/NrioNetwork/IO$2dR$2d16$2d1/points/SysA5TempB 302.0 °F {down,stale}

My question is this.

On this jace in the web interface there is a [ Refrigeration ] and [HVAC] tab. Clicking on those shows there are refrigeration systems called System A1 System A2 .... System A6

Is there a query that I can execute to show me all refrigeration systems by name, or somehow get the config for the .px page?

Secondly, is there a way I can execute a contorl:ControPoint query as in above but only return controlPoints that have been associated/reated to for example SysA1. a door sensor or compressor might not have SysA1 in it's point name but it is showing as a part of that refrigeration system in the jace web UI.

Hi

This might be a starting point:

station:|slot:/VAV_Bldg_1|bql:select slotPath as 'Path', displayName as 'Display', out.value as 'Output Value' from control:NumericPoint where displayName like 'ZN_T' or displayName like 'STPT'

I think you would be able to change displayName like 'STPT' to something more specific such as parent.parent.displayName = 'System A1'.
They can then be conditioned to look for multiple specific matches.

station:|slot:/VAV_Bldg_1|bql:select slotPath as 'Path', displayName as 'Display', out.value as 'Output Value' from control:NumericPoint where parent.parent.displayName = 'System A1' or parent.parent.displayName = 'System A2'

hi guys i wanted to show the controller ststus and device id on px file how can i use px include feature

hi guys i wanted to show the controller ststus and device id on px file how can i use px include feature

You can use a label with a value binding with the ord set to the device you want to show status of and animate the text with %status%

To show the device ID set the ord to "station:|slot:/Drivers/BacnetNetwork/YourDevice/config/deviceObject" and animate the text with %objectId.getInstanceNumber%

Thank You @rfincher86

@rfincher86 I TRIED ADDING THE STUFF AND IT WORKS N=BUT HOW CAN I GET RID OF "DEVICE:" WHILE PRITING THE TEXT IS THERE ANY BFORMAT TO REDUCE THE LENGTH OF TEST I JUST WANT CONTROLLER NUMBER

@rfincher86 I TRIED ADDING THE STUFF AND IT WORKS N=BUT HOW CAN I GET RID OF "DEVICE:" WHILE PRITING THE TEXT IS THERE ANY BFORMAT TO REDUCE THE LENGTH OF TEST I JUST WANT CONTROLLER NUMBER

Are you putting %objectId.getInstanceNumber% in the animated text field? It will show 'device' if you only put %objectId%

DOES ANYONE HAVE A FORMULA TO CALCULATE ABSOLUTE HUMIDITY OR LIKE A BLOCK BASED ON PSYCHOMETRIC CHART IN NIAGARA ?

i got upto this but cant find way to conver hum ratio