- Innon Knowledge Base
- Tridium Niagara
- Programming Tips
How can I display the latest alarm on a PX page?
Baja Query Language (BQL) can be used to query the alarm database to find and display this for you
There are a number of ways of displaying this, but the simplest method is -
- Open the "Report" palette and under "ReportWidgets" folder, drag a BoundTable onto the PX page
- Copy and paste the following into the ord of the above -
- alarm:|bql:select Top 1 timestamp, sourceState, ackState, alarmData.sourceName, alarmClass, priority order by timestamp DESC
- Make any other settings you require to the widget
- You're done! You can change the BQL to display different alarm fields or show the top 10 alarms, change order etc. to get it showing exactly what you want