Skip to content

Instantly share code, notes, and snippets.

View mrupperman's full-sized avatar

Bryan Upperman mrupperman

  • Ohio
View GitHub Profile
@mrupperman
mrupperman / Niagara Sample BQL Queries
Last active June 20, 2024 13:57
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 *
@mrupperman
mrupperman / Niagara AX Sample Code
Last active March 8, 2024 17:34
Niagara AX Sample Code
Create a new component
Delete a component
public void xcmRemove(String paramString)
{
Slot[] arrayOfSlot = BOrd.make("station:|slot:/EnergyReporting/EnergyLogic").resolve().getComponent().getSlotsArray();
for (int i = 0; i < arrayOfSlot.length; i++) {
if (arrayOfSlot[i].getName().toString().equals(paramString))
{
@mrupperman
mrupperman / Niagara Create Component
Last active March 8, 2024 17:34
Niagara Create Component
public boolean addEnergyModule(String paramString)
{
int i = 0;
BFolder localBFolder1 = new BFolder();BFolder localBFolder2 = new BFolder();BEnergyAnalyzer localBEnergyAnalyzer = new BEnergyAnalyzer();
Slot[] arrayOfSlot = BOrd.make("station:|slot:/").resolve().getComponent().getSlotsArray();
for (int j = 0; j < arrayOfSlot.length; j++)
{
if (arrayOfSlot[j].getName().toString().equals("EnergyReporting")) {
i = 1;
@mrupperman
mrupperman / Niagara Supervisor Global Override
Created June 8, 2017 17:28
Niagara Supervisor Global Override
BOrd ord = BOrd.make("station:|slot:/Drivers/NiagaraNetwork|bql:select slotPath, type, toString from control:ControlPoint where slotPath like '*OCC_MODE'");
public void onOccupied() throws Exception
{
GetPoints("occ");
}
public void onUnoccupied() throws Exception
{
GetPoints("unocc");
@mrupperman
mrupperman / Enum Override Example
Created June 8, 2017 17:33
Enum Override Example
public void onExecute() throws Exception
{
process((BComponent)getProgram().getParent());
}
public void process(BComplex c)
throws Exception
{
if (c instanceof javax.baja.control.BEnumWritable)
{