Re: Trying to do a query inside my XML but not sure what to do.
If you are using HPOO 9.x you can use the XPath filter in the results tab to perform an XPath query against the XML; if you are using 7.51 or as an alternative to a filter there is an XPath operation under /lib/util/xml processing.
There are two instances of relationship.name in the XML you provided so not sure which one you want (or both?); also not sure if you just want the value or the entire XML tag.
This XPath will get you the values for n number of tags
If you want the entire tag returned simply remove the /text() component.
If you only want one of them returned you need to specify the parent tag of either ns:keys or ns:instance like below
Please note that XPath is case sensitive so it will not find -prod or -Production etc. XPath 2.0 allows for some case insensitivity but HPOO only uses XPath 1.0. There is a workaround for XPath 1.0 using the translate() function but it's very messy.
If you want to return n number of values (instead of just one) you won't be able to use the XPath filters as they only return the first result unfortunately.