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 1: / Line 1: @@
-'''Syntax''' :
+'''Syntax''' : queryregion "<POSTGRESQL QUERY>" <ENTER>
-QueryRegion:
+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++)
-Syntax : queryregion "<POSTGRESQL QUERY>" <ENTER>
+{
-Description : Executes the given postgresql query on the available region and gets the response in tabular form.
+   var account_id = table.Rows[x]['Id'];
+   var account_name = table.Rows[x]['Name'];
+   ...maybe import into another system...etc
+}