Queryregion: Difference between revisions

Latest revision as of 14:54, 9 May 2025

Syntax : queryregion "<POSTGRESQL QUERY>" <ENTER>

Description : Executes the given postgresql query on the available region and gets the response in tabular form.

JINT example

var table = di.queryregion("select * from accountupdate");

di.display("Got the data..."+table.Rows.Count);

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

{

var account_id = table.Rows[x]['Id'];

var account_name = table.Rows[x]['Name'];

...maybe import into another system...etc

}

@@ Line 8: / Line 8: @@
 JINT example
-	var table = di.queryregion("select * from accountupdate");
-	di.display("Got the data..."+table.Rows.Count);
-	for(var x=0;x<table.Rows.Count;x++)
-	{
+var table = di.queryregion("select * from accountupdate");
-		var account_id = table.Rows[x]['Id'];
-		var account_name = table.Rows[x]['Name'];
+di.display("Got the data..."+table.Rows.Count);
-        ...maybe import into another system...etc
-	}
+for(var x=0;x<table.Rows.Count;x++)
+{
+   var account_id = table.Rows[x]['Id'];
+   var account_name = table.Rows[x]['Name'];
+   ...maybe import into another system...etc
+}