Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Creating repeating and non repeating subform XML using Multiple Row Module

Avatar

Level 7
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 Reply

Avatar

Level 9
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+populating+a...

Addons: http://www.avoka.com/avoka/addons.shtml

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now