Forums
Lawson Design Studio
List Box Selection
Author
Messages
Chris12
Veteran Member
Posts: 150
4/15/2014 7:44 PM
I have developed a custom PA52.1 form which will let a user perform certain PA on themselves ...
I would like to put in a listbox for the reasoncode which will display the values from PA57.3 for that particular PA for the user to select from ...
I am not sure what is the best way via design studio .... Any help is appreciated.
I am stuck
Ragu Raghavan
Veteran Member
Posts: 469
4/15/2014 11:39 PM
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;
}
Chris12
Veteran Member
Posts: 150
4/16/2014 12:43 PM
Thanks .... I will give it a try
Chris12
Veteran Member
Posts: 150
4/16/2014 4:24 PM
Doing a data refresh now ... I will hit it first thing tomorrow
Chris12
Veteran Member
Posts: 150
5/2/2014 7:39 PM
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
Ragu Raghavan
Veteran Member
Posts: 469
5/2/2014 9:14 PM
Yes Chris12, the code extract is from a custom screen that works.
Chris12
Veteran Member
Posts: 150
5/6/2014 12:39 PM
Thanks ... I stepped away from it for a day or two to clear my head
I will get back with it today