persistent class %BI.MailOutBox
extends %Persistent
property MailAtt
as %String;
property MailBcc
as %String(MAXLEN=1000);
property MailCc
as %String(MAXLEN=1000);
property MailDate
as %String;
property MailMsg
as %String(MAXLEN=10000);
property MailSubject
as %String(MAXLEN=1000);
property MailSysUser
as %String;
property MailTo
as %String(MAXLEN=100);
property MailUID
as %String;
query MailByUID()
SQL Query
:
SELECT ID,MailTo,MailSubject,MailDate FROM %BI.MailOutBox ORDER BY MailUID
index (UID on MailSysUser:Exact,MailUID:Exact);
index (Usr on MailSysUser:Exact);