Business Rule returns an array

Home Page Forums BizTalk 2004 – BizTalk 2010 Business Rule returns an array

Viewing 1 reply thread
  • Author
    Posts
    • #20705

      Hi,

      I have an BR that makes the same that the following query:

         select id_integrator
         from integratorBD
         where id_Function like Schema.Id_Function

      This query returns 2 ints (10 and 20 for example)

      But the schema that results from BR only shows one id_integrator (the last one).

      Input Schema :

      <input>
      <id_function>3</id_function>
      <id_integrator></id_integrator>
      </input>

      Output Schema (result from a test to the BR):

      <input>
      <id_function>3</id_function>
      <id_integrator>20</id_integrator>
      </input>

      Output schema I was expecting:

      <input>
      <id_function>3</id_function>
      <id_integrator>10</id_integrator>
      <id_integrator>20</id_integrator>
      </input>

       

      And yes id_integrator can occurs more that one time.

       

      Business Rules only return one result? Is this the behavior by default? Theres any way you guys recommend me to obtain the result with the 2 values output?

       

      Thanks

    • #20711

      Come on, anyone?

       

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