beautypg.com

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

background image

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 . The Save Custom View window will appear:


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