I have a bunch of pop-up alarm windows that have a date range component that queries the alarm table. I notice a lot of times that when I open that window the date range is selected for the correct time frame but sometimes it never runs the query on the database with that date range. I have to move the date range bar a little bit for it to bring back the correct data. This only seems to happen when the client is first started. After that if the pop-up window is opened again it has the correct data in it. I don’t know if this is a window caching thing or what.
Another weird thing is that the query is set to poll every 30 seconds but never uses the correct date range until the date range is moved or adjusted.
How do I force the query to run with the correct date range the first time that the window is opened?
I’ll include a screen shot of the screen in question. You can see that there are two alarms in the date range (by the histogram on the date range) but they don’t show up in the table until the date range component is adjusted slightly.
I don’t have this problem anymore with 7.7, I think it was ok with 7.6 too (after the big alarming change). But now I use the alarm journal. FYI.
The old window was passed in a parameter to filter on a specific display path. I don’t think I have that problem anywhere else, but I’ll double check.
Here is the query on the table:
SELECT STATE_NAME, ACTIVE_TIMESTAMP, CLEARED_TIMESTAMP, (DATEDIFF(second,ACTIVE_TIMESTAMP,CLEARED_TIMESTAMP)/60.0) as Downtime
FROM ALERT_LOG
WHERE displaypath like '%{Root Container.AlarmGroup}%'
and {Root Container.Dropdown 1.whereClause}
and ACTIVE_TIMESTAMP>='{Root Container.Date Range.startDate}'
and ACTIVE_TIMESTAMP<='{Root Container.Date Range.endDate}'
and {Root Container.Search Field.WhereClause}
order by ACTIVE_TIMESTAMP desc
Yes I'm having exactly the same type of problem. Ignition 7.6.6.
I've got a Date Range component with Startup Mode Automatic.
I've got various charts on the page with their Data properties bound to SQL including references to the date range.
On startup the date range component appears correctly.
But in the SQL queries the startDate and endDate properties of the Date Range are using the values from what they were when the window was last saved in the Designer.
Indeed I've bound a Label component's Text property to the startDate and it shows wrongly (I'd previously been doing things trying to refresh the chart's data etc but clearly the problem is with the startDate and endDate properties being reported by the Date Range).
As per the original poster's issue, making a minor adjustment to the Date Range sorts everything out.
Obviously this is unacceptable to the client as they're not seeing current data on startup.
I emailed these on Thursday but have had no acknowledgement, either via the support system or on here. Even if you haven’t had an opportunity to investigate the problem please can you let me know that you’ve received the files. The support ticket ID is #4778. Thanks.
I’ve back ported the fix to 7.6.8 – it will probably make it into rc2.
But a heads up on 7.6 – it’s not a LTS version, and at this time we’re being selective about what gets back ported. It’s likely the last update to 7.6 will be in just a few months.
