View Name:alert_view
View Number:4302
Group:Alerts
Description:Alerts and alert_to_other
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Custom

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidalertobjidalert Internal record number 3 (UNIQUE)
alert_textalertalert_textText of the alert message 
start_datealertstart_dateDate the alert becomes effective 
end_datealertend_dateLast date the alert is effective 
activealertactiveIndicates whether alert is active; i.e., 0=inactive, 1=active. In order to fire, an alert must be both effective and active 
titlealerttitleThe title of the alert 
hotalerthotIndicates whether alert is flagged as hot; i.e., 0=no, 1=yes 
x_activealertx_activeIs this really active - ignore pre-defined active flag for find caller, i.e., 0=no, 1=yes 
other_objidalert_to_otherobjidalert_to_other Internal record number 
obj_numalert_to_otherobj_numObject number of related table 
obj_idalert_to_otherobj_idObject ID of related row in table 
alias_namealert_to_otheralias_nameAlias of table/view that this row was found from 

Joins:

Join FromJoin To
(alert_to_other).to_other2alert(alert).alert2alert_to_other
My Recent Objects
alert_view