List Box Selection

Here is a piece of JavaScript code that populates a custom listbox with the union codes from the PCODES table.
Maybe you can bulid something similar based on the data in PAACTREAS?

function Populate_UnionCode(vList)
{
// alert("Populate Emp Status");
var sPDL = portalWnd.oUserProfile.getAttribute("productline");

var s = portalWnd.DMEPath;
s += "?PROD=" + sPDL;
s += "&FILE=PCODES";
s += "&FIELD=CODE;DESCRIPTION";
s += "&INDEX=PCOSET1";
s += "&KEY=UN";
s += "&MAX=999";
s += "&OUT=XML";
// alert("s " + s);

var sReturn=portalWnd.httpRequest(s);

if (!sReturn || sReturn.status)
{
alert("status s " + sReturn.status);
return true;
}

var vObjXML = new portalWnd.DataStorage(sReturn);
var vRecords = vObjXML.document.getElementsByTagName("RECORD");
// alert("vrecords " + vRecords.length + " " + vRecords.text);

//_l132 is the listbox
// var InvList = document.getElementById("VALUES_l132");
var vValue = "VALUES_" + vList;
var InvList = document.getElementById(vValue);

for (var ix=0; ix < vRecords.length ; ix++)
{
var vCols = vRecords[ix].getElementsByTagName("COL");
// alert("vCols " + vCols[0].firstChild.data);
var vCode = vCols[0].firstChild.data;
var vDesc = vCols[1].firstChild.data;
var vShow = vCode + ": " + vDesc;
ListVal = document.createElement("span");
ListVal.setAttribute("tran",vCode);
ListVal.setAttribute("disp",vCode);
ListVal.setAttribute("text",vShow);

InvList.appendChild(ListVal);
}
return true;
}

Thanks .... I will give it a try

Doing a data refresh now ... I will hit it first thing tomorrow

Hi Ragu, I have been struggling with this one for a while now Were you able to succesffuly populate a listbox with data from a table via Design Studio ????? Please let me know ...... I can forward you the code I am using if that would help

Yes Chris12, the code extract is from a custom screen that works.

Thanks ... I stepped away from it for a day or two to clear my head
I will get back with it today