Reporting module - Alarm journal query - sort order

We’re using an alarm journal query data source in a report and are looking to see if there is a way to change the sort order of the results that are returned. We couldn’t see anything obvious in the query config properties, so wanted to see if anyone knows if this is configurable, and if so how to do it, and if not are there other ways to sort the data at the page config on the report - we couldn’t see a way to do that either.

Any assistance appreciated,

-Greg

Use a script datasource after the alarm journal query data source and you can rearrange the data to your heart’s content.

Kathy,

Thanks for the tip. We ended up using a standard SQL query instead…we have a system with auto-acknowledged alarms and if we had “Active” filter checked in the Alarm journal query but not “Acknowledge” (we only want to see when alarms went active) then no alarms would show up at all. Looks like the alarm journal query is using the eventflags in addition to the eventtype, so even if eventtype is 0 for active, if the eventflag has the ack bit set then the query rejects it. For our query we just used the eventtype =0 and that gave us what we wanted and then we could just add the order by to that for sorting.

1 Like