Nested List Items with Xml Data Source

0
danvonfeldt posted this 07 September 2017

I'm wondering if it is possible to do the following:

xml looks like

<source>
    <event_id>1</event_id>
</source>
<destination>
    <event_id>1</event_id>
    <line_number>1</line_number>
</destination>
<destination>
     <event_id>1</event_id>
     <line_number>2</line_number>
</destination>

I would like to have a nested list that does something like.

[ParentList] Sources: source.eventid [SubList] Destinations: destination.eventid destination.line_number [/SubList] [/ParentList]

Where the SubList is defined by all entries that match the ParentList on event_id.

Since the xml structure is not nested I would think I could use the parent's context to xpath my way into the destinations based on event_id, but I'm not seeing how or if I can do this.

Thanks for any help!

29 Posts
29 Points
2 Comments
Order By: Standard | Newest | Votes
0
danvonfeldt posted this 07 September 2017

Nevermind, I think I must of just had my xpath incorrect. Found that you support this here ==> http://www.docentric.com/news

29 Posts
29 Points
1
jles posted this 08 September 2017

Hi Dan,

Yes, you are on the right track.

Just in case you still haven't found the solution, I attached an example that you can use a learn from. (see attachment).

Best regards, Jure

155 Posts
295 Points

Our 228911 members have posted 344 times in 102 discussions