Events auto refresh

[MikeEckert]

😁Hello,

I am inquiring about a way for the events screen to auto refresh. I currently for our operators run a WebX session that

refreshes every minute with the event screen and this works great. I could free up a WebX license if there is a way for

the ViewX events to refresh in the same manner. I appreciate your time and help on this.

Thanks

[BevanWeiss · Accepted solution]

This is primarily for performance reasons that it doesn't automatically update.

So you need to be mindful of performance if you 'force' it to refresh periodically.

Event Journal queries can be quite a lot of rows to scan through for the query filters, and they can return quite a lot of data (since they are text fields, they are very non-optimised).

As such, the easiest way to do this is to use an animation expression for the embedded list SQL.  If this animation is something like

'SELECT RecordId, RecordTime, Severity, Message FROM CDBEventJournal WHERE RecordTime > [TIME THING] AND ' + IFF( "System.Time.Seconds" MOD 10 = 0, 'TRUE', '1=1')'

Then the query will be changed every so often, and will be re-executed.  You would need to have a point which is triggering subscription updates (for System.Time.Seconds).

I can't recall if the SQL string itself has to change... or if the animation being triggered by a value change is enough.. but to avoid potential future optimizations I'd change the SQL query string (like above... which is untested)