Working with custom data views, Building a useful sql statement, Saving the data view – Comtech EF Data MIDAS Event Log Viewer User Manual
Page 20: Uilding, Seful, Sql s, Tatement, Aving
MIDAS Event Log Viewer
On-line User Guide
WORKING WITH CUSTOM DATA VIEWS
Building A Useful SQL Statement
Since a data view is “driven” by the SQL statement behind it, a custom data view
equates to a custom SQL statement. The MIDAS Event Log Viewer is constantly
updating the SQL Pane, so even though a user can enter or alter the SQL statement
directly, usually just selecting the right elements with the mouse is sufficient.
Occasionally an SQL statement is worth saving for re-use (e.g. perhaps to track a
severe error that has been cropping up on the same device). Once the SQL statement
is displaying the correct data and is deemed worthy of re-use it can be saved.
Saving The Data View
To save a data view, click on Custom View within the Data View selector and then click
on
Enter a view name consisting of thirty characters or less and using no punctuation other
than the space, comma, and forward slash character (/) (e.g. High Severity / Error 8).
Working With Custom Data Views
Page 18 of 26