DI Jint - Revision history

Sagecrmw at 12:09, 3 June 2026

2026-06-03T12:09:16Z

← Older revision		Revision as of 13:09, 3 June 2026
Line 30:		Line 30:
	=== Insert ===		=== Insert ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 40:		Line 40:
	var key = sageRecord.Insert();		var key = sageRecord.Insert();
	di.display(key);		di.display(key);
	</~~syntaxhighlight~~>		</pre>

	=== Update ===		=== Update ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 52:		Line 52:
	sageRecord.Set("Comp_Name", "Updated:TestCompany");		sageRecord.Set("Comp_Name", "Updated:TestCompany");
	sageRecord.Update(key);		sageRecord.Update(key);
	</~~syntaxhighlight~~>		</pre>

	=== Delete ===		=== Delete ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 63:		Line 63:

	sageRecord.Delete(key);		sageRecord.Delete(key);
	</~~syntaxhighlight~~>		</pre>

	== 2. SageCRM - Person ==		== 2. SageCRM - Person ==
Line 69:		Line 69:
	=== Insert ===		=== Insert ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 79:		Line 79:
	var key = sageRecord.Insert();		var key = sageRecord.Insert();
	di.display(key);		di.display(key);
	</~~syntaxhighlight~~>		</pre>

	=== Update ===		=== Update ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 93:		Line 93:

	sageRecord.Update(key);		sageRecord.Update(key);
	</~~syntaxhighlight~~>		</pre>

	=== Delete ===		=== Delete ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 104:		Line 104:

	sageRecord.Delete(key);		sageRecord.Delete(key);
	</~~syntaxhighlight~~>		</pre>

	== 3. SageCRM - Cases ==		== 3. SageCRM - Cases ==
Line 110:		Line 110:
	=== Insert ===		=== Insert ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
Line 120:		Line 120:
	var key = sageRecord.Insert();		var key = sageRecord.Insert();
	di.display(key);		di.display(key);
	</~~syntaxhighlight~~>		</pre>

	=== Update ===		=== Update ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
Line 133:		Line 133:

	sageRecord.Update(key);		sageRecord.Update(key);
	</~~syntaxhighlight~~>		</pre>

	=== Delete ===		=== Delete ===

	<~~syntaxhighlight lang="javascript"~~>		<pre>
	jint di		jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
Line 144:		Line 144:

	sageRecord.Delete(key);		sageRecord.Delete(key);
	</~~syntaxhighlight~~>		</pre>

Sagecrmw at 12:07, 3 June 2026

2026-06-03T12:07:55Z

Show changes

Sagecrmw at 12:07, 3 June 2026

2026-06-03T12:07:01Z

← Older revision		Revision as of 13:07, 3 June 2026
Line 25:		Line 25:


	#1~~----------------------------------------------------~~		#1
	//SageCRM - Company		//SageCRM - Company
	//insert		//insert

	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 37:		Line 38:
	di.display(key);		di.display(key);

	//update		//update

	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 44:		Line 46:
	sageRecord.Update(key);		sageRecord.Update(key);

	//delete		//delete
	jint di		jint di
	var sageRecord = SageCRMRecord('Company');		var sageRecord = SageCRMRecord('Company');
Line 50:		Line 52:
	sageRecord.Delete(key);		sageRecord.Delete(key);

	#2~~----------------------------------------------------~~		#2
	//SageCRM - Person		//SageCRM - Person
	//insert		//insert

	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 61:		Line 64:
	di.display(key);		di.display(key);

	//update		//update

	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 69:		Line 73:
	sageRecord.Update(key);		sageRecord.Update(key);

	//delete		//delete

	jint di		jint di
	var sageRecord = SageCRMRecord('Person');		var sageRecord = SageCRMRecord('Person');
Line 75:		Line 80:
	sageRecord.Delete(key);		sageRecord.Delete(key);

	#3~~----------------------------------------------------~~		#3
	//SageCRM - Cases		//SageCRM - Cases
	//insert		//insert
	jint di
			jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
	sageRecord.Set("Case_product", "");		sageRecord.Set("Case_product", "");
Line 86:		Line 92:
	di.display(key);		di.display(key);

	//update		//update

	jint di		jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
Line 93:		Line 100:
	sageRecord.Update(key);		sageRecord.Update(key);

	//delete		//delete

	jint di		jint di
	var sageRecord = SageCRMRecord('Cases');		var sageRecord = SageCRMRecord('Cases');
	var key = di.getguid('Cases', 'TestCaseDescription');		var key = di.getguid('Cases', 'TestCaseDescription');
	sageRecord.Delete(key);		sageRecord.Delete(key);

Sagecrmw at 12:05, 3 June 2026

2026-06-03T12:05:43Z

← Older revision		Revision as of 13:05, 3 June 2026
Line 18:		Line 18:

	>var val=di.getlookupcode("Company", "Comp_Sector","Construction")		>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);

Sagecrmw: Created page with "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..."

2026-03-02T11:26:31Z

Created page with "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..."

New page

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")