1 Reply Latest reply on Feb 21, 2009 12:41 AM by HowardTreisman

    Creating repeating and non repeating subform XML using Multiple Row Module

    Aditya S. Level 1
      I have a form with repeating and non repeating subforms. The xml looks something like


         

             01122009
             12122009
             Sam
             Evaluator
         

         
             Joe
            
         

         
             Bob
            
         



      The problem is in "XML Information". I cannot specify more than one repeating element.

      Using one "Query for Multiple Rows as XML" module, can I create the above XML structure ?

      Thanks
      Aditya
        • 1. Re: Creating repeating and non repeating subform XML using Multiple Row Module
          HowardTreisman Level 1
          No, you can't do it directly.
          You'll need to create multiple small snippets of XML from multiple invocations of the SQL query component, and then merge them together using Set Value.

          You could also use SQL PLus, which allows you to inject XML results directly into an existing XML document.

          Check out these resources.

          Components: http://www.avoka.com/avoka/escomponents.shtml
          Docs: http://avoka.dnsalias.com/confluence/display/Public/Avoka+LiveCycle+ES+Components - click on "SQL Plus"
          Example: http://avoka.dnsalias.com/confluence/display/Public/Retrieving+data+from+a+database+and+p opulating+a+form+with+the+data
          Addons: http://www.avoka.com/avoka/addons.shtml