Load Rich Display Grid using SQL

Content Freeze

As of July 25th, 2023, there is a content freeze on this page.

In the examples below, the assumption is made that the display grid fields have matching field names and definitions to the database table fields.

Load all records at once

pjs.defineDisplay("display", "mydisplay.json");
 
var records = pjs.query("SELECT * FROM ORDERS");
display.grid1.replaceRecords(records);

Load one record at a time using primitive objects

pjs.defineDisplay("display", "mydisplay.json");
 
display.grid1.clear();
 
var c1 = pjs.allocStmt();
c1.executeDirect("SELECT * FROM ORDERS");
 
var record = c1.fetch();
while (c1.hasMoreRows()) {
  // custom processing before record is added can go here
  display.grid1.push(record);
  record = c1.fetch();
}

Load one record at a time using a data structure with global fields

pjs.defineDisplay("display", "mydisplay.json");
 
pjs.define("ordersDS", { type: 'data structure', extName: "ORDERS"});

display.grid1.clear();
 
var c1 = pjs.allocStmt();
c1.executeDirect("SELECT * FROM ORDERS");
 
pjs.fetch(c1, ordersDS);
while (c1.hasMoreRows()) {
  // custom processing before record is added can go here
  display.grid1.write();
  pjs.fetch(c1, ordersDS);
}