DI Jint
There are specific commands in the Javascript Engine (JINT) relating to SageCRM Only.
getID - This is used where you have the "Name" value and need the ID. You would use this for an integration where Id's would not map but you could map the Names. Only one result is returned so this depends on the Name value being unique. Otherwise use querydb.
- Parameters (a) COLLECTION (b) FILTER - returns ID value
EG
>var _compId = di.getID('Company', 'Union Computer');
2. getLookupCode - In Sage CRM some fields are lookups/selects and they use codes and translations, to get the translation value from given code.
- Parameters (a) COLLECTION (b) SOURCE_FIELD (c) SOURCE_CODE - returns translation value from COLLECTION
EG
>var val=di.getlookupcode("Company", "Comp_Sector","Construction")
Example
#1----------------------------------------------------
//SageCRM - Company
//insert
jint di
var sageRecord = SageCRMRecord('Company');
sageRecord.Set("Comp_Name", "TestCompany");
sageRecord.Set("Comp_Status", "Active");
sageRecord.Set("Comp_Type", "Prospect");
sageRecord.Set("Comp_Sector", "Finance");
var key = sageRecord.Insert();
di.display(key);
//update jint di var sageRecord = SageCRMRecord('Company'); var key = di.getguid('Company', 'TestCompany'); sageRecord.Set("Comp_Name", "Updated:TestCompany"); sageRecord.Update(key);
//delete jint di var sageRecord = SageCRMRecord('Company'); var key = di.getguid('Company', 'Updated:TestCompany'); sageRecord.Delete(key);
#2---------------------------------------------------- //SageCRM - Person //insert jint di var sageRecord = SageCRMRecord('Person'); sageRecord.Set("Pers_FirstName", "TestFirstName"); sageRecord.Set("Pers_LastName", "TestLastName"); sageRecord.Set("Pers_CompanyId", "1241"); var key = sageRecord.Insert(); di.display(key);
//update jint di var sageRecord = SageCRMRecord('Person'); var key = di.getguid('Person', 'TestFirstName'); sageRecord.Set("Pers_FirstName", "TestFirstName-Updated"); sageRecord.Set("Pers_LastName", "TestLastName-Updated"); sageRecord.Update(key);
//delete jint di var sageRecord = SageCRMRecord('Person'); var key = di.getguid('Person', 'TestFirstName-Updated'); sageRecord.Delete(key);
#3---------------------------------------------------- //SageCRM - Cases //insert jint di var sageRecord = SageCRMRecord('Cases'); sageRecord.Set("Case_product", ""); sageRecord.Set("case_description", "TestCaseDescription"); sageRecord.Set("Case_ReferenceId", "Abc-123"); var key = sageRecord.Insert(); di.display(key);
//update jint di var sageRecord = SageCRMRecord('Cases'); var key = di.getguid('Cases', 'TestCaseDescription'); sageRecord.Set("Case_ReferenceId", "Abc-123-Updated"); sageRecord.Update(key);
//delete jint di var sageRecord = SageCRMRecord('Cases'); var key = di.getguid('Cases', 'TestCaseDescription'); sageRecord.Delete(key);
