Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.

Iterating through the result of a multiple row sql statement

Avatar

Level 8
Level 8
Hi all,



I would like to access the results of a multiple row sql-statement. However I can't find out how to do this, can you help me here?



I have tried using the "node-set" functions in xpath, but I can't seem to get it right.



How should I approach this scenario?



Sincerely

Kim
2 Replies

Avatar

Former Community Member
The jdbc service has the option of returning xml back to you ...if you do it this way then you can interogate the xml

Avatar

Level 8
Level 8
Hi again,



I figured this one out, thanks for your input Paul.



Sincerely

Kim