AnsweredAssumed Answered

Query a list for multiple items, each item with repeater

Question asked by nmjohns on Oct 3, 2017
Latest reply on Oct 5, 2017 by emha

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. 

Outcomes