SYSALERTS

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Alert records for watched records


See Also

CLEAR TIMELINE, DATA TYPES, LIST TIMELINE, ROLLBACK TIMELINE, SELECT, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, SYSTIMELINE, UNWATCH(), WATCH(), WATCHCHANGED(), WATCHING(), WATCHRESET()


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
DATABASE C 30 Database name
Table C 30 Table name
RUID C 16 Record ID
USER C 20 Name of user to alert (watching)
LASTALERT I 11


Example

SELECT * FROM sysalerts WHERE user = user()


Products

Recital, Recital Server