PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/06/2014 8:39 AM by  Chris12
List Box Selection
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chris12
Private
Private
Veteran Member
(366 points)
Veteran Member
Posts:150


Send Message:

--
04/15/2014 3: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
    Private
    Private
    Veteran Member
    (887 points)
    Veteran Member
    Posts:309


    Send Message:

    --
    04/15/2014 7: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
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    04/16/2014 8:43 AM
    Thanks .... I will give it a try
    Chris12
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    04/16/2014 12:24 PM
    Doing a data refresh now ... I will hit it first thing tomorrow
    Chris12
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    05/02/2014 3: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
    Private
    Private
    Veteran Member
    (887 points)
    Veteran Member
    Posts:309


    Send Message:

    --
    05/02/2014 5:14 PM
    Yes Chris12, the code extract is from a custom screen that works.
    Chris12
    Private
    Private
    Veteran Member
    (366 points)
    Veteran Member
    Posts:150


    Send Message:

    --
    05/06/2014 8:39 AM
    Thanks ... I stepped away from it for a day or two to clear my head
    I will get back with it today
    You are not authorized to post a reply.