You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing email@example.com.
We are experiencing playback issues from our video hosting provider. Please check back shortly.
2:58Basic SQL Query
2:43Tag Historian Query
1:32Tag Calculation Query
2:03Alarm Journal Query
Take topic challenge
Alarm Journal Query
The Alarm Journal Query provides easy access to alarm journal data in your reports.
Video recorded using: Ignition 7.9
Transcript(open in window)
[00:00] You can very easily pull alarm information into your reports with the Alarm Journal Query. Begin in the data panel, click on the plus icon, we will add a new Alarm Journal Query. Now the start and the end data are already set to use the start and end data parameters. You can go ahead and choose include system events, cleared, active, acknowledged events, you can filter by alarm source, by the display path, by the provider filter, and you can also use the search filter, now the search filter is a combination of source filter and display filters. So you can have a single parameter that searches the source and the display path for a match. You can also specify the minimum and maximum priority. And then on the right hand side there's the journal drop down box, this allows you to select which alarm journal to search through. So let's go ahead and add a search filter here, I've already created the search parameter, and it's using a single spaces of value, so it's filtering for all alarms with the space in the path somewhere. So let's come to the search filter, we'll click on the little magnifying glass, we'll find our search parameter, click okay. Next let's take a look at the design panel. You'll now already have a table set up that's using this, and if we take a look at our alarm journal data source, you'll see there's a large number of keys that you have available, these are all the various alarm properties, that are available for you to use. Now I won't go over all of them, but we will go ahead and use the display path. We'll get the active variations, so how long it's, the alarm has been active, and the event state, what kind of alarm event was it in, was it in acknowledgement, was is a cleared, active and so on and so forth. And if you take a look in preview, you can see that it's bringing all that information here, there's no active durations because it wasn't in an active event. Now let's try to use this in a window, pull up the report viewer here and we have this all set up for us. Now we can very easily go ahead and take advantage of that search parameters. Now I have two alarms here, I have this on the Bool tag and the Int tag, so we can go ahead and just put in, bool, and we'll go ahead and get all of our bool events, alternatively we can type in Int.