Creating repeating and non repeating subform XML using Multiple Row Module

Avatar

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Aditya_S_
Level 4

29-01-2009

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

Replies

Avatar

Avatar
Boost 5
Level 9
HowardTreisman
Level 9

Likes

5 likes

Total Posts

936 posts

Correct reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Level 9
HowardTreisman
Level 9

Likes

5 likes

Total Posts

936 posts

Correct reply

9 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
HowardTreisman
Level 9

21-02-2009

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