Jint - Revision history

WikiSysopdi at 12:13, 4 September 2025

2025-09-04T12:13:53Z

← Older revision		Revision as of 12:13, 4 September 2025
Line 120:		Line 120:

	----		----

			di.include

			Typically we want to reuse code so this is now possible using this command

			Example of a local file

			di.include("somefilepath.js");

			Example of a remote

			di.include("https://repo.somedomain.com/js/customfunctions.js");

2025-05-25T15:23:44Z

2024-01-12T13:37:35Z

2024-01-12T10:32:07Z

← Older revision		Revision as of 10:32, 12 January 2024
Line 95:		Line 95:

	};		};
			----Comments in code

			Single line comments only are supported and they must be on their own line.

			Not working

			var x=2;//set x to 2

			working

			//set x to 2

			var x=2;

			and not working

			/*

			multiline comments

			are not supported

			<nowiki>*</nowiki>/

2024-01-11T14:33:56Z

← Older revision		Revision as of 14:33, 11 January 2024
Line 76:		Line 76:
	var table = di.querydb("select * from customers");		var table = di.querydb("select * from customers");

	'''table.~~Column~~.Add("SomeCustomfield");'''		'''table.Columns.Add("SomeCustomfield");'''

	'''///adds a column to the dataset'''		'''///adds a column to the dataset'''

2024-01-10T10:56:14Z

← Older revision		Revision as of 10:56, 10 January 2024
Line 10:		Line 10:

	>di.status()		>di.status()

			>di.deleteisland('ISLANDNAME')

	----		----
Line 74:		Line 76:
	var table = di.querydb("select * from customers");		var table = di.querydb("select * from customers");

	'''table.~~AddColumn~~("SomeCustomfield");'''		'''table.Column.Add("SomeCustomfield");'''

	'''///adds a column to the dataset'''		'''///adds a column to the dataset'''

2022-10-21T11:29:14Z

← Older revision		Revision as of 11:29, 21 October 2022
Line 1:		Line 1:
			'''Syntax''' : jint "<OBJECT NAME>" <ENTER>

			Description : Jint command will be used to initialize Javascript Object which we can use to perform available commands same as Javascript syntax.

			For eg.

			>jint di

			>di.islands()

			>di.status()

			----


	You can write and run javascript commands (and scripts in ,js files) allowing you to code iteratation over a dataset (querydb), alter the data (in a csv for example) and automate region creation and various other commands.		You can write and run javascript commands (and scripts in ,js files) allowing you to code iteratation over a dataset (querydb), alter the data (in a csv for example) and automate region creation and various other commands.

2022-08-04T13:44:24Z

← Older revision		Revision as of 13:44, 4 August 2022
Line 1:		Line 1:
	You can write and run javascript commands allowing you to ~~iterate~~ over a dataset (querydb) and automate region creation and various other commands.		You can write and run javascript commands (and scripts in ,js files) allowing you to code iteratation over a dataset (querydb), alter the data (in a csv for example) and automate region creation and various other commands.

2022-08-03T15:07:45Z

← Older revision		Revision as of 15:07, 3 August 2022
Line 13:		Line 13:


	~~Sample~~ script that queries a "customers" table for any customers that have a flag set and then for each of those it creates a data island "region" and pushes up the customers "orders" to an island.
			Here is a sample script that queries a "customers" table for any customers that have a flag set and then for each of those it creates a data island "region" and pushes up the customers "orders" to an island.


Line 35:		Line 36:


	<nowiki>'''~~Some~~ Examples'''</nowiki>
			<nowiki>'''More Examples'''</nowiki>

	a. Accessing Column names		a. Accessing Column names

2022-08-03T13:35:18Z

← Older revision		Revision as of 13:35, 3 August 2022
Line 52:		Line 52:


	b. Altering data before pushing
			b. Altering data before pushing - you can add a column and alter existing

			var table = di.querydb("select * from customers");

			'''table.AddColumn("SomeCustomfield");'''

			'''///adds a column to the dataset'''

			for(var x=0;x<table.Rows.Count;x++) {

			var fieldValueID = table.Rows[x]['CustomerID'];

			var fieldValueCode = table.Rows[x]['CustomerCode'];

			'''table.Rows[x]['SomeCustomfield']=fieldValueID+fieldValueCode; //composite field'''

			}

			///pass in the altered dataset

			di.push("customers", '''table''');

			};