1 Reply Latest reply on May 6, 2010 10:41 AM by johnqdaily

    Parse XML in Workbench Issue

    johnqdaily Level 1

      Running LC ES 8.2.1.3 on MS Server 2003 with MSSQL 2005 and JBoss

       

      I have a stored procedure call that I have set up in workbench using the queryMultipleToXml service.  I am able to connect fine and can get the data into an XML type output variable called xmlOutput.  Below is the xml schema.

       

      <Subordinates>

           <Subordinate>

                <full_name>Public, John</full_name>

                <id_nbr>123456</id_nbr>

                ....

           </Subordinate>

            <Subordinate>

                <full_name>Doe, Jane</full_name>

                <id_nbr>987654</id_nbr>

                ....

           </Subordinate>

           <Subordinate>

                <full_name>Doe, John</full_name>

                <id_nbr>654987</id_nbr>

                ....

           </Subordinate>

           <Subordinate>

                <full_name>Dandy, Jim</full_name>

                <id_nbr>123789</id_nbr>

                ....

           </Subordinate>

      </Subordinates>

       

       

      What I need to do in Designer is output all of the names into a drop-down list so that when the user selects a name it will populate the id number into a text field.

       

      I am sure this is simple but I haven't been able to get this figured out.

       

      Thank you in advance,

       

      John