SYSALERTS
From Recital Documentation Wiki
Revision as of 09:15, 21 September 2011 by Yvonnemilne (Talk | contribs)
Contents
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
