GETKEYVALUES
This function returns a list of all the values of a specified key from an xml variable. It is similar to the GETKEYVALUESA function, which returns the values as an array.
You can use the asterisk (*)
character at the beginning or end of a string as a wildcard. For example, to
return particular keys or properties. Asterisks within a string do not act as
wildcards. A wildcard search returns only the first matched key or property.
Note: We cannot guarantee the order in which keys or properties are matched.
Syntax
GETKEYVALUES("XML_properties","key","separator")Example
=GETKEYVALUES(ReportVariables.rv_xmlvariable.text,"[Product]",",")Note: In GETKEYVALUES,
the
.text attribute is
optional. In GETKEYVALUESA, the .text attribute is required. GETKEYVALUES is a list function. It can be used in server lists, relational lists, and in slices.