DataBase functiod issue issue while extracting example included

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DataBase functiod issue issue while extracting example included

Viewing 0 reply threads
  • Author
    Posts
    • #18193

      Hi biztalkgurus

       I have an issue with database functoid. i am using a value extracter to extract the result. But the problem is if my database lookup returns more than one value. The extracter only pulling one value. I would like to explain further using the schemas.

      my source schema looks  like this
      <request>
      <header>
      <desc>abc</desc>
      </header>
      <header>
      <desc>def</desc>
      </header>
      </request>

      My Database look up functoid which takes input orderno from the  source schema
       table POrders
       column   column
       orderno  desc
       125      abc
       125      def

      in the lookup functoid takes orderno, connectionstring, POrders, orderno
       now i have a table extracter which extracts for column (desc) and returns to the outputschema

      My output schema after execution is

      <response>
      <header>
      <desc>abc</desc>
      </header>
      </response>

      but my desired output is
      <response>
      <header>
      <desc>abc</desc>
      </header>
      <header>
      <desc>def</desc>
      </header>
      </response>

       

      Thanks for the response and very much appreciated

      regards

      ram

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.