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 -

  1. Open the "Report" palette and under "ReportWidgets" folder, drag a BoundTable onto the PX page
  2. 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
  3. Make any other settings you require to the widget
  4. 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