Associated with: The Event Journal table (CDBEventJournal)
ClearSCADA is supplied with various ‘standard’ Events Lists—the Events List for a particular system, and the Events Lists for an individual Group or database item. Each of these Lists query the Event Journal table. Users can insert a comment for any event in any of these Events Lists—for example, in order to indicate the unusual occurrence that resulted in a particular event being logged.
With a ‘custom’ Events List, include both the SeqNo and CommentNo fields in the SELECT Clause if you want users to be able to add such comments to any entries in that List. (For information on inserting comments, see Insert a Comment for an Event.)
The SeqNo indicates the position of an event in the Events List. (The first event to be logged on a system is number 1, the second event is number 2, and so on.) Include this field in the ORDER BY Clause so that when two or more events occur at the same time, they are shown in the correct order in the List