persistent class %BI.SMS
extends %Persistent, %XML.Adaptor, %BI.Adaptor
property ContactNumber
as %String(MAXLEN=200,TRUNCATE=1);
property ProcDateTime
as %String(TRUNCATE=1);
property ProcStatus
as %String(TRUNCATE=1);
property SMSDateTime
as %String(TRUNCATE=1);
property SMSMessage
as %String(MAXLEN=32000,TRUNCATE=1);
property SendRecvFlag
as %String(TRUNCATE=1);
property StatusFile
as %String(MAXLEN=200);
property TrialCount
as %Integer;
query ListAll()
SQL Query
:
SELECT %ID,SendRecvFlag,ProcStatus,SMSDateTime,ProcDateTime FROM SMS
ORDER BY %ID DESC
index (STAT on SendRecvFlag:Exact,ProcStatus:Exact);