I have discussed in a previous article the structure and purpose of the SQL clause of an Escalation rule.
e.g.
e.g.
(quot_IsQuote is not null) AND UPPER(RTRIM(quot_Status))=UPPER(RTRIM(N'Active')) AND (Escl_DateTime<#T And Escl_UserID=#U)
We know that in the SQL trigger clause the #T and #U codes represent the current time and the currently logged on user. If the #T code represents the current time then we can imagine it being substituted as getDate in an implementation on SQL Server.
(quot_IsQuote is not null) AND UPPER(RTRIM(quot_Status))=UPPER(RTRIM(N'Active')) AND (Escl_DateTime #T ) and ((oppo_targetclose - 28)
or case_assigneduserid=#U and (case_notifytime+7)>#T
or
DATEDIFF (mi, case_notifytime, getdate()) > 30
or
DATEDIFF (mi, case_notifytime, getdate()) > 30
-
1520763
-
Cancel
-
Vote Up
0
Vote Down
-
-
Sign in to reply
-
More
-
Cancel
Comment-
1520763
-
Cancel
-
Vote Up
0
Vote Down
-
-
Sign in to reply
-
More
-
Cancel
Children