possibleItemsProcess.js

import("system.logging");
import("system.result");
import("system.db");
import("Sql_lib");

//TODO: change field to lookup field
var sqlUtils = new LegacySqlUtils();
var prodsSql = "select PRODUCTID, " + sqlUtils.concat(["PRODUCTCODE", "'/'", "PRODUCTNAME"]) 
                    + " from PRODUCT";

var prods = db.table(prodsSql);

var retArray = [];
for(var i = 0; i < prods.length; i++)
    retArray.push(prods[i]);

result.object(retArray);