What is the EZest way to print/export alert reports from history database?
I have read about setting up DataSets and I can see the data that I want on the Gateway server webpage when I go to “Alert Console” and filter by severity etc.
I have the PDF report module but I don’t think I need it if I could just print the filtered reports that I want.
The easiest way is to write a SQL query that brings back the alerts that you want based on your filters. You can bring the information back on a table component and print/export the data. What information do you want exactly?
I need three filters; last 24 hours from 12 to 12 with Low severity, Low Med severity, and Med to High severity.
Auto print or export to PDF would be nice too.
That should be very easy to do with the built-in functions in Ignition. Particularly: system.alert.queryAlertHistory()
I see the example but remember, I come with a RSView background and I’m not a programmer nor am I experienced in Ignition. So please elaborate.
Where do I put this code, how do I show it in a window and how do I print the result.
Lets just say, “Make it Barney style for me!”. LOL
It really depends on whether or not you want it to automatically happen or view the information on a window. If you want it to be automatic you can put a script in the “Event Scripts - Gateway.” Otherwise, you can just simply make a window in your project.
On the window you can add a table component. You can bind the data property of the table to a function binding where you can use the alert history function. That binding will return any alerts with your filters. You can put a button on the window to save the data to CSV or print it.
The system.alert.queryAlertHistory function that Robert mentioned is used in scripting only. That is what you would use in your automatic script.
I would suggest you contact your account rep here and setup a web demonstration. We can tailor it to specific functions you want accomplished and show you how to do it. You can also call our tech support at (800) 266-7798 and press 2. They can also walk you through setting this up.