Let's see if I can even explain myself correctly. I'm trying to query a list, returning multiple items. Each item has a repeater with multiple details.
Item has:
Building
City
Repeater
Created Date
Repeater fields are:
Person
Number
Since I have multiple items I'm returning, I need to call web service. I'm able to build an HTML table with the returned information that is stored in the Results variable (After using XSL transform option).
The problem is each row becomes:
Building | City | Repeater XML with everything about all people entered in repeater | Created Date
I need to be able to build an HTML table consisting of
Repeater Person | Repeater Person Number | Building | City | Created Date
Next Repeater Person | Repeater Person Number | Same Building | Same City | Same Created Date
What actions would I even use to keep track correctly? It seems like I would benefit from using a collection but the returned XML can only be stored in a single variable.