Queryregion: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 8: | Line 8: | ||
JINT example | 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 | |||
} | |||
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
}
