Queryregion: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
Description : Executes the given postgresql query on the available region and gets the response in tabular form. | 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 | |||
} | |||
Revision as of 14:53, 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
}
