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