Table Scripting: Difference between revisions
From Sage CRM Knowledge Base
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
if (Values("case_AssignedUserId")+""=="undefined") | if (Values("case_AssignedUserId")+""=="undefined") | ||
return; //bad update from crm..or field not changed | return; //bad update from crm..or field not changed | ||
var CaseRec=CRM.CreateQueryObj("SELECT * FROM Cases WITH (NOLOCK) WHERE " + WhereClause); | var CaseRec=CRM.CreateQueryObj("SELECT * FROM Cases WITH (NOLOCK) WHERE " + WhereClause); | ||
CaseRec.SelectSQL(); | CaseRec.SelectSQL(); | ||
if (CaseRec("case_assigneduserid")!=Values("Case_AssignedUserId")) | if (CaseRec("case_assigneduserid")!=Values("Case_AssignedUserId")) | ||
{ | { | ||
Revision as of 13:03, 8 February 2012
This sample shows you how to check if the field has been changed from one value to another
function UpdateRecord()
{
if (Values("case_AssignedUserId")+""=="undefined")
return; //bad update from crm..or field not changed
var CaseRec=CRM.CreateQueryObj("SELECT * FROM Cases WITH (NOLOCK) WHERE " + WhereClause);
CaseRec.SelectSQL();
if (CaseRec("case_assigneduserid")!=Values("Case_AssignedUserId"))
{
ErrorStr="field value has changed from "+CaseRec("case_assigneduserid") +" to "+Values("Case_AssignedUserId");
}
}
